Google Base Feeder Support Thread [OLD]

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