Community Add-Ons

Change to make the Feeder compatible with the separate price per customer (SPPC) contribution.
Every product which is configured to be hidden from retail-users (customers not logged in and standard customers) is automatically excluded from the feed.

Additionally a small bug is fixed - OPTIONS_DEFAULT_FFEED_LANGUAGE occured in the feed caused by a typo.

Please note: this is not a full package, it contains only the patched googlefeeder.php.

The current version of this contribution hardcodes in series 2 seo urls which means that no others can possible work with it.

This revised googlefeeder.php does two things: -

1) Removes the hardcoding so that the propper tep_href_link() function can be used (e.g. with Ultimate Seo Urls 5)
2) Corrects the aweful query that returns 247 rows where it should return just 27 on a stock osCommerce.

Please see the instructions.txt for a small change to the cron and a small USU5 update.

- Changed expiration date, as mentioned by kmb40, to shorten the expiration date and prevent google errors
- Changed how manufacturer and manfacturer ID (now product model) are handled.
- Corrected spelling mistake for manufacturer (found by mdtaylorlrim)
- Fixed installation instructions for the feeder link as noticed by user buysellleasetrade
- Added code to exclude products listed as Quotes from that contribution
- Added code to handle product attributes
- Added option to easily turn tax calculation on and off
- Added option to skip some manufacturer names
- Added Version Checker code to allow easy checking for updates

This is the full package.

Support Thread:
http://forums.oscommerce.com/index.php?showtopic=71088

- Added code to include for tep_not_null, which is a failure for some installations
- Changed deprecated label column heading to product_type
- Changed installation instructions to include setting up a feed creation link in admin


This is the full package.

Support Thread:
http://forums.oscommerce.com/index.php?showtopic=71088

- Fixed mysql code for specials

This is the full package.

Support Thread:
http://forums.oscommerce.com/index.php?showtopic=71088

Fixed a mistake I introduced in the last version. Use this one instead.

This is the full package.

Support Thread:
http://forums.oscommerce.com/index.php?showtopic=71088

- Fixed coding error that was only seen when the currency type was enabled.
- Added the product weight option.

This is the full package.

Support Thread:
http://forums.oscommerce.com/index.php?showtopic=71088&st=386

- Rearranged code to make setting up the options easier.
- Enabled the options, condition in particular, so google doesn't complain.
- Works with Ultimate SEO.

This is the full package.

Support Thread:
http://forums.oscommerce.com/index.php?showtopic=71088&st=386

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.

Updated Admin layout alot, made it all work together nice and neat.

Scott

Added the weight attribute into a complete package


Full Package

Use this version for use with SEO-G located at:
http://addons.oscommerce.com/info/5080

This package only contains the googlefeeder.php file.
To install, please overwrite in your admin directory.

nerd Design Group, inc.
nerdDesignGroup.com

The product weight doesn't get put on the feed page, or google unless this fix is done...

Updated googlefeeder.php is attached for fix.

Thanks for this great contribution. And just tested it, and got some bugs, to make it work with Ultimate SEO url, there are two bug fixes in googlefeeder.php:

1. change :

$SEO_FLAG = 0; //default = 0

to

$SEO_FLAG = true;

2. change:

$_cleaner_array = array(">" => "> ", "®" => "", "? => "", "™" => "", "?=> "", "t" => "", " " => "");

to

$_cleaner_array = array(">" => "> ", "®" => "", "?" => "", "™" => "", "?" => "", "t" => "", " " => "");

thanks.

Shobi

Google Base / Froogle Data Feeder v1.20
Released By: Calvin K
E-Mail: calvink@conceptualnetworking.com
------------------------

Date: February 25, 2006
Creates and automatically sends a data feed to Google Base and Froogle using Google's new unified feed specification. This Google Data Feeder, handles product duplicates, specials(if available), currency conversion, tax support, SEO links, html descriptions, full category trees, and automatic upload. In addition, the Google Data Feeder supports advance feeds. With the advance feed option enabled and the "quantity" field enabled, it will create a feed with all of the products. Without the advance feed option enabled, it will only submit in stock items.

Note: v1.10 was not publically released, but are included in v1.20 and includes SEO link capabilities.

Feature: v1.20 updates the feed attribute requirements to Google's new February 2007 Requirements.

Forum Thread: http://forums.oscommerce.com/index.php?showtopic=71088&st=386 (aka FlyingMonkey on the forums)

Just got an e-mail from GoogleBase that they are sharpening their attributes rules.
http://base.google.com/base/products.html

