Quote Originally Posted by ericny View Post
I just installed and run Google Base Feeder. Some of my products did not get written to the XML file.

I compared the data of the ones that worked and ones that did not and found that as soon as I enter a value into PRODUCTS table PRODUCTS_PRICE_SORTER the product gets written to the file and the value from PRODUCTS_PRICE_SORTER goes into <grice>12345.00</grice> tag.

The reason I do not have anything in PRODUCTS_PRICE_SORTER is because i am using product price attributes where product's price is structured as follows:

Product 1: 30
60
90

Product's attribute price is stored on PRODUCTS_ATTRIBUTES table. Is there a way to get the feeder program to recognize the attributes and read the correct table?
The script is getting a little more complicated in 1.6.1 but under the case "products" section, you can add to extract the product attributes from TABLE_PRODUCTS_ATTRIBUTES and then if that exists, replace $price with the attributes price.

However, if you have three products with everything the same but the price, Google will need a unique ID for each one which won't be product id, model, etc... I would set one as the default price and then it's option will be +0.00 and the other options +30 +60 that won't appear in the feed but will still be noticed as most people would never click on the two more expensive items as all other things are equal. Is this making sense?

Samsung 19" LCD MONITOR

OPTIONS:

BLACK -> +0
SILVER -> +30
METALLIC BLUE -> +60

You'd then need to feed the option name as a separate attribute, change the price, and then somehow come up with a unique id that can be derived from the database for each separate product.