Google Base Feeder Support Thread [OLD]

Quote:

---

Originally Posted by mattee77

yes, i dont have any confirm button, i have tried downloading and re-installing several times but all i get on the config screen is the columns but no button to update/confirm changes, see my attached image on the top of page 339

---

What version of the mod are you using?

Your sql upload includes:




INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Magic SEO URLs', 'GOOGLE_PRODUCTS_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 999, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');


I have ceon's uri mappings, with a @configuration_group_id, 1013

Could i swap group ID's??

Quote:

---

Originally Posted by RescoCCC

What version of the mod are you using?

---

The current version I have also tried previous versions. It says 9 statements processed when installing. Should there be more than that?

Quote:

---

Originally Posted by mattee77

The current version I have also tried previous versions. It says 9 statements processed when installing. Should there be more than that?

---

Please give us the EXACT VERSION NUMBERS for the google mod, zen , and sql file that you PATCHED in. Also any other google related mods additions, such as Numinix, etc.

Quote:

---

Originally Posted by marvin

Please give us the EXACT VERSION NUMBERS for the google mod, zen , and sql file that you PATCHED in. Also any other google related mods additions, such as Numinix, etc.

---

zencart 1.3.9h
mod version 1.10.2

google analytics also installed

Quote:

---

Originally Posted by mattee77

google analytics also installed

---

so do I

The module installs perfectly on my admin and works,, BUT its is missing the new fields in configuration i.e default product category and the rest,,
Is there any possible reason why its not uploading the full configuration fields///

Quote:

---

Originally Posted by sash

The module installs perfectly on my admin and works,, BUT its is missing the new fields in configuration i.e default product category and the rest,,
Is there any possible reason why its not uploading the full configuration fields///

---

it is the latest release: this one

Zen Cart™ Version: v1.3.9

Version: 1.10.2

Last Updated: Sep 10 2011

Author: Delia Wilson Lunsford

PHP 5.3 Compatible?: Unknown or N/A

ive tried so many times ive lost count,, before trying again ive made sure its gone from admin and database..
ran uninstall file of previous version and from this one,,,
and yet still dont get the full field in configuration,,,
when going installing the "install sql file" to finish the process of the module, i continually get the duplicate error file.........
even though its been completely cleare before trying again......

Quote:

---

Originally Posted by sash

it is the latest release: this one

Zen Cart™ Version: v1.3.9

Version: 1.10.2

Last Updated: Sep 10 2011

Author: Delia Wilson Lunsford

PHP 5.3 Compatible?: Unknown or N/A

ive tried so many times ive lost count,, before trying again ive made sure its gone from admin and database..
ran uninstall file of previous version and from this one,,,
and yet still dont get the full field in configuration,,,
when going installing the "install sql file" to finish the process of the module, i continually get the duplicate error file.........
even though its been completely cleare before trying again......

---

well, you must have old settings in the database.

If you run the uninstall file and still get the duplicate error messages - here's the full scoop of how to get rid of the old stuff - from a previous post of mine:

Using phpmyadmin or similar interface, first, look at your configuration groups table and find the one for the feeder. Note the group id for it.

Then go to the configuration table. Do a search for that group id and then delete what shows up. You can also then delete that group id in the groups table.

Suggestion though: also do a search in the config table for a group id of 0. If you have results, check to see if any of those look like they are for the feeder. If so , delete them. If you have others, they also may need deleting. Having a group id of 0 means those settings don't show up in the admin and are usually from botched installs.

Hi,

Does anyone know the solution to the 'Availability' error? I have the following settings:


Show Quantity: true
Include Zero Quantity: false
Default Quantity: 0

