Google Base Feeder Support Thread [OLD]

[Andy-C27]

Also getting this message
Google Merchant Center Feeder v started 2011/10/14 08:35:12
Feed file - /var/www/vhosts/pewterworld.co.uk/httpdocs/feed/google/GOOGLE_PRODUCTS_OUTPUT_FILENAME_products_.xml
Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 0.001668 Seconds 0 of 0 Records

I only had time to re add all the files and run the sql
zen version is 1.3.9h

thanks for any help

[spid3r1987]

can someone please show me what im doing wrong ,, uploading the module isnt a problem,but as soon as i hit this bit,,

5.Go to Admin->Tools->Install SQL Patches and patch your database with install.sql by copying and pasting (If you encounter errors, try the upload option)

it gives the duplicate error,, its a clean install as it goes up without any overwrites to a file i might have left,,

ive done this to see if it helps with a new install
http://www.zen-cart.com/forum/showpo...postcount=3249

every time is the same duplicate

if your getting a duplicate error, then its "apparently" installed
best bet is to run the uninstall.sql
make sure the google feeder is gone from Admin>configuration
if this is all clear, re-run the install.sql
if u really struggle with this, PM me and il see wht we can sort :)

[spid3r1987]

Found a debug file that has this message. Can someone translate what it means??

[13-Oct-2011 20:53:45] PHP Fatal error: Call to undefined function zen_generate_category_path() in /home/herbschi/public_html/sourceforherbs.com/includes/classes/google_base.php on line 233

The message above ties into the following prior posting.
---------------------------------------------
Working on a site and have upgraded to latest Google Merchant Center feeder. I've reinstalled the latest sql files without a problem. Have no errors of any kind.
Actual website is functioning normally.

Ran the feed and the Confirm shows the following:
------------------------------------------
Google Merchant Center Feeder v1.10.2 started 2011/10/13 10:07:14
Feed file - /home/herbschi/public_html/sourceforherbs.com/feed/sourceforherbs_products_en.xml
Processing: Feed - Yes, Upload - No
---------------------------------------------

Where are my products??

Zen 1.3.7
Google feeder 1.10.2
sql 1.10.2
Numinix product feed

i originally had the same problem with no products
i had to go through all the new version, and the old version(original files)
and then compare with my hosted session and delete ALL files that match with originals.
then run uninstall.sql
if u got phpmyadmin, log into that, goto configurationgroup
make sure googleconfig is removed from the configgroups
then
re-upload all files to hosting, then login to admin on website and goto install sql patches then run the install.sql(dont run the upgrade.sql's)
this should work
then you have replaced all the files incase one is corrupted during upload.
its all fresh
if this still fails then im nt too sure

[cuysan]

Hey google merchant center requires as well known by now for apparel categories

these attributes:

age group attribute.
gender attribute
color attribute

These were not found in the latest froogle module correct ?

I mean everything else can be edited from the admin configure panel

But I dont see these there ?

Its already lot of work to add all these to my remaining listings
But how in earth you get these into my google_base.xml_products_en.xml feed to google

I changed them but the wont show in the feed


Anybody else feeding apparel products to google with similar problems ....

Cheers

Version 1.11.2 resolves this for your feed. You need to go in and create read-only attributes, then connect them to the items.

Instructions for adding attributes:

https://www.zen-cart.com/tutorials/index.php?article=57

Once the attributes are created, a lot of them can be added to all products in a category. Not as bad as one at a time.

https://www.numinix.com/zen-cart-mod...1752eea8a26441

[kitcorsa]

try changing it to TRUE on display tax(even tho it says us only)
then redo file and upload...think this might work :)

tried that and let it repopular over last couple of days and still no joy... shipping still showing with no VAT

[marvin]

