Re: Google Base Feeder Support Thread
ok I have a question, I have like 19,000 products, now, when i create the file in my zen cart, tools>google base feeder>Create Product Feed:
How am i to break that file up so google can grab it?
How many products can I upload to google, and what should I call the file name? for example, the google base feeder autimatically calls it froogle_products.xml
To my understandings, I should also call it froogle_pructs.xml in my account with google. When I create the file in google, should I leave the xml extension on the end when im writing it, or should I just choose that option in the settings in google when i create the file?
Thanks in advance, I have been trying to tackle this now for 2 months with 0 products uploaded.. :cry:
Re: Google Base Feeder Support Thread
Hi there
I have searched for same error in the forum but cannot find anything. Am installing the mon on a new site, have uploaded all files and installed all the sql updates without incident. When I try and install the googlefroogle sql query there is the following error:
1062 Duplicate entry 'GOOGLE_BASE_PASV' 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, '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, 'Google Base PASV', 'GOOGLE_BASE_PASV', 'true', 'Turn PASV mode on or off for FTP upload?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (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, 'Default Quantity', 'GOOGLE_BASE_DEFAULT_QUANTITY', '0', 'What is the default quantity for products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, NULL), (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. 1,2,3)
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. 1,2,3)
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\'),'), (NULL, 'Payments Accepted', 'GOOGLE_BASE_PAYMENT_METHODS', 'Cash,Check,Visa,MasterCard,AmericanExpress,Discover,WireTransfer', 'What payment methods do you accept?', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Payment Notes', 'GOOGLE_BASE_PAYMENT_NOTES', 'GoogleCheckout', 'Add payment notes (use this for showing you accept Google Checkout)', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Image Handler', 'GOOGLE_FROOGLE_IMAGE_HANDLER', 'false', 'Resize images using image handler (separate module required)?', @configuration_group_id, 36, 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.
Am hoping you can help us!
Thanks
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
jgg1974
ok I have a question, I have like 19,000 products, now, when i create the file in my zen cart, tools>google base feeder>Create Product Feed:
How am i to break that file up so google can grab it?
How many products can I upload to google, and what should I call the file name? for example, the google base feeder autimatically calls it froogle_products.xml
To my understandings, I should also call it froogle_pructs.xml in my account with google. When I create the file in google, should I leave the xml extension on the end when im writing it, or should I just choose that option in the settings in google when i create the file?
Thanks in advance, I have been trying to tackle this now for 2 months with 0 products uploaded.. :cry:
You should register the filename that is outputted by the script. Which will be "whatevernameyoudefined_products.xml"
2 months? You could have profitted many times the amount of our installation cost by now...
Quote:
Originally Posted by
sajiepaj
Hi there
I have searched for same error in the forum but cannot find anything. Am installing the mon on a new site, have uploaded all files and installed all the sql updates without incident.
Am hoping you can help us!
Thanks
What do you mean all of the SQL updates? If it is a new site, you shouldn't be upgrading. Run the uninstall and then only patch with the file mentioned in the documentation...
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
newuser123
Hi, i received a an error message from googlebase recently, it said that 94% of my listings Missing Identifiers /Missing UPC.
I'm confused because all my listings are the same stly in format,why 6% of my listing seems OK?
I use the latest version and did give a Products Model # when I create a new item in zencart admin.
Any help will greatly appreciated~
Are you confusing the word "ERROR" with "WARNING"? Google never ended up making the UPC and ISBN attributes required. You'll get a warning that these attributes are recommended, but this won't stop the product from being processed.
Re: Google Base Feeder Support Thread
I have tried the uninstall and then just upload the googlefroogle.sql, but still get the same error. I can get the file to execute if I remove all the lines that are duplicated in the update files, but then I have no fields showing in the Froogle configuration page in admin.
Is there any way of removing the updates?
Thanks
Sara
Re: Google Base Feeder Support Thread
Any Ideas Why this isn't working?:frusty:
Google Base Feeder v.1.7.0 09.019.2008 17:38:59 started 2008/11/25 10:04:41
Feed file - /homepages/36/d230576161/htdocs/feed/domain_products.xml
Processing: Feed - No, Upload - No
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
sajiepaj
I have tried the uninstall and then just upload the googlefroogle.sql, but still get the same error. I can get the file to execute if I remove all the lines that are duplicated in the update files, but then I have no fields showing in the Froogle configuration page in admin.
Is there any way of removing the updates?
Thanks
Sara
Most likely they weren't associated with a configuration_group_id which was a typo in one of the older versions. You'll have to manually remove the rows from the db using PHPMYADMIN.
Re: Google Base Feeder Support Thread
I've been using this for months and all the sudden it will only take 287 of 2500+ items.
I haven't changed anything. Did Google make changes ot the file format they'll accept?
Here are my errors:
Code:
Error Bad data Line #
We recommend including this attribute.
weight
We recommend including this attribute.
upc
We recommend including this attribute.
isbn
This expiration date is too far in the future.
expiration date:2009-11-25
I have NO IDEA where it is getting that expiration date. I've searched my entire database and my entire site and that date is NOWHERE to be found. I also get a "There is a problem with the character encoding of this attribute" for my product description. Again, nothing changed so I am baffled.
Re: Google Base Feeder Support Thread
Can you point me to the rows that need deleting please? I had a quick look at the configuration table there didn't seem to be anything relating to the froogle feed there.
Thanks
Sara
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
confused_aswell
Hi
I have installed the mod, but seem to be having a few problems. The main problem is when I am in Tools > GBF when I go to click the "you may view your product feed......" link there is no file domain_products.xml is there a file missing?
Sorry if this has been asked before.
Thanks,
Phil
Look at this maybe this will help you.
http://www.zen-cart.com/forum/showpo...postcount=1144
