Google Base Feeder Support Thread [OLD]

Line 452 should be:

 
$_cleaner_array = array(">" => "> ", "®" => "", "®" => "", "™" => "", "™" => "", "\t" => "", "    " => "");   

numinix:

Line 452 should be:

$_cleaner_array = array(">" => "> ", "®" => "", "®" => "", "™" => "", "™" => "", "\t" => "", " " => "");

yes, I replace Line 452,but I got a blank page when I create products feed.

I found the problem, Google Base Feeder comflict with wordpress on zencart!

I finally got it work, but still have a question.
I set Compress Feed File to true, but the feed still show up in xml ext

When I set up a cron job to get the the googlefeeder file, I get this error:

500 EOF when chunk header expected

Also, when I try to do the Create/Upload Feed through the zen cart admin, 90% of the time it'll do this:

to

http://techawave.jitbid.com/techawave/googlefroogle.php

A word to the wise: Update Google Product Search (daily)

I have a catalog of products that hasn't changed much in a month or two. I've been busy on other projects. Because nothing changed i didn't update/submit froogle feed.

I used to be one of the first products listed for common searches. I go back and lo and behold I was DROPPED!

So, lesson learned. Do the cron job task mentioned on the admin page and this won't happen to you.

Postscript: I resubmitted after being dropped and all my reviews came back and it looks like my position was restored. I was re-listed about 24hrs after I resubmitted.

Live and learn!

techawave:

When I set up a cron job to get the the googlefeeder file, I get this error:

Nevermind, had to use mget and it fixed the problem.

ok. I have updated to the latest version of google feeder (11). And I am still having issues uploading. I can manually do it, but not from the web interface. Eventually I will cron job it.

When I upload products a pop-up window opens and reads:

Google Base Feeder v.1.6.11 03.27.2008 00:05:59 started 2008/04/02 07:52:42
Feed file - /home/content/i/n/k/inkuyo/html/feed/googlebasehd_products.xml
Processing: Feed - No, Upload - Yes
Upload started...

in the lower left it is processing for a little bit, then reads done. Nothing ever uploads and I get no errors. Any ideas?

I have another question too. On another site I updated to the latest feeder and now only 269 products exported to my xml file instead of the over 1000 products. Any ideas?

The previous versions had duplicate products. The latest version will only ever use one products_id. Before products with attributes were showing up multiple times as identical duplicates since the feeder did not alter anything for the attributes. The change was added to help with timeouts since the duplicates are just eating up more of the cpu.

Hi...

I am based in the UK and have to display prices in google with TAX (Vat) added.

My output works fine but the price shown in the XML does not include TAX so from experience Google will kick the feed out.

I'm hoping I have an admin setting problem.

I can see from your coding in googlefroogle that you have worked on this.

Any idea what the problem might be...

I've fixed it by turning in admin > Config > My Store > display prices with tax to true.

I then had to turn it back to off after I had created the XML file.

Is there a VAT attribute for Google UK? If so you could use that to display the VAT percentage.

Ok Guys - i'm approaching this point at the minute....

:lamo:

I had an older version of the feeder installed which uploaded from the admin interface a text file to googlebase fine.

I decided to uninstall that older version and reinstall the latest version. It will create my feed for (currently) 388 products - no sweat.

The issue i'm having is when i click the upload bit. I have registered the feed with Gbase, as i had done before and given it a name of richtone_products.xml which matches the file generated in /feeds

The upload pop up window just goes white for a long period before giving me

Second attempt (passive mode on): Upload Failed
Google Base Feeder v.1.6.11 03.27.2008 00:05:59 started 2008/04/04 14:26:55Feed file - 

Upload failed...

Now, my server would allow me to upload a .txt file yesterday, so i'm assuming there should be no problem with uploading via admin an .xml file.

Looking in googlebase it appears, as expected at this stage, that the "Last upload date & status" section just says "None".

Anything you can think of in case i've just not thought of something would be fantastic.

Bit gutted - worked a treat before and am giving myself a serious does of the if it aint broke don't fix it blues.

Thanks in advance guys

Rich

Which version were you using previously?

Looks like it's not even making the first attempt... with passive mode off.

