Google Base Feeder Support Thread [OLD]

[delia]

One more thing about this version. He did change the documentation and the javascript doesn't seem to be working in Firefox so you can't see the full page text.

I just installed this newest version on one of my sites that had the older version on it. I had been fighting getting the products to exports - hundreds weren't. Now all but 2 are and google accepted all but 2 online. I have no clue what the difference is but the last version wouldn't accept & and wouldn't export any product with that. Many of these products are coffee creamers and had half & half in them. So they are all exporting now.

[sigung]

I believe this is the reason why my feeds are incomplete..

Is there a way to allocate other product fields such as UPC etc. to fulfill these requirements? I have thousands of products that have a model# and UPC, but no description. How could I allocate the product title to the description ONLY for products with no description???

Example HERE

Yes, you can use this sql statement:

UPDATE zen_products_description
SET zen_products_description.products_description = concat(zen_products_description.products_name,' ',zen_products_description.products_description)

Unfortunately, this will also add the product title and a space before the product description of products that already have a description. I couldn't figure out an sql statement that would ONLY add the product title to products with an empty description leaving all other descriptions intact, so I figured this would be a decent compromise. It will add the product title (and an invisible space at the end) to product descriptions that are empty, and will add the product title and a space before any existing product descriptions. The space is purely for cosmetic reasons, otherwise, it would run the two together in fields that already have a description.

MAKE SURE YOU BACK UP YOUR SQL DATABASE AND DOWNLOAD IT BEFORE YOU RUN THIS STATEMENT!

[Boatersplanet]

Yes, you can use this sql statement:

UPDATE zen_products_description
SET zen_products_description.products_description = concat(zen_products_description.products_name,' ',zen_products_description.products_description)

Unfortunately, this will also add the product title and a space before the product description of products that already have a description. I couldn't figure out an sql statement that would ONLY add the product title to products with an empty description leaving all other descriptions intact, so I figured this would be a decent compromise. It will add the product title (and an invisible space at the end) to product descriptions that are empty, and will add the product title and a space before any existing product descriptions. The space is purely for cosmetic reasons, otherwise, it would run the two together in fields that already have a description.

MAKE SURE YOU BACK UP YOUR SQL DATABASE AND DOWNLOAD IT BEFORE YOU RUN THIS STATEMENT!

Sigung- I appreciate your help. However, i receive this error when trying to run that syntax...

#1146 - Table 'boater6_test.zen_products_description' doesn't exist

[delia]

do you have a prefix on your tables? If not remove zen_ from the three spots where it exists or replace with your prefix

[sigung]

Sigung- I appreciate your help. However, i receive this error when trying to run that syntax...

#1146 - Table 'boater6_test.zen_products_description' doesn't exist

I can't be sure, because I have not looked at your sql database, but I think it's unlikely that you have a table named:

boater6_test.zen_products_description

You will have to substitute your actual table names, so go into your phpmyadmin, look at your database names, and substitute your database names in place of the examples I gave you.

[countrycharm]

do you have a prefix on your tables? If not remove zen_ from the three spots where it exists or replace with your prefix

delia told you right. If you are not using a prefix then remove the zen_ from the sql statement.

[mydanilo]

Newest version just does not work for me. Re installed 1.9.1 and started fixing some product description that the feeder skipped. Not sure what it is in my descriptions that it did not like but all I had to do is edit the product with Fckeditor and re saved. Then it worked. Seems to clean up some stuff when saving again. On other products there were spell errors and after fixing the feed worked on these as well. So debug helped identifying the skipped items and fixing them. I guess no need for upgrading until we hear from Numinix.

[vanian777]

[FONT="Times New Roman"]The following tips:
Google Merchant Center Feeder v1.9.1 started 2011/06/18 05:40:44
Feed file - /home1/ambercra/public_html/oilpainting777/feed/googleabstract_oil_paintings_products_1000_1.xml
Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 0.877804 Seconds 18 of 18 Records

i have 2000+ productions ,but not the addon just export 18[/FONT].

[willieWontGo]

Newest version just does not work for me. Re installed 1.9.1 and started fixing some product description that the feeder skipped. Not sure what it is in my descriptions that it did not like but all I had to do is edit the product with Fckeditor and re saved. Then it worked. Seems to clean up some stuff when saving again. On other products there were spell errors and after fixing the feed worked on these as well. So debug helped identifying the skipped items and fixing them. I guess no need for upgrading until we hear from Numinix.

Yep, getting similar errors in the descriptions; and then have to go back and edit, it's somewhat of a pain.

I initially thought it was because of tables I have set up within the description(s), but that is not the case.

[mydanilo]

[FONT="Times New Roman"]The following tips:
Google Merchant Center Feeder v1.9.1 started 2011/06/18 05:40:44
Feed file - /home1/ambercra/public_html/oilpainting777/feed/googleabstract_oil_paintings_products_1000_1.xml
Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 0.877804 Seconds 18 of 18 Records

i have 2000+ productions ,but not the addon just export 18[/FONT].

Turn on debug and look at the messages... Any indication what happens to the other products? I assume they are all PRODUCTS?