benspun Posted May 19, 2007 Share Posted May 19, 2007 Thanks benspun. I reuploaded everything. This is what I get now: Warning: fopen(/home/charm3/public_htmlfeeds/froogle_us_file.txt) [function.fopen]: failed to open stream: No such file or directory in /home/charm3/public_html/store/admin/froogle_us.php on line 446 Warning: fwrite(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 447 Warning: fclose(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 448 Warning: fopen(/home/charm3/public_htmlfeeds/froogle_us_file.txt) [function.fopen]: failed to open stream: No such file or directory in /home/charm3/public_html/store/admin/froogle_us.php on line 454 Warning: fwrite(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 455 Warning: fclose(): supplied argument is not a valid stream resource in /home/charm3/public_html/store/admin/froogle_us.php on line 456 File completed: froogle_us_file.txt Warning: chmod() [function.chmod]: No such file or directory in /home/charm3/public_html/store/admin/froogle_us.php on line 458 Connected to uploads.google.com, for user charmedbystarr uploads.google.com: FTP upload has failed! Script timer: 4.839561 seconds. Hi Melissae & Jason, You both ave the same error. If you look at the error you get, you will notice that the path is not correct: [...]/public_htmlfeeds/[...] there should obviously be a "/" between "public_html" and "feeds", so that it looks like: [...]/public_html/feeds/[...] This is a very commun issue for this contribution. The solution for it is on the 2nd post of the 1st page of this forum topic. Here is a direct link: http://www.oscommerce.com/forums/index.php?s=&...st&p=936919 Regards, -Ben Martin Quote Link to comment Share on other sites More sharing options...
Aire Posted May 19, 2007 Share Posted May 19, 2007 Thanks. In addition to what was here, I had to edit it to say "/store/feeds/" because my store is in a directory called "store" instead of catalog. File completed: froogle_us_file.txtConnected to uploads.google.com, for user charmedbystarr Uploaded /home/charm3/public_html/store/feeds/FROOGLE_FTP_FILENAME to uploads.google.com as froogle_us_file.txt Script timer: 7.843379 seconds. Beautiful. Much kudos to you, benspun. I hope Trentide fixes his issue as well. :) Quote Link to comment Share on other sites More sharing options...
showery Posted May 28, 2007 Share Posted May 28, 2007 My system works fine but froogle US dont like the file uploaded errors below dfw.txt Bulk upload failure. 249 errors. None of these items are active Errors: Error Bad data Line # This attribute has been deprecated. - help label 1 This attribute has been deprecated. - help shipping 1 We didn't understand this location. - help location: Address of the items's location here 2 We didn't understand this location. - help location: Address of the items's location here 3 We didn't understand this location. - help location: Address of the items's location here 4 We didn't understand this location. - help location: Address of the items's location here 5 We didn't understand this location. - help location: Address of the items's location here 6 We didn't understand this location. - help location: Address of the items's location here 7 We didn't understand this location. - help location: Address of the items's location here the list goes on but we get the idea it wants an address I guess. I have my address in the store is there another location I should have it for froogle? Quote Link to comment Share on other sites More sharing options...
benspun Posted May 28, 2007 Share Posted May 28, 2007 My system works fine but froogle US dont like the file uploaded errors belowthe list goes on but we get the idea it wants an address I guess. I have my address in the store is there another location I should have it for froogle? Hi showery, The errors "We didn't understand this location. - help location: Address of the items's location here" are there because you haven't specified your item's location in the file /catalog/admin/froogle_us.php, at line 04: $default_location = "Address of the items's location here"; // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma. Perhaps I forgot to mention this in the readme.txt file. Regards, -Ben Martin Quote Link to comment Share on other sites More sharing options...
benspun Posted May 28, 2007 Share Posted May 28, 2007 As showery has also pointed out, the fields "label" and "shipping" are now deprecated by Google Base. I will removed them from the next relese of Automated Store Feeds. But that does not have an influence on your feed, Google Base simply does not consider this field anymore. -Ben Martin Quote Link to comment Share on other sites More sharing options...
showery Posted May 28, 2007 Share Posted May 28, 2007 Thank you both very much and for the speedy responce. I will change the froogle_us.php and see if that helps. I hope it does as this mod xeems the be the best I have tried so far as for ease to install and use. I did not see the info in the readme but I could have missed it. I have sent to new upload to froogle now waiting to see if they accept or reject. Thanks agian and be safe! Steve Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted May 28, 2007 Share Posted May 28, 2007 (edited) I don't have long so excuse me if I haven't read the previous threads. Thanks for attempting this it could well be a valuable contrib but there seem to be some fundamental flaws with this package (I have only tried google Base so far). The urls are being written wrongly for a start. Because my admin is https my urls are starting https = wrong is is because the URLs are being "assumed" from the admin end where the correct method would be to load the key files from the catalog dir Perhaps take it back like .. chdir('../'); define('DIR_WS_CATALOG', DIR_WS_HTTP_CATALOG); require_once('includes/configure.php'); require_once(DIR_WS_INCLUDES . 'filenames.php'); require_once(DIR_WS_INCLUDES . 'database_tables.php'); require_once(DIR_WS_FUNCTIONS . 'database.php'); and include SEO URLs like .. if ( file_exists(DIR_WS_CLASSES . 'seo.class.php') ){ include_once(DIR_WS_CLASSES . 'seo.class.php'); $seo_urls = new SEO_URL($languages_id); } require_once(DIR_WS_FUNCTIONS . 'html_output.php'); You can then use the tep_href functions to create good urls Edited May 28, 2007 by Babygurgles Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
nafri Posted May 29, 2007 Share Posted May 29, 2007 Hi Nafri, You are not supposed to have a file named "FROOGLE_UK_FTP_FILENAME". That is the name of a variable in the code! If you haven't solved your problem, please post the beginning of your feed file here, with the error message given by Google. Google says that there is an error on line 2 of your file, so there must be something there, we just need to look at it. Also post the entire error message Google gives you, so that we can track back the error. Regards, -Ben Martin hi Martin sorry for late reply.HAd alok at the other file and this is what i found link title description expiration_date label price image_link id instock shipping brand quantity payment_accepted payment_notes product_type currency language ship_to condition location http://www.xxxxx.co.uk/product_info.php?la...p;products_id=1 Toshiba PX1176U-2NAC 2007-06-03 Toshiba PX1176U-2NAC,PX1176U-2NAC,Toshiba 3.55 http://www.xxxx.co.uk/images/m_images/prod...mages/sorry.jpg 1uk Y US:Ground:2.05,CA:Ground:2.05,UK:Ground:1.70,DE:Ground:0,AT:Ground:1.70,IE:Groun d:1.70,CH:Ground:1.70,DK:Ground:1.70,PL:Ground:1.70,FR:Ground:1.70 Toshiba 1 Visa,MasterCard,AmericanExpress,Discover,check,WireTransfer,PayPal We also accept payments by PayPal and by Bank Transfer. Keyboards and mice GBP en ALL new Address of the items's location here http://www.xxxxx.co.uk/product_info.php?la...p;products_id=2 Toshiba PX1253E-1DAC Multimedia Keyboard UK English - black Multimedia Keyboard UK English - black Suitable for all Toshiba notebooks 2007-06-03 Toshiba PX1253E-1DAC Multimedia Keyboard UK English - black,PX1253E-1DAC,Toshiba 11.96 http://www.xxxxx.co.uk/images/m_images/pro...mages/sorry.jpg 2uk Y US:Ground:2.05,CA:Ground:2.05,UK:Ground:1.70,DE:Ground:0,AT:Ground:1.70,IE:Groun d:1.70,CH:Ground:1.70,DK:Ground:1.70,PL:Ground:1.70,FR:Ground:1.70 Toshiba 54 Visa,MasterCard,AmericanExpress,Discover,check,WireTransfer,PayPal We also accept payments by PayPal and by Bank Transfer. Keyboards and mice GBP en ALL new Address of the items's location here under location it has ur address here..Is that right Many thanks Quote Link to comment Share on other sites More sharing options...
benspun Posted May 29, 2007 Share Posted May 29, 2007 I don't have long so excuse me if I haven't read the previous threads. Thanks for attempting this it could well be a valuable contrib but there seem to be some fundamental flaws with this package (I have only tried google Base so far). The urls are being written wrongly for a start. Because my admin is https my urls are starting https = wrong is is because the URLs are being "assumed" from the admin end where the correct method would be to load the key files from the catalog dir Perhaps take it back like .. chdir('../'); define('DIR_WS_CATALOG', DIR_WS_HTTP_CATALOG); require_once('includes/configure.php'); require_once(DIR_WS_INCLUDES . 'filenames.php'); require_once(DIR_WS_INCLUDES . 'database_tables.php'); require_once(DIR_WS_FUNCTIONS . 'database.php'); and include SEO URLs like .. if ( file_exists(DIR_WS_CLASSES . 'seo.class.php') ){ include_once(DIR_WS_CLASSES . 'seo.class.php'); $seo_urls = new SEO_URL($languages_id); } require_once(DIR_WS_FUNCTIONS . 'html_output.php'); You can then use the tep_href functions to create good urls Hi Robert, Thanks for your input. Yes, this contribution is always open to new improvements. It uses HTTP_SERVER for creating the URLs and the script starts by: include('includes/application_top.php'); Even if it might not be coded optimally, it is still working in a satisfactory way for most of us. I have looked at a few other Google Base/Froogle/other feeds and they were almost all built on the same "frame". So if your URLs are generated with https, then I suppose that it is because you have changed your HTTP_SERVER from http://... to https://... in your configure.php? I unfortunately also do not have so much time for trying out the modification you suggested, but I'll remember it in case I happen to have more in the future! :) I am not using SEO urls myself, so I cannot try out with these, but it would also be a good idea, indeed. Regards, -Ben Martin Quote Link to comment Share on other sites More sharing options...
benspun Posted May 29, 2007 Share Posted May 29, 2007 hi Martin sorry for late reply.HAd alok at the other file and this is what i found link title description expiration_date label price image_link id instock shipping brand quantity payment_accepted payment_notes product_type currency language ship_to condition location http://www.xxxxx.co.uk/product_info.php?la...p;products_id=1 Toshiba PX1176U-2NAC 2007-06-03 Toshiba PX1176U-2NAC,PX1176U-2NAC,Toshiba 3.55 http://www.xxxx.co.uk/images/m_images/prod...mages/sorry.jpg 1uk Y US:Ground:2.05,CA:Ground:2.05,UK:Ground:1.70,DE:Ground:0,AT:Ground:1.70,IE:Groun d:1.70,CH:Ground:1.70,DK:Ground:1.70,PL:Ground:1.70,FR:Ground:1.70 Toshiba 1 Visa,MasterCard,AmericanExpress,Discover,check,WireTransfer,PayPal We also accept payments by PayPal and by Bank Transfer. Keyboards and mice GBP en ALL new Address of the items's location here http://www.xxxxx.co.uk/product_info.php?la...p;products_id=2 Toshiba PX1253E-1DAC Multimedia Keyboard UK English - black Multimedia Keyboard UK English - black Suitable for all Toshiba notebooks 2007-06-03 Toshiba PX1253E-1DAC Multimedia Keyboard UK English - black,PX1253E-1DAC,Toshiba 11.96 http://www.xxxxx.co.uk/images/m_images/pro...mages/sorry.jpg 2uk Y US:Ground:2.05,CA:Ground:2.05,UK:Ground:1.70,DE:Ground:0,AT:Ground:1.70,IE:Groun d:1.70,CH:Ground:1.70,DK:Ground:1.70,PL:Ground:1.70,FR:Ground:1.70 Toshiba 54 Visa,MasterCard,AmericanExpress,Discover,check,WireTransfer,PayPal We also accept payments by PayPal and by Bank Transfer. Keyboards and mice GBP en ALL new Address of the items's location here under location it has ur address here..Is that right Many thanks Hi Nafri, Yes, you got it, the error is related to the field "location", which is currently "Address of the items's location here" and Google is expecting an address and can't recognize this one! That's my mistake, I forgot to update the installation instruction to tell people to modify this according to their own address. So, in the file /catalog/admin/froogle_us.php froogle_uk.php and froogle_de.php edit line 94: $default_location = "Address of the items's location here"; // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma. and put the adresse of your items. Or disable the "location" field by changing line 93 to: $location = 0; And it will work fine for your. Regards, -Ben Martin Quote Link to comment Share on other sites More sharing options...
benspun Posted May 29, 2007 Share Posted May 29, 2007 If Google is giving you a "We did not understand this location." error, here is the solution: In the file /catalog/admin/froogle_us.php froogle_uk.php and froogle_de.php , edit line 94: $default_location = "Address of the items's location here"; // Addresses should be formatted as: street, city, state, postal code, country. Each location element should be separated by a comma. and replace "Address of the items's location here" by the adress where your items are located (keep the quotes " " there). Or you can disable the field "location" by changing the line 93 to: $location = 0; That field was enabled by default in the last release and I forget to update the installation instructions, that's my mistake. -Ben Martin Quote Link to comment Share on other sites More sharing options...
showery Posted May 29, 2007 Share Posted May 29, 2007 The contrib is working perfectly for me at this point, third upload to froogle with no errors...I am now looking to cron this so I dont have do do it with each date. Quote Link to comment Share on other sites More sharing options...
ikishk Posted June 15, 2007 Share Posted June 15, 2007 uncategorized products are not showing up in the feeds. I admin a store which only has one type of product and categories would be a pain. Any ideas on how to update the code to see uncatagorized products? I looked at the sql which seems to be based on the categories table, so i'm not sure what to tinker with without breaking everything. Quote Link to comment Share on other sites More sharing options...
eliteinkandtoner Posted July 2, 2007 Share Posted July 2, 2007 I keep getting the following message when i try to run froogle_us.php File completed: froogle_us_file.txtFTP connection has failed! Attempted to connect to uploads.google.com for user ... Script timer: 17.876165 seconds. Any suggestions on this problem. Everything seem to install fine but it just gives this message. Also has anyone noticed that. Thanks sooo much for your help Quote Link to comment Share on other sites More sharing options...
zeeshop Posted July 11, 2007 Share Posted July 11, 2007 Hi every one, I was using Google Base / Froogle Data Feeder v1.20 for a while now, , i was updating google feed every 2nd or 3rd day using ftp service(Part of this contributionl. But from last couples of days Google base started giving me error that there are too many formating error in my file. and ten no item is live any more. What I did now I made a backup of system and Installed Automated Store Feeds v3.3a. http://www.oscommerce.com/community/contributions,4455 Now after following instructions When I upload feed, I am getting almost error below. " : SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.zeeshop.co.uk/product_info.php?language=en¤cy=GBP&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_or description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.zeeshop.co.uk/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' AND products_description.language_id = '1' AND products_description.language_id = '1' AND categories_description.language_id = '1' ORDER BY products.products_id ASC " Please help me, because i had a major update in stock and need to upload in many different shopping search engines. Also What experienced User suggestes, Should I continue to use Froogle Data Feeder v1.20 or udate to Automated Store Feeds v3.3a is right decision. Please help me sorting this error out for me. Thansk and regards. zee Quote Link to comment Share on other sites More sharing options...
Silverado05 Posted July 17, 2007 Share Posted July 17, 2007 I just have a small issue with the BizRate feed. I have connected and everything is working good but some of my products the description is over 1000 characters. So is their a way to limit it to only 1000 characters or does this have to be done manually? Is their an easy way for this? -Thanks Quote Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works. Link to comment Share on other sites More sharing options...
Silverado05 Posted July 28, 2007 Share Posted July 28, 2007 Anyone have a solution for this or some quick idea to fix this? -Thanks Quote Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works. Link to comment Share on other sites More sharing options...
benspun Posted August 5, 2007 Share Posted August 5, 2007 I keep getting the following message when i try to run froogle_us.phpAny suggestions on this problem. Everything seem to install fine but it just gives this message. Also has anyone noticed that. Thanks sooo much for your help Hi Jonathan, You need to configure the "Froogle FTP username" in the configuration section of your store, under "Feed Settings". Regards, -Ben Martin Quote Link to comment Share on other sites More sharing options...
benspun Posted August 5, 2007 Share Posted August 5, 2007 Hi every one, I was using Google Base / Froogle Data Feeder v1.20 for a while now, , i was updating google feed every 2nd or 3rd day using ftp service(Part of this contributionl. But from last couples of days Google base started giving me error that there are too many formating error in my file. and ten no item is live any more. What I did now I made a backup of system and Installed Automated Store Feeds v3.3a. http://www.oscommerce.com/community/contributions,4455 Now after following instructions When I upload feed, I am getting almost error below. " : SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.zeeshop.co.uk/product_info.php?language=en¤cy=GBP&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_or description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.zeeshop.co.uk/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' AND products_description.language_id = '1' AND products_description.language_id = '1' AND categories_description.language_id = '1' ORDER BY products.products_id ASC " Please help me, because i had a major update in stock and need to upload in many different shopping search engines. Also What experienced User suggestes, Should I continue to use Froogle Data Feeder v1.20 or udate to Automated Store Feeds v3.3a is right decision. Please help me sorting this error out for me. Thansk and regards. zee Hi zee, It seems that you don't have the column "products.manufacturers_id" in your database. I'd suggest looking at your database (with phpMyAdmin or similar). Perhaps some other contribution(s) have modified it's name, I'm not sure... (If that's the case, then replace "products.manufacturers_id" (without the quotes " " ) by the name of your column in the code and it should fix it.) Hope this can help. Regards, -Ben Quote Link to comment Share on other sites More sharing options...
benspun Posted August 5, 2007 Share Posted August 5, 2007 I just have a small issue with the BizRate feed. I have connected and everything is working good but some of my products the description is over 1000 characters. So is their a way to limit it to only 1000 characters or does this have to be done manually? Is their an easy way for this? -Thanks Hi Nick, There surely is a way to do that, but I don't know right now, I'd have to search for it. You could use "sprintf" in the php code to take that long description and cut it to 1000 characters. Search for "php sprintf" in Google and you'll find the manual for it, to know how to use it. Hope this can help as well. Regards, -Ben Quote Link to comment Share on other sites More sharing options...
Silverado05 Posted August 8, 2007 Share Posted August 8, 2007 Ok thanks for the tip. What file do I need to edit to add this code? -Thanks Quote Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works. Link to comment Share on other sites More sharing options...
nafri Posted August 9, 2007 Share Posted August 9, 2007 Hi.. i am getting this message from google.once i upload my feed. This attribute has been deprecated. - help label 1 This attribute has been deprecated. - help shipping 1 Looking at the previous post i know the deprecated attribute is something froogle doesnt use. how do i fix this error. many thanks Quote Link to comment Share on other sites More sharing options...
benspun Posted August 9, 2007 Share Posted August 9, 2007 Ok thanks for the tip. What file do I need to edit to add this code? -Thanks Hi Nick, There is only 1 file for the BizRate feed, and it is /catalog/admin/bizrate.php When you'll have found your solution, please post it here, it might help others as well. Regards, -Ben Quote Link to comment Share on other sites More sharing options...
benspun Posted August 9, 2007 Share Posted August 9, 2007 Hi.. i am getting this message from google.once i upload my feed. This attribute has been deprecated. - help label 1 This attribute has been deprecated. - help shipping 1 Looking at the previous post i know the deprecated attribute is something froogle doesnt use. how do i fix this error. many thanks Hi naf, That just says that Google Base stopped taking this attribute into consideration. But your feed should still be accepted. If you want to disable these attributes, simply disable these attributes in the files /catalog/admin/froogle_us.php , froogle_uk.php and/or froogle_de.php, by changing the "1" to a "0" at the top of these files. Regards, -Ben Quote Link to comment Share on other sites More sharing options...
nafri Posted August 13, 2007 Share Posted August 13, 2007 hi the froogle feed is being accpeted by goodle ok now . i get the success message when i check the status. The problem i am having now is that none of the out stock products are showing under products in google.When i look at the froogle feed the products are there.Google only seems to include the products that are in stock. I have looked at the same item from another shop which is showing up and on there site it shows item is not in stock.So how come there is showing and mine isn't. If i browse by shop for the same item then i can see my item which is no good, as ppl dont search by shop but by model number. I hope it makes sense.. thanks in advance nafri Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.