i originally had the same problem with no products
i had to go through all the new version, and the old version(original files)
and then compare with my hosted session and delete ALL files that match with originals.
then run uninstall.sql
if u got phpmyadmin, log into that, goto configurationgroup
make sure googleconfig is removed from the configgroups
then
re-upload all files to hosting, then login to admin on website and goto install sql patches then run the install.sql(dont run the upgrade.sql's)
this should work
then you have replaced all the files incase one is corrupted during upload.
its all fresh
if this still fails then im nt too sure

Nope. tried all that and still problem. No products show up .

[Andy-C27]

Hi

I tried this too and reinstalled and got this message after sql

1062 Duplicate entry 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY' for key 2
in:
[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, 'Debug', 'GOOGLE_PRODUCTS_DEBUG', 'false', 'Turn on simple debug?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Google Merchant Center FTP Username', 'GOOGLE_PRODUCTS_USERNAME', 'ftp_username', 'Enter your Google Merchant Center FTP username', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Google Merchant Center FTP Password', 'GOOGLE_PRODUCTS_PASSWORD', 'ftp_password', 'Enter your Google Merchant Center FTP password', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Google Merchant Center Server', 'GOOGLE_PRODUCTS_SERVER', 'uploads.google.com', 'Enter froogle server
default: hedwig.google.com', @configuration_group_id, 3, NOW(), NULL, NULL), (NULL, 'Google Merchant Center PASV', 'GOOGLE_PRODUCTS_PASV', 'true', 'Turn PASV mode on or off for FTP upload?', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Security Key', 'GOOGLE_PRODUCTS_KEY', @security_key, 'Enter a random string of numbers and characters to ensure only the admin accesses the file', @configuration_group_id, 5, NOW(), NULL, NULL), (NULL, 'Store Address', 'GOOGLE_PRODUCTS_ADDRESS', 'http://www.domain.com', 'Enter your website address', @configuration_group_id, 6, NOW(), NULL, NULL), (NULL, 'Store Description', 'GOOGLE_PRODUCTS_DESCRIPTION', '', 'Enter a short description of your store', @configuration_group_id, 7, NOW(), NULL, NULL), (NULL, 'Output File Name', 'GOOGLE_PRODUCTS_OUTPUT_FILENAME', 'domain', 'Set the name of your froogle output file', @configuration_group_id, 8, NOW(), NULL, NULL), (NULL, 'Compress Feed File', 'GOOGLE_PRODUCTS_COMPRESS', 'false', 'Compress Google froogle file', @configuration_group_id, 9, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Uploaded date', 'GOOGLE_PRODUCTS_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 10, NOW(), NULL, NULL), (NULL, 'Output Directory', 'GOOGLE_PRODUCTS_DIRECTORY', 'feed/google/', 'Set the name of your froogle output directory', @configuration_group_id, 11, NOW(), NULL, NULL), (NULL, 'Max products', 'GOOGLE_PRODUCTS_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 20, NOW(), NULL, NULL), (NULL, 'Starting Point', 'GOOGLE_PRODUCTS_START_PRODUCTS', '0', 'Start at which entry (not product_id)?
Default=0', @configuration_group_id, 21, NOW(), NULL, NULL), (NULL, 'Included Categories', 'GOOGLE_PRODUCTS_POS_CATEGORIES', '', 'Enter category ids separated by commas
(i.e. 1,2,3)
Leave blank to allow all categories', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Excluded Categories', 'GOOGLE_PRODUCTS_NEG_CATEGORIES', '', 'Enter category ids separated by commas
(i.e. 1,2,3)
Leave blank to deactivate', @configuration_group_id, 23, NOW(), NULL, NULL), (NULL, 'Included Manufacturers', 'GOOGLE_PRODUCTS_POS_MANUFACTURERS', '', 'Enter manufacturer ids separated by commas
(i.e. 1,2,3)
Leave blank to allow all categories', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Excluded Manufacturers', 'GOOGLE_PRODUCTS_NEG_MANUFACTURERS', '', 'Enter manufacturer ids separated by commas
(i.e. 1,2,3)
Leave blank to deactivate', @configuration_group_id, 25, NOW(), NULL, NULL), (NULL, 'Expiration Date Base', 'GOOGLE_PRODUCTS_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, 30, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'), (NULL, 'Expiration Date Adjust', 'GOOGLE_PRODUCTS_EXPIRATION_DAYS', '29', 'Expiration Date Adjust in Days', @configuration_group_id, 31, NOW(), NULL, NULL), (NULL, 'Show Default Currency', 'GOOGLE_PRODUCTS_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 40, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Currency', 'GOOGLE_PRODUCTS_CURRENCY', 'USD', 'Select currency', @configuration_group_id, 41, NOW(), NULL, 'google_cfg_pull_down_currencies('), (NULL, 'Show Offer ID', 'GOOGLE_PRODUCTS_OFFER_ID', 'id', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 42, NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\', \'UPC\', \'ISBN\', \'EAN\', \'false\'),'), (NULL, 'Show Quantity', 'GOOGLE_PRODUCTS_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 43, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Include Zero Quantity', 'GOOGLE_PRODUCTS_ZERO_QUANTITY', 'false', 'Include products with zero quantity?', @configuration_group_id, 44, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Quantity', 'GOOGLE_PRODUCTS_DEFAULT_QUANTITY', '0', 'What is the default quantity for products with zero quantity?', @configuration_group_id, 45, NOW(), NULL, NULL), (NULL, 'Shipping Options', 'GOOGLE_PRODUCTS_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 46, NOW(), NULL, NULL), (NULL, 'Default Condition', 'GOOGLE_PRODUCTS_CONDITION', 'new', 'Choose your default condition', @configuration_group_id, 47, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),'), (NULL, 'Condition', 'GOOGLE_PRODUCTS_PRODUCT_CONDITION', 'false', 'If using Numinix Product Fields, include condition?', @configuration_group_id, 48, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Product Type', 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_TYPE', '', 'Enter your product type if using default', @configuration_group_id, 49, NOW(), NULL, NULL), (NULL, 'Product Type', 'GOOGLE_PRODUCTS_PRODUCT_TYPE', 'top', 'Use top-level, bottom-level, full-path, or your default setting as product_type?', @configuration_group_id, 50, NOW(), NULL, 'zen_cfg_select_option(array(\'default\', \'top\', \'bottom\', \'full\'),'), (NULL, 'Show Feed Language', 'GOOGLE_PRODUCTS_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @configuration_group_id, 51, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Feed Language', 'GOOGLE_PRODUCTS_LANGUAGE', '1', 'Set your feed language (required):', @configuration_group_id, 53, NOW(), NULL, 'google_cfg_pull_down_languages_list('), (NULL, 'Show Weight', 'GOOGLE_PRODUCTS_WEIGHT', 'false', 'Include products weight?', @configuration_group_id, 53, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Weight Units', 'GOOGLE_PRODUCTS_UNITS', 'pounds', 'What unit of weight measure?
pounds OR kilograms', @configuration_group_id, 54, NOW(), NULL, 'zen_cfg_select_option(array(\'pounds\', \'kilograms\'),'), (NULL, 'UPC/ISBN/EAN', 'GOOGLE_PRODUCTS_ASA_UPC', 'false', 'If using Numinix Product Fields, include UPC/ISBN/EAN?', @configuration_group_id, 55, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Description 2', 'GOOGLE_PRODUCTS_ASA_DESCRIPTION_2', 'false', 'If using Numinix Product Fields, append description 2 to description?', @configuration_group_id, 56, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Use Meta Title', 'GOOGLE_PRODUCTS_META_TITLE', 'false', 'Use meta title as the title if it exists (for products only)?', @configuration_group_id, 57, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Enable Map Pricing', 'GOOGLE_PRODUCTS_MAP_PRICING', 'false', 'Enable MAP Pricing (requires separate add-on)?', @configuration_group_id, 58, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Use cPath in url', 'GOOGLE_PRODUCTS_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 59, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Product Category', 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY', '', 'Enter a default product category from the Google Category Taxonomy or leave blank:', @configuration_group_id, 60, NOW(), NULL, NULL), (NULL, 'Display Tax', 'GOOGLE_PRODUCTS_TAX_DISPLAY', 'false', 'Display tax per product? (US only)', @configuration_group_id, 70, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Tax Country', 'GOOGLE_PRODUCTS_TAX_COUNTRY', 'US', 'The country an item is taxed in (2-letter ISO CODE)', @configuration_group_id, 71, NOW(), NULL, NULL), (NULL, 'Tax Region', 'GOOGLE_PRODUCTS_TAX_REGION', 'CA', 'The geographic region that a tax rate applies to, e.g., in the US, the two-letter state abbreviation, ZIP code, or ZIP code range using * wildcard (examples: CA, 946*)', @configuration_group_id, 72, NOW(), NULL, NULL), (NULL, 'Tax Rate', 'GOOGLE_PRODUCTS_TAX_RATE', '5.00', 'Enter the percentage as a decimal number (without "%" symbol)', @configuration_group_id, 73, NOW(), NULL, NULL), (NULL, 'Tax on Shipping', 'GOOGLE_PRODUCTS_TAX_SHIPPING', 'n', 'Boolean value for whether you charge tax on shipping, y for yes or n for no - the default value is n', @configuration_group_id, 74, NOW(), NULL, 'zen_cfg_select_option(array(\'y\', \'n\'),'), (NULL, 'Payments Accepted', 'GOOGLE_PRODUCTS_PAYMENT_METHODS', 'Cash,Check,Visa,MasterCard,AmericanExpress,Discover,WireTransfer', 'What payment methods do you accept?', @configuration_group_id, 80, NOW(), NULL, NULL), (NULL, 'Payment Notes', 'GOOGLE_PRODUCTS_PAYMENT_NOTES', 'GoogleCheckout', 'Add payment notes (use this for showing you accept Google Checkout)', @configuration_group_id, 81, NOW(), NULL, NULL), (NULL, 'Select Shipping Method', 'GOOGLE_PRODUCTS_SHIPPING_METHOD', 'none', 'Select a shipping method from the drop-down list that is used in your store, or leave as none', @configuration_group_id, 90, NOW(), NULL, 'zen_cfg_select_option(array(\'zones table rate\', \'flat rate\', \'per item\', \'per weight unit\', \'table rate\', \'zones\', \'percategory\', \'free shipping\', \'free rules shipping\', \'none\'),'), (NULL, 'Table Zone ID', 'GOOGLE_PRODUCTS_RATE_ZONE', '', 'Enter the table rate ID if using a shipping method that uses table rates:', @configuration_group_id, 91, NOW(), NULL, NULL), (NULL, 'Shipping Country', 'GOOGLE_PRODUCTS_SHIPPING_COUNTRY', '', 'Select the destination country for the shipping rates:', @configuration_group_id, 92, NOW(), NULL, 'google_cfg_pull_down_country_list('), (NULL, 'Shipping Region', 'GOOGLE_PRODUCTS_SHIPPING_REGION', '', 'Enter the destination region within the selected country (state code, or zip with wildcard *):', @configuration_group_id, 93, NOW(), NULL, NULL), (NULL, 'Shipping Service', 'GOOGLE_PRODUCTS_SHIPPING_SERVICE', '', 'Enter the shipping service type (i.e. Ground):', @configuration_group_id, 94, NOW(), NULL, NULL), (NULL, 'Pickup', 'GOOGLE_PRODUCTS_PICKUP', 'do not display', 'Local pickup available?', @configuration_group_id, 95, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\', \'do not display\'),'), (NULL, 'Alternate Image URL', 'GOOGLE_PRODUCTS_ALTERNATE_IMAGE_URL', '', 'Add an alternate URL if your images are hosted offsite (i.e. http://www.domain.com/images/). Your defined image will be appended to the end of this URL.', @configuration_group_id, 100, NOW(), NULL, NULL), (NULL, 'Image Handler', 'GOOGLE_PRODUCTS_IMAGE_HANDLER', 'false', 'Resize images using image handler (separate module required)?', @configuration_group_id, 101, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Magic SEO URLs', 'GOOGLE_PRODUCTS_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 999, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
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.

[RescoCCC]

Also getting this message
Google Merchant Center Feeder v started 2011/10/14 08:35:12
Feed file - /var/www/vhosts/pewterworld.co.uk/httpdocs/feed/google/GOOGLE_PRODUCTS_OUTPUT_FILENAME_products_.xml
Processing: Feed - Yes, Upload - No

Google Merchant Center File Complete In 0.001668 Seconds 0 of 0 Records

I only had time to re add all the files and run the sql
zen version is 1.3.9h

thanks for any help

Do you have two google feeds in admin/configuration? One called Google Base Feeder Configuration, and the other called Google Merchant Center Feeder Configuration? If so, use the second one to configure your feed.

[RescoCCC]

I tried this too and reinstalled and got this message after sql

1062 Duplicate entry 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY' for key 2
in:

I got exactly the same message during installation. My feeds work fine. Have you tried to generate a feed to see what happens?

[Andy-C27]

Do you have two google feeds in admin/configuration? One called Google Base Feeder Configuration, and the other called Google Merchant Center Feeder Configuration? If so, use the second one to configure your feed.

oops thank you I didn't see that as it was off the page ,once I had opened config I saw it at the bottom of the list .... I've made it the same as the other 1 and it produced a file (which is good)..will have to wait and see if it has uploaded and gone though to google now
I take it I can delete "Google Base Feeder Configuration" now as the other has taken over

thanks for prodding me in the right direction