Google Base Feeder Support Thread [OLD]

Quote:

---

Originally Posted by brimsjewelry

ceegeeaar,
Could you show me what to do? I'd greatly appreciate it.
Jason

---

Code:

---

while ($attempt < 3 || !$success) { // two attempts, one with pasv off, one with on
            if ($attempt = 0) {
                ftp_pasv($cd, false); // on first attempt, turn pasv off
            } else {
                ftp_pasv($cd, true); // on second attempt, turn pasv on
            }

---

In the googlefroogle.php in your shops root directory find the above bit of code, around line 441 for me.
Swap the false and true around. You can change the text shown too just below there if you wish to.
If you are not generating the xml file to start with though then ftp is not your problem, you might have some content which is causing problems as it seems to with IE.

I have just uploaded the latest Google Base Feeder v1.6.2

Smashing product I must say.

It grabbed all my products ok but when viewing the file the currency was in USD. My default current is GBP so shouldn't be in that format??

Also, when I ran the document feed the result was zero (nothing in my file). What is the document feed for?

I hope somebody can help me.

Thanks in advance.

David.
http://www.thefashionhut.co.uk

Sorted out the currency problem. All uploaded to Google so hopefully will appear in 24 hours!

Still nothing in my document folder tho? :wacko:

I have version 1.3.5 of this contribution and want to update it. Does anyone know if there's a way I can update directly to the newest version or will I need to install each of the many updates in order?

just run the uninstall.sql from your version, overwrite all the files and run install.sql. You'll need to reenter your configuration information and register the new file name (name_products.xml). Your current list will remain active until you delete it so you can make sure your new list is up and running before deleting your old feed.

Thanks! I'll get on that as soon as I finish up something else I'm working on for my site.

Just had a email from Google about Irrelevant product types.
Luckly on the store in question all product types are the same so it was a quick fix.

If you are in the same boot e.g. you only sell one type of product and your categories are made up from brand name here is the fix.

In public_html/googlefroogle.php about line 149 find

PHP Code:

---

$product_type = zen_froogle_get_category($products->fields['products_id']);
      array_pop($product_type);
     $product_type = implode(",", $product_type);
     $product_type = htmlentities($product_type); 


---

And Change to

PHP Code:

---

$product_type = ENTER YOUR PRODUCT TYPE HEAR ;
     // array_pop($product_type);
     // $product_type = implode(",", $product_type);
    // $product_type = htmlentities($product_type); 


---

Change ENTER YOUR PRODUCT TYPE to what ever your product type is.

IMPORTANT this only works if you just sell one product type

Just got another email about Irrelevant product types, on a different store.
Seems Google are having a crack down I need to have just my top category as a product type with no sub categories showing has anyone worked out how to do this yet?

This feature is included in 1.6.2

Also, in response to your suggestion above, you can also install Auction Site Attributes and set the products_category per item. This will override any settings you've set for product_type in the configuration and use your custom category name as the product_type in the feed.

This can be a tiresome effort to set each product individually, especially if they are all the same product type. So, what you can do is when installing Auction Site Attributes sql, before patching change category line to default=YOURCATEGORYNAME. This will set each product to default to that category name and then Google Base Feeder will use that as the product type if you activate ASA in the GBF. Currently all sql statements are default=NULL.

I installed this yeterday and everything went OK.

Just went into Tools > Google Base Feeder and tried to create a product feed.

I'm getting the following error:

Code:

---

Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/10/17 11:11:02
Feed file - /home/httpd/vhosts/prideofthefleet.org.uk/httpdocs/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, p.products_weight, p.products_condition, p.products_category FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN 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 DESC]

---

Is the 1054 Unknown column 'p.products_upc' in 'field list' likely to cause a problem?

When I go to upload the feed I get the following error message:

Code:

---

Google Base FTP content:
Connected to: ftp://uploads.google.com
Connection failed: ftp://uploads.google.com

---

Any ideas?