Sales have decreased since google changed their feed :(

Quote:

---

Originally Posted by spiggles87

Hi,

Does anyone know the solution to the 'Availability' error? I have the following settings:


Show Quantity: true
Include Zero Quantity: false
Default Quantity: 0

Sales have decreased since google changed their feed :(

---

No one is reporting an error with those settings - is it giving you a warning for all products for availability?

what version of googlebase feeder?

Hello,

Thanks for the reply,

I have the 1.10.2 version of the feed.

The error I am receiving is the following:

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

Thanks in advance! :unsure:

Quote:

---

Originally Posted by spiggles87

Hello,

Thanks for the reply,

I have the 1.10.2 version of the feed.

The error I am receiving is the following:

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

Thanks in advance! :unsure:

---

I don't know that I've tried it with the zero quantity turned off so try it that way.

A word to the wise as well:

I've found it easy to end up thinking I'm uploading the changed feed to google when in fact, it's the wrong feed, the cron job didn't run when I thought, I interrupted the export, didn't realize or forgot the feed name had changed between google feeder versions etc.

So when in doubt, also check the feed file date in ftp to see if it's the feed you think you exported. Then make sure that's the one uploading to Google.

Hello!

Thank you so much,

I checked the feed google was taking from zen cart and it was the wrong feed. I uploaded the new feed from the 1.10.2 version manually and it worked a treat :clap: Thank You!!

Quote:

---

Originally Posted by spiggles87

Hello!

Thank you so much,

I checked the feed google was taking from zen cart and it was the wrong feed. I uploaded the new feed from the 1.10.2 version manually and it worked a treat :clap: Thank You!!

---

Aha! Yep, there's not a mistake made that I haven't made myself!

Quote:

---

Originally Posted by delia

I don't know that I've tried it with the zero quantity turned off so try it that way.

A word to the wise as well:

I've found it easy to end up thinking I'm uploading the changed feed to google when in fact, it's the wrong feed, the cron job didn't run when I thought, I interrupted the export, didn't realize or forgot the feed name had changed between google feeder versions etc.

So when in doubt, also check the feed file date in ftp to see if it's the feed you think you exported. Then make sure that's the one uploading to Google.

---

This is some excellent information and may explain why several people haven't been able to solve the availability attribute problem in spite of having the correct settings.

Quote:

---

Originally Posted by delia

well, you must have old settings in the database.

Suggestion though: also do a search in the config table for a group id of 0. If you have results, check to see if any of those look like they are for the feeder. If so , delete them. If you have others, they also may need deleting. Having a group id of 0 means those settings don't show up in the admin and are usually from botched installs.

---

Delia you :censored: Genius :clap::clap:

thats where i found the duplicate,, deleted it ,,

uploaded it all again and its all there!!

:D:D

Looks like everyone else has solved their problems except me :yuck: Still only getting 216 out of 649 products to upload ..Have been though every product to make sure there are no duplicates all have model number and no clashes all have manufactures ..
I do have attributes for text so only use 2 of them

Any ideas

What did it for the ones I was working on - the images... if there's a 'blank' in the DB for the image it won't seed it. If you have the product exporter 'Easy Populate', it's easy to just scroll through fast and check. If you have a 'no image' image - that's a good placeholder, but The Google does like proper images.

Have you run the Feeder in 'Debug' mode and looked at the output? Proper length titles? etc?

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;]

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??

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. :no:

Try "in stock"

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

anyone have it working?

Hello

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

Thanks

Quote:

---

Originally Posted by cuysan

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.

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.

Quote:

---

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" ?

Quote:

---

Originally Posted by ideasgirl

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" ?

---

What version of this mod are you using?

Quote:

---

What version of this mod are you using?

---

Google_base_froogle_feeder_1-10-2

Quote:

---

Originally Posted by ideasgirl

Google_base_froogle_feeder_1-10-2

---

I don't know that version works like you need. I've not worked on a site that needed this.

The most recent version says this in the documentation:

Supported attributes are: Size, Color, Age Group, Gender, Material, Pattern, UPC, ISBN, EAN, and Google Product Category. Please use these exact names when creating your Option Names in Zen Cart.

I just installed the 1.12.0 version.

In my feed, additional images are no longer included.

Also I have products using the standard attributes for Colour.
If a product has colour options of green, black & yellow then it will only add the yellow variation and not the the other 2.

Hi
Will the google feeder use the URL's developed by either Ceon or the Magic seo mod by Numinix

the sql statement states:

(NULL, 'Magic SEO URLs', 'GOOGLE_PRODUCTS_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 999, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');


If we use Ceon can we substitute the @configuration_group_id, 999

for ceon's @configuration_group_id, 1013

Quote:

---

Originally Posted by ideasgirl

Google_base_froogle_feeder_1-10-2

---

Based on the responses in this thread, version 1.10.2 is a no go with attributes.

Quote:

---

Originally Posted by mikebr

Hi
Will the google feeder use the URL's developed by either Ceon or the Magic seo mod by Numinix

the sql statement states:

(NULL, 'Magic SEO URLs', 'GOOGLE_PRODUCTS_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 999, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');


If we use Ceon can we substitute the @configuration_group_id, 999

for ceon's @configuration_group_id, 1013

---

Man, I wouldn't play with it at all. I doubt seriously that can work.

Hi Yes I do have debugging active
as it is 615 strings long I will post a few lines

Google Merchant Center Feeder v started 2011/10/18 16:55:41
Feed file - /var/www/vhosts/pewterworld.co.uk/httpdocs/feed/google/: Feed - Yes, Upload - No
id: 19sitemapindex_products_en.xml
Processing7, price: 8.79, description length: 482 - including - success
id: 198, price: 12.5, description length: 467 - including - success
id: 199, price: 17.5, description length: 470 - including - success
id: 200, price: 17.5, description length: 493 - including - success
id: 201, price: 9.95, description length: 482 - including - success
id: 202, price: 6.95, description length: 357 - including - success
id: 203, price: 6.95, description length: 365 - including - success
keeps going like this til the end
id: 1099, price: 4.99, description length: 362 - including - success
id: 1100, price: 4.99, description length: 362 - including - success
id: 1101, price: 4.1, description length: 355 - including - success
id: 1102, price: 4.1, description length: 355 - including - success
id: 1103, price: 4.1, description length: 355 - including - success
id: 1104, price: 4.1, description length: 355 - including - success
id: 1105, price: 4.1, description length: 355 - including - success
id: 1106, price: 4.1, description length: 355 - including - success

Google Merchant Center File Complete In 8.394893 Seconds 644 of 644 Records

|File after upload
Google Merchant Center Feeder v started 2011/10/18 17:24:54
Feed file - /var/www/vhosts/pewterworld.co.uk/httpdocs/feed/google/sitemapindex_products_en.xml
Processing: Feed - No, Upload - Yes
Upload started...
Uploaded Successfully
-r--r----- 1 root ÷ root ÷ 687282 Oct 18 09:25 sitemapindex_products_en.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 root ÷ root ÷ 687282 Oct 18 09:25 sitemapindex_products_en.xml

Upload ok

file after
then actual google site after processing

sitemapindex_products_en.xml - Edit
Type: Products [?]
Target country: United Kingdom None - Create
Manual upload 18-Oct-2011 17:25 BST 212 of 213 items inserted (View warnings)

you are doing a manual upload - not the best way and since it says 213 of 213, it's not uploading the file you are exporting. Check your config settings and proper file name.

Ok, installed the latest version and my tests work like a charm.

Now, for my tests I used the brand "noname" since they are handmade items and google doesn't want any "store name" used as the brand. Does anyone here has more information about this? Can that get me in trouble? or does anyone have any better idea on how to use this field?

Another question is... if I have to do different categories at a time. Will uploading a new feed delete the other items already there? I thought not because they are different id's BUT I just did an upload (of different items) and the already approved/inserted items with green checkmarks were deleted.

Quote:

---

Originally Posted by ideasgirl

Ok, installed the latest version and my tests work like a charm.

Now, for my tests I used the brand "noname" since they are handmade items and google doesn't want any "store name" used as the brand. Does anyone here has more information about this? Can that get me in trouble? or does anyone have any better idea on how to use this field?

---

YIPPEE! I assume you mean 1.12.0?

I just installed on 2 sites with no problems.

You are supposed to apply for an exemption for the brand on your particular items.

Thanks Delia.

Do you have any clue about my other question? (I added it while you were answering my first question). :lookaroun

Quote:

---

Originally Posted by ideasgirl

Thanks Delia.

Do you have any clue about my other question? (I added it while you were answering my first question). :lookaroun

---

Handmade, IE; custom items, are exempt from the unique product identifier requirements.

Quote:

---

Originally Posted by RescoCCC

Handmade, IE; custom items, are exempt from the unique product identifier requirements.

---

That's not the question I'm looking for... Delia answered that.

This is my other question:

Quote:

---

Another question is... if I have to do different categories at a time. Will uploading a new feed delete the other items already there? I thought not because they are different id's BUT I just did an upload (of different items) and the already approved/inserted items with green checkmarks were deleted.

---

Quote:

---

Originally Posted by delia

you are doing a manual upload - not the best way and since it says 213 of 213, it's not uploading the file you are exporting. Check your config settings and proper file name.

---

lol not to sound rude but I've tried all the ways even ftp .always get the same result

Quote:

---

Originally Posted by ATSWorld

lol not to sound rude but I've tried all the ways even ftp .always get the same result

---

Have you taken a look to the feed created? Maybe checking the item where stops will help you determine where's the error.

Also, if you can... delete all products and delete the feed. Then create a new one. Upload from the module on admin before trying to upload if manually.

Quote:

---

Originally Posted by Linux

anyone have it working?

---

i almost have it working.

thanks so much for posting that link in the google forums for checking errors on my feed it really helped me out.

thanks again for all your help.

OKKKKKKKKKKKKKK
I too have almost got it working now ... I disabled every category except 1 and started from there ,eventually I found 2 categories causing a problem as soon as I turn them on it fails even with just 1 product active it fails ..bizarre ... It's getting very late now so going to leave it as it is for now and have another go tomorrow

thanks for the help though

Quote:

---

Originally Posted by 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.

---

Quote:

---

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 agree with you 100%. Not none of my business but since this thread is so long with old information, and On Sept. 22, Google started gradually enforcing the new Google products feed spec requirements why not start a new thread with Numinix's latest version and go from there.

Quote:

---

Not none of my business but since this thread is so long with old information, and On Sept. 22, Google started gradually enforcing the new Google products feed spec requirements why not start a new thread with Numinix's latest version and go from there.

---

This makes excellent sense.

Quote:

---

Originally Posted by countrycharm

I agree with you 100%. Not none of my business but since this thread is so long with old information, and On Sept. 22, Google started gradually enforcing the new Google products feed spec requirements why not start a new thread with Numinix's latest version and go from there.

---

Absolutely true.

A lot of the information is very old and it makes it confusing.

I personally want to thank Numinix. I will be definitely donating or purchasing some of your addons. You were always polite in answering questions *especially on your forum*.

Numinix - thanks for the last update...that really did the trick. YOU are amazing, helpful and always nice. Thanks for all of your contributions too.

Quote:

---

Originally Posted by countrycharm

I agree with you 100%. Not none of my business but since this thread is so long with old information, and On Sept. 22, Google started gradually enforcing the new Google products feed spec requirements why not start a new thread with Numinix's latest version and go from there.

---

Sounds logical to me - but then so did the world being flat:smile:

I have Google Base Feeder working - kinda. File had 365 products in it but Google Merchant Centre shows 0 of 109 products inserted. So 2 issues but I will worry about the actual quantity later - it is the errors for the 109 that I need to get sorted.

By the way - read as many pages back as I could without going GaGa.

Getting errors as follows;
Invalid price (109 errors)

We don't accept non-numeric values or negative prices. If you are including the currency code or symbol, please make sure it matches the currency of the target country.

examples shown had prices as "7.95" which I see no problem with - maybe the problem is that the default currency on the site is AUD and in Google Merchant Centre Configuration it is USD and cannot be altered!! - it will not let me alter it, there is no edit box when you click on the info icon.

AFTERTHOUGHT = Google Merchant Check Out is not available yet in Australia - from what I gather it is only available in USA, CAN and UK - but I have selected do not use checkout - wondered if this may have something to do with it ??

Missing recommended attribute: brand (109 warnings)

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

The products do not have a brand and are not Handmade or Custom - do I insert a made up brand name and if so where? (under manufacturer in product details?)

Missing recommended attribute: availability (109 warnings, 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.

Really not sure what this is about - in product description pages I have selected "do not show qty box" (albeit they still show in product pages) - any ideas ?

Missing recommended attribute: google product category (109 warnings)

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

Of the 109 products singled out they are from about 3 or 4 different categories .... so how does one sort this?

I have tried re-configuring config but it doesn't change things.

So now I look for help. Thank you indeed in advance.

cheers,
Mike

p.s. ZenCart v1.3.9 add-on is latest version showing in add-ons section. (but not the super dooper very last recent one I don't think from reading recent posts)

shags38

first, you need to download the latest & greatest from the one and only Numinix

here

make sure you uninstall the sql and then re-install it.

if you did that than you are on your way.

make all your adjustments to new config

on the attribute: availability you need to go to your admin in zen cart and edit your page layout and show stock. that's why i have done to make it work. on your new configuration for google merchant make these adjustments:

show quantity true
default quantity 1

start with those and post your results.

hope that helps :clap:

Quote:

---

Originally Posted by shags38

By the way - read as many pages back as I could without going GaGa.

---

Isn't that the truth...LOL

Here's the category tree

here.

Quote:

---

Originally Posted by shags38

Missing recommended attribute: brand (109 warnings)

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

The products do not have a brand and are not Handmade or Custom - do I insert a made up brand name and if so where? (under manufacturer in product details?)

---

Manufacturer and that would be in admin.

Then when you list a new item you add the manufacturer.

My feed has <g:availability>in stock</g:availability>

but google has rejected the feed with the error Missing required attribute: availability

any ideas?

OK, I have searched through this thread for a solution to my problem but I can't find one :blush:

I'm trying to set product type to "bottom", but when I do this the tag isn't generated in the feed. If I set it to "top" or "full" it works as it should, but not for bottom.

If anyone can help with this, I'd very much appreciate it. Thanks, Rob.

Could anyone show a sample of the feed file from the new download from numinix, i have installed it but dont see any difference in the feed info than before,,

Mainly in regards to the attributes, ive installed stock to attributes,

Just need to check as maybe im looking for something thats not there in the first place,,,,

basically are you supposed to see your attributes in the feed???

Thanks

getting my hair off now......

Is it right that only 9 statments have installed.

I only get half the options in config, and no update/save button to save changes made

sash,


The xml file will look the same apart from additional lines if the product has that information available in the database: The extra fields I get are <g:size> <g:color> and <g:item_group_id> see below :

The rest are pretty much the same: extra ones might include <g:brand><g:mpn> or <g:isbn> depending on which of those fields you use for the product (if using Numinix extra fields)


<g:item_group_id>008</g:item_group_id>
<g:id>008-03</g:id>
<g:size><![CDATA[0-3 months]]></g:size>

hope that helps.

mattee77

I had this issue and discovered when looking at the database phpmyadmin that there was an error with the install of the Mysql patch and the configuration group id had not been applied - they were 0 rather than 1017 for example.

Also if you get an error due to a duplicate key then you will find that half the fields might not install (at least that what appears to have happened when I tried first time)

To resolve you can either manually enter the config group id (if that is the issue) or uninstall the old one and reinstall the new one from scratch. - you will have to reconfigure through admin but it is not that long a process.

Hope that helps, as without seeing exactly what you did I might have missed something.

Quote:

---

Originally Posted by gbdriver

OK, I have searched through this thread for a solution to my problem but I can't find one :blush:

I'm trying to set product type to "bottom", but when I do this the tag isn't generated in the feed. If I set it to "top" or "full" it works as it should, but not for bottom.

If anyone can help with this, I'd very much appreciate it. Thanks, Rob.

---

Rob,
"
Can't answer your problem specifically but if you read the google specification they suggest that "full" would be the better route to take.

Quote:

---

Originally Posted by MikeyG

sash,


The xml file will look the same apart from additional lines if the product has that information available in the database: The extra fields I get are <g:size> <g:color> and <g:item_group_id> see below :

The rest are pretty much the same: extra ones might include <g:brand><g:mpn> or <g:isbn> depending on which of those fields you use for the product (if using Numinix extra fields)


<g:item_group_id>008</g:item_group_id>
<g:id>008-03</g:id>
<g:size><![CDATA[0-3 months]]></g:size>

hope that helps.

---

AAhh, my feed is just showing the same as before, doesnt contain new bits,, the only attribute i need in it is (size)..

should the attribute setting be in configuration

Sash

I cannot see any attribute configuration as far as I can make out from the code it checks if the product has attributes and then checks the TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK for the quantity. (would suggest you need the stock by attributes module installed for this) So this part of it should be automatically produced if the product has attributes - not all of mine do for example and it produces the xml file accordingly.

One suggestion - have you uploaded the new googlefroogle.php right at the route of the site - this is the file which determines the xml output. if you have not replaced that one with the new version then you will not get the attributes being output.

Quote:

---

Originally Posted by MikeyG

mattee77

I had this issue and discovered when looking at the database phpmyadmin that there was an error with the install of the Mysql patch and the configuration group id had not been applied - they were 0 rather than 1017 for example.

Also if you get an error due to a duplicate key then you will find that half the fields might not install (at least that what appears to have happened when I tried first time)

To resolve you can either manually enter the config group id (if that is the issue) or uninstall the old one and reinstall the new one from scratch. - you will have to reconfigure through admin but it is not that long a process.

Hope that helps, as without seeing exactly what you did I might have missed something.

---

Mikey, thanks for the response

I have tried unistall.sql and install and still only 9 statements install.
I have no idea how to manually enter the config group. any guidance is appeciated

Quote:

---

Originally Posted by MikeyG

Sash

I cannot see any attribute configuration as far as I can make out from the code it checks if the product has attributes and then checks the TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK for the quantity. (would suggest you need the stock by attributes module installed for this) So this part of it should be automatically produced if the product has attributes - not all of mine do for example and it produces the xml file accordingly.

One suggestion - have you uploaded the new googlefroogle.php right at the route of the site - this is the file which determines the xml output. if you have not replaced that one with the new version then you will not get the attributes being output.

---

Must be something ive missed or not clicked ,, the stock to attributes seems fine, and yea just tried it and the feed takes that info automatically as i changed the quantity in a few of them,, and saw they changed in the feed,,
Just dont see the attribute <size> in the feed// cheers

I am assuming that you are running the install from the admin area of the site? and no errors are reported?

If you have phpmyadmin available you can use that to look at the tables in the database and just see what has gone into the configuration tables - there are two that need to be looked at. You can use the features of phpmyadmin to then do a search for the configuration keys in the configuration table and see if they have all been inserted. if you look at the install.sql file these keys tend to be in capitals.

Quote:

---

Originally Posted by MikeyG

I am assuming that you are running the install from the admin area of the site? and no errors are reported?

If you have phpmyadmin available you can use that to look at the tables in the database and just see what has gone into the configuration tables - there are two that need to be looked at. You can use the features of phpmyadmin to then do a search for the configuration keys in the configuration table and see if they have all been inserted. if you look at the install.sql file these keys tend to be in capitals.

---

i installed via installsql patches under tools I have no phpmyadmin available

Quote:

---

Originally Posted by MikeyG

My feed has <g:availability>in stock</g:availability>

but google has rejected the feed with the error Missing required attribute: availability

any ideas?

---

First, try completing a who need feed with a new name. Then make the changes in your google account.

I did this and it worked! :clap:

Quote:

---

Originally Posted by mattee77

getting my hair off now......

Is it right that only 9 statments have installed.

I only get half the options in config, and no update/save button to save changes made

---

What version do you have installed?

A new one came out less than a week ago.


click here for newest version.

Quote:

---

Originally Posted by PinkLeopard

What version do you have installed?

A new one came out less than a week ago.


click here for newest version.

---

zencart 1.3.9h
mod version 1.10.2

I have just tried the latest version i am having the same problem only half the config options on view and no save button. i had 10 statements installed this

getting no where fast

is it time to get my wallet out?

Quote:

---

Originally Posted by mattee77

I have just tried the latest version i am having the same problem only half the config options on view and no save button. i had 10 statements installed this

getting no where fast

is it time to get my wallet out?

---

Did you do the upgrade patches of database 1 by 1?

Quote:

---

Originally Posted by mattee77

I have just tried the latest version i am having the same problem only half the config options on view and no save button. i had 10 statements installed this

getting no where fast

is it time to get my wallet out?

---

Quote:

---

Originally Posted by delia

Suggestion though: also do a search in the config table for a group id of 0. If you have results, check to see if any of those look like they are for the feeder. If so , delete them. If you have others, they also may need deleting. Having a group id of 0 means those settings don't show up in the admin and are usually from botched installs.

---

think this is your answer (maybe) do you get a duplicate error?? if so this maybe your answer,,

if you dont have access to phpmyadmin, ask your host to do it...

Quote:

---

Originally Posted by ideasgirl

Did you do the upgrade patches of database 1 by 1?

---

i haven't touched any upgrade patches

i cant get any version to work, my knowledge of this mod is very limited, i have only installed simple mods in my past.

Quote:

---

Originally Posted by sash

think this is your answer (maybe) do you get a duplicate error?? if so this maybe your answer,,

if you dont have access to phpmyadmin, ask your host to do it...

---

i get no errors just missing parameters and no save function. maybe the files aren't finding there correct location when i upload them to my public html folder

Quote:

---

Originally Posted by mattee77

i get no errors just missing parameters and no save function. maybe the files aren't finding there correct location when i upload them to my public html folder

---

check your feed/google file - chmod to 755 or 777

also if you feel comfortable can you screen shot your config without your users name or pw. maybe you left something out. i will take a look at it.

Quote:

---

Originally Posted by mattee77

i haven't touched any upgrade patches

i cant get any version to work, my knowledge of this mod is very limited, i have only installed simple mods in my past.

---

no patches are necessary at this time.

it appears you have the newest version.

I installed version 1.12.0. What I'm noticing so far is

1. - the feed output file is showing duplicate google_product_category for each product

<g:google_product_category><![CDATA[Media &gt; Music]]></g:google_product_category>
<g:google_product_category><![CDATA[Media &gt; Music]]></g:google_product_category>

2. - Configuration no longer has, Include Zero Quantity - Is it showing for anyone else?

3. - Configuration still has the Shipping Country drop down list error. This fix works.

http://www.zen-cart.com/forum/showpo...postcount=2849

The feed is uploading to google without problem.

I'm getting some odd duplications in my data as well. For example anything with an ampersand or special character, like greater than has mysteriously added characters.

For example:

Code:

---

<g:google_product_category>Home &amp;amp; Garden &amp;gt; Kitchen &amp;amp; Dining &amp;gt; Barware</g:google_product_category>

---

Notice all the extra

Code:

---

amp;

---

? So I get XML formatting errors from Google. It's taking forever to manually clean each generated file and I get no errors when running debug.

Any ideas?

This was a fresh install of 1.10.2

I'm all working yehaaaaaa ..1 product was causing all the grief ..I disabled all my products and opened them 1 by 1 till I found which categories were causing the problem ,just finished finding out which product was faulty ...now just need to play around and get it to upload :clap::clap::clap::clap::clap::clap::D

Hi, im having problems getting our feed to work, getting the following error:

Encoding problem in attribute: description (12684 errors)

Some of the characters in your items seem to be invalid. Please verify that all the characters in your feed are valid for your selected encoding.
Examples:

Item ID Line No. Value
1752 69 RRP £8.99  Battle of the Bands: Backstage Pass introduces 60 new cards for your Battle of the Bands games! What do you, your cat, a cute backup singer and the dread K'tulu on lead zither have in common? They're in your band! You're a star, so lets jam! Complexity (1-10): 3 Playing Time: 30-45 minutes Number of players: 2-6 Ages: 13 and higher (Teen Themes)


We run a UK shop if that makes any difference which ran the Numinix Google Base Feeder absolutely brilliantly up until Google made the changes and now nothing works.

The Guys at Numinix have installed the latest version release but just seems to be a problem getting my data into Google.

Just wanted to confirm that I need to update my files and DB to UTF-8 >?

Any advice would be most grateful

Cheers
Chris

Maybe totally not related, but i'll ask anyway,, has anyone had a customer reporting an error at checkout i replicated it and it says this..

Whoops! Sorry, but you are not allowed to perform the action requested.
You are still logged in to your account and may continue shopping. Please choose a destination from a menu..

i installed the brand new google merchant feed from numinix,,

would someone like to relicate it aswell just to see if its connected

I just went through checkout on my site and there were no errors.

After having installed the latest Google Base Feeder I am getting the "No Picture Available" error when adding new products to the shop (not to Google Feed). I can't figure the relationship but thought I'd ask if anyone else has experienced this??

I have some 350+ products already loaded and never had any issues with images and no changes have been made in admin to configurations (other than Google Merchant).

Any clues??

cheers,
Mike

Quote:

---

Originally Posted by shags38

After having installed the latest Google Base Feeder I am getting the "No Picture Available" error when adding new products to the shop (not to Google Feed). I can't figure the relationship but thought I'd ask if anyone else has experienced this??

I have some 350+ products already loaded and never had any issues with images and no changes have been made in admin to configurations (other than Google Merchant).

Any clues??

cheers,
Mike

---

By chance are you using image handler...if so...turn it ON on the config of your Google Merchant.

I also am getting the Whoops message after installing the Numinix Google Merchant Feed. It is very frustrating. If you find the issue, please let me know.:frusty:

Quote:

---

Originally Posted by sash

Maybe totally not related, but i'll ask anyway,, has anyone had a customer reporting an error at checkout i replicated it and it says this..

Whoops! Sorry, but you are not allowed to perform the action requested.
You are still logged in to your account and may continue shopping. Please choose a destination from a menu..

i installed the brand new google merchant feed from numinix,,

would someone like to relicate it aswell just to see if its connected

---

Quote:

---

Originally Posted by PinkLeopard

By chance are you using image handler...if so...turn it ON on the config of your Google Merchant.

---

Thanks Pink for the quick response.

I read your reply and went HAHA!! ... then turned it on but alas it was not the problem:no:

cheers,
Mike

Go the new forum for the new version of GM

click here.


I will answer questions there.

Thanks!

Quote:

---

Originally Posted by shags38

Thanks Pink for the quick response.

I read your reply and went HAHA!! ... then turned it on but alas it was not the problem:no:

cheers,
Mike

---

go here for updated questions & answers

click here.

Hi,

Since changing the charset in Zen Cart 1.3.9 to UTF-8 following the installation instructions the Order Totals no longer show in Admin or in the My Account/Order History function on the website.

I am using zencart 1.3.9h and google_base_froogle_feeder_1-10-2. Yes, I know I there's an upgrade available - I tried this but it didn't fix the problem.

Order Totals show for orders that were placed after the change to utf-8 but not any prior to the change.

I have discovered that it's to do with the Text field not being completed in the database, please see this image.

I can amend this manually in the database through phpmyadmin but as you can see this affects 3770 orders (eek!) - and will take too long.

When I look at old backups of the database the Text field is also not filled in so I can't even export & import the old data to fix this.

Is there a way to populate these fields by executing a command somewhere/somehow please?

Any suggestions welcome/appreciated.

many thanks
Claire :blink:

P.S. I have also tried uninstalling google_base_froogle_feeder_1-10-2 and changing the database back to latin1_general_ci but it still doesn't fix my problem.

...forgot to say I found a great tool to change the database collation here:

http://www.phoca.cz/download/categor...collation-tool

(no, this isn't my problem either - I have used this tool to convert other zencart databases with complete sucess).

:smile:

I have installed 1.12.0 and debug shows
'skipped due to user restrictions' for most products. does anyone know how to get past this?

Quote:

---

Originally Posted by ATSWorld

I'm all working yehaaaaaa ..1 product was causing all the grief ..I disabled all my products and opened them 1 by 1 till I found which categories were causing the problem ,just finished finding out which product was faulty ...now just need to play around and get it to upload :clap:

---

Isn't that a great feeling? That's the best way to troubleshoot. Going 1 by 1 until you find where is the error.

how do i get the feed to recognise that the model field is actually the upc / barcodes / unique product identifier??? looking at a suspension so need to get this fixed asap.check out the screenshot ive attached of what im being told in my merchant centre dashboard

Quote:

---

Originally Posted by Xbox Memberships

how do i get the feed to recognise that the model field is actually the upc / barcodes / unique product identifier??? looking at a suspension so need to get this fixed asap.check out the screenshot ive attached of what im being told in my merchant centre dashboard

---

In the configuration page.

the only option i see requires me to have numinix product fields which i couldnt get to work on my site

Quote:

---

Originally Posted by Xbox Memberships

the only option i see requires me to have numinix product fields which i couldnt get to work on my site

---

Show Offer ID
A unique alphanumeric identifier for the item - products_id code.
id
model
UPC
ISBN
EAN
false