Google Base Feeder Support Thread [OLD]

[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..

[motti]

[FONT=Times New Roman]Hi Numinix[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Do you know abut uploading top live .com ? do you know of a Thread abut it, it seam like it can use the froogle txt file, but I keep getting errors, I wonder if your mod could work with live.com also[/FONT]
[FONT=Times New Roman]http://productupload.live.com/Default.aspx?lc=1033[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you[/FONT]

[numinix]

Motti,

I cannot endorse the Google Base Feeder for use on any other website than base.google.com. Other feeders will be created eventually depending on the amount of interest and support in the creation of that mod. For live.com specifically, I believe they are US only and therefore are not accessible by many Zen Cart members, including myself.

That said, possible future scripts could include:

eBid.net
Yahoo! Product Submit
Shopzilla.com
Live Product Search
Shopping.com
Shopzilla.com
BizRate.com
RSS 2.0
and more...

In other words, if they support bulk uploaded files, then I can create a script to generate the feed file whether it's in tabbed, CSV, or XML format. I will be writing the eBid.net feeder as soon as they begin accepting tab delimited bulk upload files. Other than this script, and possibly an updates version of the RSS 2.0 script, I have not planned to write any other feeders.

[motti]

[FONT=Times New Roman]Hi Numinix[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Yes the do support bulk upload.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]I was able to upload my file [/FONT]
[FONT=Times New Roman]I only insert in the header of the feed.txt ( OfferName ActionURL RegularPrice ReferenceImageURL OfferDescription Brand CurrentPrice MerchantCategory)[/FONT]
[FONT=Times New Roman]And it work .[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Catalog file 'feed.txt' last uploaded on Aug 08, 2007 03:50:33 AM [/FONT]
[FONT=Times New Roman]Current status: Processing [/FONT]
[FONT=Times New Roman](It may take up to 36 hours for the files under processing to be published and searchable) [/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]my only problem is that this feed.txt are made with your 1.4.8 version or older, and I only got abut 250 items there. I now have over 400 items, how can I update my feed again using your mod, my feed not getting update , only my froogle.txt[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you[/FONT]

[numinix]

If you are using a per-XML version, you should be using v1.4.10. Whatever file name you declare in the configuration is the file that will be written to.

[roni]

Hello Numinix,

Thanks for the work on this.

I have installed 1.5.1 and created a blank google_base.xml file in feed and named that file in the configuration section.

When I do Step 1 and click Here, then View, my xml page has only the store name and no products, and the pop up window says "File Complete In 0.620673 Seconds 0 Records"

I also have Easy Populate installed, not sure if that means anything or not. I have zencart 1.3.7.

If you have any ideas about what I am doing wrong they would be much appreciated.

Thanks.

[batteryman]

I'm going to help you out and do it for you this one time as you seem very determined. Now you'll have a better understanding of the script as well!

replace line 85 with:

$products_query = "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, p.products_weight 

You'll notice all I did was add the products_weight, found in TABLE PRODUCTS denoted with the (p.). Now you just need to create the outputs of

$output["weight"] = "weight"; 

and

$output["weight"] = products->fields['products_weight']; 

They will need to be placed in the same order on both the titles and the column outputs. I recommend you add this to v1.5.1 instead and have it output the weight in XML format by just copying any of the other lines and using the appropriate google base attribute name such as <g:weight> (not sure if that is correct, you'll have to check in base.google.com). If so, all you'll need to add is this:

$content["weight"] = '<g:weight>' . $products->fields['products_weight'] . '</g:weight>'; 

I would put this under line 146.

Side Note:

I am no longer going to support versions previous to the XML version 1.5.0. I have changed to this format for a reason due to future issues with google base. Older versions such as 1.3.3 are very outdated and do not include most of the required attributes unless you have heavily edited this version as woodymon did. In which case, it is no longer version 1.3.3 but some variant that he created himself. The UPC/ISBN is required and will eventually be used by Google to automatically include information about the product by using the stored attributes for that UPC/ISBN.

All illegal characters should now be removed and all of your products should validate and be accepted. Once again, if this is not the case, please post here and I will try to remedy the issue.

I did you modifications on the new version on a local version that i use for testing off of my laptop which worked great.

then after i tested it i went live with it and my site when nuts. it through off everything and gave me errors. i fixed it quickly but here are the errors.

Warning: Variable passed to each() is not an array or object in /home/batte9/public_html/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /includes/classes/db/mysql/query_factory.php:114) in /includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /includes/classes/db/mysql/query_factory.php:114) in /includes/init_includes/init_templates.php on line 78

I am a total idiot. i read half of your first post which told me how to get the weight then i was happy and figured that it was all instruction on how to do it so I stopped reading and went on to the other post and saw that you had released another version(1.5.1). I then went to dl it and then proceeded to make a reply which asked how to set it up for the weight with out fully reading your post which already explained it. Sorry. Lessoned learned,

You were also correct in the weight attribute for Google '<g:weight>'. One thing i didn't understand is the p. and pd., what do they mean?? and why were they required?? The only thing I came up with is that they a part of a built in function a php function that is used to call upon information in a database.

Also why doesn't a product that has a upc code in the new field display it on the front page of the product, is a setting or is it just for the backend use?