Community Add-Ons

it should now be working with chemo's ultimate seo urls contribution

only updated file

Description:
This mod will add the ability to add PRE and POST text to your titles and descriptions and also a REFID to your URL.
I used the REFID with the OSC affiliate mod to do product tracking. Set up an affiliate account for each website, ie froogle, yahoo etc..
The pre and post title and description text is useful for adding text that may be needed when viewed by buyers on feeder sites, but would be out of place on your actual website. I use this for coupon codes to attract buyers.

I have also added the ability to make the feeder files that are created clickable so you can view them easier.
I have added a sql file for easy upgrades.
I have only changed froogle_us.php, froogle_uk.php, and froogle_de.php as it is the only feeder I use, but you should be able to use these changes in any other feeder files with minimal effort.

Example: If your actual title is, Flamingo. With my pre and post text mod you could make it show as, Pink Flamingo Accessories. The Word pink is your PRE title word, and Accessories is your POST title word. The pre and post title and description adds will be on ALL of the items in your feeder files, so be sure it makes sense to add them to all your items.

This mod is based on the contribution "Automated Store Feeds v3.3b" and all previous credit should be give to everyone that helped with its creation. I simply added some adjustments and improvements to allow features I needed and I thought would be helpful to others.

Please view the readme file for more info.

Screenshots are included in the zip file for the configure screen and the clickable feeder file.

I Use this mod on www.azcustomshirts.com and it works great.

Fixed SQL injection. The previous upload named the new row 'test'. I used test as a placeholder and forgot to remove it. Sorry for the confusion. Every thing should work 100% now.

Update only. Not the full package.

this contribution addresses the need for a MPN and UPC in the feed to Google Base. It uses the model_number field for the MPN and creates a new field for the UPC that can be entered while creating or editing products, will be displayed on product_info.php, and will be included in the feed to Google Base.

Basically we are just duplicating the stock code to edit and display the model_number in osCommerce, and applying it to a new UPC field.

Screenshots included.

Updated SQL to work with MySQL 5.x.

Just needed some extra parenthesis around FROM statements.

Package only includes changed files.

Updated the Google Base feeds to include the "model" field as well (using the "product_model" field of the database)

(Optional update)

Made the feeds compliant to the new (Feb 2007) Google Base attributes requirement.

This is a complete package, including the DB value installer from dave111 (v3.2b)

Instructions to update from v3.2 are included (just the 3 Google Base feed files to copy)

Added a DB value installer (for those you do not have access to phpMyAdmin or similar)

This is a full package, same as v3.2a plus installer.

Bug/fixes:
- Fixed a bug that prevented the items to be listed in Google Base US *and* UK: Changed the id for the US and UK version, so that they have distinct ids.

This is a complete package.

Added support for multi-languages stores, to generate feeds in the choosen language for Google Base (US, UK and Germany) and in English with USD for bidhopper.com

New features:
- Modified the Google Base feeders to permit to select the language of the feed. (Useful especially for non-English stores.)
- Created a froogle_us.php, froogle_uk.php and froogle_de.php for easy submitting to the different localizations of Google Base.
- Modified the sql file to insert entries in the database
- Updated the admin interface
- Modified the output of the id (last field of the feed) of the froogle feed, to respect the specifications of Google Base. (You need to have different ID for products submitted to Google Base US than for those sumbitted to Google Base UK & DE, otherwise Google considers them duplicate and removes them. So added a simple "us", "uk" and "de" to the id.)
- Fetching of the path is now done automatically (no need for manual editing) if currency conversion is enabled in the Google Base feed

- Modified the bidhopper feeder to get the prices in special (and not the normal prices) for special items:
- Modified the bidhopper feeder to specifically select the English language (useful for shop who don't have English as their default language)
- Modified the bidhopper.com feeder to accept currency conversion to USD.

Bug/fixes:
- Fixed an error of a double "/" in the path of the Froogle feed

Includes the previous bidhopper.com update of Jan 7th, 2006.
Does not include the previous edirectory feed and it's update of Nov 10 & 15, 2006.

Update for bidhopper.com feed v2.2

New in this version:
- Enabled currency conversion

Installation:
Simply copy the file "bidhopper.php" in your osCommerce installation directory, over the previous file.

This is *not* the full installation. You still need to download the latest version of Automatic Store Feeds (currently "Automatic Store Feeds v3.1" of 30 aug 2006).

added variable
show_zero_qty

you can set to true or to false.

also some changes as recomended by edirectory admin.

This is only feed file for update.

This is only addon to this contribution. Not full version.

Made some minor adjustments to coding based upon developer feedback and some suggestions by Google Base technicians.

This is the FULL release:
---------

v3.1: 8/30/2006:

/catalog/admin/froogle.php
- added new LABEL field for keywords.
- made LABEL field dynamic to pull product_name, product_model, and manufacturer_name as keywords IF they exist.

/catalog/admin/froogle.php & bizrate.php & yahoo.php
- corrected directory error: previous code did not accomodate for developers using both /catalog/ or /, so new code accomodates for this.
- image issue: previous code would pull in http://www.yoursite.com/images/ in the IMAGE_URL field even IF an image did not exist. This was causing rejection of froogle feed files, so this was corrected so IF image does not exist, it leave those fields blank for each feeder.

AUTOMATED STORE FEEDS SYSTEM v3.0
8/13/2006

This contribution is a combination of the Froogle (Google base), Yahoo, Bizrate, and the new Bidhopper Store Feed contributions plus the added admin configuration group for easy install.

This contribution was created as an improvement to the existing 'store feeders' contribution with the addition of tons of new features including the new BidHopper.com feed.

It is now VERY customer friendly.

This contribution has been tested to work in all unmodified and modified versions of oscommerce MS2.2.

Credit goes to original creditors of each corresponding module, especially David from AdvancedStyle.com who created the much needed admin configuration section for easy install.

---------------------
VERSION NOTES:
---------------------
v3.0: 8/13/2006:
Bruce Hakala

/catalog/admin/feeders.php
- customer friendly layout, introduction, and multiple column setup in preparation for future store feed contributions to be incorporated.
- multiple columns including quick links for each provider to RUN FEED, DOWNLOAD (if file exists), SIGN-UP, and LOGIN.
- description added for each provider and indicator if store feed service is free or fee based.
- trouble shooting section.

/catalog/admin/froogle.php , yahoo.php, bizrate.php:
- updated file headers to exclude the CATEGORY column, since Google informed me that they are no longer using it.
- trim out HTML and ' from product descriptions IF exist (common with the WYSIWYG editors)
- query update to ignore any products with a $0 or NULL price, commonly found in the 'CALL FOR PRICE' contribution. Works even without it.
- query update to ignore products with status of 0 (turned off).

/catalog/bidhopper.php:
- query update to ignore any products with a $0 or NULL price, commonly found in the 'CALL FOR PRICE' contribution. Works even without it.
- query update to ignore products with status of 0 (turned off).
- updated coding to dynamically pull store URL, so it no longer requires opening and configuring file.

---------

I welcome all comments, suggestions and feedback to improve upon this system.

Enjoy
~ Bruce