Google Base Feeder Support Thread [OLD]

[onetrade]

1.5.1 is the magic version, finally works! Thnks Numinix! i would only suggest adding a file into the feed zip directory google_base.xml for simplicity...THANKS ALOT!!!

[numinix]

1.5.1 is the magic version, finally works! Thnks Numinix! i would only suggest adding a file into the feed zip directory google_base.xml for simplicity...THANKS ALOT!!!

Yes, good point. Version 1.5.1 works perfectly for myself as well and I believe it should also solve the issues that blessisaacola was facing as well.

Btw, doesn't it create the file google_base.xml automatically? I've now added it for future releases anyways, but I believe it shouldn't be an issue.

[mbheald]

numinix,

I just upgraded to version 1.5.1, it seemed to create the xml file correctly exept I am receiving this error from google.

Outcome: Bulk upload failed. No items are live. There are too many formatting errors in your file. - help
Number of items processed: 1
Number of items succeeded: 0
Number of active items: 0
Uploaded at: Aug 7, 2007 5:26am PDT
Processed at: Aug 7, 2007 5:26am PDT

Errors:
Error Bad data Line #52
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help

You can view my file at:
http://hotnbottled.com/feed/froogle.xml

P.S. I had to manually add the file feed/froogle.xml as it is not included with my version of the download.

If you need to take a look at my admin, please PM me and I will get back to you.

Thanks,
Matt

[numinix]

There are no errors in your xml file. I would try sending it again. If you've named it froogle.xml, make sure this is also the name you've registered with Google Base.

For clarity reasons, line 52 is:

<g:pickup>true</g:pickup> 

Your feed would validate if not for the <g:mpn> which is required by Google Base. So, I would suspect that you've tried sending a file before or something like that and they have denied the original file. Sending it again should remedy it. Allow a few hours for it to be accepted.

P.S.

I like your hot sauce!

[mbheald]

Ok, I verified the settings and the file name, but am still running into a problem. I tried to upload via the site admin and it seems to hang...

Google Base Feeder v.1.5.1 06.08.2007 23:35 started 2007/08/07 22:09:50
Feed file - /home/hotnbott/public_html/feed/froogle.xml
Processing: Feed - No, Upload - Yes
Upload started...

The browser window says done in the status bar. Does this mean the file is being processed?

[batteryman]

Hello Numinix,

I downloaded your newest releaase because of the new features that you added (rss). I am working locally on my laptop usin XAMPP and I created a freash zencart and then load the googlefeeder 1.5.1. When I went to use it after I uploaded the sql syntax, I got this error.

Google Base Feeder v.1.5.1 06.08.2007 23:35 started 2007/08/07 21:59:50
Feed file - C:/xampp/htdocs/biaf/feed/google_base.xml
Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_upc' in 'field list'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id ASC]

I also had to create a blank xml file in the feed folder in order to get it to work up until this point because before I did I got an error saying file does not exist.

I really appreciate you helping me on the shipping weight issue. Will your suggestion still work for this lastest version once we figure out what the problem is?

thank you,

avel

[numinix]

Hello Numinix,

I downloaded your newest releaase because of the new features that you added (rss). I am working locally on my laptop usin XAMPP and I created a freash zencart and then load the googlefeeder 1.5.1. When I went to use it after I uploaded the sql syntax, I got this error.



I also had to create a blank xml file in the feed folder in order to get it to work up until this point because before I did I got an error saying file does not exist.

I really appreciate you helping me on the shipping weight issue. Will your suggestion still work for this lastest version once we figure out what the problem is?

thank you,

avel

Taken directly from the SQL file:

#REMOVE #'s BELOW TO INSTALL UPC/ISBN SUPPORT:
#ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model; 
#ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc; 

Remember that many SQL patches will include comments just like in PHP.

And yes, I gave you instructions for adding it to the latest version or a pre-XML version..

[CnTGifts]

finally got it to work but it only loaded 812 out of 3172 products