Google Base Feeder Support Thread [OLD]

Quote:

---

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

Quote:

---

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