Printable View
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.Quote:
Originally Posted by RescoCCC
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.Quote:
Originally Posted by discoverytdi
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.Quote:
Originally Posted by US Purchase
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?
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?
%3A is the URL encoding for a collon (:) ..
this link may help you .. http://www.php.net/manual/en/functio...ity-decode.php
Granted, but how do I get the feed to create the correct character? Product images are not showing in Google Shopping.Quote:
Originally Posted by treefrog
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.
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.
[FONT=Calibri]1) [/FONT]DO NOT TEST THIS ON A PRODUCTION SERVER - as if you need to be told!
[FONT=Calibri]2) [/FONT]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.
[FONT=Calibri]3) [/FONT]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
[FONT=Calibri]4) [/FONT]Go into phpmyadmin and Backup the database
[FONT=Calibri]5) [/FONT]Ensure you have carried out step 4)!
[FONT=Calibri]6) [/FONT]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:
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.sqlPHP Code:#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
[FONT=Calibri]7) [/FONT]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.
...continuing from my previous post, the install file:
PHP Code:#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,
It works perfectly! Thank you for going to the effort to do this.
That's unusual for my contributions!Quote:
It works perfectly!
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.
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.Quote:
It did take me an embarrassingly long time to get right
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.
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.
Fantastic Job! Thanks! :clap:
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?
Quote:
Originally Posted by PinkLeopard
I just found that Numinix has a paid version that allows for this: https://www.numinix.com/zen-cart-mod...-search-feederQuote:
Originally Posted by kevinmc3
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~
Hi
Looking for a little help as trawled this thread and the previous one, until boredom set in
I have 1.3.8 and have had a previous version of base feeder installed and working fine for several months
However, now getting errors due top lack of "Availability" being shown on my products
I realise I need to upgrade this add-on as new version now includes this attribute, however I have uploaded the new files to the site and am getting a little stuck with what I have to do with the SQL database stuff.
The previous version was done by a chap that new what he was doing, but I think at last check he is now in a tent outside St Pauls!!!
I am trying to get this sorted, but have now spent way too long staring dumbly at my PC
I gather I need to un-install the previous SQL stuff before installing the new?? But I don't know what to do
Any pointers Please!:lamo::lamo:
www.mobiles2gaming.com
Mike
First, figure out what version you are currently using and run the uninstall SQL patch that came with it. Then run the install patch that comes with the current version.Quote:
and am getting a little stuck with what I have to do with the SQL database stuff.
To run these patches, login to your admin and go to tools/install SQL patches. Open the patch in a PLAIN text editor such as notepad++. Copy and paste the contents in the box and click "send". Make sure you have no spaces at the beginning or the end of the contents.
I am using latest version of this software and zen v1.3.9h.
I would like to be able to include/exclude products marked "out of stock" in my products feed - is this possible?
Its just that it seems pointless to include products that are out of stock.
I cant see any obvious settings in feeds config.
Many ThanksQuote:
Originally Posted by RescoCCC
Got it creating file and I am able to up-load, but the file seems to be corrupted somehow, when I click on the file to look at it in raw form in a web page I get the following quote
"This page contains the following errors:
error on line 2122 at column 67: EntityRef: expecting ';'
Below is a rendering of the page up to the first error."
I get the same error message from Google Merchant account and it says that only 106 of 107 have been added, although my feed should be 1300 products
It also tells me that I am missing the "Availability" attribute still, which was the whole point of upgrading the Add-on and I thought this version now included
Has anybody got any ideas??
Mike
mobiles2gaming.com
:frusty:
Sometimes it takes going back through a bunch of the sql updates. Never hurts to run previous ones again and then you might pick up what is needed. If I remember correctly there was a major change back towards 10 to 11 or in 11.
Hi, I've got zen cart 1.3.9h and google merchant 1.4.9 with the update_1_12_4.sql patch. I've tried hard to find the answers on my own before I post. Basically it's not generating the xml file, the latest thing I'm seeing in the popup box is:
Processing: Feed - Yes, Upload - No
2 skipped due to user restrictions
3 skipped due to user restrictions
(repeats for every product)
I can't find anywhere what the user restrictions has to do with. I have a google merchant account, I'm signed into it, I've submitted the feed name in google merchant.
One interesting thing: I use easy populate, and when I downloaded the froogle file with this and opened it in notepad, all my product url's are https instead of http, but I only use https for login and checkout. Why would it be doing this, and is this causing problems?
If anyone has any ideas I'd love to hear them! Thanks!
So when we've installed the latest version do we still need to install all the previous patches? I thought only the latest....Quote:
Originally Posted by delia
Ok, I uninstalled google merchant and installed again, now I'm not getting the above error, but it's not creating the whole xml feel file, just basically the header as you can see here.
I'm still wondering if it's creating https links instead of http like the easy populate frugal file does.
This is what is in the pop up window:
Feed file - /home6/blackor1/public_html/store/feed/google/domain_products_en.xml
Processing: Feed - Yes, Upload - No
id: 2, price: 32, description length: 271 - including - success
id: 3, price: 29, description length: 121 - including - success
etc. for all products.
When I click upload, it uploaded, but just the header apparently, no products were installed. It's probably something in the configuration of my cart settings. Anyone recognize this problem? Thanks!
Nevermind all of the above, I downloaded the file from the feed/google folder and it seems to be right. Now I'll just have to add the extra attributes I need and then see if I can upload it. So I should be good for now!
Numinix have released a version for zencart 1.5 will there sql unistall remove torvista's fix posted on page 32.
Cheers
If you are asking will Numinix post a script to reverse the SQL torvista posted?? The answer is no.. You can compare the SQl included with the new Numinix version and see how different it is from Torvista's and make manual changes accordingly..Quote:
Originally Posted by discoverytdi
Will someone else post a reversal script?? Maybe..:smile:
A few questions about feed etiquette:
How soon can you re-feed your products to google?
I uploaded last Wednesday, data was good but I am still awaiting the google "manual" review (can take 5 biz days) before being inserted into searchable category.
While waiting, I added a bunch of new products, would like to feed them also. Should I just wait until the google review is complete?
Also, as a matter of general protocol, should I wait until my products expire before re-feeding? I have a fast moving inventory, constantly adding stuff.
Thanks!
I can't answer your first question about waiting for google to review before you upload another feed. Actually, I think I can make a good guess, because your feed would have the same name, if/when they look at it they will see the most current version of the file. As for how often to submit it, I do remember reading somewhere on here that daily is ideal, especially if it's changing a lot.
Thanks, BlackOrchidCouture! That sound pretty reasonable to me.
If you're getting a manual review, it must be a new feed. After this first manual review, and assuming it's approved, the feed will process automatically. Google actually encourages frequent updates to insure that the data is fresh.
I'm running Zen 1.3.9h with google merchant 1.13. I'm ready to pull my hair out. I finally got everything to work correctly and was ready to upload my data. THEN, I saw a post on google regarding watermarks. All my images have them and they must since I sell graphics. :frusty:
I have a few display boxes that don't have watermarks and in the future, I will create two (one with and one without). My question is, has anyone been rejected because of watermarks? Mine are so faint you can barely see them. The other question is if I put the images in a new folder on the host server, how do I link them with the actual products? I'm so confused and have been working on this for days. HELP. :blink:
Also, I don't charge taxes but won't be using the google shopping cart. How do I handle taxes if I my products arent' taxable?:dontgetit
watermarks - my understanding is that image handler applies watermarks on the fly so doesn't affect the actual images.
Google's is getting really strict about a lot of things - not had the experience with watermarks.
So there really isn't fix for my issue other than to move forward with products with no watermarks?
I'm using Image Handler and I don't see where it adds a watermark on the fly. I'll have to look into that. Maybe Image Handler 3 will do this as I'm using IH2.
Image Handler adds the watermark to the images stored in the bmz_cache file (which are the ones you see cartside) not the actual original image which is stored in the images folder.Quote:
Originally Posted by theclipartcorner
Works the same with both IH2 and IH3 as far as I can tell.
Wow!
I have a zc139h and I upgraded my merchant feeder from 1.8.2 to 1.12.5 the other day.
My first feed went fine, I had to wait a week for the google manual review but it went off without a hitch. While waiting I added 10 more products.
So I updated the feed and submitted to google, only to receive tons of xml parsing errors.
Here is a link to w3's validator w/ my feed already plugged in (I used google short url to reduce the size):
http://goo.gl/wFQpq
Should I erase and reinstall? what did I do wrong?
Thanks!
I've run this module for awhile. Wasn't able to really put the time to fixing everything for googles new requirements, finally getting to it.
Currently, in my config menu, it shows running version 1.13.0, BUT when I click on the button in the tools menu to make a new feed file, the window that pops up says, 1.12.4 at the top.
I got my hands crossed yesterday, and uninstalled the files, and ran the sql script. instead of saying x amount of steps processed, it filled the screen up with words.
Anyways, I then reinstalled 1.12.4 and ran the sql file. Everything came back and running normal.
Now, I have the xml sanitizer turned on.
My feed file, google inputs 1500 out of 3000 items. I check errors, and it states XML error 48,253 col 30. I try to open the xml file with Microsoft xml notepad and get an error, but then it allows me to open it directly into notepad. I scroll down to 48253 col 30 and the whole line is this: <g:tax>
the whole section at that line area is.
<g:tax>
<g:country>US</g:country>
<g:region>FL</g:region>
<g:rate>7</g:rate>
</g:tax>
So not sure what the error is? could this be a UTF8 coding problem? any insight....just want to get the rest of my products uploaded
Thanks...
Oh on another thing, I tried earlier to put up 1.13.0 and when running the sql, it had two errors with not finding a table or something....could this be an issue?
I saw this question in the thread and did not see an answer. I am suffering the same problem. I have over 300 items on my store but when I try to view it in the xml feed I get the feed code error. Can someone point me in the right direction. I would love to ge it fixed.Quote:
Originally Posted by spawnie69
Have you tried turning on the sanitizer? That frequently cures all problems.
Enable Advanced XML Sanitization turn to true
Will I find that option in my admin/configuration?
Ok I just found it and the same thing anymore advice?
Just to let you know I am using the 1.13.0 version.. is that outdated? I have the new upgrade on my site 1.5Quote:
Originally Posted by dnwmarket
1.12.5 is the most recent version that I suggest everyone use. If you go to that, you must make sure you run all the sql updates.
Why do you not recommend the versions following v1.12.5???Quote:
Originally Posted by delia
Ok but will that older version 1.12 help me with the feed code error. I have the newer version as stated and followed the process and getting feed error.
When I hit the confirm button i get
Google Merchant Center Feeder v started 2012/02/21 13:38:24
Feed file - //home/wrightsm/public_html/www.buybackissuesonline.com/feed/google/domain_products_en.xml
Processing: Feed - Yes, Upload - No
Google Merchant Center File Complete In 3.972183 Seconds 325 of 329 Records
But when i try to view my feed i cannot
You said earlier in your post about running all the sql in the version I have I only have one sql and then there are the updates for the past ones.
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 :blush: 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 :smile:
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);
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.Quote:
Originally Posted by voluntaryist.only
I have tested it all & aside from some tiny niggles I'm good to go..
should i worry?
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
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.Quote:
Originally Posted by DivaVocals
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.
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?Quote:
Originally Posted by voluntaryist.only
Got it!!:smile:
Quote:
Originally Posted by delia
HiQuote:
Originally Posted by delia
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
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.
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
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.:censored:
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!:clap:
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.:unsure:
My system
Windows XP home
Running Abyss Web Server
Zencart 1.5
All latest MySQL Database and PHP5
Hi Golowenow,
I am gald you got yours up and running.
I noticed that with 1.13, I can only generate products that have single category.All products that are found in the subcategories are not generated.
I will try the 1.12.5 version and see if that works for me as well.
Thank you,
Ed.
"Further in Admin--Configuration--Google Merchant Center Feeder Configuration, ensure you have suitable values for Show Quantity, Include Zero Quantity and Default Quantity" - copied from a previous thread.
I don't seem to have these in my config page. Is there a list of what configuration fields / options should show?
That was information about an earlier version so ignore that one. No list is ever available for what is to show in admin.Quote:
Originally Posted by MikeyG
This might sound liie a silly question but can anyone please
post a link for me to download the 1.12.5 version?
Thank you,
Ed.
This is the latest version:
https://www.numinix.com/google-merchant-center-feeder
Thank You,
That is the version that I am using already.
I found my problem. When I enabled the "Debug mode" I was getting message: skipped due to user restrictions.
To fix it I had to convert my 1.50 zencart to use the utif-8 format.
found here: https://www.numinix.com/blog/2011/08...-3-9-to-utf-8/
I thought that I didn't need to convert since I am using zencart 1.5.0 but it turns out that was the problem.
Now I am able to generate all of my prducts and upload to google.
Onward,
Ed.:clap:
I'm about to drive myself nuts getting this module to work. I have a clean install of ZC 1.5 and I've installed version 1.13.0. Everything looks good in the XML file except for the product links. Here's an example:
What the link should look like: http://www.rainbowstitchery.com/zen1...roducts_id=447
What comes up in the XML file: http://www.rainbowstitchery.com/zen1...roducts_id=447
I've tried it with Enable Advanced XML Sanitization set to true and false with no change in the links. What else can I try to get this fixed and running?
Well, I think I may have figured out my problem. When I download the file and view it on my computer, the links are just like the incorrect one above, but when I click on the link in my admin area, the links are fine. Weird, but if it works, I'm not going to question it. :)Quote:
Originally Posted by laurelsstitchery
I am having issues with my google merchant. It will work for a while then stop working, the error says product expiration date. Can someone walk me through on how to fix this issue?
Hi all,
Google encounters an xml error when one of my items has a registered trade mark in the product name.
If I insert a new product with a product name like this:
My Test Product ®
the feed failed at the point where google reads the line <title><![CDATA[My Test Product xAE]]</title>
Is there a solution for this error? Thanks.
I've installed version 1.13.0 on my site (ZC 1.50). When I click to create the feed, it runs for a while (several minutes) and then gives me the "internal server error" screen. If I specify just one category, it runs fine, but I have literally hundreds of categories. I can't do a file for each one separately. I looked in the error logs and it gives me this:
But obviously that file isn't missing or it wouldn't run correctly with just one category selected. I'm assuming it's timing out, so I increased the max execution time to 900 and the memory limit to 999M. It still doesn't work. What else can I try to get this to work?Quote:
[07-Mar-2012 11:28:19] PHP Warning: fopen(/private/catalog/module_version/google_merchant_center_feeder.txt) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in /private/catalog/includes/classes/google_base.php on line 81
[07-Mar-2012 11:28:19] PHP Warning: filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /private/catalog/module_version/google_merchant_center_feeder.txt in /private/catalog/includes/classes/google_base.php on line 82
[07-Mar-2012 11:28:19] PHP Warning: fread(): supplied argument is not a valid stream resource in /private/catalog/includes/classes/google_base.php on line 82
[07-Mar-2012 11:28:19] PHP Warning: fclose(): supplied argument is not a valid stream resource in /private/catalog/includes/classes/google_base.php on line 83
That error tells me you need to go back and make sure that file isn't missing first.Quote:
Originally Posted by laurelsstitchery
I checked that before I posted. It works with only one category selected, so like I said, I'm assuming it's timing out. I've increased the max time and memory with no change. What else can I try? Has anyone with such a large catalog gotten this version to work? The older version I had on my 1.39h catalog worked with the same inventory.Quote:
Originally Posted by delia
Hi, I am running 1.3.9h.
I have now sorted my teething problems with shipping and weight etc but have an issue with Product Type. Out of 403 products I'm getting this error:
Missing recommended attribute: product type (69 warnings)
I cant workout why only 69 items are incorrect and not all 403 of them (which would suggest a configuration error on my part), any ideas?
Any help would be greatly appreciated as I am starting to lose the will!:frusty:
Jane
I think I've figured out the problem, but I don't know how to fix it. In the zip of 1.13.0 that I have (and I just downloaded it again to see if I accidentally deleted the file) there is no catalog/module_version/ folder or catalog/module_version/google_merchant_center_feeder.txt file. Where can I get these?
Which file did you check for?? I believe that the error says that this file: /private/catalog/module_version/google_merchant_center_feeder.txt is missing.. if you checked that the /private/catalog/includes/classes/google_base.php is there, you have checked for the wrong file..Quote:
Originally Posted by laurelsstitchery
Yes, I finally rebooted my brain and realized that. LOLQuote:
Originally Posted by DivaVocals
The missing file is not included in the package I downloaded from numinix though.
I have yet to get mine to work since I have converted to the new 1.13. I have created a brand new store and I am on ZC 1.5. I am also using the latest CREON URI mod. It works fine if I limit to 100 or 200 products, but fails with anything higher. I have disabled the memory and time limits and still can't get it to work. Unfortunately, since Google has modified their structure, I can't go back to the old feed. The old feed worked perfectly with over 5,000 products.Quote:
Originally Posted by laurelsstitchery
I'm having the same problem. Yesterday I was able to generate a feed file with around 1000 items, out of over 6000.
I excluded category after category until I was down to a number small enough for the mod to complete.
I have no idea why its not completing, but I do know it has something to do with the number of products it has to include in the feed file.
started getting invalid price on a new site i set up (i have 2 other sites already this is just my 3rd site for one manufacturer) and all my items failing 0 of 138 items inserted.
Invalid price (138 errors) We don't accept non-numeric values or negative prices. If you are including the currency code or symbol, please make sure it matches the currency of the target country.
Examples:
price 1177.38
how is it wrong?
also failing because all my items are free shipping. says 0 is incorrect for shipping
Does anyone know why when running the feed creation I'm getting this message for all products?
Processing: Feed - Yes, Upload - No
id: 570, price: 0, description length: 127 - skipped: price below zero, description length less than 15 chars, or title less than 3 chars - failed
id: 571, price: 0, description length: 122 - skipped: price below zero, description length less than 15 chars, or title less than 3 chars - failed
id: 572, price: 0, description length: 124 - skipped: price below zero, description length less than 15 chars, or title less than 3 chars - failed
id: 573, price: 0, description length: 264 - skipped: price below zero, description length less than 15 chars, or title less than 3 chars - failed
Help very much appreciated.
maybe because the item is price below zero,
or the title less than 3 chars
??
Ok, I left the post open to that one :blush:Quote:
Originally Posted by kitcorsa
Additional information I should have put in the post. I'm using Zen Cart 1.5 and have just re-implemented the add on. The error message is for all products and NO the prices aren't below zero or titles less than 3 chars.
Hope someone can help with this as it’s a great contribution and I'd love to get it working properly.
When going to the feed URL it appears that the feed is in order from the oldest products to the newest. Is there a way to sort it from the newest to oldest?
I had the same problem after upgradin to 1.13. After some troubleshooting, if removed line 376Quote:
Originally Posted by rortega01
from the file catalog\includes\classes\google_base.php , and all is working fine again :clap:Code:$additional_images = $this->additional_images($products->fields['products_image']);
this line was added in version 1.13
I don't know or care why this worked, but it worked!!!!!!!!!! Thank you!!!! :)Quote:
Originally Posted by Design75
Is this the current google merchant update?Quote:
Originally Posted by PinkLeopard
The latest version can be found here google merchant center feederQuote:
Originally Posted by gpsupps10
Line 2 in the configurationQuote:
Originally Posted by askaquestion
Code:Debug true
I received a similar error message. I have a few free products on my site.
Do you have a price on the products mentioned? Check them to see if they have a valid price. Once I cleared the problem with my free items, I didn't get any further errors.
I don't charge for shipping either. I have 'download' in my store, configuration, google merchant. Also, within Google Merchant, I believe you can specify your shipping cost there as well.Quote:
Originally Posted by kitcorsa
It worked!!! Thanks, this has been a nightmare for me and was getting anxious.
Worked for me too!! No questions from me either.
I finally got 1.13 to process my 19,456 items and created a good file. Now this file is over 25MB in size and google is choking on the upload.
I see that I can compress the file, how do I set it up with google to fetch the compressed file?
Do I create a product feed with the compressed filename?
Or do I leave the filename_products_en.xml alone and upload the compressed file?
Hello,
Have installed the latest version of Google Feed and I also have the latest version of Zen cart (v.1.5.0). I managed to get the google feed to work first time with just one test product in my store. Now as I am adding more the feed is failing, even though the products are added in exactly the same way as the test product?
I have looked at the feed in Opera and it is telling me the following:
XML parsing failed
XML parsing failed: syntax error (Line: 32, Character: 575)
Reparse document as HTML
Error:
illegal byte sequence in encoding
Google chrome is telling me:
This page contains the following errors:
error on line 32 at column 329: Encoding error
Below is a rendering of the page up to the first error.
and my merchant account is telling me:
XML formatting error - Error
Our system encountered an error when processing your data feed. Learn more.
Examples:
Line No. Column No.
32 29
Does anyone know what "illegal byte sequence in encoding" means so that I can correct this in my feed?
Many thanks
Quote:
Originally Posted by spiggles87
Found the problem - It was the £ signs within my description.
I am struggling, and cross my heart I have read this thread through 3 times and still struggling to understand what I have done wrong, help appreciated:blush:
I get the error mentioned already by someone, about missing admin_table (after adding update.sql), is the answer to change the reference to 'admin' to the name I used for over-ride, if so in which files?
In my items descriptions, I have the cost of different types of delivery, put there because customers weren't reading the delivery section, will the £ signs in that description really affect an upload?
where can I download this module?
see aboveQuote:
Originally Posted by Design75