wizardsandwars Posted January 1, 2003 Posted January 1, 2003 If anyone is interested, you can get it in pdf format here http://www.wizardsandwars.com/google_feed_dec02.pdf ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
beckysmith Posted January 1, 2003 Posted January 1, 2003 Thanks for sharing... has anyone worked out a way to easily automate this for Oscommerce users?
wizardsandwars Posted January 1, 2003 Author Posted January 1, 2003 Well, I'm think that I am among the first to receive these requirements, so I doubt if anyone has started on an autoated script yet. I've started writing an SQL statement that will provide the desired results, however, I'm not familiar enough with PHP and MySQL to provide a script to automate the construction of a tab delimited file containing the results. The rest of it, I could probably handle. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
Mark Russell Posted January 2, 2003 Posted January 2, 2003 Anyone have any ideas on how to handle the "category" field in the basic file format. Mark
wizardsandwars Posted January 2, 2003 Author Posted January 2, 2003 Why not just pull the "categories_name" from the "categories_description" table? That's what I was planning to do. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
dreamscape Posted January 2, 2003 Posted January 2, 2003 have you checked out EasyPopulate??? it exports the catalog in tab deliminted format... It shouldn't be too hard to modify it into a "froogle" export of the catalog. The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke
Mark Russell Posted January 2, 2003 Posted January 2, 2003 That will get you the lowest level category, but not the category trail that I believe they are looking for (e.g. Home & Garden > Kitchen > Appliances) M
wizardsandwars Posted January 2, 2003 Author Posted January 2, 2003 It looks like the 'parent_id" column in the 'categories' table identifies the 'category_id' of a parent category. Although mlti tiered categories may be more tedious to code, it looks like there is a way to get the data we need with just a select statement. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
Mark Russell Posted January 2, 2003 Posted January 2, 2003 I agree, though I'm really concerned with providing the correct file the first time because of their slow response. If I click through my category structure to a product page I end up with this URL: http://www.mysite.com/product_info.php?cPa...products_id=160 . '22' is the category_id for Tights. '260' is a subcategory Size 4-6. '160' is the product id for Ivory Lace Toddler Girls Tights. So in this example, I think Froogle is looking for 'Tights > Size 4-6' in the category field in the row for this specific product. Agree? M
wizardsandwars Posted January 2, 2003 Author Posted January 2, 2003 Yes, I would agree that this is probably what they are looking for. I have similar category structure, and I had assumed that this is what they wanted. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.
dreamscape Posted January 2, 2003 Posted January 2, 2003 to get the category field that froogle wants, you could use the built in tep get Cpath function to get the category path of the product and then explode the returned result at "_", get the category names for each cat number in the cPath, create an array, and add in the ">" between the returned array results... not very pretty but it works, I think. The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke
wasson65 Posted January 3, 2003 Posted January 3, 2003 Hi all, Tim here: I'm currently developing a "Froogle" download link for EasyPopulate. Ted Joffs is sponsoring this development - Thanks Ted! Expect a release in about 2 days! Tim
VyReN Posted January 4, 2003 Posted January 4, 2003 I'm currently developing a "Froogle" download link for EasyPopulate. Ted Joffs is sponsoring this development - Thanks Ted! Expect a release in about 2 days! SWEET :!: :!: :!:
wasson65 Posted January 8, 2003 Posted January 8, 2003 Hi all, Tim here: I'm currently developing a "Froogle" download link for EasyPopulate. Ted Joffs is sponsoring this development - Thanks Ted! Expect a release in about 2 days! Tim OK, so I lied, it was 4 days instead of 2. -- Tim whips self with wet noodle -- But it's for real, and you can get your own taste of Froogly goodness with EP2.4 at: http://www.oscommerce.com/community/contributions,500 Enjoy, and thanks again to Ted Joffs for sponsoring this work. Tim
VyReN Posted January 8, 2003 Posted January 8, 2003 ROCK ON! Installed on a September snapshot, worked AWESOME! Everything seems to be in order -- file has been sent to Froogle! T H A N K Y O U ! !
networkdad Posted January 8, 2003 Posted January 8, 2003 <---------Awaiting patiently for my froogle ftp login. Oh well, gives me time to spruce up my tab delim file ready to go...!
wvmlt Posted January 8, 2003 Posted January 8, 2003 I sent my feed to froogle about 5 days ago. I'm still waiting for their confirmation to let me know if the file I sent was okay. Keith What the hell was I thinkin'?
VyReN Posted January 8, 2003 Posted January 8, 2003 I sent my feed to froogle about 5 days ago. I'm still waiting for their confirmation to let me know if the file I sent was okay. I think they are just really overloaded with the responce to Froogle.
wvmlt Posted January 8, 2003 Posted January 8, 2003 Yeah, Google requests you send an email after first feed then you get an autoresponse telling you it may take 10 days or so to get back with you. I just took a few items and made a test feed to see if it worked. When they get back with me, I'll do a complete feed. Should be much easier with the new and improved EP. Keith What the hell was I thinkin'?
wasson65 Posted January 8, 2003 Posted January 8, 2003 Hi all, Tim here: I'm currently developing a "Froogle" download link for EasyPopulate. Ted Joffs is sponsoring this development - Thanks Ted! Expect a release in about 2 days! Tim OK, so I lied, it was 4 days instead of 2. -- Tim whips self with wet noodle -- But it's for real, and you can get your own taste of Froogly goodness with EP2.4 at: http://www.oscommerce.com/community/contributions,500 Enjoy, and thanks again to Ted Joffs for sponsoring this work. Tim Some bugs were found in the 2.4 Froogle download. It's very likely that any Froogle uploads done with 2.4 will not work. I've got a bugfix release available here, but I'm calling it a beta until it gets settled down a bit: http://www.wassons.org/EasyPopulate_v2.41beta2.zip As I learn more and go from beta to release, I'll keep this thread updated. Tim
wvmlt Posted January 10, 2003 Posted January 10, 2003 Tim- I'm having trouble getting the V2.41 fix. The link isn't working for me. Keith What the hell was I thinkin'?
wasson65 Posted January 10, 2003 Posted January 10, 2003 Tim- I'm having trouble getting the V2.41 fix. The link isn't working for me. I've put the latest betas in the contrib section under Features ->EasyPopulate You can get it there. Tim
jeana Posted July 29, 2003 Posted July 29, 2003 I just signed up for my account today and the response was surprisingly fast - I got the instructions pdf and login/password within like an hour! Problem is, I keep getting a 530 login failed when I try to login to ftp my file. Im wondering if they just haven't activated my account on the ftp server yet and it will work maybe tomorrow? Has anyone else experienced this? I even submitted two different requests (for two different clients), got both user info, but neither one will login to the FTP...someone please enlighten me?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.