Google Base Feeder Support Thread [OLD]

[bloomingvine]

Just wanted to let everyone know.. the new shipping requirements to the google base feed have been extended to september.

Just read on the google merchant blog On March 14, we let you know about a new set of data requirements for Product Search merchants. As part of these changes, we communicated that shipping and tax information would be required in your data feeds as of June 6.

However, based on feedback we’ve received from merchants, we are extending the deadline until September 1, allowing you more time to modify your data feeds. We are also permitting estimates for tax/shipping information. However, we recommend reviewing the submission options and submitting the most accurate information that you can, as this ensures the best experience for shoppers.

http://googlemerchantblog..com
So no need to go crazy this monday. Is there anything I need to do or watch for any fix for my feed by then? I am unclear as to weather shipping information as is in the feed will suffice.

[willieWontGo]

My feed runs ok, but I get the following error:

1054 Unknown column 'p.products_upc' in 'field list'

Any ideas how to remedy this issue?

[BlessIsaacola]

My feed runs ok, but I get the following error:

1054 Unknown column 'p.products_upc' in 'field list'

Any ideas how to remedy this issue?

You need to install either the numinix product fields or the other mod in the admin that creates the UPC/ISBN in your product table.

In the log run the Numinix Product fields will be your best bet and the link to the mod is here: http://www.numinix.com/zen-cart-modu...product-fields

Please keep in mind that it's for 1.3.9g so you will have to compare the core files overriden to your current installation if it's newer than 1.3.9g (which should be 1.3.9h).

[willieWontGo]

You need to install either the numinix product fields or the other mod in the admin that creates the UPC/ISBN in your product table.

In the log run the Numinix Product fields will be your best bet and the link to the mod is here: http://www.numinix.com/zen-cart-modu...product-fields

Please keep in mind that it's for 1.3.9g so you will have to compare the core files overriden to your current installation if it's newer than 1.3.9g (which should be 1.3.9h).

Thank you for the suggestion!

I see the Numinix download contains new files as well as other files that will be modified. I understand that part of it.

However, there are also separate folders with 'optional fields'? One of them is titled "upc_isbn", do I need to add those as well?

Thank you very much for your help.

[willieWontGo]

Darn, now I get the following error:

1054 Unknown column 'pd.products_description2' in 'field list'
in:
[SELECT p.products_weight, pd.products_description2 FROM zen_products p, zen_products_description pd WHERE p.products_id = 4 AND p.products_id = pd.products_id AND pd.language_id = '1' LIMIT 1]

What could I be missing?

[willieWontGo]

Just discovered I did not install the "Second Description" folder and corresponding sql code.

[willieWontGo]

OK, finally got this baby to work.

Checked the debug logs and found the errors: PHP Warning: htmlentities() [<a href='function.htmlentities'>function.htmlentities</a>]:......includes/classes/google_base.php on line 277........

Looked back in this thread, and followed the advice:

Inside includes/classes/google_base.php, I changed the code on Line 276, and then commented out Line 277.

Bada bing, bada boom, zero errors!

Uploaded to a Google Test Feed. Uploads fine, but I get a warning that the Weight descriptors are not included.

The only thing, now I have a Second Description field that I did not want, but installed it so I could get this to work.

All in all, it's a good day!