Forums / All Other Contributions/Addons / [OLD] Google Merchant module Version 1.12.0 by Numinix

[OLD] Google Merchant module Version 1.12.0 by Numinix

Locked

Started by pinkleopard on 20 Oct 2011, 1:25 AM · Views: 113,658

Results 301 to 320 of 567
This thread is locked. New replies are disabled.
7 Jan 2012, 10:17 AM
#301
discoverytdi avatar

discoverytdi

Totally Zenned

Join Date:
May 2011
Location:
Sunny Rossendale (not)
Posts:
562
Plugin Contributions:
0

[OLD] Google Merchant module Version 1.12.0 by Numinix

RescoCCC:

That error is familar looking and I think a fix was posted in the old Google Merchant Center thread.

Hi thanks for the info I've moved the site back to it's original folder and it's working fine, I moved it cause I've rebuilt my site on zencart 1.5 but as not all the mods I use have been upgraded I can't go live with it any way.

What ever your doing remember to KISS ( Keep It Simple Stupid )

7 Jan 2012, 2:38 PM
#302
discoverytdi avatar

discoverytdi

Totally Zenned

Join Date:
May 2011
Location:
Sunny Rossendale (not)
Posts:
562
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

has anyone tried this on zencart 1.5 or is a compatible mod due .
cheers

What ever your doing remember to KISS ( Keep It Simple Stupid )

7 Jan 2012, 5:58 PM
#303
rescoccc avatar

rescoccc

Totally Zenned

Join Date:
May 2010
Location:
WA State
Posts:
1,700
Plugin Contributions:
2

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

discoverytdi:

has anyone tried this on zencart 1.5 or is a compatible mod due .
cheers

It does not work with 1.5 since 1.5 handles the installation of admin configuration options differently than previous versions.

The best way to learn is to try stuff. But, back it up first.

10 Jan 2012, 10:19 PM
#304
us_purchase avatar

us_purchase

New Zenner

Join Date:
Oct 2007
Posts:
24
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

It there an update in the works for the latest Zen Cart version? Or is there another plug in that works with 1.50?

11 Jan 2012, 12:27 AM
#305
rescoccc avatar

rescoccc

Totally Zenned

Join Date:
May 2010
Location:
WA State
Posts:
1,700
Plugin Contributions:
2

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

US Purchase:

It there an update in the works for the latest Zen Cart version? Or is there another plug in that works with 1.50?

You'll have to ask Numinix if there's an update in the works. I assume there is, but they'll need to answer that. No, there isn't another plugin. There are a couple commercial options out there, but reports have been mixed about their reliability and compatibility.

The best way to learn is to try stuff. But, back it up first.

11 Jan 2012, 7:15 PM
#306
tapper avatar

tapper

Zen Follower

Join Date:
Nov 2007
Location:
Upstate NY
Posts:
233
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

I have around 50K products. I used the old Google Froogle mod with no problems. Of course, all of Google's changes last year killed my feed so I'm just getting started with the new one.

I am now on a VPS with 2 GB of memory. I editeds teh PHP config to increase php mem limit to 1 gb and max execution to 5 minutes (6000 seconds). I deleted the settings in the zen admin (blank = no limit). And still, it runs for a minute and then goes to page not found.

I just tried running in batches of 7000 products with different starting points. I generated the files and I just registered and uploaded them. One is a 4 GB file that Google says "234 of 235 products inserted".

What could this problem be? The instructions talk about increasing execution time in the config files but it doesn't say how to do it. It looks like the php file is designed to pick up the values in the database (from the admin).

If your script is timing out, edit the configurable area of /googlefroogle.php and increase the values as appropriate.
If you are seeing constants in the ADMIN->CONFIGURATION or ADMIN->TOOLS (i.e. BOX_GOOGLEFROOGLE), then you are missing a definitions file.
If the FTP function is timing out, as indicated by a timeout error, increase the timeout length in admin->googlefroogle.php near the beginning of the file.

Anyone have an idea what's wrong here?