"Quote"
That's why we're asking all Froogle merchants to send us bulk uploads in the Google Base format, with five additional attributes (along with the basic ones you've submitted in the past). Because we think it's important to provide a consistent user experience, we will no longer list items that don't meet a minimal number of attributes by the end of February 2007 "UnQuote"

This is why I had to add 4 new conditions, added file googlefeeder.php only, look in the file for lines marked with "// 31 jan 2007 Added condition due to Froogle making mandatory"

Dont replace your googlefeeder.php with this one, just look for the changes and implement the ones you need according to the google URL above.

Same as below, but with a fix to prevent items on special without an expiration date being listed at regular price.

googlefeeder.php only, download 1.03 full package first. Ignore v 1.03a

I edited v1.03 and added Ultimate SEO URL code from an earlier version of this contribution. It works fine for me and should for anyone else until FlyingMonkey puts out his own. This will work with Ultimate SEO URLs 2.1d only - no other SEO contribution is supported.

googlefeeder.php file only, download v1.03 first.

Google Base / Froogle Data Feeder v1.03
Released By: Calvin K
E-Mail: calvink@conceptualnetworking.com
------------------------

Date: September 23, 2006

Description: Creates and automatically sends a data feed to Google Base and Froogle using Google's new unified feed specification. This Google Data Feeder, handles product duplicates, specials(if available), currency conversion, tax support, html descriptions, full category trees, and automatic upload. In addition, the Google Data Feeder supports advance feeds. With the advance feed option enabled and the "quantity" field enabled, it will create a feed with all of the products. Without the advance feed option enabled, it will only submit in stock items.

Forum Thread: http://forums.oscommerce.com/index.php?showtopic=71088&st=386 (aka FlyingMonkey on the forums)

Bug Fix: This fixes a bug when advanced options is enabled related to quantity.

Google Base / Froogle Data Feeder v1.02a
Released By: Calvin K
------------------------

Date: September 14, 2006

Description: Creates and automatically sends a data feed to Google Base and Froogle using Google's new unified feed specification. This Google Data Feeder, handles product duplicates, specials(if available), currency conversion, tax support, html descriptions, full category trees, and automatic upload. In addition, the Google Data Feeder supports advance feeds. With the advance feed option enabled and the "instock" field enabled, it will create a feed with all of the products. Without the advance feed option enabled, it will only submit in stock items. The Google Data Feeder is based on my stable Froogle Data Feeder.


Forum Thread: http://forums.oscommerce.com/index.php?showtopic=71088&st=1633 (aka FlyingMonkey on the forums)

Author: calvink@conceptualnetworking.com

Added: Readme Fixed

Google Base / Froogle Data Feeder v1.02
Released By: Calvin K
------------------------

Date: September 14, 2006

Description: Creates and automatically sends a data feed to Google Base and Froogle using Google's new unified feed specification. This Google Data Feeder, handles product duplicates, specials(if available), currency conversion, tax support, html descriptions, full category trees, and automatic upload. In addition, the Google Data Feeder supports advance feeds. With the advance feed option enabled and the "instock" field enabled, it will create a feed with all of the products. Without the advance feed option enabled, it will only submit in stock items. The Google Data Feeder is based on my stable Froogle Data Feeder.


Forum Thread: http://forums.oscommerce.com/index.php?showtopic=71088&st=1633 (aka FlyingMonkey on the forums)

Author: calvink@conceptualnetworking.com

Added: Missing files to package again

Google Base / Froogle Data Feeder v1.00
Released By: Calvin K
------------------------

Date: September 5, 2006

Description: Creates and automatically sends a data feed to Google Base and Froogle using Google's new unified feed specification. This Google Data Feeder, handles product duplicates, specials(if available), currency conversion, tax support, html descriptions, full category trees, and automatic upload. In addition, the Google Data Feeder supports advance feeds. With the advance feed option enabled and the "instock" field enabled, it will create a feed with all of the products. Without the advance feed option enabled, it will only submit in stock items. The Google Data Feeder is based on my stable Froogle Data Feeder.


Forum Thread: http://forums.oscommerce.com/index.php?showtopic=71088&st=1633 (aka FlyingMonkey on the forums)

Author: calvink@conceptualnetworking.com

Added: Missing files to package

Google Base / Froogle Data Feeder v1.00
Released By: Calvin K
------------------------

Date: September 5, 2006

Description: Creates and automatically sends a data feed to Google Base and Froogle using Google's new unified feed specification. This Google Data Feeder, handles product duplicates, specials(if available), currency conversion, tax support, html descriptions, full category trees, and automatic upload. In addition, the Google Data Feeder supports advance feeds. With the advance feed option enabled and the "instock" field enabled, it will create a feed with all of the products. Without the advance feed option enabled, it will only submit in stock items. The Google Data Feeder is based on my stable Froogle Data Feeder.


Forum Thread: http://forums.oscommerce.com/index.php?showtopic=71088&st=1633 (aka FlyingMonkey on the forums)

Author: calvink@conceptualnetworking.com