Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

talon177

Archived
 View Profile  See their activity

  • Posts

    403

  • Joined

  • Last visited

 Content Type 

Posts posted by talon177

    Ad Tracker (where did they come from) Update

    in General Add-Ons Support

    Posted

    I still have this contrib installed but over the last 2 months since I installed it the only two users returned when I run this myswl query:

     

    select customers_firstname, customers_lastname from customers where customers_advertiser is not null;

     

    are the two test users I set up when testing to see if it was working. It seems to work only if a customer signs up for an account immediately after clicking the link to the site. The "sign up for an account" link must be the first link they click, otherwise the ad= value is lost. I left it installed but for me it's only wasting CPU cycles. :(

    works for me, value still shows after clicking other links within the site before signing up.

    Ad Tracker (where did they come from) Update

    in General Add-Ons Support

    Posted

    One thing i noticed is that the stats_ad_results.php counts in shipping and tax, so you still don't really no how much profit you make from each ad.

     

    For instance lets say 1 item totals 37.88 but 5 was shipping and 2.88 was tax, and item sold was 30 and item cost was 28 which equals 2 profit.

     

    But then u spent 15 dollars for advertising.

     

    Currently theres no way to factor in how much you really made, I guess the best solution for now would be just to show total sale item, that way you can just sales - cost = profit, but then you would still have to figure out what profit came from which ad.

    bump, anyone have an opinion on this or know a solution/fix?

    [Contribution]Paypal IPN - Devosc

    in Other

    Posted

    Talon, if your working on using PWA as well I suspect that you will need to change the way this IPN contrib handles the cusotmer order confirmation email notifications, since PWA removes the temporary account once they have paid and returned to the site (or are you only going to remove them once the payment is 'Completed'), see this post for info on the possible email related changes.

     

    When someone decides to use Paypal to pay (via IPN), and they don't complete:

    1) No stock is removed from the DB

    2) They can't return and pay for the goods later

     

    I'm looking for this too. I had a customer today try a couple times to make an order. He told me that he forgot his password, and when he went through the whole deal to get his lost password, there wasn't a way to complete the transaction.

     

    I'm not too familiar with the code, but it seems like it wouldn't be too difficult if it's "pending paypal notification" to put a link on the Order information page to complete the payment at paypal.

     

    It seems that modules/payment/paypal/checkout_process.php already has "if($order_exists)" all over it, but I just don't know how to call it.

     

    At present stock is only subtracted once a customer's payment is 'Completed' i.e. the store owner has received successfully received the payment amoun into their account.

     

    v2.2 and above allows the customer to click through to PayPal at which time that order status is 'Pending PayPal Notification', the customer can then click back (or retrun) to the site and still recommence the checkout (possibly updated) for that order.

     

    In this case if the customer's session expires or for example cookies are removed then that associated order upon their return to the site, at present, will not be available to recommence that order's checkout sequence. This is because the session var paypal_order_id would of been removed/destroyed.

     

    $order_exists determines whether the session_order_info exists it it's respective db table, this session info is not removed until the payment is 'Completed' (and is independent of the above paypal_order_id session var).

     

    By osC default each customer has only one shopping basket, this allows the contents of the basket to be restored upon their next login, so for example if the customer payed via PayPal and that payment 'Failed' (or maybe that session was destroyed) in order for the customer to retry and pay for that particular order a method would need to be devised to destroy the existing contents of that customer's shopping basket and then to repopulate that basket with the products (and associated attributes) of that particular order (and possibly the related checkout session info such as sendto, billto and comments).

     

    However, outside of this forum thread, I've indirectly heard that some IPNs do not get 'VERIFIED' when indeed a payment has been made, this may the result of a network or PayPal problem, what could possible happen is that for example IPN verifications could be retried and or have the ability to click to retry via the admin or when the customer logs back in or prior to attempting to allow the customer to recommencing/resconstructuring the order as mentioned above. But without any real feedback it may not warrant enough attention.

    Hey Greg, thanks for the post info on the checkout_update.php in the paypal payment folder. I changed your file from

     

      
include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_PROCESS);
 $email_order = STORE_NAME . "\n" .
                EMAIL_SEPARATOR . "\n" .
                EMAIL_TEXT_ORDER_NUMBER . ' ' . $orders_id . "\n" .
                EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $orders_id, 'SSL', false) . "\n" .
                EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n";

 $orders_history_query = tep_db_query("select comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . $orders_id . "' order by date_added limit 1");
 if (tep_db_num_rows($orders_history_query)) {
   $orders_history = tep_db_fetch_array($orders_history_query);
   $order->info['comments'] = $orders_history['comments'];
 }

 if ($order->info['comments']) {
   $email_order .= tep_db_output($order->info['comments']) . "\n\n";
 }
 $email_order .= EMAIL_TEXT_PRODUCTS . "\n" .
                 EMAIL_SEPARATOR . "\n" .
                 $products_ordered .
                 EMAIL_SEPARATOR . "\n";

     

    To This to work with Purchase Without Account 0.71

     

      include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_PROCESS);

