Google Base Feeder Support Thread [OLD]

rxalex:

I keep getting this Connection failed: uploads.google.com . can anyone tell me whats wrong?

Check that your google base ftp account is already activated and working. Using Internet Explorer or Firefox type ftp://uploads.google.com on the address bar.

Enter your username and password. If you can connect then your ftp account is working properly, if not, you have to wait until it becomes activated or contact Google if doesn't become active after a couple of days.

Check that you have entered your username and password correctly and in the correct fields in ZC Admin > Configuration > Google Base Feeder Configuration.

Note that the field for password comes first, then the username. We're used to entering username first, so check to make sure they're not switched.

Thanks Tj I guess overlooked that sawwwy:oops: eventhough put in the correct ftp username and password but still
Google Base Feeder v.1.6.1 19.09.2007 16:37:59 started 2007/09/24 21:49:56
Feed file - /home/fae/public_html/sun/feed/1800_google_base_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: uploads.google.com

Upload failed...

any other ideas why this may not be working or am i stuck doing it manually :(

Are you able to connect to Google's ftp using an FTP program or Internet Explorer or Firefox?

You might also want to contact your host to make sure all the required ports for PHP FTP functions are open.

I am having a strange problem.

Looking at my google feed I noticed that most of my products are there
But not all of them! Sections by manufacturer are missing.

I have tried and tried again and it keeps doing the same thing.

My live feed has everything. How ever that is in xml and I dont know how to work with that.

Thanks Tj yes it was the host, the only way for ftp uploads is to make it a dedicated ip :( ... I guess I have to upload the file manually... Appreciate your help Tj.

Hey, Im using 1.6.1 in zen 1.3.7. Google is having a fit with me as of late.
I guess I need to know how to get my sale prices to list in the feed along with non sale prices.

Also need to know how to control my product types. Feeder produces a very long product type name and I got a letter from google about it.
I guess I would like to have Feeder use the products top category as the "Type".
How can I do this? I dont see any way to change this in config.

Does anyone eles have these problems too?
Thanks ,
John

I guess I would like to have Feeder use the products top category as the "Type".

The script stores the categories in a array called product_type and then converts it into a string (implode) with commas separating each category. You can use a function called array_pop() to remove the first element in the array (the top level category) and store it into a variable that you can use as the product_type.

For example, before turning product_type into a string, do this:

$product_type = array_pop($product_type);

and then comment out the other lines of code concerning product_type.

To have these functions permanently added to the Google Base Feeder, or to make other configurable changes, please contact Numinix Technology directly and I can make these changes to be admin configurable by donation.

Numinix,
Thnx for the quick reply!
With the hard hit of feeder not function properly for me lately (hope thats why) I really cant afford a donation right now. Im gonna have to do this myself.
Can you please tell me which .php am I editing with the pop stuff ?
Also, How do i deal with the sale price not being used?

   Thank you,
                     John

It supports special pricing. You would have to make conditional statements to define $price as the sales price as I had done for specials pricing. Otherwise, use products_price. This will involve linking the tables as shown in the products_query and extracting the relevent fields from the db. You can do it all by mimicking what I've done already and also by using PHPADMIN to see which fields in the database store the sales price. If there are expiry dates you'll also need to create conditional statements for that. The script has already defined the current date at the top.

Just got things working some what... until I try to run feed for products. This is the error that I get.. When I look at the "domain" file all of the products are there but when I try to view the file in zen admin I get nothing.

Google Base Feeder v.1.6.1 19.09.2007 16:37:59 started 2007/09/27 00:30:41
Feed file - /home/scrapboo/public_html/store/feed/sbdd_products.xml
Processing: Feed - Yes, Upload - No

1054 Unknown column 'p.products_condition' 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, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_condition, p.products_category 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.products_type = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_last_modified DESC]

running zen cart 1.3.7. Any suggestions?

Thanks

I am not exactly sure what's causing the problem but we are experiencing two issues after upgrading to 1.6.1

1. The script is appending products.xml to the output file name which end up rendering the output file name to not match the filename registered with Google.

2. Since upgrading to version 1.6.1 it's only generating about 70% of our product in the feed. I am not sure if this is related to the new parameter for figuring out what a product is versus download, document, etc. Reverting back to 1.5.3 solves the problem and all 10,583 products are included in the feed.

Both Yahoo product submit and Live product feed works fine and generate all active products.

I have temporarily downgraded to 1.5.3 so we can at least upload all products.

Thanks!

The documentation for 1.6.1 needs to be updated. But, you basically create three cron jobs for each product type and register each file with Google with the new name. You won't have any downtime since your old feed will still be active until you delete it.

help please,

I am getting this error after copying the all the sql patches to the sql and can't figure it out

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NULL default NULL after products_model' at line 1
in:
[) NULL default NULL after products_model;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I did not upload I did a cut and paste any help?????

numinix:

The documentation for 1.6.1 needs to be updated. But, you basically create three cron jobs for each product type and register each file with Google with the new name. You won't have any downtime since your old feed will still be active until you delete it.

Numinix, is you post addressing my issues of the script not generating all the products in the feed? I don't see how a cron job will solve my problem. The cron job will still upload only the file generated which is what I am having issues right.

All the other script works far as far as generating the right amount of products but the google base is not working unless I revert back to 1.5.3 which is what I've done until such a time when my issue is resolved.

Thanks!

BlessIsaacola

You mentioned some other feed places.

Both Yahoo product submit and Live product feed works fine and generate all active products.I have looked at yahoo and at msn and cant find product feed info.
Where can I find this and are there any fees associated?
Do you use the same feed generated for google base for the other two?

    Thanks, 
                John

bumba000:

I have looked at yahoo and at msn and cant find product feed info.
Where can I find this and are there any fees associated?
Do you use the same feed generated for google base for the other two?

Thanks,
John

John,

All of my scripts are available for download in the Numinix Technology Zen Cart Downloads section.

You can view the readme.txt file to find out more information about the service or simply do a search for Windows Live Product Search.

Numinix,
Hey - Just installed Live Feed. Thanks. Got the config done after creating an account for Search Live. Over to tools and Live Product Search Feeder!
Get this error.

Live Product Search Feeder v.1.02 19.08.2007 17:02 started 2007/09/28 23:13:39
Feed file - /home/john724/public_html/feed/lps.xml
Processing: Feed - Yes, Upload - No

Warning: chmod() [function.chmod]: Operation not permitted in /home/john724/public_html/lps.php on line 69

Warning: chmod() [function.chmod]: Operation not permitted in /home/john724/public_html/lps.php on line 177
Live Product Search File Complete In 1.021822 Seconds 628 Records

Can you tell me whats wrong here? It says the feed was created (and it was) so I tried to upload and that gave an error too.

Headed over to productupload.live and uploaded it myself. . .
http error 500

Soooo Any Ideas?

                              Thanks, John

Delete your feed file and allow the script to create it. This goes for all of the feeders/exporters.

Okay, That took care of the that. Upload still gives me the [quote]
Live Product Search Feeder v.1.02 19.08.2007 17:02 started 2007/09/28 23:55:02
Feed file - /home/john724/public_html/Mfeed/lps.xml
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: ftp.productupload.live.com
Warning: ftp_connect() [function.ftp-connect]: php_network_getaddresses: getaddrinfo failed: Name or service not known
Upload failed...[/quote}

Visiting productupload.live and manually uploading give an error as well.
Says " Upload error!
HTTP Error, 500 occurred."

Thanks In Advance,
John

This seems to be a common error with the Windows Live Product Seach FTP, those who are having this issue can copy and paste all of the Google Base functions and rename them to match the WLPS Feeder.