Quote:
Originally Posted by new2u
It seems to relate to the UPC/ISBN/EAN field.. I have the Numinix Product Fields installed... maybe something changed in that too
It works with it disabled
Printable View
Quote:
Originally Posted by new2u
It seems to relate to the UPC/ISBN/EAN field.. I have the Numinix Product Fields installed... maybe something changed in that too
It works with it disabled
Thanks for your input @countrycharm While that post helped with some of my problem, it did not solve all of it. Which is detailed in my entire posts. Personally I would rather find everything together if I was searching for an issue and how it was solved, rather than piece together various issues scattered throughout a forum as I had to do.
In a forum environment comprised of fellow users giving freely of their time to support an open source software package, it is unrealistic to expect to find all the answers you need neatly packaged in to a single source. If that's what you desire, buy a commercial cart.Quote:
Originally Posted by new2u
So you suggest I should just resolve my own problems and not post the solutions to them I have found as I troubleshot them? finding the 1062 error helped, but it was not my 1064 problem which was an issue with my version of mysql. It helps to read the entire post rather than skimming the first 2 lines and posting some snide remarks. Seriously guys, read my post. There was more to it than what he had posted. I shared it to help out others.
What happened to the Brand field?
I am getting an error on my feed. Missing recommended attribute: brand
I no longer see it in my feed.
The brand attribute is derived from the Products Manufacturer entry on the product setup page.Quote:
Originally Posted by new2u
Ugg... was afraid of that.. Thanks RescoCCC... This'll take a whileQuote:
Originally Posted by RescoCCC
The base feeder was so slow, I played around, checking times in various places. I hit the jackpot - if you remove the call to additional_images in the google_base class, the time to execute was 1/10 of what it was with the call in there. That's huge, considering folks on shared servers with limited processing.
So, a tweak would be to set up some form of caching for this directory info.
Hi I have installed the latest version of your Google feeder which I have been using for the past 3-4 months with out and issues.
But since I have updated the feeder I have been getting the following errors
Missing required attribute: availability (125 errors, only affecting Product Search, Search API for Shopping)
Please make sure that you include all required attributes in your data feed.
Examples:
Item ID Line No.
7 217 Show Item
170 322 Show Item
11 352 Show Item
185 532 Show Item
212 888 Show Item
I have deleted these products and the feed and recreated them with out any luck.
Have I missed a step when installing the plugin?
This question is answered multiple times in this thread.Quote:
Originally Posted by mobile-gear
Set include zero quantity to false, show quantity to true, and default quantity to 0.Quote:
Originally Posted by mobile-gear
Hi,
I've just got 1.10.2 running on Zen 1.3.8a and all looked ok. However, spotted a problem happening which was reported earlier in this mammoth thread but the fixes suggested then applied to code which is now different.
Basically, the feed contained things like:
' where the first 5 characters there should actually be an ampersand
the Google Product Category line was coming out as...
<g:google_product_category>Arts &amp; Entertainment &gt; Party Supplies</g:google_product_category>
etc.
The relevant bit of code in includes/classes/google_base.php , in 1.10.2 anyway, is...
function google_base_sanita($str, $rt=false) {
//global $products;
$str = str_replace("\r\n", ' ', $str);
$str = strip_tags($str);
$str = preg_replace('/\s\s+/', ' ', $str);
if (phpversion() >= 5) $str = htmlspecialchars_decode($str);
$charset = '';
if (defined(CHARSET)) {
$charset = strtoupper(CHARSET);
}
$str = html_entity_decode($str, ENT_QUOTES, $charset);
$str = htmlentities($str, ENT_QUOTES, $charset);
return $str;
}
/*
function google_base_xml_sanitizer($str, $cdata = false) {
$str = $this->google_base_sanita($str);
$length = strlen($str);
for ($i = 0; $i < $length; $i++) {
$current = ord($str{$i});
if ((($current == 0x9) || ($current == 0xA) || ($current == 0xD) || (($current >= 0x20) && ($current <= 0xD7FF)) || (($current >= 0xE000) && ($current <= 0xFFFD)) || (($current >= 0x10000) && ($current <= 0x10FFFF))) && ($current > 10) ) {
$out .= chr($current);
} else {
$out .= " ";
}
}
$str = trim($str);
if ($cdata) {
$str = '<![CDATA[' . $str . ']]>';
}
return $str;
}*/
function google_base_xml_sanitizer($str, $products_id = '') { // products id added for debugging purposes
$str = $this->google_base_sanita($str);
$strout = null;
for ($i = 0; $i < strlen($str); $i++) {
$ord = ord($str[$i]);
if (($ord > 0 && $ord < 32) || ($ord >= 127)) {
$strout .= "&#{$ord};";
}
else {
switch ($str[$i]) {
case '<':
$strout .= '<';
break;
case '>':
$strout .= '>';
break;
case '&':
$strout .= '&';
break;
case '"':
$strout .= '"';
break;
default:
$strout .= $str[$i];
}
}
}
return $strout;
}
There are 2 versions of the function google_base_xml_sanitizer , one commented out. Swapping which was commented out made it work correctly for me. Not sure if there are any other implications mind you! Just posting this in case it's any use for anyone else.
I have been reading every post I could find that looked like a possible answer.
I deleted (several times) the sql file and then reinstalled it 3+ times and got several "duplicate copy" messages.
And voila I have a perfect output file for Google.
Only took 4 days.
Now the last question" why is my file name - domain_products_en.xml instead of the file name in the config setup dor the feed??
Any ideas? Do I have to change code in some file??
BINGO!!!
I SOLVED THE "domain_products_en.xml" PROBLEM.
For some reason, without realizing it, I suddenly have two configuration options for Google:
- Google Base Feeder Configuration
- Google Merchant Center Feeder Configuration
Google Base is the old one which I tried to change but nothing worked.
My first change of Google Merchant Center did the trick and all is well.
Thanks to everyone who tried to help.
Hi ppl, Ive look throuh this thread and sorted a few bits that were wrong with mine,,
The bit i cant get working is the "download link" within the module,,
It processes the file , but in the blue bit where its says download,, the link isnt clickable??
Could someone show me why it isnt a clickable link, please
edit that last post:::Quote:
Originally Posted by sash
it now come up with a parse error, which totally baffles me:no:
Nice - funny how it boils down to this - yet this happened to me too as it was installed beyond my screen resolution and never saw it! I assume this is due to an improper uninstall.sql? I assume that with all the attempts you and I were doing, that was missed along the way.Quote:
Originally Posted by marvin
So is my "google merchant center feeder configuration" correct in only having only 12 Title parameters? The last is "Output Directory"
I am still getting 0 of 0 products but the OLD "Google Base Feeder Configuration" is set for.....
Show Quantity true
Include Zero Quantity false
Default Quantity 0
I am also assuming that having TWO configurations is not normal.
Having two configuration options simply means the old version wasn't uninstalled. It shouldn't effect functionality of the new version though. I have both Google Base Feeder Configuration, (which was version 1.7.4), and Google Merchant Center Feeder Configuration, (version 1.10.2), on one of my sites, and the latter works fine.
There should be way more settings than that.Quote:
So is my "google merchant center feeder configuration" correct in only having only 12 Title parameters? The last is "Output Directory"
*** Multiple Configs in Admin solved
Post #3249 Solved this for me - I am up and running.
Read over Stedman's troubles around pages 325 or so.
What helps is post 3249 to wipe out all traces of google, then running the install.sql to whatever version you run.
I am running 1.10.2 (on 1.3.8a) with only image and description problems with "&" and foreign letters respectively. I am weeding these out as I speak (write).
if u have phpmyadminQuote:
Originally Posted by sbbemn
login
goto your DB
then goto configurationgroup
find the one related to google base(old version)
then delete :D
no longer there :D
sorted
Im confused lol,, does the latest update work or not, when i try and upload it just sends a blank file, not quite sure if you guys are getting it to work or not,,
Sep 10 2011
v1.3.9
1.10.2
:D
seems to be working for me. but not getting all my products yet :SQuote:
Originally Posted by sash
only like 10% of my products are put into the list....and id say 98% of them have stock etc
Thanks for the reply, How do you get past it sending up a blank file, cheersQuote:
Originally Posted by spid3r1987
hmmQuote:
Originally Posted by sash
best bet, re-upload all the files incase 1 is corrupted
make sure folder for the file is "777"
then in the confuration mine is set like this
http://www.xxx-tools.co.uk/images/settings1.jpg
not sure if these will help, but here's the second half of settings lol
http://www.xxx-tools.co.uk/images/setting2.png
make sure you have run the install.sql after UNINSTALLING the previous version...
well iv found out why mine is only getting 1700 items out ofr 17k items
its timing out after so long
iv had this problem before but cant remember how to fix it now :(
been having some issues although i have succesfully upgraded this module and my feed seems to be more acceptable to google im still getting an error for all 356 of my current items saying that avalability is unavailable and therefore my items are being rejected by google merchant centre, i was getting an average of one or two orders a day and now nothing :( not had a single online order for over 2 weeks now so i really need to find out how to get this working. ive read through about 25 pages and still nothing seems to solve my issue, im running zencart 1.3.8a if thats any help and i followed the steps in post number 3249 which helped alot. I no longer have any options listed under the old settings tab but the newly labeled "google base feeder" tab under configuration has the options i believe should be there and everything is setup as in the quotes above plus the needed information that was the same in the previous version. any ideas what i can try??Quote:
Originally Posted by new2u
availability:
turn on include zero quantity
turn on show quantity
That works - now whether it works with zero quantity turned on or not I don't know - but the answer is in the settings.
just turned on inclde zero quantity and uploaded a fresh feed file and it still gives me the availability missing error :(Quote:
Originally Posted by delia
i already had show quantity set to true, thankyou for the reply any more ideas?
Hi there
Bit new here around this area of knowledge ...!
But wanted to know if anybody knows answer to my problem here.?
I recently had Installed the google froogle into my zen cart
And had these 3 attribute problems show one after an other after my ftp upload to google merchant center
Missing recommended attribute: mpn (282 warnings)
Missing recommended attribute: google product category (282 warnings)
Missing recommended attribute: brand (229 warnings)
Now I know this last one brand I forgot to add the product manufactor for all my listings. Thats no problem But
these other two attributes I have not being managed to locate them or how to add them or turn them on at my feeder config.?!
Thank you for your time.:dontgetit
Your question is answered multiple times in this thread.Quote:
Originally Posted by sonofflorida
anyone know how to stop it timing out after so long and missing 90% of my products off??
My items are now showing on google :-)
they are also now showing the postage cost underneath which is great.... however the postage cost is inoccrect and is missing the VAT ie my postage cost might be £2.50 but google is showing the price as £2.08 which is 20% less. I have the setting in the config:
Display Tax false (as it says us only)
Tax Country UK
Tax Region CLEVE
Tax Rate 20.00
Tax on Shipping y
nvm, sorted it :)Quote:
Originally Posted by spid3r1987
try changing it to TRUE on display tax(even tho it says us only)Quote:
Originally Posted by kitcorsa
then redo file and upload...think this might work :)
It's very kind of you,and your reply helps me much!!
thank you
Quote:
Originally Posted by RescoCCC
Does anyone know if there is another update coming out soon,,
Im totally out my depth trying to get this to work, and have zero products displayed anywhere in google,
:shocking::(
Ok so i think i made some progress using the 3 supplied snippets of code from 3249 to removethe old google feeder and i now have just the one set of configurations however it shows as making the feed domain_products_en.xml and so now google has emailed me to say my feed does not match the filename it should and also for some reason it has only generated 351 out of 355 items processed when last night it successfully processed all 376 of my items?? any ideas?
Another update won't help you if you can't figure out what's going on now. Too many variables.Quote:
Originally Posted by sash
I just discovered something I hadn't run into before and hadn't seen posted here.
If you have the stock by attributes mod installed, it will export your variants to the feed.
However, since it was set up for Numinix's upcoming new stock by attributes, it does not work as it needs to and can/will get your products invalidated.
So if you have it installed, you are going to have to edit the googlefroogle.php file in the root.
Comment out this line by adding the // in front of it.
Code:if (defined('TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK')) $stock_attributes = true;
Question came up:
i cant upload to google as it says my file is called product_domain_en.xml when the _en shouldnt be there and also it has now missed off about 20 items it successfully processed when manually generating a feed last night?
The new version has the en added so you need to go to google and set up a new feed for the new file. Then delete the old one without the en.
I don't know what Xbox Memberships means by the missing products but do check to see if you have the include products with zero quantity as true.
thanks thought it may be a case of that but was hoping not to have to let google reassess every single item as first time processing of a new feed can take quite a while. i get the following when creating a new feed file....
Google Merchant Center Feeder v1.10.2 started 2011/10/12 16:34:07
Feed file - /home/xboxmemb/public_html/feed/google/domain_products_en.xml
Processing: Feed - Yes, Upload - No
~~~
Google Merchant Center File Complete In 5.872130 Seconds 351 of 355 Records
however yesterday when i did it i got
Google Merchant Center Feeder v1.10.2 started 2011/10/12 16:34:07
Feed file - /home/xboxmemb/public_html/feed/google/domain_products_en.xml
Processing: Feed - Yes, Upload - No
~~~
Google Merchant Center File Complete In 1.898273 Seconds 376 of 376 Records
and i have just listed about 10 more items on my site today so this figure should have gone up not down :(
Turn on debugging in your config settings and you will have more information when you output your feed.Quote:
Originally Posted by Xbox Memberships
I am trying to get the Google Product Category attribute to work with zencart. I have at least three different fields that need to go to Google with different products.
I have gathered from this forum that I need to use the admin/catalog area for option names and option values. How is this to be set up?
I have books, educational books, cards, and gifts.
For example, One Google product catagory for books is listed in Google as:
Text: "Media > Books > Non-Fiction > Religion Books"
XML: Media > Books > Non-Fiction > Religion Books
Do I put option names: Google Product Catagory?
Do I put option values: Media > Books > Non-Fiction > Religion Books?
And then add to all products that pertain to each?
If I missed in thread, please disregard and redirect.
Thanks, Kim
turned on debugging mode and all it told me was whichitems have been processed but it did tell me that items with id's 867, 975, 1027 and 1029 have failed as the description is less than 15 characters long? it doesnt tell me why it has missed out roughly 30 items though and also seems that the file i uploaded before has been succesfully sent to google and processed but quite alot of my items have been dissaproved by google when they was fine previously.Quote:
Originally Posted by delia
plus side is i have finally got rid of the availability warnings :D
1.3.8a
google 1.10.2
upc/isbn mod installed - ISBN/UPC/EAN set to true in google config
After several hours on going back and forth with versions and fixes, I finally have been able to upload a feed to google succesfully.
I have 1,000 book products in critical warning that may get us suspended!
ISBN will not populate in the feed. It's in the googlefroogle.php files and I have pasted hundreds on the product pages. Anyone run into this before? UPC is working fine?!
Populating and Good:
MPN, Brand, UPC
The Google Product Category is a single entry in the feed configuration. You don't have to do anything with the individual products.Quote:
Originally Posted by kburner
Quote:
Originally Posted by sbbemn
IN CONFIG:
UPC/ISBN/EAN
If using Numinix Product Fields, include UPC/ISBN/EAN? Set to true
Is the problem I am having the fact that I used the UPC/ISBN mod and not the full fledged Numinix Product Field Mod?
UPC is working correctly though? I'm SO CLOSE - all I need is the ISBN to populate in the google feed!
If I set to one feed,it will not populate to the correct one with gifts and items other than books.Quote:
Originally Posted by RescoCCC
How are those handled?
Select a single category from the Google taxonomy that best fits your product line overall.Quote:
Originally Posted by kburner
That would be it.Quote:
Is the problem I am having the fact that I used the UPC/ISBN mod and not the full fledged Numinix Product Field Mod?
Thank you!:smile:Quote:
Originally Posted by RescoCCC
Hey google merchant center requires as well known by now for apparel categories
these attributes:
age group attribute.
gender attribute
color attribute
These were not found in the latest froogle module correct ?
I mean everything else can be edited from the admin configure panel
But I dont see these there ?
Its already lot of work to add all these to my remaining listings
But how in earth you get these into my google_base.xml_products_en.xml feed to google
I changed them but the wont show in the feed
Anybody else feeding apparel products to google with similar problems ....
Cheers :dontgetit
well just checked in now and out of the 357 items that was generated into the feed (should be more like 380 items) 68 of these have been dissaproved by google :( any ideas whats going wrong?
Oh cheers Delia, your're my hero! :D I was having this very problem and getting a 2500+ product feed on a site that only has 167 :blink: I was just resigned to editing the variants out of the feed with an xml editor.Quote:
Originally Posted by delia
...On a nother note, i've been trying to figure out why 3 of my products are never included in the feed, and i think i've gotten to the bottom of it. I have a few pairs of products with the same product title but different MPNs on my site and the feeder seems to miss out the second product with the same title :huh:. Is there anything in the code that is there to avoid/skip duplicate product titles?
can someone please show me what im doing wrong ,, uploading the module isnt a problem,but as soon as i hit this bit,,
5.Go to Admin->Tools->Install SQL Patches and patch your database with install.sql by copying and pasting (If you encounter errors, try the upload option)
it gives the duplicate error,, its a clean install as it goes up without any overwrites to a file i might have left,,
ive done this to see if it helps with a new install
http://www.zen-cart.com/forum/showpo...postcount=3249
every time is the same duplicate:frusty:
Working on a site and have upgraded to latest Google Merchant Center feeder. I've reinstalled the latest sql files without a problem. Have no errors of any kind.
Actual website is functioning normally.
Ran the feed and the Confirm shows the following:
------------------------------------------
Google Merchant Center Feeder v1.10.2 started 2011/10/13 10:07:14
Feed file - /home/herbschi/public_html/sourceforherbs.com/feed/sourceforherbs_products_en.xml
Processing: Feed - Yes, Upload - No
---------------------------------------------
Where are my products??
Zen 1.3.7
Google feeder 1.10.2
sql 1.10.2
Numinix product feed
Thanks in advance
I believe that it is not compatible with zen 1.3.7 and I have only seen one site on that version that wasn't hacked.Quote:
Originally Posted by marvin
Upgrade zen cart!
Could anyone show me whats wrong with the way ive installed it,,Quote:
Originally Posted by sash
the google catergory and tax bits are missing,
Might get some sleep tonight , i was up the whole night install/uninstalling for the same result every time :no:
Found a debug file that has this message. Can someone translate what it means??
[13-Oct-2011 20:53:45] PHP Fatal error: Call to undefined function zen_generate_category_path() in /home/herbschi/public_html/sourceforherbs.com/includes/classes/google_base.php on line 233
The message above ties into the following prior posting.
---------------------------------------------
Working on a site and have upgraded to latest Google Merchant Center feeder. I've reinstalled the latest sql files without a problem. Have no errors of any kind.
Actual website is functioning normally.
Ran the feed and the Confirm shows the following:
------------------------------------------
Google Merchant Center Feeder v1.10.2 started 2011/10/13 10:07:14
Feed file - /home/herbschi/public_html/sourceforherbs.com/feed/sourceforherbs_products_en.xml
Processing: Feed - Yes, Upload - No
---------------------------------------------
Where are my products??
Zen 1.3.7
Google feeder 1.10.2
sql 1.10.2
Numinix product feed
Also getting this message
Google Merchant Center Feeder v started 2011/10/14 08:35:12
Feed file - /var/www/vhosts/pewterworld.co.uk/httpdocs/feed/google/GOOGLE_PRODUCTS_OUTPUT_FILENAME_products_.xml
Processing: Feed - Yes, Upload - No
Google Merchant Center File Complete In 0.001668 Seconds 0 of 0 Records
I only had time to re add all the files and run the sql
zen version is 1.3.9h
thanks for any help
if your getting a duplicate error, then its "apparently" installedQuote:
Originally Posted by sash
best bet is to run the uninstall.sql
make sure the google feeder is gone from Admin>configuration
if this is all clear, re-run the install.sql
if u really struggle with this, PM me and il see wht we can sort :)
i originally had the same problem with no productsQuote:
Originally Posted by marvin
i had to go through all the new version, and the old version(original files)
and then compare with my hosted session and delete ALL files that match with originals.
then run uninstall.sql
if u got phpmyadmin, log into that, goto configurationgroup
make sure googleconfig is removed from the configgroups
then
re-upload all files to hosting, then login to admin on website and goto install sql patches then run the install.sql(dont run the upgrade.sql's)
this should work
then you have replaced all the files incase one is corrupted during upload.
its all fresh
if this still fails then im nt too sure
Version 1.11.2 resolves this for your feed. You need to go in and create read-only attributes, then connect them to the items.Quote:
Hey google merchant center requires as well known by now for apparel categories
these attributes:
age group attribute.
gender attribute
color attribute
These were not found in the latest froogle module correct ?
I mean everything else can be edited from the admin configure panel
But I dont see these there ?
Its already lot of work to add all these to my remaining listings
But how in earth you get these into my google_base.xml_products_en.xml feed to google
I changed them but the wont show in the feed
Anybody else feeding apparel products to google with similar problems ....
Cheers
Instructions for adding attributes:
https://www.zen-cart.com/tutorials/index.php?article=57
Once the attributes are created, a lot of them can be added to all products in a category. Not as bad as one at a time.
https://www.numinix.com/zen-cart-mod...1752eea8a26441
tried that and let it repopular over last couple of days and still no joy... shipping still showing with no VATQuote:
Originally Posted by spid3r1987
Nope. tried all that and still problem. No products show up .Quote:
Originally Posted by spid3r1987
Hi
I tried this too and reinstalled and got this message after sql
1062 Duplicate entry 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY' for key 2
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Debug', 'GOOGLE_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 froogle 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, '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, 'Show Quantity', 'GOOGLE_PRODUCTS_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 43, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Include Zero Quantity', 'GOOGLE_PRODUCTS_ZERO_QUANTITY', 'false', 'Include products with zero quantity?', @configuration_group_id, 44, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Quantity', 'GOOGLE_PRODUCTS_DEFAULT_QUANTITY', '0', 'What is the default quantity for products with zero quantity?', @configuration_group_id, 45, NOW(), NULL, NULL), (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, 'Default Product Category', 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY', '', 'Enter a default product category from the Google Category Taxonomy or leave blank:', @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\'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Do you have two google feeds in admin/configuration? One called Google Base Feeder Configuration, and the other called Google Merchant Center Feeder Configuration? If so, use the second one to configure your feed.Quote:
Originally Posted by ATSWorld
I got exactly the same message during installation. My feeds work fine. Have you tried to generate a feed to see what happens?Quote:
I tried this too and reinstalled and got this message after sql
1062 Duplicate entry 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY' for key 2
in:
oops thank you I didn't see that as it was off the page ,once I had opened config I saw it at the bottom of the list .... I've made it the same as the other 1 and it produced a file (which is good)..will have to wait and see if it has uploaded and gone though to google nowQuote:
Originally Posted by RescoCCC
I take it I can delete "Google Base Feeder Configuration" now as the other has taken over
thanks for prodding me in the right direction :cool:
[QUOTE=spid3r1987;1072081]if your getting a duplicate error, then its "apparently" installed
best bet is to run the uninstall.sql
make sure the google feeder is gone from Admin>configuration
if this is all clear, re-run the install.sql
if u really struggle with this, PM me and il see wht we can sort :)[/QUOTE
i dont have this in my configuration ?? this is what ive been trying to get it but it doesnt appear
seem to have gotten a little further ....I think
I can now press confirm but all I get is this now
<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">
<channel>
<title>Pewter World</title>
<link>http://www.pewterworld.co.uk</link>
<description>Pewter &amp; gift store</description>
any ideas please ..I've changed so many settings now I'm getting lost in what I have changed
thanks again
This doesn't work for me. The feed does not generate the attributes for the items.Quote:
Version 1.11.2 resolves this for your feed. You need to go in and create read-only attributes, then connect them to the items.
Instructions for adding attributes:
https://www.zen-cart.com/tutorials/index.php?article=57
Once the attributes are created, a lot of them can be added to all products in a category. Not as bad as one at a time.
https://www.numinix.com/zen-cart-mod...1752eea8a26441
For that reason the items aren't approved at Google Merchant.
Having been more than frustrated in issue with trying to get this module to work I recently asked via this forum:
has anyone used the magneticone google base feed module? (http://www.magneticone.com/store/Zen...Base.Data.Feed) wondering if it will work better than the current issues with this one.
And was told:
I manage quite a few dozen production level shopping carts so naturally having a feed that will work without issue or hassle is of great interest.Quote:
Originally Posted by delia
My last issue was with the latest version not showing the apparent fix of being able to include categories and no one here had an answer to give me. I went round and round and round. Uninstalling it, reinstalling it and on and on. And my level of proficiency, while not expert, is, I guess I could say, well seasoned so I wasn't totally ignorant, maybe just a little.
Finally, I figured, well for $29 I might as well get this magneticone googlebase feeder and install it on the shopping cart that has the least production activity for least risk since we have carts that do high 6 figures annually we manage I didn't want to mess around with any of those).
I have to say, I won't be looking back now at this forum. It (the magneticone software) installed flawlessly and easily with well written directions, I had one minor issue with the file not pulling my categories until I realized I hadn't ticked one box correctly. I sent up my feed and it was accepted with not one error from google. man am I happy. Now I will be uninstalling this one from our other carts and installing the magneticone feed software.
So I don't know why they have gotten a bad rap here in this forum. Maybe my situation is just an anomaly I don't know. But it doesn't seem that way since it did everything I hoped and more. I'm not a paid actor, get nothing if you use it just voicing my experience because I have been utterly frustrated with solving this and in one fell swoop took a chance and had all of my frustration and fears absolved. For what its worth, I know some people have put alot of energy and time in this forum and the module, don't get me wrong I understand and appreciate that. But what works works and what doesn't work, doesn't work and maybe there is another answer so we'll leave it at that.
Except that for many of us, the Numinix module works perfectly. I installed it on three sites and it works just fine, and I'm a friggin' rookie compared to most here.Quote:
But what works works and what doesn't work, doesn't work and maybe there is another answer so we'll leave it at that.
OK after a lot of hassle's I have gotten 216 of my 615 products uploaded ..it just doesn't seem to see the rest of the products
any ideas
thanks
A truncated feed file is usually caused by special characters, either in the product title, description, or image file name.Quote:
Originally Posted by ATSWorld
Why is this module a pain in the ########,,
Ive deleted all the files ,,ran the unintall file and then ran this below:
http://www.zen-cart.com/forum/showpo...postcount=3249
So in theory is this the module completely gone?????
because when installing a fresh copy im still getting the duplicate error at the install file:frusty:
Is this right? i have attached a screen shot of my configuration set-up. there is no update button to save the settings when changed, i have uninstalled and reinstalled the mod 5 times now and its always the same
Hi getting the hang of this ,when I confirm (and have debug active) the box comes up saying success except for a few saying thisQuote:
Originally Posted by RescoCCC
id: 874, price: 9.99, description length: 28 - skipped: zero quantity product. turn on include zero quantity to include. - failed
id: 892, price: 9.99, description length: 86 - skipped: zero quantity product. turn on include zero quantity to include. - failed
could this be the cause of my issue and how can I overcome this
thanks
Exactly what is always the same? What errors or problems are you experiencing?Quote:
Originally Posted by mattee77
yeah, I can appreciate that. And apparently, it does seem to work fine for some or many or most, for whatever reason that may be, likely in proportion to many different variables. And I'm not a rookie per se having worked with zencart for many, many years, modded it considerably, administer over 20 active production stores using it currently and as well might be slightly better than a layperson with respect to php plus managing over a dozen web servers so well versed in recompiling php at the server level to do what it needs to do on a script by script basis, yada, yada, yada.Quote:
Originally Posted by RescoCCC
But my point might have been that there are still what seems to be waaay to many with comments like this from a most recent post: "Why is this module a pain in the ########,," and a proportionate amount of people that seem to be struggling with it and finding all kinds of issues with it working for THEM.
And so, in relation to that point I was simply pointing out that for those people, there might be another solution. At least, I was one of those people having issues with this particular module, tried the other one and found it to be a breeze. That might not work for everyone but it did for me so likely it will for someone else and I was simply providing my anecdotal experience.
nope isn't this as I have turned them all off and despite having 615 products I am only getting 215 to upload ...I would understand if they were all from 1 supplier but they are across the board (3 different suppliers) :censored::censored::censored::censored:Quote:
Originally Posted by ATSWorld
There is no way of saving the settings (no update button on config screen) see my screenshot on my original postQuote:
Originally Posted by RescoCCC
mine looks like this ,if it is any help
If items have zero quantity, then they will not be included in the feed. The items referenced above show zero available. The feed appears to be working as it should.Quote:
Hi getting the hang of this ,when I confirm (and have debug active) the box comes up saying success except for a few saying this
id: 874, price: 9.99, description length: 28 - skipped: zero quantity product. turn on include zero quantity to include. - failed
id: 892, price: 9.99, description length: 86 - skipped: zero quantity product. turn on include zero quantity to include. - failed
The feed module itself works perfectly. However we cannot troubleshoot what may be happening on a particular site. All of my sites are running feeds as they should. If I were going to recommend something for those who may have problems installing / configuring, I would point them to Numinix. They can pay them $25 and they will install it correctly.Quote:
And so, in relation to that point I was simply pointing out that for those people, there might be another solution. At least, I was one of those people having issues with this particular module, tried the other one and found it to be a breeze. That might not work for everyone but it did for me so likely it will for someone else and I was simply providing my anecdotal experience.
https://www.numinix.com/zen-cart-mod...-center-feeder
Then you are not doing something that's preventing your extra attributes from being included. They're on my feed as in the examples below. Zero items rejected. Make sure you link up the extra attributes to all your items.Quote:
ideasgirl
Version 1.11.2 resolves this for your feed. You need to go in and create read-only attributes, then connect them to the items.
Instructions for adding attributes:
https://www.zen-cart.com/tutorials/index.php?article=57
Once the attributes are created, a lot of them can be added to all products in a category. Not as bad as one at a time.
https://www.numinix.com/zen-cart-mod...1752eea8a26441
This doesn't work for me. The feed does not generate the attributes for the items.
For that reason the items aren't approved at Google Merchant.
<g:gender><example></g:gender>
<g:size>example</g:size>
<g:color><example></g:color>
your config file looks like mine,, and its not right!! going by your attachement it doesnt contain DEFAULT PRODUCT CATEGORY.. and others,,,Quote:
Originally Posted by ATSWorld
i still cant get the new config files to appear....
edit: unless they are below your attachment oops lol
lol couldn't get the whole page but that is there on my site
Have you tried deleting GMCFC from there ..I did as I had 2 of them
:censored::censored::frusty::frusty::no: Gonna explode with this,
Ive deleted this module from zen cart admin , checked phpmyadmin and its gone from there,,,
SO why is it when installing a fresh version and get to the point to put in the "INSTALL" file it comes up with that duplicate massive error file and have to click back to get to zen cart admin again,,,
Ive ran the uninstall from the old google base aswell incase any bits left,,,,
It is completely gone...
To make things clear when i install a new version, the module itself works,,
it just doesnt contain the new configuration of default product category etc,,, it should because its the latest updated file....
So this is clearly incorrect I only have half the config options and no button at the end to save any changes made.. anyone know why or how to fix?Quote:
Originally Posted by mattee77
I don't intend to get into a back & forth on this Manetic (whatever) Google mod.Quote:
Originally Posted by thomaswhiteeagle
I tried it a couple of years ago and had problems with it immediately.
I tried to call the number on their website and got through after a number of tries. I was rudely told the number was for SALES only. when I asked for a support number I was told to put in a ticket and I would receive a quick response. BS!! It took several days and after a number of back & forth ticket messages I gave up after I was basically told I was dum to not understand their instructions.
AND BY THE WAY THEY HAVE A "CONTACT" LINK TO 2 DIFFERENT PAGES WITH "FATAL ERRORS" .
Their support "knowledge base" has some of the dumbest questions and explanations . They unbelievale user comments that are 99.9% full of fantastic praise and no criticism that I could find.
And I am also quite perplexed as to why you so vehemently are protecting them when someone doesn't like their mod.
The mods on the ZEN-CART website are all written and maintained for free - other than occasional contributions. Yes they do have occasional bugs and we who use them are not experts and make mistakes and at times we have a difficulty in expressing our problems but we are patient with each other and go to great lenghts to help each other out.
I for one am always appreciative of all the help I get here.
THAT'S MY 2 CENTS ON THE MATTER.
To clear up your confusion about updating. EACH option on the configuration screen has its own update (save) button. there is no need for a button at the end of the page.Quote:
Originally Posted by mattee77
OOPS to my prior post. Just got a better look at your "config".Quote:
Originally Posted by mattee77
what versions of this mod and zen you are running and any additonal config changing mods.
Ok, but I don't have that save option either. Please look at my attachment on the previous pageQuote:
Originally Posted by marvin
Could anyone throw in a suggestion????Quote:
Originally Posted by sash
Hi where are you getting this save button from ,I don't think there is a save button as such all you do is edit and update like all teh others in config ..under tools/gmcf there is a confirm button to get the file ..is this what you are talking aboutQuote:
Originally Posted by mattee77
Once you have run the instal file it fails ,but if you look in the config link you will see it there ,try clicking on the config link so it opens all the links up it is there .....I had the same problem it wasn't there too I ran teh install it failed thought :censored: but when I went to the link there was feeder linkQuote:
Originally Posted by sash
This is as far as I have gotten so don't worry you are catching up fast
Quote:
Originally Posted by sash
@ATSWORLD Thanks for the input, but i have said a few times that it does work ,just missing a few bits:lookaroun
yes, i dont have any confirm button, i have tried downloading and re-installing several times but all i get on the config screen is the columns but no button to update/confirm changes, see my attached image on the top of page 339Quote:
Originally Posted by ATSWorld
yep it looks completely different to mine ..sorry can't be of anymore helpQuote:
Originally Posted by mattee77
@Sash sorry you are right you did mention it a few times ..just been a hectic day for me .Been trying to sort my problems out too :censored::censored:
been though every product correcting every small error and still no go :censored::censored::censored: