Thanks for that.
One thing that could make a difference our website developer has included an RRP field in the product listing, will I need to add code to ignore this field as sometimes it is blank. That must be the reason?
Printable View
Hello,
Can anyone give me a good site to get information about Cron Jobs? I set up a Cron Job in my cPanel through my host but the results were not correct. The Cron Job command line I put in was:
The file is saved in the /feed folder as vg_google_products.xml but the command line above saved it as vg_google_.xml. It omitted the products from the file name. It also only parsed the store name and the store website information into the xml file. It did not upload it to Google, which is fine since it would not have been accepted because it wasn't the correct named file. Lastly, it saved the file with the file permissions of 777, which isn't correct either.Code:GET http://www.values-galore.com/googlefroogle.php?feed=yes&upload=yes&type=products
If I put the above command into the address bar of my browser, it runs perfect (omit the GET). So we know the googlefroogle.php file is working properly. My store has close to 3000 products and when I run all the steps from the Admin -> Tools -> Google Base Feeder it all works perfect (both the creating of the feeder and the uploading).
Any assistance would be greatly appreciated.
I just tried the PHP instead of GET and the email I got said:
/bin/sh: PHP: command not found
I will keep watching for more ideas.
:smile:
I just got it working with the following:
I found this on the forum at http://www.numinix.com/forumCode:GET 'http://www.values-galore.com/googlefroogle.php?feed=yes&upload=yes&type=products' > /dev/null 2>&1
OK, I've looked all throughout this thread and simply can't find the answer I'm looking for :(
I just installed GBF and I also use USEO URLs. I changed the two settings that numinex said to change in the USEO config section, but when I click to create a new feed, a new window pops up for my domain and it a page not found :(
Any ideas on what I need to do?
Thanks Guys!
hi
i am getting the following message:
Not Found
The requested URL /GOOGLE_FROOGLE_DIRECTORYGOOGLE_FROOGLE_OUTPUT_FILENAME_products.xml was not found on this server.
done everything by the book, anyone know whats up ???
Egg:cool:
UPS! forgot the googlefroogle.php file in the main directory, all is well now :)
Now that I've got this mod working, I wonder if it is at all possible for special characters to exist in seo urls, and still use the feeder at the same time?? I would prefer if the categories and products don't run together. any way to avoid this and still have my feed work?
Thanks!
Hello,
Seems the feeder strips out all the quote (") marks. About 90% of my products use this character in the description to define measurements. Does the XML file require the quote marks be removed? If it does, then I will just have to live with it. If it doesn't, can the GBF be adjusted to leave the quote marks in?
Thanks
Help With Google base feeder install!!!
I've uploaded all the files to my store directory as per instructions and checked that they are all in the proper locations.
I set the permissions on the feed directory to 777
I opened the file googlefroogle.sql in my text editor and copied the code to the clipboard.
I went to Admin->Tools->Install SQL Patches and pasted the code into the Enter the query to be executed box and clicked send.
I Whent to Admin>Configuration>google base feed configuration. and set
I whent to go to Admin>tools>google base feeder. and nothing their is nothing there.
I read a post of one guy haveing the same problem but never saw an answer
Can anyone help with this?
nope I have not re named the admin file yet so the file names match
Are you using the latest version available at numinix.com?
Im useing 1.6.14 mod and I, runing Zen 1.3.8
Just installed Google Base Feeder v.1.6.14a downloaded from you site.
If I create a feed, it reports: Google Base Feeder v.1.6.13a
How come? Is this ok?
I upgraded because I get error reports from Google:
Some items do not get inserted and I don't know why....
Feed status details
Outcome: Data feed has some errors. Some items contained errors and were not processed successfully, but all other items are active. - help
Number of items processed: 223
Number of inserted items: 181
Uploaded at: May 8, 2008 10:38 pm EDT
Processed at: May 8, 2008 10:39 pm EDT
Errors:
Error Bad data Line #
We recommend including this attribute. - help
isbn:
647
We recommend including this attribute. - help
upc:
647
The item is missing a required attribute. - help
description:
647
This is a product feed, why would it want isbn attribute? I see that it required a product description. Maybe this is the main problem? I have some items with just title but no description.
Google Base Feeder v.1.6.14a
I was missing the googlefroogle.php in the root. My bad..
Question about the errors from google about my feed still apply.
I want to activate my Google Checkout and searched this thread but don't quite understand yet how to activate or add the Payment_accepted attribute in the google_base.xml file - can you tell me where to add the info I got from Google's web site. <g: payment_accepted>GoogleCheckout</g: payment_accepted> and where to add it in the file named??
Google info:
http://base.google.com/base/formatti...d=3&country=US
Payment_accepted
What it is: The acceptable payment methods for this item.How to format: Acceptable values are: Cash, Check, GoogleCheckout, Visa, MasterCard, AmericanExpress, Discover, and WireTransfer. You may include as many methods as you accept. For tab-delimited, separate each payment method by a comma. For XML, include each payment method as a separate tag.Tab-delimited example: Visa, MasterCard, DiscoverXML example: <g: payment_accepted>Visa</g: payment_accepted>
<g: payment_accepted> MasterCard</g: payment_accepted>
<g: payment_accepted> Discover</g: payment_accepted>
I am not sure what assistance you need on top of the explanations returned by Google? These are required attributes. If you do not have a UPC, you must have an ISBN. If you don't have an ISBN, you must have a UPC.
This is already supported in the latest version.
I keep getting this error code when I upload a feed
We didn't understand the header (first) row of your file. Please make sure you're using valid attribute names. - help <?xml version="1.0" encoding="UTF-8" ?>: 1
can someone tell me what IM doing wrong?
What? UPC and ISBN fields are not even present in Zen Cart products. I don't have them and never needed them before. Up to very recently I used v 1.3.2 and had froogle.txt file that I uploaded without any errors. Now I upgraded zen cart to 1.3.8a and figured I upgrade Google Base Feeder as well. Now the mod creates a *.xml file and I get error reports back from Google. I don't understand why I suddenly need UPC and ISBN?
I know I have some products without the description, I will fix that and see if Google still complains about UPC and ISBN.
Google in the UK are now requiring a EAN number this is easy to do just by changing
toQuote:
$content["upc"] = '<g:upc>' . zen_froogle_sanita($products->fields['products_upc'], true) . '</g:upc>
in googlefoogle.php about line 213Quote:
$content["upc"] = '<g:ean>' . zen_froogle_sanita($products->fields['products_upc'], true) . '</g:ean>
The problem I am having is we have about 5,000 products and at this time we are still trying to get the EAN numbers from the suppliers for about 1,500 of them, is there away to set it up so if the UPC field is blank it will not add the product to the feed.
It is as I suspected, the description that was missing was causing google to reject the items. Now all items were accepted, no more errors.
Numinix, you were correct, once items get rejected they produce a list of stuff that can be done. But only the ones showing required attribute need correction. After that, no more complains.
647 We recommend including this attribute. - help
upc:
647 The item is missing a required attribute. - help
description:
Hi,
When I upload my feed to google base, It fails and gives me the error...
We recommend including this attribute. help isbn:
7
We recommend including this attribute. help upc:
7
Google Checkout requires a quantity greater than zero. help
7
To accept Google Checkout, you must first sign up for a Google Checkout account. help
7
You must specify your website's URL on the settings page before uploading items with URLs. help
7
This expiration date is too far in the future. help expiration date:2009-05-15
12
:censored:
Lol help please
You must specify your website's URL on the settings page before uploading items with URLs
Did you do this? You have to do this in your google account somewhere under setting for your feed. Did you register your feed file?
I did, Still not working, getting Failed. We recommend including this attribute. help isbn:
7
We recommend including this attribute. help upc:
7
Google Checkout requires a quantity greater than zero. help
7
To accept Google Checkout, you must first sign up for a Google Checkout account. help
7
This expiration date is too far in the future. help expiration date:2009-05-15
12
Hi..
I understand the Products Feed, that's easy.. But what's the Document Feed? I don't quite understand what the purpose of that is? And do you have to create a seperate feed in Google for it?
Thanks
David
If you sell products, the product feed is for you. If you publish, sell documents, document feed is for you....
You pick what you need. I suspect you don't need to bother about documents since you asked.
Hello All,
Trouble getting GBF to work, at 1st I would get a upload failed error, It seems that GBF had created a file called (domain_products.xml) but it was trying to upload a file called (domain_products.xml_products.xml) no that is not a typ-o.
Since the file names did not match the upload failed. So I deleted the file (domain_products.xml) and recreated a product file with GBF witch it named (domain_products.xml_products.xml) and tried the upload again, the upload was successful.
However, I now get an error from Google that the upload failed,no products are live. Looking at the details it would seem that Google can not understand the file.
I am not sure where to go from here !
Can anybody help ?
Jim
https://ecmauto.com
For the output file name use only your domains name without the www and no .com
www.thisismydomain.com would be just thisismydomain
The mod will add the _products.xml automatically. The feed needs to be registered with exactly the same complete file name in Google Base.
Hope this helps...
Hi mydanilo,
Thing is that I am not adding the ext. "_products.xml", In fact the mod does not ask me for a file name, it will generate the file name"domain_products.xml".
If I used the upload products feature in "admin-tools-google base feeder" I get an error,in the error it will tell me the path and file name of the file it tried to upload, the file it was looking for was "domain_products.xml_products.xml". I went to my c-panel and changed the name of the file to match and the upload succeeded.
However I now get an error from google that the upload failed stating that they either can not understand the URL or the attribute on nearly every line of the file.
Is it somthing the mod is doing or do I need to reformat my entire site ?
Help
Jim
https://ecmauto.com
[FONT=Times New Roman]Is there a way to have this mod create a [/FONT][FONT=Arial]tab-delimited plain text file instead of a XML file?[/FONT]
mydanilo,
Sorry i can be a bit slow at times,I found what you referd to,"admin-config-google base-output filename" the name "domain_products.xml" was a sample name,duh. I gave a name,went to c-panel and deleted the file 1st file it generated,went to admin-tools-google base and created a products feed file,it created one just as I named it and gave the ext. just as you said. I went tot my google base acct. and registerd the file excactly as named,went back to admin-tools-google base and upload product feed. It has stalled at "upload started"
jim
https://ecmauto.com
Hi all,
More info on my problem,GBF will create a .xml file but it stalls at "upload started". I can upload it manualy however,but, google reject it reporting errors in every link url in the file.It seems that they are missing the "http://"prefix that google requires. How can I fix this ?
anyone!
Thanks,jim
https://ecmauto.com
Google Base Feeder Configuration
Store Address
make sure you use http://www.yourdomainname.com
not just yourdomainname.com
Danilo,
Thanks for the reply, since last post I went through the .xml file that GBF generated and added the "https://mydomain.com/"in front of every link and uploaded again manually,Google reported no errors this time, Trouble is that I will have to modify the .xml file every time I generate a new one,monthly,before upload.What a headache.
Bigger problem however is that I never checked my site during all this,when I did I found it was down,reported a 1064 syntax error and made the site unusable. I un-installed GBF and site is now fixed.
Any suggestions on how to correct ?
Jim
https://ecmauto.com
I believe he was just telling you to put http://www.ecmauto.com for the setting STORE ADDRESS located in ADMIN->CONFIGURATION->GOOGLE BASE FEEDER CONFIGURATION.
Yep, exactly. Do as numinix said and no more editing.
Numinix, I was wondering if it is possible to tweak the mod to export a feed with lowest price instead of the base price. I have a shop with lots of qty discounts set and I display "As low as" pricing. My competitors upload feeds with lowest price to google base and I look pretty bad with my highest price listed. Any easy solution to this?
Find $price in the main root file and you can change how it is given its value.
OK, so I will try and replace it with:
zen_get_products_discount_price_qty
I will test and then post.
I tried to replace
with:PHP Code:
$price = zen_get_products_actual_price($products->fields['products_id']);
PHP Code:
$price = zen_get_products_discount_price_qty($products->fields['products_id']);
I guess this would have been too easy. I do not know enough about PHP to be able to come up with the right solution. Could somebody give me a hand?
Good Morning everyone.
I ran this excellent mod (1.6.11) with zen cart (1.3.7) yesterday and ran into a problem. Although it creates, displays and apparently uploads the feed it does not appear in Google Base (either in the public area or in my account). I assume I have got a configuration setting wrong and would really appreciate some advice.
After uploading, the mod reports the following:-
Google Base Feeder v.1.6.11 03.27.2008 00:05:59 started 2008/05/21 11:41:46
Feed file - /var/www/html//feed/domain_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
First attempt (passive mode off): Uploaded Successfully
-r--r----- 1 ftp root 331095 May 21 04:31 domain_products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp root 331095 May 21 04:31 domain_products.xml
Upload ok!
Viewing the Google Base FTP content (last option on the /admin/Tools/Google Base Feeder page gives
Google Base FTP content:Connected to: uploads.google.com/total 0
Many thanks in anticipation of help
Philip
You might just give it 12- 24h and see what shows up in your google account. Did you check there yet? Google Base is kind of slow...
Did you check in Google Base and see what the status is?
My Items - Data Feed
Numinix,
I greatly appreciate all your input,But that is what I did,I put"https://ecmauto.com/" in front of all link's. And was able to successfully upload the file manually.
Question is why doesn't the mod do that ? and
Why do I get the 1064 syntax error ?
I have since uninstalled the mod to keep my site working.
I would love to get your mod working as it would save me having to learn how to create a file.
Thank again,jim
https://ecmauto.com
It does put your website into all of the links, otherwise how would Google know where to link to?
If you need to have this module installed for you, please PM me or visit the Numinix services page found in my forum signature.
Hi Numinix,
Thanks for the offer but I think I'm ok on the the installation.
The problem is that the mod. did not put my web add. into any of the links. That is why the 1st upload failed. It wasn't until I edited the .xml file GBF generated and added my web add. into all the links that I was able to get a successful upload.
I tried the install twice, double checked the local of all files and I used cut and paste with notepad++ to install the .sql patch. I did not use upload.
Thanks,Jim
https://ecmauto.com
I keep getting this error when I upload to google
Errors:
Error Bad data Line # 22150
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.
line 22150 looks like this - <g:mpn>ChameleonEvoGore-Tex®XCR®</g:mpn>
I've been searching the forum, and I think it has to do with the sanitizer function not working right, but I have no clue how to fix it:frusty:
what am I missing?
Hi,
I've tried installing google base feeder. I've uploaded the files, pasted and ran the sql patch and put all of the things needed in admin>configuration
My screen looks like this in admin. Other than that I don't get errors or anything... just no feed.
http://i285.photobucket.com/albums/l...creen_base.jpg
Can someone help me? I'm using zc 1.3.7 and have installed base feeder 1.6.7. (it said it was compatible with zc 1.3.7)
Thanks in advance,
Juliet van Ree
does anyone know if its possible to add a few lines of code to be able to override the expiration date and the google checkout?
my issue is when i try to upload the file to google base its giving me an error that says "item's expiration date is greater than 31 days" and for google, i want to change it so <g:payment_accepted>GoogleCheckout</g:payment_accepted> is deleted from all feeds.
is this possible?
thanks!
Sorry to take so long to reply fvb, but I have only just got roung to looking at this again, as important as it is to me.
Yes, a file was created and it looks ok to me.
I had thought that my problem was that I was trying to link into the google base account that was linked to my name rather than the website. I have sorted this out with goole and also created an new ftp account. When I went to upload my login failed about 8 times out of 10. Logging in to view the feed has been equally problematic, although I have just started getting in. It is reporting 0 uploads though!! (Mind you, I have only just uploaded)
So, I still don't do where I am.
Any advice would be apreciated.
Philip
Has anybody gotten this mod to work ?
I have not been able to figure out the problem so far so unfortunately I have had to uninstall it.
If anybody has any suggestions I would love to hear them.
Thank's in advance,Jim
https://ecmauto.com
The mod works great, google base on the other hand is goofy. For some reason every site I have use this or the other google base/froogle mods with take about a month to work. Just make really sure you have followed the directions exactly, set up a cron job, and ignore the errors for about a month. Then (magicaly as far as I can tell) google decides it like you and will accep your feed.
Sorry! I had to repost so the code would look readable instead of some smilies that showed up...
does anyone know if its possible to add a few lines of code to be able to override the expiration date and the google checkout?
my issue is when i try to upload the file to google base its giving me an error that says "item's expiration date is greater than 31 days" and for google, i want to change it sois deleted from all feeds.PHP Code:
<g:payment_accepted>GoogleCheckout</g:payment_accepted>
is this possible?
thanks!
it takes my feed about 30-60 min to show up after a upload
I have never had problems login into google, you may want to try starting a brand new account
skip the ftp for now and use the manual web upload, till you get it working
(this will take one more thing out of the equation and also give you error messages to help trouble shoot the problems
ah thank you. i didn't see those for some reason.
i don't suppose anyone can help me figure out how to add attributes to my feeder? i don't need all these isbn and upc codes, i need the models that are attached to the items.
Example
like this item has a few models attached to it. i'm sorry i ask some stupid questions but i just don't want to break the site...again.
Alright, i realized why they weren't producing any feed, because the quantity fields for my items are set at 0. I kinda like the quantities at 0, so how do I make it "ignore" the quantity amounts so i can produce feeds?
First, sorry if this has been discussed before. I used Search and it only pointed out this thread, but not which page on the thread. I don't have the time to read through over 50 pages...
I just installed the G Base patch. Since I'm running ZenCart 1.37, I used patch v1.5.3, the last one listed as compatible with Zen 1.3.7. After pasting in the content of googlefroogle.sql, I got this response:
8 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
The upgrade_exceptions table shows this record:
upgrade_exception_id: 1
sql_file: SQLPATCH
reason: Cannot insert configuration_key "" because it already exists
errordate: 2008-06-03 22:37:09
sqlstatement: 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
As a result, Admin -> Configuration -> Google Base Feeder Configuration only shows an empty table with columns Title/Value/Action and no content and Admin -> Tools -> Google Base Feeder brings PHP errors when clicking on the links in Step 1 and Step 2.
What can I do? Thanks!
wtf!? everything was going good, than...BOOM... my feeds process as ONEWORD! Like I want to go to the store is, "iwanttogotothestore" the descriptions, the titles everything... how do I fix this?
I know this has been ask, but I have read through the first 20 pages of this thread without finding the answer. Google base tells me that
Error
We didn't understand the header (first) row of your file. Please make sure you're using valid attribute names. help
Bad data<?xml version="1.0" encoding="UTF-8" ?>
Line #1
Could someone point me in the right direction. Thank you
Thank you for your help [B]fvb. This is what my header in the file looks like.
<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">
<channel>
It's name is domain_products.xml
Is this right? If it is then I don't know why Google is rejecting it.
All is working perfectly now - must have just be a glitch.
On a separate issue I have had a few errors reported - attribute no longer supported, recommended ones not being used etc. It actually rejected some listings which turned out to be gift vouchers. Is there a way of excluding gift vouchers? I'm currently using version 1.6.11. Would upgrading to the latest version solve any of these issues.
Regards
Philip
I have been using the feeder for a while and it has been great. Yesterday, I started having problems with the submittal process. I have Goddady as a host, so I upload the XML file from my Googlebase account. I added 4 products so I decided to refresh the file. I keep getting a failed message with errors: Disapproved. I cannot figure it out. Any ideas?
Thanks!
so no one knows how to help me?
only suggestion i have is trying this forum
http://www.numinix.com/forum/viewfor...b5e517f3ed64d5
My google feed failed in style today. It is a feed on my test site www.pleasuredisc.co.uk and has been working away every day without failure until today. I have attached below the failure results as per the google site report and would appreciate it if anyone can help with this. A further annoyance is that I also installed this mod on a client's site yesterday and got the same failures today so it is not site related as far as I can see.
Many thanks - and if I have been a proper muppet in doing something wrong then I bow to that in advance :)
My test site has 7 items but clearly I have only shown the result for one of them as they are all the same failure.
GOOGLE FAILURE REPORT TEXT:
Feed status details
Outcome: Data feed upload failed. No items are live. help
Number of items processed: 7
Number of inserted items: 0
Uploaded at: Jun 5, 2008 7:04 pm BST
Processed at: Jun 6, 2008 7:56 am BST
Errors:
Error Bad data Line #
We recommend including this attribute. help mpn
28
We recommend including this attribute. help isbn
28
We recommend including this attribute. help upc
28
We recommend including this attribute. help brand
28
The item is missing a required attribute. help description
28
This expiration date is too far in the future. help expiration date:2009-04-07
33
You entered a payment method that is not currently available. help payment accepted:Maestro
45
Many thanks in advance.
Rob
I'm getting the same thing from Google BaseQuote:
Errors:
Error Bad data Line #
We recommend including this attribute. help mpn
28
We recommend including this attribute. help isbn
28
We recommend including this attribute. help upc
28
We recommend including this attribute. help brand
28
The item is missing a required attribute. help description
28
This expiration date is too far in the future. help expiration date:2009-04-07
33
You entered a payment method that is not currently available. help payment accepted:Maestro
45
Hi and thanks for this but I have trawled through all 900+ posts and I cannot see this. As it has only just happened today after many weeks of working fine I assumed that it was a recent issue but still cannot see this. I will go search again but of you could point me to the post I would greatly appreciate it.
Thanks
Rob
I think I found what I am looking for and really wasn't trying to be lazy in asking first without looking. Now I just need to get my head around the 'recommendations' given by google such as using mpn, isbn, upc and brand attributes because as things stand right here and now - this may as well be in chinese.
Anyhow I see where I need to make a few alterations in admin but still wonder why it has taken until today after many weeks of uploading without errors, for the feed to suddenly fail. Could it be that google has changed something?
Cheers
Rob
The message from Google clearly states that a description is required for all products. It also recommends certain attributes such as UPC. Finally, you need to set an expiry date within their limits.
firstly, it is an issue when the information is required to properly post your products. the attributes is all im asking about. i dont know how to add certain attributes without killing the php thats why im posting here. i dont need upc or isbn just models. and finally, i didnt ask about the date, thats been set.
I just install Google Base Feeder v1.6.15
worked great, best one yet!
thanks Numinix
:clap:
Hey all,
I have been using base feeder for a while. At first it worked like a charm. I haven't edited any files on my store but for some reason the past few months i just get this from froogle
"Error Bad data Line #"
I'm not sure how to fix it. It worked before and suddenly it stopped working. Again i haven't made any changes to my store except adding new products.
Any help would be appreciated.
Thanks