Google Merchant module Version 1.12.0 by Numinix

[voluntaryist.only]

I uninstalled the previous iteration of GM & installed all the files in the correct places & installed the sql insert & got the error below (sorry it is long btw my question is this do I ignore the errors & install the latest sql update? do I have to find the error & change them & then re-upload the sql insert & then install the latest sql patch, any help would be great, thanks

regards,

ed

12 statements processed.
ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!
Note: 2 statements ignored. See "upgrade_exceptions" table for additional details.
Query Results:
ALTER TABLE zen_products_options_values MODIFY products_options_values_name varchar(150);
SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM zen_configuration_group WHERE configuration_group_title = 'Google Merchant Center Feeder Configuration' LIMIT 1;
DELETE FROM zen_configuration WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
DELETE FROM zen_configuration_group WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
INSERT INTO zen_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google Merchant Center Feeder Configuration', 'Set Google Merchant Center Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE zen_configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
SET @security_key = SUBSTR(MD5(RAND()),1,10);
INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Version', 'GOOGLE_PRODUCTS_VERSION', '1.13.0', 'Version Installed:', @configuration_group_id, 0, NOW(), NULL, NULL), (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 Merchant Center 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, 'Enable Advanced XML Sanitization', 'GOOGLE_PRODUCTS_XML_SANITIZATION', 'false', 'If weird characters are causing your feed to not validate and you have already ensured your Zen Cart has been properly updated to use the UTF-8 charset, try enabling this option. If this option is already enabled, try disabling it.', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Max Execution Time', 'GOOGLE_PRODUCTS_MAX_EXECUTION_TIME', '300', 'Override your PHP configuration by entering a max execution time in seconds for the tool (leave blank to disable):', @configuration_group_id, 13, NOW(), NULL, NULL), (NULL, 'Memory Limit', 'GOOGLE_PRODUCTS_MEMORY_LIMIT', '128M', 'Override your PHP configuration by entering a memory limit for the tool (i.e. 128M or leave blank to disable):', @configuration_group_id, 14, 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, '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, 'Google Product Category Default', 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY', '', 'Enter a default Google product category from the Google Category Taxonomy or leave blank (note: you can override this default setting by creating a Google Product Category attribute as per the documentation):', @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\'),');
INSERT IGNORE INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order ) VALUES ('configGoogleMerchantFeed','BOX_CONFIGURATION_GOOGLEMERCHANTFEED','FILENAME_CON FIGURATION',CONCAT('gID=',@configuration_group_id),'configuration','Y',@configur ation_group_id);
INSERT IGNORE INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('toolsGoogleMerchantFeed', 'BOX_GOOGLEFROOGLE', 'FILENAME_GOOGLEFROOGLE', '', 'tools', 'Y', @configuration_group_id);

[voluntaryist.only]

