Magnus Posted May 16, 2003 Posted May 16, 2003 Hi Can someone please help me with excel import 1.51 Ok I have a category - Hardware - 1 and a sub category - products - 2 I got those numbers from the view root and category in the upload section. Now I installed it but when I go to upload just the example form.csv This is what it tells me: File uploaded. Temporary filename: /tmp/phpSfsW0Z User filename: Form.csv Size: 344 | unavailabl | | | | | | | | | | | | No products_model field in record or incorrect root for category. I cannot import this record! Thats all! And as usual, no products go in the products list. I used all the default info in the form.csv and only modified root to 1 and category to 2 So what the hell am I doing wrong?
Guest Posted May 16, 2003 Posted May 16, 2003 So what the hell am I doing wrong? As far as I am concerned.... its known as crossposting.... what makes you think you are so important??
Guest Posted May 16, 2003 Posted May 16, 2003 To me it appears to tell you exactly what the problem is.... No products_model field in record or incorrect root for category Perhaps the contribution is not quite compatible with the version of osC you are running?.... this commonly happens.
Magnus Posted May 16, 2003 Author Posted May 16, 2003 I'm using ms 2.2 ms1 Will it work with that? And do I have to go php database and make that category then?
Guest Posted May 16, 2003 Posted May 16, 2003 Its a bit old... pre MS1.... looking at the contributions you would be better off with Easypopulate... its based on Excel Upload 1.51 http://www.oscommerce.com/community/contributions,500
Magnus Posted May 16, 2003 Author Posted May 16, 2003 Yup OK i got it and I managed to get it to upload one product but I noticed the v_product ids and so on went across. Like v_name1 bla bla bla v_name 2 So does this mean i have to insert them going across? or can I have them going down horizontally like so product name price etc. product2name price etc So um yea can I? and uh I have like a whole excel list of files like below from when I used a different program which I believe was very near to what you guys have it was by Ben Halsted at webmediagroup I believe. Anyway I have the coding from my excel file when I used his program and it goes like below: product cde Description Price Manufacturer Category 831963M IBM Netvista 2170.8 IBM Computer Systems So um is there any fast way I can convert them into the format easy populate uses?
Magnus Posted May 16, 2003 Author Posted May 16, 2003 quick nother questoin Wiht easy populate csv files Does the php look in the file for the headers like v_product name or does it look for the cell number? Coz I wanna remove some cells with info I dont need. So can i?
Guest Posted May 16, 2003 Posted May 16, 2003 There are quite a number of threads on easypopulate..... perhaps you can look through them... or somebody else can answer.. I have never used these contribs.... or you can look at the *code* to see what it is doing.... :shock:
Guest Posted May 16, 2003 Posted May 16, 2003 I meant search these forums.... there is a link at the top of the page
wasson65 Posted May 18, 2003 Posted May 18, 2003 Yup OK i got it and I managed to get it to upload one product but I noticed the v_product ids and so on went across. Like v_name1 bla bla bla v_name 2 So does this mean i have to insert them going across? or can I have them going down horizontally like so product name price etc. product2name price etc So um yea can I? and uh I have like a whole excel list of files like below from when I used a different program which I believe was very near to what you guys have it was by Ben Halsted at webmediagroup I believe. Anyway I have the coding from my excel file when I used his program and it goes like below: product cde Description Price Manufacturer Category 831963M IBM Netvista 2170.8 IBM Computer Systems So um is there any fast way I can convert them into the format easy populate uses? The short answer to your question, um, is yes, list each product on it's own row. Easypopulate is going to require that the products_model be used, so it can tell what products are new and which ones are updated of existing products. There's a fairly good size doc with the EP contrib (I know, 'cause I wrote it...), that describes how to go about getting started with EP. Start there, read the troubleshooting tips, and then search the forums. It's probably been hashed through before. Good luck with your store, Tim (EP author)
Magnus Posted May 18, 2003 Author Posted May 18, 2003 Thanks. yea read the readme um could you give me like an example set of fields for the info I listed? Was my example ok? do i just need that eorer on the end?
wasson65 Posted May 18, 2003 Posted May 18, 2003 Thanks. yea read the readme um could you give me like an example set of fields for the info I listed? Was my example ok? do i just need that eorer on the end? About page 8 or so in the docs it gives a rundown of all the field names, what they do, and yes, the EOREOR field is required. You need to put a couple products into the store the way you want them, then download, and look at the fields. That should make the requirements clear.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.