Google Base Feeder Support Thread [OLD]

RescoCCC:

What happens if you download the file to your local system and open it with a text editor?

I believe quotes are the problem in my description of products. I have dimension such as 6"x2" which is colored in green on my Dreamweaver when I open the xml file. This happens to be the line where these quotes are located from my product description,

I created an XML file of a single product that has no quotes and I was able to see the product without feed error and upload to Google base and had is successfully entered into the Google base.

How can I get around this without edit every single area I am using quotes?

Am I on the right track here?

Thanks RescoCCC

Yep, use the word inches instead of ". That's something I learned the hard way early on. It created problems with the search results in Google Shopping.

I've just installed Version: 1.10.2 and paid attention on XML error that Google shows for generated feed. The problem is that google_base.php class function (google_base_image_url) doesn't sanitize the image name, so filenames with space, like "file name.jpg" crashes everyhing. But it's easy to fix using rawurlencode PHP function:

$products_image_large = DIR_WS_IMAGES . rawurlencode($products_image);

Equinox

I did exactly what RescoCCC mentioned and added a space before the word inches so i would appear appropriate " inches".
and I now have 530 of 530 items inserted (View warnings). Which is AWESOME!!

Here were my only 2 warnings only effecting 3 of my 530 items which I can live with:
Missing recommended attribute: image link (2 warnings)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.

Item ID Line Nr.
486 5,450 Show Item
625 7,953 Show Item

Missing recommended attribute: product type (1 warning)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.
Examples: Examples:

Item ID Line Nr.
276 1,546 Show Item

Thank you RescoCCC for all you help!

Using Zen cart 1.3.9

Just installed this , today obviously..

When I go to google, i have it download the file from http://www.google.com/merchants/bulkuploads -- and clicking "edit" "update and fetch"

After it processes, it shows 150 of 152 items entered (view errors)

I view the errors, and this is one of the biggest ones..

Missing recommended attribute: google product category (152 warnings)

