Pepper Posted October 15, 2002 Share Posted October 15, 2002 Hi, Ive got a serious problem. I need to a 700 products to oscommerce. I have the products in EXCEL 2 coloms........ This is what its look like 700 times in Excel. --> Article name | Price Article name | Price Article name | Price Article name | Price --> Is there a fast way to put this into the database... I dont know how to write a script so it will be putted automatically in my database....i have talked to people if it was possible to write a script for it but it takes very much time he sad.. Maybe there already is a script so that people with excel can add all these products????????? Can someone plz help me!!!! Tnx! And regards from Holland! :) Link to comment Share on other sites More sharing options...
Guest Posted October 15, 2002 Share Posted October 15, 2002 Hi,Ive got a serious problem. I need to a 700 products to oscommerce. I have the products in EXCEL Pepper, I have written something to do a *very* basic import of this type. It can be found at: http://www.oscommerce.com/downloads.php/co...ions,574/type,3 It is a bit of a foreshadow of my contrib that will be released in about a month that will allow other carts to convert to osCommerce :) Link to comment Share on other sites More sharing options...
Guest Posted October 15, 2002 Share Posted October 15, 2002 d'oh. forgot the instructions. Drop the 'import.php' file into the top level of the 'admin' folder. go to: http://www.yourserver.net/path-to-admin/import.php and locate the file you want to import via the selector. Sample files have been provided. leave them in the layout that is shown, otherwise it will break. change the products at your will :) any problems, email me or put it on the forums. Link to comment Share on other sites More sharing options...
Pepper Posted October 15, 2002 Author Share Posted October 15, 2002 Tnx! Ill check it out If i have problems, ill pm u ":) Link to comment Share on other sites More sharing options...
dynamok Posted October 15, 2002 Share Posted October 15, 2002 I have a programer that is working on a new contribution for importing the products. It will automatically put the products into categories and subcategories. I'll post it as soon as he's done. Link to comment Share on other sites More sharing options...
Pepper Posted October 16, 2002 Author Share Posted October 16, 2002 cool, Is it gonna take long? Just asking.......:) ill wait :):) Link to comment Share on other sites More sharing options...
dynamok Posted October 16, 2002 Share Posted October 16, 2002 About a week, I'll post as soon as it's done. Link to comment Share on other sites More sharing options...
Guest Posted October 16, 2002 Share Posted October 16, 2002 i just finished adding 1600+ products...what a chore that was..... Link to comment Share on other sites More sharing options...
dynamok Posted October 16, 2002 Share Posted October 16, 2002 That's crazy 1600!!!!!!! I thought my 1000 was too many and I didn't want to do it by hand. Did you do it all by hand? I'm suprised there is already not an easy way to do this. Link to comment Share on other sites More sharing options...
Guest Posted October 16, 2002 Share Posted October 16, 2002 yeah, its started out as pure hell, but my friend and I came up with a temporary solution just to get the basic products in there (product name, number, desc, price) I have NO access to phpmyadmin at all so we found a cgi version of it (kinda limited but helped) at http://www.gossamer-threads.com/scripts/my...qlman/index.htm but after we did an import I had to manually change every single product to their proper category and mod some other stuff as well, if wasn't fun at all. There were some other knots along the way and I became a data enty goon for a week or so - heh http://www.ebuywarehouse.com is the result so far my thanks to my buddy b3rt Link to comment Share on other sites More sharing options...
CC Posted October 16, 2002 Share Posted October 16, 2002 Yo Wills! Hoping you can help me mate... When I use your mod I get the following errors when I try to add the file.csv file you provided in the package... What seems to be the problem? Warning: open_basedir restriction in effect. File is in wrong directory in /usr/local/psa/home/vhosts/casetech.co.uk/httpdocs/admin/import.php on line 37 Warning: Unable to access /usr/local/psa/home/vhosts/casetech.co.uk/httpdocs/images/file.csv in /usr/local/psa/home/vhosts/casetech.co.uk/httpdocs/admin/import.php on line 45 Warning: fopen("/usr/local/psa/home/vhosts/casetech.co.uk/httpdocs/images/file.csv", "r") - No such file or directory in /usr/local/psa/home/vhosts/casetech.co.uk/httpdocs/admin/import.php on line 45 Warning: Supplied argument is not a valid File-Handle resource in /usr/local/psa/home/vhosts/casetech.co.uk/httpdocs/admin/import.php on line 46 Warning: Supplied argument is not a valid File-Handle resource in /usr/local/psa/home/vhosts/casetech.co.uk/httpdocs/admin/import.php on line 48 Warning: Supplied argument is not a valid File-Handle resource in /usr/local/psa/home/vhosts/casetech.co.uk/httpdocs/admin/import.php on line 91 Cheers dude. CC Link to comment Share on other sites More sharing options...
CC Posted October 18, 2002 Share Posted October 18, 2002 Ok, maybe pointing this directly to Will was a bad idea... If anyone else can point me in the right direction on how to make this work I would very much appreciate it. I have to input 1000's of products ASAP. Cheers guys. CC. Link to comment Share on other sites More sharing options...
Pepper Posted October 18, 2002 Author Share Posted October 18, 2002 Give the url of ur site Link to comment Share on other sites More sharing options...
Pepper Posted October 18, 2002 Author Share Posted October 18, 2002 Give the url of ur site Link to comment Share on other sites More sharing options...
CC Posted October 18, 2002 Share Posted October 18, 2002 What good will that do? It runs via admin... CC. Besides if you read through this post, it dont take amstermind to find it. But I am not publishing it freely as yet... And I dont see why you would need it anyway. Link to comment Share on other sites More sharing options...
Pepper Posted October 18, 2002 Author Share Posted October 18, 2002 oke good luck.. Link to comment Share on other sites More sharing options...
CC Posted October 18, 2002 Share Posted October 18, 2002 pfff... :roll: CC. Link to comment Share on other sites More sharing options...
Guest Posted October 22, 2002 Share Posted October 22, 2002 UPDATE: This problem was resolved via email. Due to the fact that I code in a non-restricted environment I was unaware of the fact that open-basedir was going to be a problem. Hopefully in my future releases there won't be these problems - I am setting my environment up to use open-basedir. For those interested in a fix: Replace line 37, currently: copy($csv_to_import, $csv_file_location); With this: move_uploaded_file($csv_to_import, $csv_file_location); And the open-basedir problems should be resolved. The other problem that may be encountered is that the catalog/images directory is not writable by the web-server process. Whilst this script does not import images at this time, the catalog/images directory is used as a temporary holding point for the uploaded file. Sorry about not replying earlier on the forums -- I am currently undertaking the HSC and as such only barely get time to skim the mirror on the news-servers. Any more queries, feel free to email me. Link to comment Share on other sites More sharing options...
dynamok Posted October 22, 2002 Share Posted October 22, 2002 The mod is almost done:) I will be testing it for the next couple of days. But it looks good. Basically what it does: It will be a part of Admin: <img border="0" src="http://www.ukrainianshop.net/admin.gif" width="599" height="345"></p> You see the Excel import on the right in Tools. Each category will be assigned a number, like here: <img border="0" src="http://www.ukrainianshop.net/categories.gif" width="599" height="345"></p> Each time you add a category it will be assigned a new number. The products will need to be placed in such way: <img border="0" src="http://www.ukrainianshop.net/catalog.gif" width="599" height="345"></p> You hit the upload button and that's it:) Let me know if I should have something added to it, or change something. Link to comment Share on other sites More sharing options...
Guest Posted October 22, 2002 Share Posted October 22, 2002 sounds awesome, will it be hard to modify a bit? I am using the "2 image" addon (one big one small product image) so I'll nee dto add another column in your import.. very cool though, thanks for the effort I know I'll be using it. Link to comment Share on other sites More sharing options...
Pepper Posted October 24, 2002 Author Share Posted October 24, 2002 oke, ill wait :) Link to comment Share on other sites More sharing options...
dynamok Posted October 25, 2002 Share Posted October 25, 2002 We're very close to finishing the module! So this is what you could add before: image model category code Product name 1 Product Description 1 Product name 2 Product Description 2 Price Latest additions: Weight Quantity Date available Have a question about the Tax Class, don't use it myself. I think it would be easier to do this if say you have: Tax Class 1 Tax Class 2 not like in the demo Taxable Goods What do you guys think? Would be easy to go to the admin and just change your tax class to 1 or 2 or what ever? We also added new feature to how the categories are assign. For example if I have: a category Mice and a subcategory Wireless a category Keyboards and a subcategory Wireless how do you distinguish between? Look here: this is the old way www.ukrainianshop.net/categories.gif this is the new way www.ukrainianshop.net/categories1.gif in the new the subcategory is underneeth the category. We also decided to move the import feature to the Catalog category, we think it's easier then having it in Tools:) Any other requests, coments? Link to comment Share on other sites More sharing options...
dcacique Posted October 25, 2002 Share Posted October 25, 2002 I am so happy you guys have been working on this, I've been trying to firgure out how to do this. I finally got my site up and running yesterday and was looking arround at how to import db. I can't believe it was manual before.. Really great job guys. thanks for all you're hard work. Cheers Link to comment Share on other sites More sharing options...
Pepper Posted October 27, 2002 Author Share Posted October 27, 2002 What do you guys think? Would be easy to go to the admin and just change your tax class to 1 or 2 or what ever? REPLY: yup, just let us enter a number, 1 or 2 :) its fine! Link to comment Share on other sites More sharing options...
Guest Posted October 28, 2002 Share Posted October 28, 2002 HAs this excel import module been finished yet or are you still working on it? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.