Contributions

Replace more pics compatible sql with stock osc

For those of you who do not have descriptions against every product you now have the option to use the product name or a default text string.

Zip file does not appear to be downloadable on previous contribution so here goes again.

March 25, 2010 - Geoffrey Walton
Updated to allow stock to be set as follows
Use true stock figures
Use true stock figures but change zero and negatives to a default level.
Set all stock levels to a default level.

Removed language, manufacturer's id and model no as per http://www.google.com/support/merchants/bin/answer.py?hl=en_US&answer=160373

Added in tax

Additional code added to allow UPC/EAN/IBSN and manu part no to be easily added to the feed if new fields have been added to the product table.

This will enable you to stop getting a "Missing gtin" message. http://www.google.com/support/merchants/bin/answer.py?hl=en_US&answer=160161

Changed to switches from 0/1 to true/false to make it more understandable.

Added in field separator selection

New param to output a product if it is active or there is stock. (how do you sell inactive products as will not appear on site.)

Changed code to work with shops in root and catalog type directories.

Now works with configuration files in /includes/local for testing.

Set up support thread : http://forums.oscommerce.com/topic/356345-google-base-feeds/

Earlier version had problem with Google due to header html tages. This one works fine even though tab settings are not visible at the URL of this file.

Google Base Report:
- - - - - - - - - - - - - - - - - - - - - - - -
Feed status details:

Outcome: Success
Number of items processed: 266
Number of inserted items: 266
Uploaded at: Feb 12, 2009 4:30 am PST
Processed at: Feb 12, 2009 5:06 am PST

* Detected delimiter: Tab (t)
* Detected encoding: US-ASCII
* Detected file format: Text

- - - - - - - - - - - - - - - - - - - - - - - -

Special Prices were not showing up in the earlier version. They show up correctly in this version.

This feeder has been revised to work with Ultimate SEO URLs contribution with all the current requirements of Google Base with proper tab settings. Many changes have been done to the earlier version. This contribution will auto generate Google Base Data Feed and you can let Google Base auto upload this file.

This contribution can let the google base upload a data feeds from your site, but this file is not a static txt file(even the file is a txt file, but the content is auto generated), It's a file that auto generated, so the google base always can get the latest products information from this data feeds file