Google Base Feeder Support Thread [OLD]

[sash]

Thought i might be back soon,, i get this error when i click confirm, ive went back about 100 pages and not seen a definite answer

1054 Unknown column 'p.products_condition' in 'field list'
in:
[SELECT distinct(pd.products_name), p.products_id, p.products_model, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, p.products_date_available, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_condition FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id)WHERE p.products_status = 1 AND p.products_type <> 3 AND p.product_is_call <> 1 AND p.product_is_free <> 1 AND pd.language_id = 1 GROUP BY pd.products_name ORDER BY p.products_id ASC;]

[marvin]

Still have problem that feed runs but no products are in feed file!!!

Confirmation shows:

Google Merchant Center Feeder v1.10.2 started 2011/10/17 21:23:48
Feed file - /home/herbschi/public_html/sourceforherbs.com/feed/sourceforherbs_products_en.xml
Processing: Feed - Yes, Upload - No
---------------------------------------------------------------------------------------

DEBUG shows the following:
[17-Oct-2011 20:45:50] PHP Fatal error: Call to undefined function zen_generate_category_path() in /home/herbschi/public_html/sourceforherbs.com/includes/classes/google_base.php on line 233

How do I correct this??

[PinkLeopard]

Attribute "availability":::

How is this added through Zen-Cart by Google Merchant Feeder?

I thought it was "unit in stock"?

It does not seem to connecting with the cart.

Any suggestions?

I have read through this forum and there does not seem to be answer for it.

[marvin]

Try "in stock"

[mikebr]

Hi Marvin
Will the google feeder work with Ceon 's URI mappings?

[Linux]

anyone have it working?

[jo_h1971]

Hello

Can anyone tell me if the newest version of the google base feeder is compatible with zencart version 1.3.8a?

Thanks

[ideasgirl]

Then you are not doing something that's preventing your extra attributes from being included. They're on my feed as in the examples below. Zero items rejected. Make sure you link up the extra attributes to all your items.

<g:gender><example></g:gender>
<g:size>example</g:size>
<g:color><example></g:color>

Do you have to add them to ALL products for it to work? I was doing a test before proceeding to do all products with only 1 of the products.

[delia]

one of the reasons why it's hard to get answers in this thread is that there are so many folks asking for help who don't bother even going back a few pages to see what might have been just asked. Several of us are trying to reply here but it's very time consuming.

I just used Numinix's latest version of 1.12.0 that he released on Sunday. I have seen no problems with it. If anyone else has used it, please post your results here. I will upload it to zen cart if no one reports any problems.

This version has added support for

UPC, EAN, and ISBN as attributes
all new required attributes (size, material, age group, gender, google product category, pattern, and color) either through Stock by Attributes or as regular attributes

I don't know if he means the existing stock by attributes mod cause he said he was going to write his own. I'll let you know later - if someone else doesn't report good things before I get to it. The 1.10.2 version does not work with stock by attributes

mikebr
no problem with ceon uri - but of course does not use the ceon urls in the feed

PinkLeopard
asked and answered many times so far - turn on show quantity and default quantity is 0

marvin
you don't have the entire mod uploaded or are mixing versions

sash
turn condition to false - you do not have the numinix product fields installed

ATSWorld
have you turned on debugging? Nobody can answer your question without a lot more information. Thanks Fez-o Joe for your response

jo_h1971
should be compatible with 1.3.8a, anything before that probably not.

ideasgirl
for google probably yes, for export from your cart, no

Linux
I'm tempted to ignore your question. I hate getting sarcastic or irritable in this thread and I generally manage not to but ......
The answer is yes or else most of the zen cart community would not have their products on Google.

[ideasgirl]

ideasgirl
for google probably yes, for export from your cart, no

Then the generated feed is not working.

Let me be more specific since I'm not a noobie and I've read a lot through this thread.

The module WORKS, the feed is generated and uploaded to Google without problems. The problem that I'm facing is Google validating or approving the items.

With that cleared, let's go now to the real problem. That issue is caused because of the attributes not being included. To test this I created a test item WITH the needed attributes of color, gender, and age (no size is needed for these).

I created the attributes and applied it to the item in question. When the feed is generated the attributes applied for the item are NOT included in the feed.

I added those attributes manually to the feed to see if that was the problem and it was since they got approved.

The ONLY problem I'm having is that the attributes FORCED NOW by Google are not being generated. OR maybe I'm not adding the attributes with the correct name (which is not explained anywhere). Do I need to add those as "g:gender" or just "gender" or can it be "Gender" ?