Skip to main content

Automatic Store Feeds v.3.0 - Reviewed

OSCommerce web-shop package is a winner in many ways, offering a huge number of out of the box features, and a vibrant community that has made some 4000 additional features. So basing our web-sales at on OSC hasn't been a bad decision.

The sales power of our OSC shop at has just now started to be even more promising. The Automatic Store Feeds 3.0 (ASF 3.0) contribution provides features to automatically submit shop contents to multiple sales channels like Google Base (aka in past life Froogle, US, UK & DE), Yahoo! Shops, BizRate and BidHopper. This basically means an online merchant is able to harness those sales channels for his/her products with minimum effort.

Installation of ASF 3.0 hasn't been trouble free though. Here's a log of problems encountered, for anyone facing the same...

MySQL 5.0 Incompatible

There have been modification is the left join construct which breaks some of the SQL used in this contrib. So you have the option of fixing the SQL, or deploying on a MySQL 4.x server.

Activating Files as Administrator

This was a minor hassle that arose because the installation documentation didn't mention. The error noted was:
"Access Denied No Right Permission Access
Please contact your Web Administrator to request more access or if you found any problem."
This is fixed by providing access to the files under Admin -> Administrator -> File Access -> StoreFeeds. Pointers in the below graphics should lead to the solution..

Bid Hopper URL (lines 29, 30)

$_SERVER['HTTP_HOST'] doesn't always work, better to use the configure.php variable HTTP_CATALOG_SERVER. Don't forget to delete the "http://" in lines 29, 30.

The bidhopper.php file should be installed in the /shop path, which is publicly accessible. In my case, since I have /admin separated from /shop (admin not nested in shop), the default instructions didn't work.

froogle_us.php URL (lines 17, 18, 38, 48)

Similar to the BidHopper issue above, froogle_us.php lines HTTP_SERVER on 17, 18, 38, 48 should be replaced with HTTP_CATALOG_SERVER.

Similarly adapt froogle_uk.php and froogle_de.php

MySQL Connection String (line 39, 89, 117)

mysql_query() is used instead of the standard tep_db_query(). This shouldn't make a difference for 99% of the users out there, but if you are using multiple databases in your shop (ex. customized stuff), you'd better stick to the standard OSC tep_db_query() method.

Default Location of Items (G-Base Error: We didn't understand this location)

At line 94 in froogle_us.php it is necessary to edit the $default_location variable and set it to the Google prescribed format of [street, city, state, postal code, country]. Longitude/Latitude data should apparently also work, though I haven't tried this myself.

Similarly adapt froogle_uk.php and froogle_de.php


Popular posts from this blog

Paypal's Ridiculous Business Practices

In Q3-2005 we discovered the power of online sales and started to market Wapsol's products extensively online. Just as importantly we decided to get into the trading business for WLAN accessories (antennae, cable, connectors etc) which entails buying from manufacturers and selling on online-retail. Needless to say ebay's 26 worldwide markets were lucrative points of sales.

We used Paypal for collecting most of payments from customers outside Germany. The numbers ticked up fast and we were hecticly building up infrastructure for shipping, online-support, product-portfolio and payment-systems.

One morning as I woke up in Germany I found that Paypal decided to lock up our account without any specific reason. There were no disputes or complaints from buyers or anything that suggested provocation. They just locked it. In it a few thousands of dollars of cash-flow and the account was listed as a favored payment option for some 100 pending auctions - now customers couldn't pay for …

The Dream of the Information Age

If this beauty of a device meets it's mission of being owned by every kid on the planet, we are looking to a new dimension of the Information Age.
For full profile of the device, visit BBC's technology page.

SnagIT Problem Solved! (Hangs for minutes)

Here's the solution to the SnagIT sluggishness (hangs for several minutes)
I would try first turning off the magnifier window under tools > program preferences > program options. Uncheck the box to show magnifier windows. Click apply > ok and then try the capture again.Check your security software and make sure that Snagit is set as a safe application. A security program that consistently scans the process will cause a very slow response like you are seeing.Please also check your printers per this article:Answer Title: Slow SnagIt startupAnswer Link:, please review the steps here and try these as well:Answer Title: SnagIt crashes or hangs when launchedAnswer Link: me know what happens.