Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by kenyastar

  1. 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
  2. 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.
  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!!
  16. kenyastar

    Authorize.Net error

    Did you figure this out?? I am having the same trouble. :)
  17. LOVE this contribution! Unfortunately, I am having a problem. All installed, works great... BUT in the shopping cart, it calculates the right price, but it shows the product price. Item A is $10 Attribute B = $15 Price in shopping cart shows $10 and the total shows $15. I read in this thread where it is possible for it to list it as a line item in the cart with the Product Price AND The Attribute price under it. THAT would really rock, if I could get it to work. The code in the previous topic seems different than what downloads with V1.41 on OSC Contributions. Which one should I use? Thank you a millions times thank you!! Burning the midnight oil for months on this project is easier knowing the forum is here and I'm not alone!!! :D Kenya
  18. kenyastar

    Easy Populate Upload error

    THANKS for responding!! At least I'm on the right track. I tried changing it like you have here and a dozen other ways and it still gives me the same error. I use IPOWER and have the security setting on the folder as "777" It only takes a string of 3 numbers. What do I do with the CHMOD?
  19. Everything working fine on download. But upload I get this error. My permissions are set to 777 on temp file. I have tried every conceivable path in easypopulate.php $tempdir = "/catalog/temp"; $tempdir2 = "/catalog/temp"; and not matter what path I put here the path in the error is exactly the same. PLease help!!! Warning: move_uploaded_file(/home/diamondn/public_html/ecommerce/os/catalog//catalog/temp/EP2005Mar27-1111.txt): failed to open stream: No such file or directory in /home/diamondn/public_html/ecommerce/os/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/var/tmp/phpKXr6iI' to '/home/diamondn/public_html/ecommerce/os/catalog//catalog/temp/EP2005Mar27-1111.txt' in /home/diamondn/public_html/ecommerce/os/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /var/tmp/phpKXr6iI User filename: EP2005Mar27-1111.txt Size: 900 Warning: file(/home/diamondn/public_html/ecommerce/os/catalog//catalog/temp/EP2005Mar27-1111.txt): failed to open stream: No such file or directory in /home/diamondn/public_html/ecommerce/os/catalog/admin/easypopulate.php on line 657 Warning: Invalid argument supplied for foreach() in /home/diamondn/public_html/ecommerce/os/catalog/admin/easypopulate.php on line 680
  20. I want to download with EZ Populate without the attributes due to the column limits in Excel. I changed the line to false: // VJ product attributes begin // **** Product Attributes **** // change this to false, if do not want to download product attributes global $products_with_attributes; $products_with_attributes = false; Is there something else I need to do? I didn't change anything else. I've read this 79 page thread, loaded a fresh file and started over and tried again and I can't get this to work. If anyone has any ideas, I'd be most grateful!!! This forum has saved my life countless times and I really appreciate everyone here.