i'm having some problems with the install...

first of all i installed the sql updates by mistake, before installing the googlefroogle.sql , and when i tried to install that now i get this error

1062 Duplicate entry 'GOOGLE_BASE_ADDRESS' for key 2
in:
[INSERT INTO zcart_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
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), (NULL, 'Auction Site Attributes', 'GOOGLE_BASE_ASA', 'false', 'Activate Auction Site Attributes?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:

* now - add Adjust to current date;
* product - add Adjust to product date (max(date_added, last_modified, date_available))

', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('now', 'product'),'), (NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '365', 'Expiration Date Adjust in Days', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('), (NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'id', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array('id', 'model', 'UPC', 'ISBN', 'false'),'), (NULL, 'Show Quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Include Zero Quantity', 'GOOGLE_BASE_ZERO_QUANTITY', 'false', 'Include products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Shipping Options', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL), (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your default condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array('new', 'used', 'refurbished'),'), (NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @configuration_group_id, 13, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?
default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('), (NULL, 'Magic SEO URLs', 'GOOGLE_BASE_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'domain', 'Set the name of your froogle output file', @configuration_group_id, 19, NOW(), NULL, NULL), (NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 21, NOW(), NULL, NULL), (NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @configuration_group_id, 20, NOW(), NULL, NULL), (NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Tax Region', 'GOOGLE_FROOGLE_TAX_REGION', 'Tax applicable regions', 'Enter the tax region', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Show Tax Region', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display Tax Region?', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Max products', 'GOOGLE_FROOGLE_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Starting Point', 'GOOGLE_BASE_START_PRODUCTS', '0', 'Start at which entry (not product_id)?
Default=0', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Pickup', 'GOOGLE_FROOGLE_PICKUP', 'do not display', 'Local pickup available?', @configuration_group_id, 25, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false', 'do not display'),'), (NULL, 'Included Categories', 'GOOGLE_BASE_POS_CATEGORIES', '', 'Enter category names separated by commas
(i.e. computers,software,televisions)
Leave blank to allow all categories', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Excluded Categories', 'GOOGLE_BASE_NEG_CATEGORIES', '', 'Enter category names separated by commas
(i.e. computers,software,televisions)
Leave blank to deactivate', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Show Weight', 'GOOGLE_BASE_WEIGHT', 'false', 'Include products weight?', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Weight Units', 'GOOGLE_BASE_UNITS', 'pounds', 'What unit of weight measure?
pounds OR kilograms', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array('pounds', 'kilograms'),'), (NULL, 'Product Type', 'GOOGLE_BASE_PRODUCT_TYPE', 'top', 'Use top-level, bottom-level, or full-path as product_type?', @configuration_group_id, 34, NOW(), NULL, 'zen_cfg_select_option(array('top', 'bottom', 'full'),');]
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.

under the Google Base Feeder Configuration, i have 3 things:
Google Base FTP Username
Google Base FTP Password
Google Base Server

i assume there are suppose to be other things here and that aren't.

unfortunately i didn't back up my database first for this (ughh, oops) but can anyone help me from here ?!

You may want to get a professional to remove the entries from the configuration table, or do it yourself.

All of the Google Base Feeder configurations start with GOOGLE_BASE or GOOGLE_FROOGLE

Use PHPMYADMIN.

numinix:

You may want to get a professional to remove the entries from the configuration table, or do it yourself.

All of the Google Base Feeder configurations start with GOOGLE_BASE or GOOGLE_FROOGLE

Use PHPMYADMIN.

thanks i removed the tables with google_base or google_froogle in phpmyadmin and i noticed it says this
"UNIQUE and INDEX keys should not both be set for column configuration_key"
should i change something with that ?!

numinix:

Which version were you using previously?

Looks like it's not even making the first attempt... with passive mode off.

Hi There

1.33a was the previous version - i uninstalled using the appropriate file.

In the main googlefroogle.php file (v1.33), copy the function ftp_file_upload() function towards the bottom of the script and replace the same function in the latest Google Base Feeder.

In my next version I will get rid of the automatic looping and instead add a feature so that the admin can choose PASV on or off.