13 Jan 2012, 9:07 PM
#307
micmed avatar

micmed

Zen Follower

Join Date:
Mar 2008
Location:
The Free South
Posts:
165
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

V1.12.0

My site links to external images. The XML created by the feeder is not formatting the URL correctly. Any ideas? This is what it looks like.

<g:image_link>http://www.simpsoncycles.com/images/http%3A//i102.photobucket.com/albums/m111/simpson_cycles/SUZUKI/G7-14_04/DSCN1197.jpg</g:image_link>

Where is the %3A coming from?

www.theCableStation.com
"If we restrict liberty to attain security we will lose them both."

16 Jan 2012, 12:39 PM
#309
micmed avatar

micmed

Zen Follower

Join Date:
Mar 2008
Location:
The Free South
Posts:
165
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

treefrog:

%3A is the URL encoding for a collon (:) ..

this link may help you .. http://www.php.net/manual/en/function.html-entity-decode.php

Granted, but how do I get the feed to create the correct character? Product images are not showing in Google Shopping.

www.theCableStation.com
"If we restrict liberty to attain security we will lose them both."

17 Jan 2012, 7:03 PM
#310
ksoup avatar

ksoup

Zen Follower

Join Date:
Jan 2004
Posts:
413
Plugin Contributions:
1

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Quotes in Product Descriptions.

We have 3,000 product descriptions that contain more than one " (quote) in them and this stops the data feed from completing. Is there fix for this or a work around? Removing all the quotes is a real pain.

18 Jan 2012, 5:02 PM
#311
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,880
Plugin Contributions:
7

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

I include here the steps I have used to get v12.5 working on my 1.5 upgrade. I take no responsibility for you buggering up your LOCAL DEVELOPMENT SERVER while testing this.
While this works for me, this does not imply the code is PCI-compliant (I doubt it), that’s for Numinix and the more knowledgeable folk to comment on.

1) DO NOT TEST THIS ON A PRODUCTION SERVER - as if you need to be told!
2) The file admin/includes/boxes/extra_boxes/googlefroogle_tools_dhtml.php is obsolete and should be deleted or rename it to googlefroogle_tools_dhtml.hidephp until you are confident all is well.
3) Open admin/includes/extra_datafiles/googlefroogle.php
Add this line:
define('BOX_CONFIGURATION_GOOGLEMERCHANTFEED', 'Google Merchant Center Feeder');//moved from _dhtml.php for 1.5
4) Go into phpmyadmin and Backup the database
5) Ensure you have carried out step 4)!
6) The problems I had all stemmed from things not being uninstalled properly and then not installing completely which became a vicious circle.
I recommend that you first use the uninstall_for_1_5.sql to try and remove all traces of the module:

#Google Merchant Center FEEDER uninstall 1.12.5 for 1.5

# BOF remove old Google Merchant Feeder configurations
SELECT (@googlemerchantcenterfeederid:=configuration_group_id)
FROM configuration_group
WHERE configuration_group_title='Google Merchant Center Feeder Configuration';
DELETE FROM configuration WHERE configuration_group_id=@googlemerchantcenterfeederid;
DELETE FROM configuration_group WHERE configuration_group_id=@googlemerchantcenterfeederid;
DELETE FROM admin_pages WHERE page_key='configGoogleMerchantFeed';
DELETE FROM admin_pages WHERE page_key='toolsGoogleMerchantFeed';

