Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

1 Follower

About kenyastar

  • Birthday 11/14/1966

Profile Information

  • Real Name
    Kenya Star
  • Website
  1. kenyastar

    Create 1000s of coupon codes

    Very clever idea! I think I can make that work. I'll update when done. THANKS! Oh, one other problem I just had. When clicking 'redeem' button on checkout_payment page it wipes out the CC info. So, the customer would have to re enter their CC info after redeeming their coupon. I am searching forums now for a solution.
  2. FAB contribution. I have the Gift and Coupon installed. My goal: Send 18,000 coupons (or certificates) to my customers via snail mail. Customer redeem coupon without an account. Each coupon will have its own unique number. Any suggestions on best way to do this would be most appreciated. So far I can only see how to create them 1 at a time or via email. I'm sure there is a way to create 1000s at once but I don't see it. Thanks for any help! Kenya Star
  3. kenyastar

    Google Analytics module

    Hey Pix I need your help please!! I have everything working except the e-commerce stats. It shows up in the view page source of the receipt page but it is not showing up in google analytics ecommerce reports. Below is my code. I really appreciate any suggestions and really appreciate your work on this. -KenyaStar Here's is the file which is in catalog\includes\google_analytics.php (I've replaced my actual account number with XXX) <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> var pageTracker = _gat._getTracker("UA-XXXXXXX-1"); pageTracker._initData(); pageTracker._trackPageview(); </script> Here's is the file which is in catalog\includes\modules\analytics\analytics.php <?php /* ========================================================== Include Google Analystics module for osCommerce Modified by PIXCLINIC (http://www.pixclinic.com) v. 1.0.0 - 2008/04/07 ========================================================== -------------------------------------------------- osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce -------------------------------------------------- Released under the GNU General Public License */ // ############## Google Analytics - start ############### // Get order id $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where customers_id = '" . (int)$customer_id . "' order by date_purchased desc limit 1"); $orders = tep_db_fetch_array($orders_query); $order_id = $orders['orders_id']; // Get order info for Analytics "Transaction line" (affiliation, city, state, country, total, tax and shipping) // Set value for "affiliation" $analytics_affiliation = 'Armani Imports'; // Get info for "city", "state", "country" $orders_query = tep_db_query("select customers_city, customers_state, customers_country from " . TABLE_ORDERS . " where orders_id = '" . $order_id . "' AND customers_id = '" . (int)$customer_id . "'"); $orders = tep_db_fetch_array($orders_query); $totals_query = tep_db_query("select value, class from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' order by sort_order"); // Set values for "total", "tax" and "shipping" $analytics_total = ''; $analytics_tax = ''; $analytics_shipping = ''; while ($totals = tep_db_fetch_array($totals_query)) { if ($totals['class'] == 'ot_total') { $analytics_total = number_format($totals['value'], 2); $total_flag = 'true'; } else if ($totals['class'] == 'ot_tax') { $analytics_tax = number_format($totals['value'], 2); $tax_flag = 'true'; } else if ($totals['class'] == 'ot_shipping') { $analytics_shipping = number_format($totals['value'], 2); $shipping_flag = 'true'; } } /* Prepare the Analytics "Transaction line" string <script type="text/javascript"> var pageTracker = _gat._getTracker("UA-xxxxx-x"); pageTracker._initData(); pageTracker._trackPageview(); pageTracker._addTrans( "1234", // order ID - required "Mountain View", // affiliation or store name "11.99", // total - required "1.29", // tax "5", // shipping "San Jose", // city "California", // state or province "USA" // country ); */ $transaction_string = ' <script type="text/javascript"> pageTracker._addTrans( '; $transaction_string .= '"' . $order_id . '",'; $transaction_string .= '"' . $analytics_affiliation . '",'; $transaction_string .= '"' . $analytics_total . '",'; $transaction_string .= '"' . $analytics_tax . '","'; $transaction_string .= '"' . $analytics_shipping . '",'; $transaction_string .= '"' . $orders['customers_city'] . '",'; $transaction_string .= '"' . $orders['customers_state'] . '",'; $transaction_string .= '"' . $orders['customers_country'] .'"'; $transaction_string .= ');'; /* Get products info for Analytics "Item lines" pageTracker._addItem( "1234", // order ID - required "DD44", // SKU/code "T-Shirt", // product name "Green Medium", // category or variation "11.99", // unit price - required "1" // quantity - required ); pageTracker._trackTrans(); </script> */ $items_query = tep_db_query("select products_id, products_model, products_name, final_price, products_quantity from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . $order_id . "' order by products_name"); while ($items = tep_db_fetch_array($items_query)) { $category_query = tep_db_query("select p2c.categories_id, cd.categories_name from " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p2c.products_id = '" . $items['products_id'] . "' AND cd.categories_id = p2c.categories_id AND cd.language_id = '" . (int)$languages_id . "'"); $category = tep_db_fetch_array($category_query); $item_string = ' pageTracker._addItem('; $item_string .= '"' . $order_id . '",'; $item_string .= '"' . $items['products_id'] . '",'; $item_string .= '"' . $items['products_name'] . '",'; $item_string .= '"' . $category['categories_name'] . '",'; $item_string .= '"' . number_format($items['final_price'], 2) . '",'; $item_string .= '"' . $items['products_quantity'] . '"'; } // ############## Google Analytics - end ############### ?> <script type="text/javascript"> pageTracker._addTrans( <?php echo $transaction_string; ?> ); <?php echo $item_string; ?> pageTracker._trackTrans();
  4. kenyastar

    Google Analytics module

    Hey Pix, I am anxiously awaiting your 'little bug fixes'. Everything is working except e-commerce not showing up in analytics reports. I've been through code line by line and have everything as you do. Please post your fixes :) :) I am very excited to see this data! Thank you for all your fine work on this! Kenya Star
  5. kenyastar

    Google Analytics module

    Thank you so much for this post it has been very helpful. I have followed it and I am nearly there. My problem is in the end it echo's the data in the browser I can see it via 'view source'. But it is not showing up in analytics. There seems to be a disconnect between gathering the data and getting it to analytics. Any ideas? I've tried everything I can think of so far. KenyaStar
  6. kenyastar

    [Contribution] Admin Specials by Category

    I have about 1400 products and even with the db optimization and only 4 product to a page this loads too slow. Is anyone aware of a way to fix this? Or another solution for offering a discount on all products?
  7. kenyastar

    FedEx Direct 2.06 Support thread

    Calling Fedex was definitely the answer in my case. Domestic rates were working great but I was getting the error above for international addresses. When I set my account up with Fedex I did not specifically request International and so I didn't get it :). They recertified my account to include international and all is well. Thank you so much for a great contribution and great support!
  8. kenyastar

    Attribute Sets Plus

    In the original Attribute SEt Contribution it effects the order total when you add the product to the shopping cart which than messes up the total at checkout... but ONLY IF there were TWO or more attirubutes and one had PRICING for each option in the drop down list. though it worked fine with one attribute that had pricing. And it boy did it effect the order total! I spent 3 days on the phone with an OSC developer trying to fix it. And in the thread on that contribution there are many examples of others with similar issues. The problem was inherent to how that contribution had been developed. The way you developed it looks like it should not be a problem at all. But before installing, I thought I'd pose the question :). As more folks find out about your awesome contribution, you will defintiley be posed with this question again. If any site can break it, it's mine, so I'll let you know ;). I'll install it this weekend on my DEV site and test test test on our stud earrings. Thanks again! Kenya
  9. kenyastar

    Attribute Sets Plus

    First, thanks for the great contribution. I love the development process and really appreciate your efforts!!! I do have one question I hope you can help with. The Attribute Sets contribution had many problems with multiple attirbutes when pricing was involved. i.e. with a diamond ring. Set 1: Gold: white/yellow Set 2 Carrats: 1, $10 2, $20 etc. It would total wrong when added to the shopping cart if there were 2 or more attributes and one of them had pricing. Do you know if this is an issue with Attribute Sets Plus??? Kindest regards, Kenyastar :)
  10. kenyastar

    Urchin 6

    I am planning on installing this on sAturday. It seems pretty straight forward, but if anyone has any warnings or suggestions, please advise. :) I saw one post from June 14th that made it sound very complicated. Is there some reason it doesn't do well with OSC? Any help is most appreciated! Thanks, Kenyastar :)
  11. kenyastar

    Authorize.net Firefox and MSIE

    This is simplistic and may not be the answer but it happened to me the same way when I was tired one night and trying to test Authorize.net. The solutions was that The credit card type; visa, MC, Discover was defaulting and I wasn't triple checking it before I hit continue. try your test again and before you hit continue check the Credit Card type. Just a thought. I hope you figure it out! KEnya :)
  12. THANK YOU THANK YOU THANK YOU!!!! From the bottom of my little geek heart! I don't know why the simple thigns are sometimes the hardest for me! I had played with this and just couldn't get it to do what I wanted. Kenyastar :D
  13. kenyastar

    Error on Admin Shipping page in OSC

    :D Who would of thought it would be so easy!!! THANK YOU!!!!!
  14. Everything is working fine. I do not use fed ex. But this code shows up on my admin shipping page from OSC WEb view. Any ideas on where I go to fix this?? I really appreciate any help you may have!! Warning: main(includes/include_once.php): failed to open stream: No such file or directory in /home/diamondn/public_html/ecommerce/os/catalog/includes/modules/shipping/fedex.php on line 4 Warning: main(includes/include_once.php): failed to open stream: No such file or directory in /home/diamondn/public_html/ecommerce/os/catalog/includes/modules/shipping/fedex.php on line 4 Warning: main(): Failed opening 'includes/include_once.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/diamondn/public_html/ecommerce/os/catalog/includes/modules/shipping/fedex.php on line 4
  15. kenyastar

    Authorize.Net error

    OK, I'm a total idiot. I didn't update my transaction key before testing. duh!!