and ```
Missing recommended attribute: product type (152 warnings)

and

Missing required attribute: availability (152 errors, only affecting Product Search, Search API for Shopping)

I'm so lost, i set my main options for this to show items with 0 quantity, and default of 0=5
Do I have to have an "available" date on all the products?

This thread is closed due to old information. On Sept, 22, Google started gradually enforcing the new Google products feed spec requirements. If you want your question to be answered you will have to go to the New Google Merchant Thread Here.
What part of old and closed does people not understand.:censored:

Post moved to New Google Merchant Thread

can anyone help please, i have deleted my google feed file from my admin merch page, how can i get this back please

BABY-INFORMATION:

can anyone help please, i have deleted my google feed file from my admin merch page, how can i get this back please

Just download the feed file from your Google Merchant Center account and upload it back in to the /feed folder on your site.

can anyone help please, i have deleted my google feed file from my admin merch page, how can i get this back please

done it thanks for help

ver 1.3.9h

Although I can upload my feed successfully, I get four attribute errors (see below) , that prevent my product feeds from Product Search.

Messages and errors below. The attribute errors are a bit cryptic and don't show exactly where and what errors are..?

"Missing required attribute: availability (500 errors, only affecting Product Search, Search API for Shopping)

While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.

Attribure errors:
Missing recommended attribute: brand

Expiration date is too far in the future

Missing recommended attribute: mpn

Missing recommended attribute: google product category "

These errors are common.
Here is what you need to do:

Availability: Go to Admin--Catalog---Categories/Products. For each product ensure that you have a number for Products Quantity. Further in Admin--Configuration--Google Merchant Center Feeder Configuration, ensure you have suitable values for Show Quantity, Include Zero Quantity and Default Quantity

Brand: Go to Admin--Catalog---Categories/Products. Select a Manufacturer for all your products. Or at least those that you want listed through this feed.

Expiration date....: Go to Admin--Configuration--Google Merchant Center Feeder Configuration. Look for Expiration Date Base, Select "Now" as the option. Then look for Expiration Date Adjust, Enter "29" here. (Google does not accept more than 30)

mpn: Go to Admin--Catalog---Categories/Products. Enter a value for the Product Model.

Product Category: Go to Admin--Configuration--Google Merchant Center Feeder Configuration---Default Product Category. You will need to select the correct category for your products from http://www.google.com/support/merchants/bin/answer.py?answer=160081 and enter the value here. Choose the value in XML (Google gives you the options). Enter it here and its done.

@kevinmc3
Check out the google product feed specification here:
http://support.google.com/merchants/bin/answer.py?hl=en&answer=188494#GB

Missing recommended attribute: mpn

mpn [mpn] - Manufacturer Part Number (MPN) of the item

This code uniquely identifies the product to its manufacturer. In particular, the combination of brand and MPN clearly specifies one product.

When to include:Required for all items - except apparel, media, and custom made goods, or if you're providing 'brand' and 'gtin'.
Type Alphanumeric characters
Text/Tab delimited GO12345OOGLE
XML '<g:mpn>GO1234568OOGLE</g:mpn>'

Missing recommended attribute: google product category "
For this see Google Product Taxonomy at
http://support.google.com/merchants/bin/answer.py?hl=en&answer=160081
hope this helps

I have updated the mod from the version I had, but now it will not insert any products into the feeder. I have about 10-11,000 products. From google base website the error is showing as this:
1 of 0 inserted
XML formatting error - Error
Our system encountered an error when processing your data feed. Learn more.
Examples:
Line Nr. Column Nr.
231 29

Line 231 has this:
<description><![CDATA[Case of 12/13oz- CANIDAE� All Life Stages with Chicken, Lamb, & Fish. All Natural Dog Food Formula with Three High Quality Meats: Chicken, Lamb, & Fish, Plus Essential Vitamins & Chelated Minerals. Dogs Love the Taste! Multi Meat Source Formula and All Natural Ingredients with Balanced Omega 6 & 3 Fatty Acids. CANIDAE� All Life Stages formula meets the AAFCO Dog Nutrient Profiles for all life stages. CANIDAE BENEFITS: � All Natural, High Quality, Holistic Pet Food � Easy-Open Lids � Convenient 12 pack cases � High Meat Content Loaf Style Canned Foods � Naturally Preserved Herbal Formulation � Excellent Palatability � Contains Skin & Coat Conditioners to Maintain a Healthy Luxurious Coat � Balanced Omega 6 & 3 Fatty Acids � Superior Digestibility � Made the CANIDAE� Way with Superior Quality: No Corn, Wheat, Soy, Grain Fractions or Fillers and Naturally Preserved]]></description>

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

new2u:

It seems to relate to the UPC/ISBN/EAN field.. I have the Numinix Product Fields installed... maybe something changed in that too

It works with it disabled
Google Merchant Center Feeder v1.10.2

upcisbn_product_fields_2-1 module
product_fields.sql

ALTER TABLE products ADD products_upc varchar(32) NOT NULL after products_model; 
ALTER TABLE products ADD products_isbn varchar(32) NOT NULL after products_upc;

only adds two fields - note, there is no products_ean added

solution: edit public_html/googlefroogle.php
line # 129 to remove products_ean

$additional_attributes .= ", p.products_upc, p.products_isbn";

Why are the urls in my products redirecting to non working urls?

http://www.merlinabrasives.com/feed/google/domain_products.xml

Also why are there only 50 products in the .xml feed?

Thirdly how do I automate the upload to Froogle?

Cheers

As well as what's above I remember being able to get a txt document created with all the prods in it. How do I do that?

HELP PLEASE!

I am running a ZC v1.3.9h and currently using Google Base Feeder 1.8.2, receiving the following errors/warnings:

AVAILABILITY (all products)
GOOGLE PRODUCT CATEGORIES (all products).

I would like to upgrade my Google Base Feeder to the most recent version (1.12.5) but do not want to make any mistakes.

Here is what I plan to do:

1. Backup (sql and files)
2. Upload 1.12.5 files
3. Run patch (update_1_12_4.sql)

Will this work? Or do I need to completely uninstall first, then install 1.12.5?

Thanks,
Mike

we have over 20,000 products and the Processing Feed always gets timeout. Anyway to fix it? We are still on zen cart 1.3.9h. Thanks in advance!