I uninstalled the previous iteration of GM & installed all the files in the correct places & installed the sql insert & got the error below (sorry it is long btw my question is this do I ignore the errors & install the latest sql update? do I have to find the error & change them & then re-upload the sql insert & then install the latest sql patch, any help would be great, thanks etc.....

I have gone back & uninstalled completely, even removed files physically too. installed from fresh on zencart 1.39f (i know, i can't devote any time to upgrading right now.) I install all this time inc ALL of the sql update inserts. I only got 2 errors right at the end, whn installing the last sql update, same error as I listed originally.

I have tested it all & aside from some tiny niggles I'm good to go..

should i worry?

[voluntaryist.only]

Hi i have got the latest GM (numinix) installed on a zencart 1.39f I ran a test feed, & submitted it (testing mode) to google merchant, all products are missing the "availablity" attribute, any pointers please?

regards,

ed

[delia]

Why do you not recommend the versions following v1.12.5???

Didn't realize there was a newer version! It says it's updated for 1.5. I would be hesitant to use it unless I was using zen cart 1.5. Might well be fine but unless you are having problems and want to fix the additional image situation (he says there is a bug fix for that), I would leave well enough alone.

I'll give his new version a try with a 1.3.9 cart when I get a chance.

Not being able to view the feed in a browser? I never look at the feeds in the browser so I don't know the answer to that.

I would go ahead and upload to google and see what happens. If google accepts the feed then seeing it in the browser is moot. But I suspect there might be a problem. Google may give you some info about where to look.

If you are upgrading more than one step, you should go back and run each sql for the past one's to pick up changes normally. The included update sql file for that one present version only adds on the updates from the last version.

[delia]

Hi i have got the latest GM (numinix) installed on a zencart 1.39f I ran a test feed, & submitted it (testing mode) to google merchant, all products are missing the "availablity" attribute, any pointers please?

regards,

ed

First, you are on the wrong version of zen cart - 1.3.9h is the final version of that series - you presently have bugs and security issues. Availability is automatic with most carts though. There used to be a setting for it but it's now built in to the mod. You said most recent version - do you mean 1.13 from Numinix's site?

[DivaVocals]

Got it!!

Didn't realize there was a newer version! It says it's updated for 1.5. I would be hesitant to use it unless I was using zen cart 1.5. Might well be fine but unless you are having problems and want to fix the additional image situation (he says there is a bug fix for that), I would leave well enough alone.

I'll give his new version a try with a 1.3.9 cart when I get a chance.

Not being able to view the feed in a browser? I never look at the feeds in the browser so I don't know the answer to that.

I would go ahead and upload to google and see what happens. If google accepts the feed then seeing it in the browser is moot. But I suspect there might be a problem. Google may give you some info about where to look.

If you are upgrading more than one step, you should go back and run each sql for the past one's to pick up changes normally. The included update sql file for that one present version only adds on the updates from the last version.

[voluntaryist.only]

First, you are on the wrong version of zen cart - 1.3.9h is the final version of that series - you presently have bugs and security issues. Availability is automatic with most carts though. There used to be a setting for it but it's now built in to the mod. You said most recent version - do you mean 1.13 from Numinix's site?

Hi
thanks for the reply, I will clarify, I have installed the latest version for 1.39f (i made sure the extra parts for 1.5 were left off in the sql update insert) yes, 1.13

regards,

ed

[djace]

Hi All,

I am having some issues with the ver.1.13 google feeder.

Here is what I have done so far:

Fresh Install of ZC 1.5
aBagon template installed for ZC 1.5
installed ceon_uri_mapping_seo_4-0-7 module.
Created one test product

installed: Google Merchant Center Feeder 1.13.0
from: https://www.numinix.com/google-merchant-center-feeder

The installation went without problems and then I copied the content from install.sql and pasted into the admin/tools/instal SQL Patches.

After I configured the module, and when I generated the xml here is what I get:
"
Google Merchant Center Feeder v started 2012/02/23 21:01:15
Feed file - /home/...../rcsquad_products_en_5.xml
Processing: Feed - Yes, Upload - No
Google Merchant Center File Complete In 0.030815 Seconds 0 of 1 Records
"
It seems it knows that there is one product but it does not include it.

Any help is truly appreciated since I spent hours and hours on this.

Thank you,

Ed.

[Chris_T]

Hello all,

This may sound like a silly question but is there an option I can use with this module so that it will only export products that have a MPN entered?

Thanks in advance

[golowenow]

Hi,
I have been working on getting this add-on up to par for the new upgraded Zencart 1.5 and the new new google standards. I sell collector stamps. After upgrading my zencart to 1.5 I followed all the info and got the newest Google merchant feeder at Numinix which is 1.13. I completely uninstalled the older version and installed the newest one. After this the creation of the xml file timed-out badly. I tried EVERY recommended setting and such on both forums with no luck. Uninstalled, cleaned up database, installed about 4-5 times. Set php.ini higher set the addon to higher max time etc; with no luck.

I then completely uninstalled the newest version and then installed version 1.12.5 with torvista's sql install code and it works perfectly! No time-outs!

Whatever Numinix has done to the add-on does not work on my system. 1.12.5 does including putting in all proper attributes etc;.
And it is super fast. I have over 1500 products.

Hopefully Numinix will look into what is causing this problem on certain systems and look at what torvista has done.

My system
Windows XP home
Running Abyss Web Server
Zencart 1.5
All latest MySQL Database and PHP5