// BoF Purchase Without Account 0.71
if (!tep_session_is_registered('noaccount')) {
// EoF Purchase Without Account 0.71
 $email_order = STORE_NAME . "\n" .
                EMAIL_SEPARATOR . "\n" .
                EMAIL_TEXT_ORDER_NUMBER . ' ' . $orders_id . "\n" .
                EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $orders_id, 'SSL', false) . "\n" .
                EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n";

 $orders_history_query = tep_db_query("select comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . $orders_id . "' order by date_added limit 1");
 if (tep_db_num_rows($orders_history_query)) {
   $orders_history = tep_db_fetch_array($orders_history_query);
   $order->info['comments'] = $orders_history['comments'];
 }

 if ($order->info['comments']) {
   $email_order .= tep_db_output($order->info['comments']) . "\n\n";
 }
 $email_order .= EMAIL_TEXT_PRODUCTS . "\n" .
                 EMAIL_SEPARATOR . "\n" .
                 $products_ordered .
                 EMAIL_SEPARATOR . "\n";
// BoF Purchase Without Account 0.71
 } else {
 $email_order = STORE_NAME . "\n" . 
                EMAIL_SEPARATOR . "\n" . 
                EMAIL_TEXT_ORDER_NUMBER . ' ' . $orders_id . "\n" .
                EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n";

 $orders_history_query = tep_db_query("select comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . $orders_id . "' order by date_added limit 1");
 if (tep_db_num_rows($orders_history_query)) {
   $orders_history = tep_db_fetch_array($orders_history_query);
   $order->info['comments'] = $orders_history['comments'];
 }

 if ($order->info['comments']) {
   $email_order .= tep_db_output($order->info['comments']) . "\n\n";
 }
 $email_order .= EMAIL_TEXT_PRODUCTS . "\n" . 
                 EMAIL_SEPARATOR . "\n" . 
                 $products_ordered . 
                 EMAIL_SEPARATOR . "\n";
 }
// EoF Purchase Without Account 0.71

    Master Products - MS2

    in General Add-Ons Support

    Posted

    includes/modules/new_products.php

     

    products_listing_status='1' is inserted into the 2 lines below.

     

    if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {

    // BoF Master Products 1.1.5

    $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' and p.products_listing_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

    // EoF Master Products 1.1.5

    } else {

    // BoF Master Products 1.1.5

    $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_listing_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

    // EoF Master Products 1.1.5

    }

    Purchase Without Account Updated & Admin Functionality

    in General Add-Ons Support

    Posted

    talon177

     

    My personal feeling is that a PWA customer should not feel that they are logged on at any stage so I have changed the login / logoff so that a PWA customer still sees "Log In".

     

    I've changed the "My Account" link to "Create Account" as well. A PWA customer could still get to the My Account page in theory, but shouldn't be able to find it unless they know the OSC page names.

     

    Tim

    Thanks for the insight

    [Contribution]Paypal IPN - Devosc

    in Other

    Posted

    talon177

     

    Should work with itemized without CCGV

    Thanks guys.

     

    When doing a fresh osC 2.2 MS2 with PP IPN 2.3 is there any other modifications that need to be done other than the instructions on the html page that comes with this contribution? I was having trouble getting the tax to send over to paypal even though i followed the directions to the dot using itemized, but when i use aggregate it works.

    Purchase Without Account Updated & Admin Functionality

    in General Add-Ons Support

    Posted

    Here's an idea maybe someone could code, on the log off page if the user is signed on as a guest account and click's log off that their could be a display warning saying that are you sure you want to log off, and that they would have to refill all their information again if they wish to make another purcahse or just signup with an account ? That way it's no longer accidental and they have the benefit of the log off button.

    Purchase Without Account Updated & Admin Functionality

    in General Add-Ons Support

    Posted

    Just wondering, what do you guys think about the log off button for guest users? Should they have this or not?

     

    Pro's:

     

    It'll make user feel more safe that they logged off rather than closing your website if they first chose to checkout without account and decide not to buy. But if they do buy they'll just automatically log off correct?

     

    Con's:

     

    If a guest account hits log off before finishing processing their purchase they would have to fill out the form again, but now if they don't have the log off they'll feel like they have to close the browser and then go back to the website to shop around again before deciding.

     

    What you guys think?

     

    Thanks!

×
×
  • Create New...