# EOF remove old Google Merchant Center Feeder Configuration
```  Then manually search for any references to google in phpmyadmin and check there are no entries left in the configuration or configuration group tables that are duplicated in the install_1_5.sql
   
  7)      Run the install in phpmyadmin->SQL (it gives errors if run from within the zen cart admin).

EDIT:I'll post the install file shortly, I posted a customised version here by mistake!

If you get errors about duplicate entries you did not clear out all the entries as described in 3). Note the name of the duplicates, run the uninstall again and check for this duplicate.

If all went well you should have the two menu options displaying as before.

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

18 Jan 2012, 5:13 PM
#312
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,880
Plugin Contributions:
7

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

...continuing from my previous post, the install file:

#Google Merchant Center FEEDER 1.12.5 for 1.5

ALTER TABLE products_options_values MODIFY products_options_values_name varchar(150);

# Insert new Google Merchant Center Feeder Configuration Group
SELECT @sortorder:=max(sort_order) FROM configuration_group;
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES 
(NULL, 'Google Merchant Center Feeder Configuration', 'Google Merchant Center Feeder Options',@sortorder+1, '1');
SET @googlemerchantcenterfeederid=last_insert_id();#get the number of the this new entry in the table
UPDATE configuration_group SET sort_order = @googlemerchantcenterfeederid WHERE configuration_group_id = @googlemerchantcenterfeederid;#use this entry number as the sort order (for the same position in the menu list)

# Insert Google Merchant Center Feeder settings

SET @security_key = SUBSTR(MD5(RAND()),1,10);

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?', @googlemerchantcenterfeederid, 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', @googlemerchantcenterfeederid, 1, NOW(), NULL, NULL),
(NULL, 'Google Merchant Center FTP Password', 'GOOGLE_PRODUCTS_PASSWORD', 'ftp_password', 'Enter your Google Merchant Center FTP password', @googlemerchantcenterfeederid, 2, NOW(), NULL, NULL),
(NULL, 'Google Merchant Center Server', 'GOOGLE_PRODUCTS_SERVER', 'uploads.google.com', 'Enter froogle server<br />default: hedwig.google.com', @googlemerchantcenterfeederid, 3, NOW(), NULL, NULL),
(NULL, 'Google Merchant Center PASV', 'GOOGLE_PRODUCTS_PASV', 'true', 'Turn PASV mode on or off for FTP upload?', @googlemerchantcenterfeederid, 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', @googlemerchantcenterfeederid, 5, NOW(), NULL, NULL),
(NULL, 'Store Address', 'GOOGLE_PRODUCTS_ADDRESS', 'http://www.domain.com', 'Enter your website address', @googlemerchantcenterfeederid, 6, NOW(), NULL, NULL),
(NULL, 'Store Description', 'GOOGLE_PRODUCTS_DESCRIPTION', '', 'Enter a short description of your store', @googlemerchantcenterfeederid, 7, NOW(), NULL, NULL),
(NULL, 'Output File Name', 'GOOGLE_PRODUCTS_OUTPUT_FILENAME', 'domain', 'Set the name of your froogle output file', @googlemerchantcenterfeederid, 8, NOW(), NULL, NULL),
(NULL, 'Compress Feed File', 'GOOGLE_PRODUCTS_COMPRESS', 'false', 'Compress Google Merchant Center file', @googlemerchantcenterfeederid, 9, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Uploaded date', 'GOOGLE_PRODUCTS_UPLOADED_DATE', '', 'Date and time of the last upload', @googlemerchantcenterfeederid, 10, NOW(), NULL, NULL),
(NULL, 'Output Directory', 'GOOGLE_PRODUCTS_DIRECTORY', 'feed/google/', 'Set the name of your froogle output directory', @googlemerchantcenterfeederid, 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.', @googlemerchantcenterfeederid, 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):', @googlemerchantcenterfeederid, 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):', @googlemerchantcenterfeederid, 14, NOW(), NULL, NULL),

(NULL, 'Max products', 'GOOGLE_PRODUCTS_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @googlemerchantcenterfeederid, 20, NOW(), NULL, NULL),
(NULL, 'Starting Point', 'GOOGLE_PRODUCTS_START_PRODUCTS', '0', 'Start at which entry (not product_id)?<br />Default=0', @googlemerchantcenterfeederid, 21, NOW(), NULL, NULL),
(NULL, 'Included Categories', 'GOOGLE_PRODUCTS_POS_CATEGORIES', '', 'Enter category ids separated by commas <br>(i.e. 1,2,3)<br>Leave blank to allow all categories', @googlemerchantcenterfeederid, 22, NOW(), NULL, NULL),
(NULL, 'Excluded Categories', 'GOOGLE_PRODUCTS_NEG_CATEGORIES', '', 'Enter category ids separated by commas <br>(i.e. 1,2,3)<br>Leave blank to deactivate', @googlemerchantcenterfeederid, 23, NOW(), NULL, NULL),
(NULL, 'Included Manufacturers', 'GOOGLE_PRODUCTS_POS_MANUFACTURERS', '', 'Enter manufacturer ids separated by commas <br>(i.e. 1,2,3)<br>Leave blank to allow all categories', @googlemerchantcenterfeederid, 24, NOW(), NULL, NULL),
(NULL, 'Excluded Manufacturers', 'GOOGLE_PRODUCTS_NEG_MANUFACTURERS', '', 'Enter manufacturer ids separated by commas <br>(i.e. 1,2,3)<br>Leave blank to deactivate', @googlemerchantcenterfeederid, 25, NOW(), NULL, NULL),

(NULL, 'Expiration Date Base', 'GOOGLE_PRODUCTS_EXPIRATION_BASE', 'now', 'Expiration Date Base:<ul><li>now - add Adjust to current date;</li><li>product - add Adjust to product date (max(date_added, last_modified, date_available))</li></ul>', @googlemerchantcenterfeederid, 30, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'),
(NULL, 'Expiration Date Adjust', 'GOOGLE_PRODUCTS_EXPIRATION_DAYS', '29', 'Expiration Date Adjust in Days', @googlemerchantcenterfeederid, 31, NOW(), NULL, NULL),

(NULL, 'Show Default Currency', 'GOOGLE_PRODUCTS_CURRENCY_DISPLAY', 'true', 'Display Currency', @googlemerchantcenterfeederid, 40, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Default Currency', 'GOOGLE_PRODUCTS_CURRENCY', 'USD', 'Select currency', @googlemerchantcenterfeederid, 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. ', @googlemerchantcenterfeederid, 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', @googlemerchantcenterfeederid, 46, NOW(), NULL, NULL),
(NULL, 'Default Condition', 'GOOGLE_PRODUCTS_CONDITION', 'new', 'Choose your default condition', @googlemerchantcenterfeederid, 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?', @googlemerchantcenterfeederid, 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', @googlemerchantcenterfeederid, 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?', @googlemerchantcenterfeederid, 50, NOW(), NULL, 'zen_cfg_select_option(array(\'default\', \'top\', \'bottom\', \'full\'),'),
(NULL, 'Show Feed Language', 'GOOGLE_PRODUCTS_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @googlemerchantcenterfeederid, 51, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Feed Language', 'GOOGLE_PRODUCTS_LANGUAGE', '1', 'Set your feed language (required):', @googlemerchantcenterfeederid, 53, NOW(), NULL, 'google_cfg_pull_down_languages_list('),
(NULL, 'Show Weight', 'GOOGLE_PRODUCTS_WEIGHT', 'false', 'Include products weight?', @googlemerchantcenterfeederid, 53, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Weight Units', 'GOOGLE_PRODUCTS_UNITS', 'pounds', 'What unit of weight measure?<br />pounds OR kilograms', @googlemerchantcenterfeederid, 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?', @googlemerchantcenterfeederid, 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?', @googlemerchantcenterfeederid, 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)?', @googlemerchantcenterfeederid, 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)?', @googlemerchantcenterfeederid, 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', @googlemerchantcenterfeederid, 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 <a href="http://www.google.com/support/merchants/bin/answer.py?answer=160081" target="_blank">Google Category Taxonomy</a> or leave blank (note: you can override this default setting by creating a Google Product Category attribute as per the documentation):', @googlemerchantcenterfeederid, 60, NOW(), NULL, NULL),

(NULL, 'Display Tax', 'GOOGLE_PRODUCTS_TAX_DISPLAY', 'false', 'Display tax per product? (US only)', @googlemerchantcenterfeederid, 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)', @googlemerchantcenterfeederid, 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*)', @googlemerchantcenterfeederid, 72, NOW(), NULL, NULL),
(NULL, 'Tax Rate', 'GOOGLE_PRODUCTS_TAX_RATE', '5.00', 'Enter the percentage as a decimal number (without "%" symbol)', @googlemerchantcenterfeederid, 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', @googlemerchantcenterfeederid, 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?', @googlemerchantcenterfeederid, 80, NOW(), NULL, NULL),
(NULL, 'Payment Notes', 'GOOGLE_PRODUCTS_PAYMENT_NOTES', 'GoogleCheckout', 'Add payment notes (use this for showing you accept Google Checkout)', @googlemerchantcenterfeederid, 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', @googlemerchantcenterfeederid, 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:', @googlemerchantcenterfeederid, 91, NOW(), NULL, NULL),  
(NULL, 'Shipping Country', 'GOOGLE_PRODUCTS_SHIPPING_COUNTRY', '', 'Select the destination country for the shipping rates:', @googlemerchantcenterfeederid, 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 *):', @googlemerchantcenterfeederid, 93, NOW(), NULL, NULL),
(NULL, 'Shipping Service', 'GOOGLE_PRODUCTS_SHIPPING_SERVICE', '', 'Enter the shipping service type (i.e. Ground):', @googlemerchantcenterfeederid, 94, NOW(), NULL, NULL),
(NULL, 'Pickup', 'GOOGLE_PRODUCTS_PICKUP', 'do not display', 'Local pickup available?', @googlemerchantcenterfeederid, 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.', @googlemerchantcenterfeederid, 100, NOW(), NULL, NULL),
(NULL, 'Image Handler', 'GOOGLE_PRODUCTS_IMAGE_HANDLER', 'false', 'Resize images using image handler (separate module required)?', @googlemerchantcenterfeederid, 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)?', @googlemerchantcenterfeederid, 999, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');


# Register the configuration page for Admin Access Control
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configGoogleMerchantFeed','BOX_CONFIGURATION_GOOGLEMERCHANTFEED','FILENAME_CONFIGURATION',CONCAT('gID=',@googlemerchantcenterfeederid),'configuration','Y',@googlemerchantcenterfeederid);

# Register the tools page for Admin Access Control
INSERT 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', 31);

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

18 Jan 2012, 6:37 PM
#313
rescoccc avatar

rescoccc

Totally Zenned

Join Date:
May 2010
Location:
WA State
Posts:
1,700
Plugin Contributions:
2

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Steve,

It works perfectly! Thank you for going to the effort to do this.

The best way to learn is to try stuff. But, back it up first.

18 Jan 2012, 9:36 PM
#314
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,880
Plugin Contributions:
7

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

It works perfectly!That's unusual for my contributions!
It did take me an embarrassingly long time to get right but at least I now know how to get pre 1.5 add-ons integrated into the menus, and have finally realised what the @ means in sql: only took me 2.5 years to cotton on!

Thanks for the thanks.

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

18 Jan 2012, 9:52 PM
#315
rescoccc avatar

rescoccc

Totally Zenned

Join Date:
May 2010
Location:
WA State
Posts:
1,700
Plugin Contributions:
2

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

It did take me an embarrassingly long time to get right

If we had to rely on me, Zen Cart version 22.5 would be out, and they'd find my long dead skeletal remains slumped over the keyboard.

The best way to learn is to try stuff. But, back it up first.

18 Jan 2012, 10:15 PM
#316
rescoccc avatar

rescoccc

Totally Zenned

Join Date:
May 2010
Location:
WA State
Posts:
1,700
Plugin Contributions:
2

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

PS: I would add a little bit to the instructions, though. Something like this:

Do the following if you've already attempted to install in Zen Cart 1.50.

And then this:

If you have not already attempted to install in Zen Cart 1.50, (so this will be a fresh install), upload the files from the mod, but do not install the SQL patch included with the mod. Then follow the instructions, omitting the uninstall process.

The best way to learn is to try stuff. But, back it up first.

21 Jan 2012, 3:13 PM
#317
ron_haltermon avatar

ron_haltermon

New Zenner

Join Date:
Dec 2007
Location:
Dothan, Alabama
Posts:
16
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Just a note of gratitude, Steve. It worked fine (after some effort). I found that copying and pasting the install file from here into the phpadmin query returned a null error. After two or three failed attempts, I copied it from here to my html/php editor and then saved it and copied it from there to phpadmin. The unwanted character was eliminated and it uploaded just fine.
I have used the GoogleFroogle for multiple sites and it has always been a breeze in prior versions of Zen Cart. Version 1.5 presented a real challenge. You made it easy! Thanks for your work on this issue.

25 Jan 2012, 1:11 PM
#318
maximusmccullough avatar

maximusmccullough

New Zenner

Join Date:
Mar 2011
Posts:
2
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Fantastic Job! Thanks! :clap:

27 Jan 2012, 12:49 AM
#319
kevinmc3 avatar

kevinmc3

Totally Zenned

Join Date:
Jun 2006
Posts:
786
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

This absolutely NOT Possible for some of us that have unique categories, not to mention how such a long trail of subcategories will affect other Mods (i.e. Simple SEO) and the page URLs??

Any way around this?

PinkLeopard:

This is the NEW thread for the latest version of Numinix Google Merchant Version: 1.12.0

  1. If you have any prior version of GM installed you must un-install by using the sql un-install located in the file.
  2. Install the NEW sql patch.
  3. Upload all NEW files.
  4. Make sure the feed/goolge file is chmod at 755 or 777

Google Requirements:

1. Basic Product Information

A .id [id]- An identifier of the item
B. title [title] - Title of the item
C. description [description] - Description of the item
D. google product category [google_product_category] - Google's category of the item
E. product type [product_type] - Your category of the item
F. link [url] - URL directly linking to your item's page on your website
G. image link [image_link] - URL of an image of the item
H. additional image link [additional_image_link] - Additional URLs of images of the item
I. condition [condition] - Condition or state of the item

All of these conditions should be automatic if everything is set-up correctly with your Zen-Cart.

Troubleshooting:

D. google product category [google_product_category] - Google's category of the item

This is a must. You have to follow Google's cateogry tree. I had to change all of my categories to match theirs.
How I did it (and it took me a full day to do it) is I made the required categories for my products and moved my items to the right categories. If anyone knows a better way, then please post it.

Here's their category tree:

catergory tree here

Example: If I sell shoes, then my categories would be the following:

Shoes - Main category

Sub categories:

Athletics Shoes

Boots

Flats

High Heel Shoes

Loafers & Moccasins

Outdoor Shoes

Sandals

Slippers

Trainers

2. Availability & Price

A. availability [availability] - Availability status of the item

  1. Your Zen-Cart must have "show quantity stock set to 1.
  2. Your GM config must have Show Quantity (true) & Default Quantity (1)

B. price [price] - Price of the item
C. sale price [sale_price] - Advertised sale price of the item
D. sale price effective date [sale_price_effective_date] - Date range during which the item is on sale

3. Unique Product Identifiers

A. brand [brand] - Brand of the item
B. gtin [gtin] - Global Trade Item Number (GTIN) of the item
C. mpn [mpn] - Manufacturer Part Number (MPN) of the item

These are the most common problems. Please read first before posting.

For more information Product Feed Specification

click here

27 Jan 2012, 1:38 PM
#320
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

kevinmc3:

This absolutely NOT Possible for some of us that have unique categories, not to mention how such a long trail of subcategories will affect other Mods (i.e. Simple SEO) and the page URLs??

Any way around this?

I just found that Numinix has a paid version that allows for this: https://www.numinix.com/zen-cart-modules/marketing/google-product-search-feeder

Right now Google is not penalizing anyone who has products in incorrect categories so your feed will be on google.

Torvista - thanks for the info on the 1.5 installation. I'll let Jeff know that you have come up with something he might be able to use. Also, thanks for all your efforts! I'm so glad you took the time to give it a try~

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo