Re: Google Base Feeder Support Thread
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.
Re: Google Base Feeder and New Google Unique Product Identifiers Requirement
Quote:
Originally Posted by
Boatersplanet
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!
Re: Google Base Feeder and New Google Unique Product Identifiers Requirement
Quote:
Originally Posted by
sigung
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...
Code:
#1146 - Table 'boater6_test.zen_products_description' doesn't exist
Re: Google Base Feeder Support Thread
do you have a prefix on your tables? If not remove zen_ from the three spots where it exists or replace with your prefix
Re: Google Base Feeder and New Google Unique Product Identifiers Requirement
Quote:
Originally Posted by
Boatersplanet
Sigung- I appreciate your help. However, i receive this error when trying to run that syntax...
Code:
#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.
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
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
delia told you right. If you are not using a prefix then remove the zen_ from the sql statement.
Re: Google Base Feeder Support Thread
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.
Pls give me a help!The feed can not be completed
[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].:oops:
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
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.
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.
Re: Pls give me a help!The feed can not be completed
Quote:
Originally Posted by
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].:oops:
Turn on debug and look at the messages... Any indication what happens to the other products? I assume they are all PRODUCTS?
