Printable View
Is there a way to make this mod display the same "Category" on google base for all items? I get the top level folder that my item is listed under (Honda, Ford, Chevrolet, Mitsubishi) and I want them to all read "Automotive" instead of the vehicle manufacturer.
Thanks!!!!
I'm running the latest version of Zen Cart. I installed the google base feeder, but it's not working. I tried installing the patch update, it seemed to take, however I still can't get any products to generate.
How can I fully remove google base feeder? I need to try reinstalling. I tried running the uninstall sql script, but it seems there are still some things in the db, as I can't reinstall.
Any ideas?
Thanks.
Hello Actionmedia,Quote:
Originally Posted by actionmedia
Please post any error messages you are getting while trying to do the reinstall. That would help anyone trying to assist you.
When I try to apply the update_1_7_1 sql patch, I receive this:
1062 Duplicate entry 'GOOGLE_BASE_MAP_PRICING' for key 2
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Enable Map Pricing', 'GOOGLE_BASE_MAP_PRICING', 'false', 'Enable MAP Pricing (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I ran the uninstall script, and tried reinstalling just the googlefroogle.sql query, and can't. I receive this:
1062 Duplicate entry 'GOOGLE_BASE_MAP_PRICING' for key 2
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Google Base FTP Username', 'GOOGLE_FROOGLE_USERNAME', 'ftp_username', 'Enter your Google Base FTP username', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base FTP Password', 'GOOGLE_FROOGLE_PASSWORD', 'ftp_password', 'Enter your Google Base FTP password', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server
default: hedwig.google.com', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base PASV', 'GOOGLE_BASE_PASV', 'true', 'Turn PASV mode on or off for FTP upload?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Store Address', 'GOOGLE_BASE_ADDRESS', 'http://www.domain.com', 'Enter your website address', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Store Description', 'GOOGLE_BASE_DESCRIPTION', '', 'Enter a short description of your store', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Auction Site Attributes', 'GOOGLE_BASE_ASA', 'false', 'Activate Auction Site Attributes (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Enable Map Pricing', 'GOOGLE_BASE_MAP_PRICING', 'false', 'Enable MAP Pricing (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:
* now - add Adjust to current date;
* product - add Adjust to product date (max(date_added, last_modified, date_available))
', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'), (NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '365', 'Expiration Date Adjust in Days', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('), (NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'id', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\', \'UPC\', \'ISBN\', \'false\'),'), (NULL, 'Show Quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Include Zero Quantity', 'GOOGLE_BASE_ZERO_QUANTITY', 'false', 'Include products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Quantity', 'GOOGLE_BASE_DEFAULT_QUANTITY', '0', 'What is the default quantity for products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, NULL), (NULL, 'Shipping Options', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL), (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your default condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),'), (NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @configuration_group_id, 13, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?
default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('), (NULL, 'Magic SEO URLs', 'GOOGLE_BASE_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'domain', 'Set the name of your froogle output file', @configuration_group_id, 19, NOW(), NULL, NULL), (NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 21, NOW(), NULL, NULL), (NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @configuration_group_id, 20, NOW(), NULL, NULL), (NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Tax Region', 'GOOGLE_FROOGLE_TAX_REGION', 'Tax applicable regions', 'Enter the tax region', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Display Tax', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display tax per product?', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Max products', 'GOOGLE_FROOGLE_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Starting Point', 'GOOGLE_BASE_START_PRODUCTS', '0', 'Start at which entry (not product_id)?
Default=0', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Pickup', 'GOOGLE_FROOGLE_PICKUP', 'do not display', 'Local pickup available?', @configuration_group_id, 25, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\', \'do not display\'),'), (NULL, 'Included Categories', 'GOOGLE_BASE_POS_CATEGORIES', '', 'Enter category names separated by commas
(i.e. 1,2,3)
Leave blank to allow all categories', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Excluded Categories', 'GOOGLE_BASE_NEG_CATEGORIES', '', 'Enter category names separated by commas
(i.e. 1,2,3)
Leave blank to deactivate', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Show Weight', 'GOOGLE_BASE_WEIGHT', 'false', 'Include products weight?', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Weight Units', 'GOOGLE_BASE_UNITS', 'pounds', 'What unit of weight measure?
pounds OR kilograms', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'pounds\', \'kilograms\'),'), (NULL, 'Product Type', 'GOOGLE_BASE_PRODUCT_TYPE', 'top', 'Use top-level, bottom-level, or full-path as product_type?', @configuration_group_id, 34, NOW(), NULL, 'zen_cfg_select_option(array(\'top\', \'bottom\', \'full\'),'), (NULL, 'Payments Accepted', 'GOOGLE_BASE_PAYMENT_METHODS', 'Cash,Check,Visa,MasterCard,AmericanExpress,Discover,WireTransfer', 'What payment methods do you accept?', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Payment Notes', 'GOOGLE_BASE_PAYMENT_NOTES', 'GoogleCheckout', 'Add payment notes (use this for showing you accept Google Checkout)', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Image Handler', 'GOOGLE_FROOGLE_IMAGE_HANDLER', 'false', 'Resize images using image handler (separate module required)?', @configuration_group_id, 36, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
guys, i need help. I have just installed Google Base Feeder according to instruction. But when i click on "Create Product Feed" it shows white blank pop up window and nothing going on further :blink: . What i am doing wrong, please help?
Are you sure you have it configured correctly in Admin>Configuration>GoogleBaseFeederConfiguration ??Quote:
Originally Posted by yorick00
It has few lines to configure :blink:Quote:
Originally Posted by limelites
Google Base PASV
Google Base Server
Google Base FTP Password
Google Base FTP Username
Store Description
Store Address
Auction Site Attributes
I soopose they influense on gogle bease account acces for file uploading. But something must be created before uploading.
I configured them, but feed even not created file (mystore/feed/index.html is empty)
when i click on "Create Product Feed" it shows blank pop up window and nothing going on. I am completely stuck. :lookaroun
There's a pretty good readme file with this mod that explains the set up process step by step by step.
Open the readme file and go through each step meticulously.
It sounds like you don't even have a Google Base account yet!? Read the step by step install guide which explains how to open an account and also how to configure it correctly.
Do this and you'll get it working... You need to know your account details (Google Base FTP Password and Google Base FTP Username) so that you can output a txt file to upload to google base.
Hi All,
v1.7.3a installed on zen 1.3.8a
I'm having a couple of problems, the first is that when I try to enter my domain name in Configuration>Google Base Feeder Configuration, I get an error:'Forbidden
You don't have permission to access /admin/configuration.php on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. '
Should it really be trying to write to configure.php? I didn't want to change permissions, as I don't know what it wants to change...
Next problem;
When I installed the sql files, the first (googlefroogle.sql) went fine but the upgrade (update_1_7_3.sql) gave an error:'1062 Duplicate entry 'GOOGLE_BASE_DEBUG' for key 2
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Debug', 'GOOGLE_BASE_DEBUG', 'false', 'Turn on simple debug?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.'
I assume this is of no consequence, as debug appears in the configuration menu just fine, but wanted to check.
I mention all the above as it may be contributory to my final problem; although an xml file is created just fine, and google grabs it with gusto, it only contains 68 of 216 products. I've not excluded any categories, and the products which are included come apparently randomly from across 2 categories only, not including the whole inventory of either category.
I've probably explained this in the longwindedest way possible, for which I apologise, but if you can help point me in the right direction, I'll be a very grateful zennite.
Thanks, and regards,
Sean
I forgot: No error messages received from google, either...
sorrysorrysorry...
I just found the debug feature, and it seems that my products were skipped for lack of descriptions. ho hum....
Hi, Can anyone really help me install this. I am having trouble in step 2. If you could walk me through I would be forever thankful.
Just email me letting me know when you can help me. My email address is microbelift###################### and my site is www.microbelift.net
Thanks for the help
Howard
i know pretty good about read me file and always read this twice before whine on forums. this file are complete unclear ... i try to explain, probably you misunderstanding me:Quote:
Originally Posted by limelites
look, please, at this screen of admin panel>conf>GBF conf
http://img17.imageshack.us/img17/9580/gbfc.jpg
than according user manual file:
1. Unzip and upload all files to your store directory (except .sql files); DONE! IT IS CLEAR.
2. Chmod feed directory to 777 DONE! IT IS CLEAR.
3. Go to Admin->Tools->Install SQL Patches and install googlefroogle.sql by copying and pasting (do not upload); DONE! IT IS CLEAR.
4. Go to http://base.google.com and create/sign to your account. Follow the link on the right hand side of their website to create your FTP account. DONE! IT IS CLEAR.
5. Go to Admin->Configuration->Google Base Configuration and setup all parameters; DONE! IT IS CLEAR.
6. Register your bulk upload .xml file using the same name in your Google Base Configuration at base.google.com FAILED! IT IS UNCLEAR! According to my screen there are no any lines for same name. Or there is any other configuration options??? What kind of same name he talking about? My feed file name is "omfgsamename.xml" on which field i should enter it, frankly speaking i can not find any suitable.
7. Go to Admin->Tools>Google Base Feeder and follow instructions to create, view, and upload feed file. FIALED. When i click on Create Product Feed: Click [HERE] to create / update your products feed - GOES nothing - plugin generates new pop-up blank window with none content or any kind of text, steps or other info, tested on 3 different browsers.
So it even do not creates product feed ... :dontgetit
So, please, could anybody help me with this problem i am stuck 2 days ahead. :frusty: i will be thankful for ages. thanks in advance.
It seems half of the installation I tried helping another ZC forum poster with went well. I can view and make changes to the configuration page for the feeder program, but yet I cannot find the listing under the Admin > Tools category. Can anyone tell me what file is missing or where it should be to get the Google Base Feeder option to show up?
Thanks!
Make sure that you copied files direct into your custom admin folder on the server. Your custom admin folder ex.: "myadmin" can differ from default one "admin" from plugin folder tree.Quote:
Originally Posted by blakdeth77
hope it will help:smile:
Tell me about it!! I had this exact same problem and it took me almost a day to suss it out!! I'd renamed my ADMIN folder fr security reasons and hadn't even thought about it as I was that used to just dragging and dropping the folders into site/root ....Quote:
Originally Posted by yorick00
Basically, rename ADMIN to match YOURADMIN before uploading it :-)
I am using Zen Cart v1.3.8a/v1.3.8 and I have downloaded the Google Base Feeder.
Initially I downloaded all the update SQL files by cutting and pasting in the sql patches section. I then found out that I did not require to do this as it was a first install so I deleted these from the sql database. I had also been unable to access google base feeder configuration but on searching google discovered that I had not changed the permissions on file public_html/admin/configuration and public_html/admin/admin.php in my root folder from 777 to 755 after download and getting instead an Internal Server Error like the one I have been reading about in this thread.
After transferring all the files via ftp and inserting the googlefroogle.sql file I attempted to use the google base feeder. It appeared to be successful and it was generating the RSS feed. The transfer also appears to have been successful and this is the result of the steps I took
Step 1: Google Base Feeder v.1.7.0 09.019.2008 17:38:59 started 2009/03/16 13:32:01
Feed file - /home/xxxxxx/public_html/feed/xxxxxx_products.xml
Processing: Feed - Yes, Upload - No
Google Base File Complete In 0.461483 Seconds 98 Records
Step 2: Google Base Feeder v.1.7.0 09.019.2008 17:38:59 started 2009/03/16 13:32:28
Feed file - /home/xxxxxxx/public_html/feed/xxxxxxxx_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Uploaded Successfully
-r--r----- 1 ftp · root · 104333 Mar 16 11:32 Accessorize_products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp · root · 104333 Mar 16 11:32 Accessorize_products.xml
but it has not appeared on google base and this is what appears when I click here:
You may view Google Base FTP content.
Google Base FTP content:
Connected to: uploads.google.com
/
total 0
Can anyone tell me what I am doing wrong?
I cannot understand how I am getting the RSS feed showing when I click on this:
NOTE: You may view your product feed file before proceeding to step 2.
I am using the correct password and think I have configured the Google Base Configuration correctly.
I have looked to see how I can download this feed to my computer to do it manually but cannot see a way of doing this. Can anyone help please.
Upload ok!
What I am looking to do is have my Google Feeder
Send out the Lowest Cost for each item.
I know there has to be a way because if I search a product
on all the competitors websites.
Is there a simple veritable I should change?
Hi i have uploaded the latest version of google base and am using the latest zencart version 1.3.8a. I have created a datafeed and have viewed it..all looks fine by default it created the patch as domain_products.xml
i get errors.
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
before the message shows up i get a blank screen in the new window for about 15 secs saying that its waiting for my site.
any idea
I have zen cart 1.3.6 and have had this installed and working properly. Worked like a dream. All of a sudden it has stopped working. when I view the product feed it is empty.
Again, this was working fine and all of sudden just stopped.
When I view the feed it is blank. When I upload it only shows 7 items processed by Google.
Any thoughts?
You must have changed something, trace back your last few steps and think what you've altered recently between the times you remember it was working.Quote:
Originally Posted by chriskelm1
Just incase anyone else had this problem.
The reason why my feed suddenly stopped working was due to a description formatting error.
I used a Bön (which is an o with two dots over it) in one of my descriptions.
So in other words, if you use special charters in your products descriptions the xml formatting does not recognize, your feed will error out and seem to suddenly stop working.
When in reality, you screwed up like me. Dont feel bad, you not alone!!! :oops:
Live, Learn or die trying! Thank you for the EXCELLENT mod!
Any idea why im getting an internal server error i posted a couple of posts before.
cheers
It sounds like you forgot to change the permissions on the feed folder to 755 or 777.
Which connect error are you getting a 500?
The chmod settings for the feed directory are 777. The feed has been created and i can view it. In mozilla and IE i get internal server error 500.
hope it can be sorted
I am still trying to get the lowest price into the feed file.
Has anybody done this successfully?Quote:
Originally Posted by mydanilo
Ok i think i know whats causing the problem but dont know how to fix it. When i go to admin/config/googlebase i notice that all of my settings have reversed back to the default settings so they are not saving over. I changed the settings again and logged out then logged back in and all of my settings were ok. when i logged in today the default settings are showing
Anyone know if google has changed anything, or if they are not working for some reason?
Do not seem to be able to upload, and I just keep getting on the bottom lines.
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: uploads.google.com
Upload failed...
I don't think I have changed any of the settings, as I have not used it for a few weeks. Just pressed the links as normal, it made the feed OK and I can view it, but when I try to upload I just get the above error.
Thanks for any help and hope you are having a good weekend.
I am the same, mine was working perfectly, no alterations now can't connect via FTP through the site.....
Anyone any ideas?
I have been able to add manually through googles control panel
It will not allow me to add it manually either as it says that the feed is not live
I've been able to add my feed manually, but no matter what I try, I can't upload via Google Base Feeder. Google must have done something on their end since we are all having the same problem. Anyone been able to contact them yet, or figure it out?
Getting same error as meknownowt a couple of posts back...
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: uploads.google.com
Upload failed...
Does not work via cron job or manually under Admin/Tools/Google Base Feeder....
Uh... That's the same error that everyone in the last several posts since meknownowt is talking about. :huh:Quote:
Originally Posted by tcustomgolf
As of today, information on this problem is very limited as Google hasn't been very forthcoming with answers yet. The problem isn't limited to zencart users and is apparently affecting commercial users as well. Check these articles:
Google Forum
and here
and here
Manual insertion still works fine from your Google Base account.
hmm. my ftp_username and ftp details just dont save over. Well they do for a little while but when i check the following day the details are reverted to the default settings. I have checked that the feed file is set to 777 and i can not do a manual submit either. The datafeed gets created but i get a 500 internal server error when i try to upload it. Any idea or any help as to how i can do a manual submit.
cheers
abs007...just save your data feed locally, go into your google base account, click the data feeds link. You will see an upload section, and click the upload file.
Hi thanks for the response. I have tried to do that but google base is not accepting the datafeed. this is the error message that i get
We did not understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error.
Also it looks like my details are saving now
any idea
I tried to edit the post above but the time ran out
Maybe i am saving the datafeed in the wrong way when i am trying to do a manual submission. I am copying the page contents of the data feed and pasting it into notepad then saving it as a .xml file. Is this correct?
Still the same for me, manual is ine once logged into the base account but otherwise upload feed doesn't work from within zen anymore
Is there a way of getting google to reply as to whats wrong?
I suppose the only good thing is we know its nothing we have done wrong !!
So, any one can help mу, :frusty:Quote:
Originally Posted by yorick00
Hi there,
I installed the most recent version of this and am having some issues with it. For some reason, the HTML tags are not being removed from the product descriptions. I'm seeing all the <b>, <p> etc tags in the "Description" field for the XML file and it's causing it to be seen as invalid.
Any thoughts?
thanks
Hi im also having problems but ive managed to get the system to generate a datafeed for me but can not upload it and dont know how to manually add it to google base.
To manually add it to google base do i open the datafeed by going to the url then copy it and paste it into notepad and save as a xml?
cheers
Hi - I installed this today and I think everything went ok, but when I create my feed it only gives me one record. I have over 1,000 thousand items in my store.
I'm having the same problem and I agree, #6 is not clear.Quote:
Originally Posted by yorick00
Anyone???
Well looks like it is working again so what ever it was, someone must have fixed it.
The problem with the html tags not being removed, I have the same problem with one or two items. I just keep going through them looking for what is out of place, as it is normally something you have in your description causing the problem. Speech marks was my problem for most of them but I still have a few other items that I have to find the tag I should not be using.Quote:
Originally Posted by bfmarini
Hope that helps
Hi
It looks like its working fine now but when i log into my google base account it doesnt show the product feed. Is this correct? or should it show it. This is the message i get when i upload the data feed through zencart:
Google Base Feeder v.1.7.0 09.019.2008 17:38:59 started 2009/03/26 08:48:37
Feed file - /home/abs007/public_html/feed/domain_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Uploaded Successfully
-r--r----- 1 ftp · root · 158706 Mar 26 06:54 domain_products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp · root · 158706 Mar 26 06:54 domain_products.xml
Upload ok!
Great news its worked and google have accepted the data feed however they are only recognising 20 products out of 55 or so. Its got error like remove ".
Where would i remove it from the actual listing in zencart?
cheers
Ok all is working fine. I have found some errors and have managed to get them sorted. However there is an error that i get for invalid expiration date once the feed has been uploaded. Do you know where i can change this expiration date from?
Even though I was getting any results I set Google up to automatically fetch my feed. This morning I got these results:
Can anyone help me figure out what's wrong, I really don't understand what this means.Code:Feed status details
Outcome: Data feed upload failed. No items are live. help
Number of items processed: 0
Number of inserted items: 0
Uploaded at: Mar 27, 2009 12:00 am PDT
Processed at: Mar 27, 2009 12:43 am PDT
* Detected encoding: US-ASCII
* Detected file format: Text
Errors:
Error Bad data Line #
We didn't understand your delimiter. help
Got to
Google Froogle Configuration -
Expiration Date Adjust -- 30
Expiration Date Base -- now
Upload every 2-3 weeks manually or with a cron job and forget about it.
I have zen-cart 1.3.8. I have google froogle loaded and file go to google. Each time I get an email for errors from google. Looks like not including all products either. I have almost 3,000 and only loading around 989. Here are some of errors. Looks like my attributes are also showing as errors.
Errors:
Error Bad data Line #
We recommend including this attribute. weight
We recommend including this attribute. upc
We recommend including this attribute. isbn
We recommend including this attribute. image link
This expiration date is too far in the future. help expiration date:2010-02-23
11462
There is a problem with the character encoding of this attribute. help description:All the elegance of the Reina Valera revisión 1960 combined with the poetic beauty of the King James.
Features:
Words of Christ in red
Presentation page
Harmony of the life of Christ
1792 pages
Binding:
  Imitation Leather
Indexed:
  N
I have been looking thru this large thread. I have not been able to find answer. Please let me know if located elsewhere.
Thanks, Kim
Those are illegal characters that the googlefroogle.php file has turned into the A type characters. Open your xml file in a text editor and copy the character and then paste it into the editor's search function so you can replace with the correct character.Quote:
Originally Posted by kburner
This is a bug in this contribution's script. I have the same problem and it takes extra steps to find all of the invalid characters.
I have tried to resolve this before, it lies in the sanitizer function in the googlefroogle.php file. Hopefully Numinix will get this resolved. If I fix it I will post the new file here.
To follow on my last post, the googlefroogle file is stripping all quotes from my products and we have many products with quotes. Not only that, but if there is anin there the the sanitizer will strip the & leaving only quot;.Code:"
I have brought this bug up before but haven't received any fix for it. Does anyone know what needs to be changed in the sanitizer function? It's mostly regular expressions and I don't know enough about them yet to make the correct changes. I will spend some time learning what the code is doing so I can change it if no one else knows what the change.
What it needs to do is change the " toand leave the existingCode:"
untouched.Code:"
Anyone???
Thank you for your response. When I did a search when in admin in the developer's tools. It shows in:Quote:
Originally Posted by lankeeyankee
admin/image handler.php
Line #438 : <option value="GBP">£ (GBP)</option>
Line #441 : <option value="JPY">Â¥ (JPY)</option>
includes/classes/support/phpmailer.lang-ja.php
Line #13 : $PHPMAILER_LANG["execute"] = '¼Â¹Ô¤Ç¤##¤Þ¤»¤ó¤Ç¤·¤¿: ';
Line #20 : $PHPMAILER_LANG["connect_host"] = 'SMTP¥¨¥é¡¼: SMTP¥Û¥¹¥È¤ËÀܳ¤Ç¤##¤Þ¤»¤ó¤Ç¤·¤¿¡£';
includes/classes/support/phpmailer.lang-ru.php
Line #19 : $PHPMAILER_LANG["file_access"] = 'Â äîñòóïå ê ñëåäóþùåìó ôàéëó áûëî îòêàçàíî: ';
Or are you referring to the google file - /feed/froogle_documents.xml?
What about the other questions like upc and ibsn? Those are model number. How do I add them to file?
Thanks, Kim
This is a really great contribution. I don't think I've seen anything yet with Numinix on it that hasn't been helpful.
Of course, I wouldn't be posting if I wasn't having a problem. Would there be a reason for product_type not to be displayed? I've tried changing it from "Full" to "Top" and even "Bottom" but nothing shows in the feed:
Code:<item>
<title><![CDATA[Dr. Maggie's Classroom Phonics Kit]]></title>
<g:brand><![CDATA[Cheapcher.com]]></g:brand>
<g:condition>new</g:condition>
<g:expiration_date>2010-03-29</g:expiration_date>
<g:id>10795</g:id>
<g:image_link>http://www.cheapcher.com/images/large/productimages/CTP/CTP-2926_LRG.jpg</g:image_link>
<link>http://www.cheapcher.com/language-arts-phonics-c-481_1526/dr-maggie-s-classroom-phonics-kit-p-10795/currency/USD</link>
<g:price>339.41</g:price>
<g:mpn>CTP-2926</g:mpn>
<g:currency>USD</g:currency>
<description><![CDATA[Designed for small group instruction, this kit includes six each of the 24 phonics readers (144 books in all), a resource guide, and 24 chant charts (17" x 22") with word cards on the back. These charts feature fun rhymes and chants that introduce each story's key vocabulary and are perfect for giving students a head start into each phonics reader. Includes a durable storage box. Grades K-3]]></description>
</item>
I just installed the latest version of this on 1.3.8a. The admin->configuration->google base configuration menu is there, and I set all the options, but the admin->tools->google base feeder menu doesn't exist. The closest there is is admin->tools->google froogle feeder, which I think was a previous version of this tool from way back in the day when they called it Froogle. This is copied text from that page. I assume this isn't it?
I ran the uninstaller for the old version, but it didn't totally get rid of it. Does it have one of the same records in the database that the installer of the new version isn't overwriting? What should I do?
Quote:
Froogle Data Feeder
OVERVIEW:
This module automatically generates product feed for your Zen-Cart store and upload it to Merchant Center ftp.
INSTRUCTIONS:
STEP 1: Click [HERE] to create / update your product feed.
NOTE: You may view your product feed file before proceeding to step 2.
STEP 2: Click [HERE] to upload product feed to Google Froogle Merchants.
NOTE: You may view Froogle Merchants FTP content.
Tips: To have this update and automatically upload product feed to Google Froogle Merchants, you will need to set up a Cron job via your host's control panel.
To run it as a cron job (at 5:0am like you wanted), put something in your crontab like the following:
0 5 * * * GET http://www.adamantbarbell.com/google...yes&upload=yes
or
0 5 * * * wget http://www.adamantbarbell.com/google...yes&upload=yes
Hello all, I have an interesting issue. I've installed Zen Cart version 1.3.8a. I've added several templates, and using apple_zen one. I've installed a few add-on mods (Ceon_uri_mapping_seo_3-0-2, easy_populate_csv_1-2-5-5, ebay_exporter_1-02a, editor_tinymce_plugin_2-1, google_analytics_by_andrew, google_base_feeder, google_sitemap-1-3-19, image_handler_for vx_2, google_checkout_module, msrp_display_1-1, Products_profitmargin_calculations, column_divider_pro_cdp_v0-4, tabbed_products_pro_v1-05). I've had all of these working except the last one I was doing which is google_base_feeder. I have installed it, when I go to tools-google-base-feeder I get the menu to create the files. When I click the "Here" button to create the file It opens a new window, but in the window is my store. Now when I go to google sitemap, it does the same thing, it opens a window with my store in it. I've re-installed the mod several times. I've even setup a new store with only 1 test product and several of these mods, but it works. Now on the new store I've not put Tabbed Products pro on it yet, but has anybody else had this issue? Any ideas why my store would be opening instead? Any help would be appreciated.
You mentioned that you installed several templates, but did you install all these mods into the current one your using? I am talking about the template override folders. apple_zen if you use it. If your other mods are not installed in this apple_zen override folder structure, they will not work. Maybe this is your issue?Quote:
Originally Posted by TechnologyDirect
Yes, I put them all in the apple zen folder. I have just put the Tabbed Products Pro in my test account and it still works. The browser window that opens even has the filename right and the right folder, just no file gets created, just the store showing in the new window.
I just found out that my ebay exporter mod does the same thing. there must be some file that is used by all 3 mods that has become messed up.
Found out this is an issue with Ceon URI Mapping.
have a problem when upload items to googlebase uk:
Errors:
Error Bad data Line #
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. help
15
updated to the latest version ,
tried again and again, not solved, please help me :frusty: :frusty:
Please Help.
It seems that my GoogleBase feeder is not seeing new products. I added around 75 new products within the last couple of days. When I go to admin > tools > googlebase feeder - and then click on Create Product Feed, the feed generates (just like it always did before) but it only shows 295 Records, which was the number of products that I had in my store before making the latest additions. I am able to Upload the Product Feed and it appears on google. I'm not getting any kind of an error or anything- it's like GBfeeder just doesn't even see the new items. Any ideas?
Thanks.
...... I can only upload products to GooglBase, via feeder, that have been on my store for some time ... Feeder gives the appearance that it is working but it just 'skips over' newly added products as if they were not even there. Can someone please help?
Quote:
Originally Posted by TechnologyDirect
Your right it is CEON that is causing the problem, do you have the new version also check in docs for the newer version if the .htaccess
that should take care of your problem did for me.
I am trying to upload my google base feed, but I am getting the folowing error:
ERROR: fy_un_tp is not a valid feed template
when I click on Create Product Feed: Click [HERE] to create / update your products feed.
How can I correct this error so that I can upload my feed to google :dontgetit
The documentation.html states the following php.ini values..
max_execution_time = 300
max_input_time = 90
memory_limit = 32M
My installation was only outputting about 2156 lines.. Then I changed the settings in my php.ini and I get all 22,000+ lines!
woohoo!
But here's my dilema, I don't feel safe with a default execution time of 300, is there a way to have specific execution times based on a directory or better yet a file name? I've head of .htaccess settings per directory, but is there a way to specify an override set of"
just apply to www.mywebsite.com/googlefroogle.php
max_execution_time = 300
max_input_time = 90
memory_limit = 32M
" or something along these lines? I know easy populate sort of has a similar thing, it has a variable to specify execution time.
I tried editing ZENCART Admin > Configuration > My Store > Admin Set max_execution_time for processes 300 , but it didn't seem to affect this , since the googlefroogle.php file resides in the root.
Ok, the feed creation works fine for me, (once I added some text to make my descriptions at least 15 characters. I tried uploading but I just get a busy arrow cursor in the little pop-up window...
I have the
Google Base Feeder Configuration
Debug > true
setting set.
It just sits there for 20+ minutes..
upload ftp settings look ok... How can I tell what's going on?
The debug is only for feed creation. You should get some ort of message that the upload failed... Have you tried changing Passive mode in the config? How large is the file. I would recommend using GB's crawling feature instead of the php upload.Quote:
Originally Posted by edwardtilbury
Still need an answer, please. Should I maybe UN-install/Re-install? Really hate to do that if it can be avoided.Quote:
It seems that my GoogleBase feeder is not seeing new products. I added around 75 new products within the last couple of days. When I go to admin > tools > googlebase feeder - and then click on Create Product Feed, the feed generates (just like it always did before) but it only shows 295 Records, which was the number of products that I had in my store before making the latest additions. I am able to Upload the Product Feed and it appears on google. I'm not getting any kind of an error or anything- it's like GBfeeder just doesn't even see the new items. Any ideas?
Thanks.
Just to mention:
- I've searched this thread and cannot find the answer.
- I've looked over the original TROUBLESHOOTING documentation that came with the download and cannot find the answer.
- I am not getting an error that would, at least, point me in a direction for searching deeper. It's just broke - without any indication as to why.
So I'm not looking for a hand-out here, just some direction, a little 'support.'
Try unistalling and reinstalling as you yourself suggested. That should be your #1 step after searching here and not finding the answer.
speedcreed, how did you add the new products? Did you use something like EasyPopulate?
If so, or just in case, go to Tools > Store Manager > Reset ALL Products Master Categories ID
WOW! Finally an answer (thank you tg1). I was beginning to think I had the plague, or something. Or- maybe the developer for this mod is just on vacation this week - which is really a shame because this was a great mod until it 'broke' and I needed some help with it.
tj1: I added the new products the regular way (admin > catalog > categories/products > 'new product' then one at a time.
I just triedbut it made no difference. When I try to run GBfeeder, it still says "Processing: Feed - Yes, Upload - No; Google Base File Complete In 1.455838 Seconds 295 Records."Quote:
go to Tools > Store Manager > Reset ALL Products Master Categories ID
As of this morning I have 420 products on my store (and not just 295).
And again: I really hate to Un-install/RE-install unless it's absolutely necessary (much rather spend that time continuing to put more products in my store).
If I cannot get this resolved, does anyone know of a better way to get ALL of my products up on Google Base? My strength does not lie in the programming aspect of this business so I need as NEWBIE-friendly a solution as I can get (I thought that Google Base Feeder by Numinix was that solution ... but alas)
Grateful for any more help you can throw my way TG1, and thank you.
I still do not have answers to why not all products load and..Quote:
Originally Posted by kburner
Errors:
Error Bad data Line #
We recommend including this attribute. weight
We recommend including this attribute. upc
We recommend including this attribute. isbn
We recommend including this attribute. image link
I thought weight was being loaded. And wouldn't model number be for upc and isbn?
I have almost 8,000 new products I am loading via easy populate and really need this to work. Any suggestions?
Thanks,
Kim
make sure your descriptions have no "hard line breaks " or " carriage returns"..
try this, in easy populate delete all your descriptions..
Make a new description that's longer than 15 characters (since that's the google min required, and less than 70).
Just put this in excel and auto complete to the bottom
"my new 15 plus character description"
If it works without your descriptions then you probably have some funky characters in there or something..
Quote:
Originally Posted by edwardtilbury
Does anyone here also have long descriptions here?
I recently uploaded my listings to google base but it said that many of them were over 70 characters in length and google base requires it to be less.
I would like to alter the code to include a php trim? function on the description variable so that it stays under 70, once I figure it out I'll post it, but if a php expert knows how to do this and posts his work that would be appreciated too :)
Oh yeah.. I thought about one more thing.. I also had a similar problem.. Do you think it's timing out before it finishes the xml output 100%.. . If you turn debug on, in the pop-up window you should get a "List completed" at the very bottom. If not then your list doesn't have enough time to finish...Quote:
Originally Posted by kburner
You might want to try adding this line of code to \store\googlefroogle.php
As you can see, on the middle line I added a new line that sets the time limit of this page to six minutes... depending on your CPU server speed you may need to make it longer.PHP Code:<?php
set_time_limit(600);
* googlefroogle.php
Play with this and see if you get different results.
I turned debug on, and in the pop-up window I got a "List completed" so it's not timing out.
Says: "Google Base File Complete In 1.459843 Seconds 295 Records." though I have 420 records that should be populating.
(sigh).
And to kburner: When my install of GBF was actually working, I was getting some of the errors that you mention. It turned out that I was editing my descriptions in MS Word, and Google Base did not like the rendering of some characters. For instance, quotation marks copy/pasted into a Zen Cart description (assuming one is using the WYSIWYG editor) is not the same as copy/pasting into the straight text editor. I wish that I could re-create what I'm talking about and show you an example but if you look at quotation marks in MS Word/Times New Roman, they look 'curly' and that formatting is not rendered, or translated, correctly into Google Base.
I solved most of my errors and got GB to accept my posts by copying the errors straight from the "Feed status details" page on Google Base and then pasted them into notepad (so as not to incur any more formatting) and I corrected the strange characters there before pasting into Zen Cart description (Text mode- and not WYSIWYG mode) and got no more errors in Goggle Base. Again- if I could re-create the error, I'd show you exactly what I mean but I can tell you that you'relooks highly suspect (emphasis on "revisión" which I'm sure should look like: "revision.").Quote:
the Reina Valera revisión 1960
Hope this helps.
And I still need some help with my problem.:D
Thanks
what about when you replace your descriptions with a generic description? like just put some blank filler text there.
You could to a store export or ext store export to backup your descriptions , then just make a test file and overwrite your descriptions in easy populate so we can tell if it's description related.
I have a feeling it's the funky characters.. but who knows.. :smile:
I'm trying to customize the google base xml exporter for zen cart to automatically reduce my Product Name / Title to 70 characters or less.. I was able to accomplish this with my test variable $test_name , see the example code below of what I was able to do:
Now my only problem is inserting the code into the google base xml exporter... I do not understand where the actual product name / title varible is.Code://BOF Edward Custom formatting of product name and title
$badstuff = array('>', '(', ')', 'discount', 'sale', '/');
$test_name = str_ireplace('doctor', 'DR', $test_name);
$test_name = str_ireplace('bill gates', 'Bill', $test_name);
$test_name = str_ireplace($badstuff, "", $test_name);
trim ($test_name);
substr($test_name, 0, 70);
//EOF Edward Custom
Here's where I think it exists, but I'm not 100% sure..
How would I edit the title with my script? In other words, how could I combine the 2?Quote:
$content["title"] = '<title>' . $google_base->google_base_xml_sanitizer($products->fields['products_name'], true) . '</title>';
:)
Need help
:P
I use Zen cart 1.3.8a Google base feed 1.7.1a
this is my google base feed http://bagsho.com/feed/ho_products.xml
I don't know where it's wrong, when i Uploads files it's say
Feed status details
Outcome: Data feed upload failed. No items are live. help
Number of items processed: 0
Number of inserted items: 0
Uploaded at: Apr 12, 2009 10:55 am PDT
Processed at: Apr 12, 2009 10:56 am PDT
Detected file format: XML
Can some one help me , thanks :bigups:
I'm just setting up my first store and wondered if anyone can confirm if this works at all? I've read some of the thread and I cant ascertain if this does work now at all.
Thanks
These threads with all the bug reports can be kind of scary. But yes, I installed it on 1.3.8a and it works great. I just had trouble at first because I was trying to upgrade from the Froogle version of a couple years ago.
Thank you- I will give it a whirl then :)
I was pretty skeptical of it at first too.. I didn't want to muck up my site with unnecessary mysql tables and new columns.. Actually it was pretty easy to install.. I have Easy Populate / Custom fields added / column view / admin privileges / and some other modules I can't think of right now, but it was a pretty easy install, just had to copy a few files over, didn't overwrite anything that I recall. The only edits were to add the button in admin mode.:smile:Quote:
Originally Posted by tiaz
Not for me.. :dontgetitQuote:
Originally Posted by tiaz
Google does not accept any of my 287 products from the feed upload, claiming that they are missing title and description attributes... News to me since they are in the store and the XML file... Dunno what the fix should be... :frusty:
look up the product # of a couple of the items that aren't uploading..
Do they have a description? Also how many characters is the title or description.. with debug mode turned on it should say something I think.. There is a max # of characters for desc / title
You can download Notepad++ it's a really good opensource notepad that counts characters and a ton of other stuff.
ok im sure this has already been mentioned in this thread but i cant find an answer to it.
Just installed this module and when running the SQL i got the following
8 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
As a result admin >> Google Base Feeder Configuration is pretty much empy, just contains teh top of a table (Title Value Action) but nothing else. Which means i cant set it up thus tools >> Google Base Feeder doesnt work.
Im off to re-read this thread again incase i missed the answer but if anyone can help it woudl be really appreciated.
read through all pages again and still cant seem to fix this issue. Anyone got any ideas? help!
After upgrading to the latest version of google base (I followed the instructions to the letter) I was able to successfully update and upload my feed several times, no problem.
Now, all of a sudden, when trying to Create Product Feed, I get a 404 error and the following link in the status bar :I've tried uninstalling and reinstalling the sql file, but no good. Anyone have any ideas? I'm using Zencart 1.3.8aCode:http://www.ashbysonline.com/googlefroogle.php?feed=fy_un_tp
Quote:
Originally Posted by wtashby
Worked fine for me.
anyone have any ideas? it was a fresh install of zencart 1.3.8a and only has the zenlightbox module installed. my clients keeps asking me for this and i have no idea why it hasnt worked.Quote:
Originally Posted by jonnyboy22
Hi, I am in need of someone to please help me install this onto my site www.microbelift.net
A fellow Zen-carter tried to help me but got stuck. Please help me. You can email me at microbelift######################
Thanks for your help. Someone PLEASE help.
OK... It seems that the Google feed gives the boot to titles and descriptions that contain certain characters like INCH marks TRADE mark symbols REGISTERED trade mark symbols, the old fashioned & character and many more I am sure. These were not a problem a few months ago, ... :huh:Quote:
Originally Posted by painterforum50
I have everything install, linked and working, but when I goto create a new xml file, only 2 products show up in the product feed when I have 800+ products in my store. Thanks
I have a similar issue where all of my products are NOT in the xml File. I am using 1.38. How do we fix this.....It is a real problemQuote:
Originally Posted by stlnyc
I followed your directions by eliminating the à in notepad. Then saved and ftp. Now, file will not even load to google. I am getting this error.Quote:
Originally Posted by speedcreed
Google Base Feeder v.1.6.16 07.03.2008 23:40:59 started 2009/05/02 17:42:31
Feed file - /home/xxx/xxxx/feed/froogle_products.xml
Processing: Feed - Yes, Upload - No
2008 MySQL client ran out of memory
in:
[select products_tax_class_id, products_price, products_priced_by_attribute, product_is_free, product_is_call from products where products_id = '36255' limit 1]
I also tried to load right from google base manually. And will not work either.:frusty:
I have loaded around 7,000 more products since my last feed. I am up to around 10,000 total.
Kim
any news on my issue?