Printable View
Is there a way to make this mod display the same "Category" on google base for all items? I get the top level folder that my item is listed under (Honda, Ford, Chevrolet, Mitsubishi) and I want them to all read "Automotive" instead of the vehicle manufacturer.
Thanks!!!!
I'm running the latest version of Zen Cart. I installed the google base feeder, but it's not working. I tried installing the patch update, it seemed to take, however I still can't get any products to generate.
How can I fully remove google base feeder? I need to try reinstalling. I tried running the uninstall sql script, but it seems there are still some things in the db, as I can't reinstall.
Any ideas?
Thanks.
Hello Actionmedia,Quote:
Originally Posted by actionmedia
Please post any error messages you are getting while trying to do the reinstall. That would help anyone trying to assist you.
When I try to apply the update_1_7_1 sql patch, I receive this:
1062 Duplicate entry 'GOOGLE_BASE_MAP_PRICING' 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, 'Enable Map Pricing', 'GOOGLE_BASE_MAP_PRICING', 'false', 'Enable MAP Pricing (requires separate add-on)?', @configuration_group_id, 2, 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.
I ran the uninstall script, and tried reinstalling just the googlefroogle.sql query, and can't. I receive this:
1062 Duplicate entry 'GOOGLE_BASE_MAP_PRICING' 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 (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Enable Map Pricing', 'GOOGLE_BASE_MAP_PRICING', 'false', 'Enable MAP Pricing (requires separate add-on)?', @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, 'Display Tax', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display tax per product?', @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.
guys, i need help. I have just installed Google Base Feeder according to instruction. But when i click on "Create Product Feed" it shows white blank pop up window and nothing going on further :blink: . What i am doing wrong, please help?
Are you sure you have it configured correctly in Admin>Configuration>GoogleBaseFeederConfiguration ??Quote:
Originally Posted by yorick00
It has few lines to configure :blink:Quote:
Originally Posted by limelites
Google Base PASV
Google Base Server
Google Base FTP Password
Google Base FTP Username
Store Description
Store Address
Auction Site Attributes
I soopose they influense on gogle bease account acces for file uploading. But something must be created before uploading.
I configured them, but feed even not created file (mystore/feed/index.html is empty)
when i click on "Create Product Feed" it shows blank pop up window and nothing going on. I am completely stuck. :lookaroun
There's a pretty good readme file with this mod that explains the set up process step by step by step.
Open the readme file and go through each step meticulously.
It sounds like you don't even have a Google Base account yet!? Read the step by step install guide which explains how to open an account and also how to configure it correctly.
Do this and you'll get it working... You need to know your account details (Google Base FTP Password and Google Base FTP Username) so that you can output a txt file to upload to google base.
Hi All,
v1.7.3a installed on zen 1.3.8a
I'm having a couple of problems, the first is that when I try to enter my domain name in Configuration>Google Base Feeder Configuration, I get an error:'Forbidden
You don't have permission to access /admin/configuration.php on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. '
Should it really be trying to write to configure.php? I didn't want to change permissions, as I don't know what it wants to change...
Next problem;
When I installed the sql files, the first (googlefroogle.sql) went fine but the upgrade (update_1_7_3.sql) gave an error:'1062 Duplicate entry 'GOOGLE_BASE_DEBUG' 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_BASE_DEBUG', 'false', 'Turn on simple debug?', @configuration_group_id, 0, 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.'
I assume this is of no consequence, as debug appears in the configuration menu just fine, but wanted to check.
I mention all the above as it may be contributory to my final problem; although an xml file is created just fine, and google grabs it with gusto, it only contains 68 of 216 products. I've not excluded any categories, and the products which are included come apparently randomly from across 2 categories only, not including the whole inventory of either category.
I've probably explained this in the longwindedest way possible, for which I apologise, but if you can help point me in the right direction, I'll be a very grateful zennite.
Thanks, and regards,
Sean