Guest Posted January 9, 2003 Posted January 9, 2003 Hi all, The EasyPopulate with Froogle support is out, and you can get it here: http://www.oscommerce.com/community/contributions,500 Ted Joffs sponsored it, be sure to say thanks to him if you get a chance. Enjoy! Tim Thanx to Tim and all other EasyPopulate Contribution Sponsors i just download it and test with over 2000 products with out any probs. <-- the new part ( froogle ) is the next step we will to --> only a small Q. i have with a language prob.: how i greate the text file w/o the language error message because i use 3 languages and one of them is rewritten in indonesia ?
wasson65 Posted January 9, 2003 Posted January 9, 2003 Hi all, The EasyPopulate with Froogle support is out, and you can get it here: http://www.oscommerce.com/community/contributions,500 Ted Joffs sponsored it, be sure to say thanks to him if you get a chance. Enjoy! Tim Thanx to Tim and all other EasyPopulate Contribution Sponsors i just download it and test with over 2000 products with out any probs. <-- the new part ( froogle ) is the next step we will to --> only a small Q. i have with a language prob.: how i greate the text file w/o the language error message because i use 3 languages and one of them is rewritten in indonesia ? You'll want to grab the bugfix release I just put in the contributions. 2.4 has some problems with extra tabs in the Froogle output file that will prevent it from working right. As far as the language error, I need more information to help troubleshoot it. Can you describe what's happening in more detail? Tim
Guest Posted January 9, 2003 Posted January 9, 2003 Hi Tim ! thanx for the quick answer ! i use distribution 2.4 from 2003 if i go to admin/catalog/easypopulate/click for : Create Model/Category tab-delimited .txt file in temp dir and get the error : 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND language_id = '1'' at line 4 SELECT * FROM products_description WHERE products_id = AND language_id = '1' [TEP STOP] :shock: i am a newbie in php and osc and before i try to fix ( or destroy ) maybe the answer is already known. sorry for the worst english
wasson65 Posted January 9, 2003 Posted January 9, 2003 Well, you found a real bug! I'm troubleshooting now. Tim
wasson65 Posted January 9, 2003 Posted January 9, 2003 Hi Tim ! thanx for the quick answer !i use distribution 2.4 from 2003 if i go to admin/catalog/easypopulate/click for : Create Model/Category tab-delimited .txt file in temp dir and get the error : 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND language_id = '1'' at line 4 SELECT * FROM products_description WHERE products_id = AND language_id = '1' [TEP STOP] :shock: i am a newbie in php and osc and before i try to fix ( or destroy ) maybe the answer is already known. sorry for the worst english Around line 900 in easypopulate.php, find the code that looks like this: $filelayout_sql = "SELECT p.products_model as v_products_model, subc.categories_id as v_categories_id and add a line like this: $filelayout_sql = "SELECT p.products_id as v_products_id, p.products_model as v_products_model, subc.categories_id as v_categories_id That should fix things. Tim
Guest Posted January 9, 2003 Posted January 9, 2003 Tim ! what a great job ! :wink: all work fine now ! gratulations
smigo Posted January 27, 2003 Posted January 27, 2003 I try the froogle addon, but i have a problem with the product price We have prices in the database like this 59,4567 ( Price without tax, 4 decimal places ). But froogle accept only 59,45 ( two mal places ) What can i do to round the price from the database or a output with two decimal places? Aother question: We hava a few products in more than one catagory. froogle accept only one category for a poduct. Ok if i delete this its ok.......but i think there must a better way to do this. Thanks
wasson65 Posted January 27, 2003 Posted January 27, 2003 I try the froogle addon, but i have a problem with the product price We have prices in the database like this 59,4567 ( Price without tax, 4 decimal places ). But froogle accept only 59,45 ( two mal places ) What can i do to round the price from the database or a output with two decimal places? Aother question: We hava a few products in more than one catagory. froogle accept only one category for a poduct. Ok if i delete this its ok.......but i think there must a better way to do this. Thanks So you need 2 things: Froogle download should round to 2 decimal places Somehow mask items that show up more than once in the db so they don't show up in a froogle download. The first is quite simple, the second is more work. I'll try to work the first on into the next release - it's in beta now. Tim
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.