Google Base Feeder Support Thread [OLD]

[pukman]

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...

[pukman]

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.

[numinix]

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

[guitarslinger]

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



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

[numinix]

Which version were you using previously?

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

[gorie]

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 ?!

[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.

[gorie]

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 ?!

[guitarslinger]

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.

[numinix]

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.