Jump to content

pfaustino

Members
  • Content count

    38
  • Joined

  • Last visited

1 Follower

Profile Information

  1. First of all, this is a great contribution and I can't wait to see EdgeIO pick up my feed. Also, I already have a Google Base feed so I'm a little worried that this will overwrite that feed. Also, I want to stress that my version of OSCommerce is a highly modified version of MS2.2 with tons of contributions installed. But since there is only one file to install and NO oscommerce files to modify, there should be no problems right. So if you are having problems, you might want to try my solution below. The bad stuff. It didn't work as installed. I was getting database errors. Then when I fixed the code (more on this later), It completely screwed up my oscommerce administration page. I couldn't get into ANY of my /admin pages!!! because it kept looking for /admin/includes/languages/en-us.php. The good news. I got it to work. So Here's the Solution: 1. To get rid of the database not found errors, I replaced the stock oscommerce classes code from line 25 with: /*INCLUDE NEEDED OS COMMERCE CLASSES*/ require('includes/application_top.php'); /*END STOCK OS COMMERCE INCLUDE*/ 2. To not get it to break my admin (my God, this put me in panic mode when I couldn't check out my admin pages). I had to shut down Firefox completely and restart. After that, I changed two lines: search for : $language='en-us'; replace with : $languagerss='en-us'; AND search for : $output.='<language>'.$language.'</language>'."\n"; replace with : $output.='<language>'.$languagerss.'</language>'."\n"; Apparently, this was setting a global session variable $languages so that my oscommerce language which was "english" was changed to "en-us". So whenever the admin pages wanted to access language files it would look for them in /admin/languages/en-us.php instead of /admin/languages/english which caused a fatal error in my browser. Weird huh? Any way, it seems to work now. Thanks again for a great contribution. Patrick Faustino
  2. pfaustino

    Google Analytics module

    First off, kudos to OSCODERS for a great contrib! I use authorize.net and Paypal too but most everything works including MOST of the ecommerce side. Products and Orders are registered (both on Paypal and Authorize.net Transactions) but only about 10% of goals are registering and 90% of transactions are registering Is anyone else using authorize.net, and got their Funnels Conversion and Transaction Lists to work properly? My problem is the following: 1. Funnels do not totally work on the goal page. I will see GA report that 2 sales/goals but I actually had 10 sales. This is evident when you look at GA's under ECommerce transaction list (a different report) that shows 10 sales with all products that were purchased. The initial steps of the funnel seem to be working fine. For example Shipping Method: 64 Visits Payment Method: 55 Visits Checkout Confirmation: 51 Visits Order Completed : 5 Visits. I know that I had 20 orders (according to oscommerce admin) for those stats but why is it only showing 5? 2. OK, transaction list is a little better than funnels but it still does not show ALL transactions. For example, oscommerce admin will show my order numbers from 5000 to 5020. That should be 20 orders in all. But the GA transaction list, will have around 2 missing. I verified that these were legit orders and they are paid via authorize.net. I can also assume that the Product Performance page on GA is also innacurate - I haven't verified it but I'm guessing. Conclusion: I have 2 theories: 1. On the Funnels thing, I think Google detecting an "EXIT" when checkount_confirmation.php calls checkout_process.php which in turn sends the user to authorize.net to run the transaction? Therefore, when Authorize.net returns the user back to checkout_success.php, GA will assume that the person has already exited the funnel and therefore does not count the goal even though the code is there? But then, if this is so, then why are there still 5 conversions? Has anyone got this to work accurately? 2. On the Transaction List vs. OsCommerce Admin Orders List, GA code is always rendered but I think the google servers may for one reason or another (server load?) occassionally ignore calls to the the urchin stats. This could be the cause to the GA Transaction List not being equal to my oscommerce admin list.
  3. pfaustino

    Automatically send data feed to Froogle

    It looks like an Overwrite was denied. Hedwig won't let you upload the same file twice. You have to wait until Froogle's bots have sucked that file out of the directory and erased it. You'll know when you have the right pw when you can upload files with a different name (froogle will just spit it out)
  4. pfaustino

    Automatically send data feed to Froogle

    I'm waiting for the fix so that the category string includes the entire cookie crumb and not just the last two. In the meantime, I'm trying to think of solutions to do this. One of them involves just manually editing the categories to just the top two categories. Does anyone know if froogle does not like this? They seem to have a thorough staff and was wondering if this would go unnoticed. I don't want to upload it unless I'm sure as we get a decent amount of customers from froogle. I wouldn't want froogle to see this as a breakage and wait for me to fix the feed. In the meantime, my listings might be removed.
  5. I'm having a problem with dual affiliate systems: If a visitor has come from a Shareasale affiliate then bought something, Shareasale gets credit. Then if the same visitor comes from DarkBlue later on, BOTH Darkblue and Shareasale gets credit. That's because you have both pixels showing. I need to figure out how to prevent the original pixel from showing once the same visitor comes back from the other affiliates. Basically change the code to: If the referrer is shareasale, only show the shareasale pixel If the referrer is Darkblue, only show the darkblue pixel.
  6. When you insert the shareasale pixel, you need to pass over the sub-total. Do not pass the Grand Total or it will take 10% of the grand total. That includes shipping and taxes.
  7. pfaustino

    Margin Report v1.11

    I had the same problem. It's a pretty simple fix - I can't beleive no one else is using this pulldown or they would have seen it and fixed it too. Here's the fix: edit admin/margin_report.php Find: echo ' <td align="right" class="main">' . tep_draw_form('filter', 'margin_report', '', 'get') . TEXT_SHOW . ' '; Replace: echo ' <td align="right" class="main">' . tep_draw_form('filter', 'margin_report.php', '', 'get') . TEXT_SHOW . ' ';
  8. pfaustino

    Automatically send data feed to Froogle

    Any chances of getting notification when 2.0 goes up? I already have email notification on this thread, so if you can just update this thread when the new version is up. It would be very much appreciated. ;) Patrick
  9. I was able to install this contrib and the sub-total seems to work but the order_id is wrong. In my case it was supposed to be 55 but the tracking is 112. I figured out the fix. Just change the contrib code from $orders_id=$order_products_id; to $orders_id=$insert_id; Thanks for the contrib!
  10. pfaustino

    Affiliates Error

    My hosting company recently upgraded mysql and deemed that this was a security issue and therefore revoked this privilege to all users. Rather than allowing the privileges described in the previous posts, they have asked us to comment out the code that locks the table. That seems to work BUT I don't know if it has any repercussions yet. Here's how to do it. Under /includes/functions/affiliate_functions.php, locate tep_db_query("LOCK TABLES " . TABLE_AFFILIATE . " WRITE"); and comment it out // tep_db_query("LOCK TABLES " . TABLE_AFFILIATE . " WRITE"); Let me know if I missed anything. There are some UNLOCK codes in this same file but I did not touch them. Patrick
  11. I don't know what I did but after installing the Gift Certificate contribution over a fresh install of osCOmmerce, all the fields starting from "Send Extra Orders E-Mails To" have doubled up under Configuration>MyStore and all the other guys too. It's weird because NOT ALL fields are doubled up, just some. And it only happens when the file is /admin/configuration.php.
  12. I have the Easy Populate Contribution installed along with the Quantity Price Breaks contribution. I use Easy Populate to mass change the prices on each product but had to manually change the price breaks for the other quantities above 1 because EasyPopulate was never made to work with Quantity Price Breaks. I set out changing easypopulate.php so that I could download the Complete file with all the new columns that came with the Quantity price breaks. I think I managed to do this and can now edit the CSV file with the quantity breaks and upload the file. It worked! Below is the code that I added. A couple of things to keep in mind: 1. The line numbers are approximate. 2. Basically, I looked for different locations where 'products_price' appeared and added the 9 lines of code for each one. 3. I only tested this for Complete CSV downloads and complete uploads. I don't use the other features of easypopulate. 4. PLEASE test this on a test server first. 5. This code comes with no warranty so please be careful. 6. Backup easypopulate.php Around line 213, add 'v_products_price1', 'v_products_price2', 'v_products_price3', 'v_products_price4', 'v_products_price1_qty', 'v_products_price2_qty', 'v_products_price3_qty', 'v_products_price4_qty', 'v_products_qty_blocks', Around line 940, add 'v_products_price1' => $iii++, 'v_products_price2' => $iii++, 'v_products_price3' => $iii++, 'v_products_price4' => $iii++, 'v_products_price1_qty' => $iii++, 'v_products_price2_qty' => $iii++, 'v_products_price3_qty' => $iii++, 'v_products_price4_qty' => $iii++, 'v_products_qty_blocks' => $iii++, Around line 1018, add p.products_price1 as v_products_price1, p.products_price2 as v_products_price2, p.products_price3 as v_products_price3, p.products_price4 as v_products_price4, p.products_price1_qty as v_products_price1_qty, p.products_price2_qty as v_products_price2_qty, p.products_price3_qty as v_products_price3_qty, p.products_price4_qty as v_products_price4_qty, p.products_qty_blocks as v_products_qty_blocks, Around line 1054, add 'v_products_price1' => $iii++, 'v_products_price2' => $iii++, 'v_products_price3' => $iii++, 'v_products_price4' => $iii++, 'v_products_price1_qty' => $iii++, 'v_products_price2_qty' => $iii++, 'v_products_price3_qty' => $iii++, 'v_products_price4_qty' => $iii++, 'v_products_qty_blocks' => $iii++, Around line 1078, add p.products_price1 as v_products_price1, p.products_price2 as v_products_price2, p.products_price3 as v_products_price3, p.products_price4 as v_products_price4, p.products_price1_qty as v_products_price1_qty, p.products_price2_qty as v_products_price2_qty, p.products_price3_qty as v_products_price3_qty, p.products_price4_qty as v_products_price4_qty, p.products_qty_blocks as v_products_qty_blocks, Around line 1190, add p.products_price1 as v_products_price1, p.products_price2 as v_products_price2, p.products_price3 as v_products_price3, p.products_price4 as v_products_price4, p.products_price1_qty as v_products_price1_qty, p.products_price2_qty as v_products_price2_qty, p.products_price3_qty as v_products_price3_qty, p.products_price4_qty as v_products_price4_qty, p.products_qty_blocks as v_products_qty_blocks, Around line 1359, add p.products_price1 as v_products_price1, p.products_price2 as v_products_price2, p.products_price3 as v_products_price3, p.products_price4 as v_products_price4, p.products_price1_qty as v_products_price1_qty, p.products_price2_qty as v_products_price2_qty, p.products_price3_qty as v_products_price3_qty, p.products_price4_qty as v_products_price4_qty, p.products_qty_blocks as v_products_qty_blocks, Around line 1750, add products_price1, products_price2, products_price3, products_price4, products_price1_qty, products_price2_qty, products_price3_qty, products_price4_qty, products_qty_blocks, Around line 1786, add '$v_products_price1', '$v_products_price2', '$v_products_price3', '$v_products_price4', '$v_products_price1_qty', '$v_products_price2_qty', '$v_products_price3_qty', '$v_products_price4_qty', '$v_products_qty_blocks', Around line 1817, add '" ,products_price1="'.$v_products_price1. '" ,products_price2="'.$v_products_price2. '" ,products_price3="'.$v_products_price3. '" ,products_price4="'.$v_products_price4. '" ,products_price1_qty="'.$v_products_price1_qty. '" ,products_price2_qty="'.$v_products_price2_qty. '" ,products_price3_qty="'.$v_products_price3_qty. '" ,products_price4_qty="'.$v_products_price4_qty. '" ,products_qty_blocks="'.$v_products_qty_blocks.
  13. Thanks for the quick answer. I created a temp directory under catalog but the new question is: Should I set the config to the absolute Unix address or relative to the catalog folder? The initial slash leads me to beleive that I should use the absolute Unix address: $tempdir = "/hsphere/local/home/inkpfaus/inkjetcartridgez.com/catalog/temp/"; $tempdir2 = "/hsphere/local/home/inkpfaus/inkjetcartridgez.com/catalog/temp/"; But that doesn't seem to work. I tried "Create Complete tab-delimited .txt file in temp dir" but no file is created there. I am the admin for the mysql db so let me know what I need to do here. Note that I haven't even started the import process. I'm just trying to create the sample file first. What's frustrating is that easypopulate is not outputting any errors. When I hit the "Create..." links I just get a blank screen at this url: http://domain.com/catalog/easypopulate.php...ile&dltype=full
  14. I'm using IE to execute populate.php but whenever I click on any of the sample files to generate, I get a resulting page that is completely blank - no text file. What am I doing wrong? The second option is to write the files to a /temp/ directory. The problem is I don't have root access. Can I just change this /temp/ directory to a directory that I have access to? Do I need to change both $tempdir = "/temp/"; $tempdir2 = "/temp/"; ?
×