Google Base Feeder Support Thread [OLD]

brimsjewelry:

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

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

$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

$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:

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:

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

Any ideas?

Just wondering, how would I know if my file has been uploaded successfully. Alos, would I have to create a froogle.txt file name at the google base website?

Hi,
First off, thanks for a great contribution

I've searched this thread and read all the posts that I can find that might be of use but haven't come across the answer to my problem yet.

I get the following when i try to upload the file that the mod creates

Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/10/19 12:50:56
Feed file - /hsphere/local/home/burningbarricade/traditionalirishgifts.com/feed/google_base.xml
Processing: Feed - No, Upload - Yes
Upload started...
First attempt (passive mode off): Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /

Upload failed...

Can any nice person please tell me what I'm doing wrong

cheers

james739:

Just wondering, how would I know if my file has been uploaded successfully. Also, would I have to create a froogle.txt file name at the google base website?

You will know it is uploaded sucessfully because the uploader informs you "Upload OK!" it will also showup in your Google Base account with the filename you registered. Speaking of which, to answer your second question, the answer is YES you need to register the google_base.xml within your Google Base account.

The answer is located in the readme.txt file under the Install: section. It is as follows... 6. Register your bulk upload .xml file using the same name in your Google Froogle Configuration at base.google.com

This means that if your default .xml file is google_base.xml then you would register the file in your Google Base bulk uploads section with a filename of google_base.xml - when you register the file there is no need to upload the filename using Google Base bulk file uploader, simply use the one provided by the Google Base Feeder Zen-Cart plugin. Wait a few minutes and you'll see your Active tab be populated with products.

I hope I have been helpful. :cool:

Remember also that v1.6.X appends the feed type to your name. In the above example, the feed file would be called google_base_products.xml or google_base_documents.xml.

awesome module, i'm trying to install it right now

it's weird i'm installing the latest version and uploaded everything and installed the sql patches but there is no "configuration"

it's the same problem here
http://www.zen-cart.com/forum/showpost.php?p=435031&postcount=421

I get the sql error

Google Base Feeder v.1.6.2 01.10.2007 18:15:59 started 2007/10/20 22:43:51
Feed file - /www/htdocs/w008f72a/feed/domain_documents.xml
Processing: Feed - Yes, Upload - No
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 'ORDER BY p.products_last_modified DESC' at line 11
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, 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, pt.type_handler FROM fw_products p LEFT JOIN fw_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN fw_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN fw_product_types pt ON (p.products_type=pt.type_id) WHERE p.products_status = 1 AND p.products_type = 3 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_last_modified DESC]

just like him ..
but i double checked that all files are there

any ideas ?

hmm can I edit posts here btw ?

I'm using SEO url's and the language file is uploaded correctly I can access the googlefroogle.php via admin menu but not the configuration :(

someone please increase the edit time this is ridiculous short

alright here is what I've found out so far:
I think all ppl with that problem have called their db differently
my db is called fw_xxxx instead of zen_xxxx

It's "processing" the sql statements but it doesnt insert the data somehow!
Well my other theory is that it's a language problem but that wouldn't make much sense it's probably a db problem.

edit:

alright

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 'true', 'false'),'), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DIS' at line 1

that's what i got when i tried to upload the sql patch INSTEAD of inserting it manually

=> it's a sql error; i will post a solution later (hopefully)

As stated in a previous post, this is due to not properly defining the language in the configuration. If your configuration is not installed, then you haven't properly patched your database by copying and pasting the SQL statements.

numinix:

As stated in a previous post, this is due to not properly defining the language in the configuration. If your configuration is not installed, then you haven't properly patched your database by copying and pasting the SQL statements.

the sql syntax is not correct i think
I have properly inserted the sql statements manually (it's not that difficult ^^)
so there is a problem in the code

that's the full line where the problem is supposed to be

(NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),

#GOOGLE BASE FEEDER
#
#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;

SET @configuration_group_id=0;
SELECT @configuration_group_id[B]:[/B]=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Base Feeder Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, 

sort_order, visible) VALUES (NULL, 'Google Base Feeder Configuration', 'Set Google Base Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, 

configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES 
(NULL, 'Google Base FTP Username', 'GOOGLE_FROOGLE_USERNAME', 'ftp_username', 'Enter your Google Base FTP username', 

@configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Google Base FTP Password', 'GOOGLE_FROOGLE_PASSWORD', 'ftp_password', 'Enter your Google Base FTP password', 

@configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Google Base Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server<br />default: 

hedwig.google.com', @configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Store Address', 'GOOGLE_BASE_ADDRESS', 'http://www.domain.com', 'Enter your website address', 

@configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Store Description', 'GOOGLE_BASE_DESCRIPTION', '', 'Enter a short description of your store', 

@configuration_group_id, 1, NOW(), NULL, NULL),

this is working when i remove the highlighted red ":"

the rest is not working yet <.< trying to find the error now