mystic_master Posted February 1, 2009 Share Posted February 1, 2009 I have a large Store With 6,000 items, all databased in excell, and I tried importing as a csv. I just need someone to add the needed fields and import the products. I"d be glad to pay 80.00 USD VIA paypal for this. I have tried exporting them, and I have the separators correct, but there field types I need to add ,and cant find out how. we sell books, so I need to add page numbers and one of the field types. Thanks. Doug Hieatzman[email protected] Link to comment Share on other sites More sharing options...
tintacreative Posted February 1, 2009 Share Posted February 1, 2009 I'm afraid i cannot help, but i do have proposal to the PrestaTeam or anybody expert into this.Is it possible for you guys to upload somewhere, the default .CSV files for every entity contains in the import section.I believe, if you did that, you can reduce a lot of storage containing questions about CSV.I really hope you guys can come out with this.Thanks in advance. Link to comment Share on other sites More sharing options...
jhnstcks Posted February 1, 2009 Share Posted February 1, 2009 we sell books, so I need to add page numbers and one of the field types You want a new field added to your product page showing how many pages there is in the book? If this is what you want it isnt possible without some changes to the importing code. The easiest work around I can think of is to use the referance field for your pages and alter the front end wording to say pages instead of referance.I have uploaded a working product csv file with all the column titles, apart from one that I cannot get to work correctly, but isnt really needed, i know it worksThe major problem i have encountered with large csv files is that the server usually times out before everything gets imported, so you could try and separate your products into multipule files.test_item_csv.csv Link to comment Share on other sites More sharing options...
tintacreative Posted February 1, 2009 Share Posted February 1, 2009 hi jhnstcks, is this for v1.1? do we have to arrange it accordingly or that wont be a problem? Link to comment Share on other sites More sharing options...
jhnstcks Posted February 1, 2009 Share Posted February 1, 2009 This is for v1.1 yes, import for v1 doesnt work anything like v1.1You can set your field out however you want, as you can select the column headings on the import page, if you dont want to use certain columns because you have no data in them you can select "ignore this column" as is shown in the image below Link to comment Share on other sites More sharing options...
jhnstcks Posted February 1, 2009 Share Posted February 1, 2009 One other thing, after you upload the file you need to change the column separator to a comma, as is shown in the image below. Link to comment Share on other sites More sharing options...
tintacreative Posted February 1, 2009 Share Posted February 1, 2009 i still dont understand how to use this.How did you got the ps to show as your attachment.steps i use is1. Upload Section - i browse your test_item_csv.csv - click upload2. Importation Section - Select which entity to import : Products - Select your .csv files : i choose the file i just upload. - others at default.3. Click Next step4. and all i got is this. Link to comment Share on other sites More sharing options...
jhnstcks Posted February 1, 2009 Share Posted February 1, 2009 See my post above about the column separators. Link to comment Share on other sites More sharing options...
tintacreative Posted February 1, 2009 Share Posted February 1, 2009 i change the separator to a comma, as per attachment, is that correct?Sorry for giving u much trouble.it still give the same result Link to comment Share on other sites More sharing options...
jhnstcks Posted February 1, 2009 Share Posted February 1, 2009 Yes, thats correct, it should work as that file works on my testshop, earlier just before I posted it. Link to comment Share on other sites More sharing options...
tintacreative Posted February 1, 2009 Share Posted February 1, 2009 that's confuse me a lot.I just figure it out, my excel is the source for the problem.I'm using office 2003, is that the cause of the problem?i'm downloading CSVed, a program dedicated to create, edit .csv file.Will update here if the files work.Thanks jhnstcks for all your help Link to comment Share on other sites More sharing options...
jhnstcks Posted February 1, 2009 Share Posted February 1, 2009 The version of excel you are using wouldnt have any affect on the import, unless you are opening the file and re-saving it for some reason, but anyway the original file was created with MS Office 2003. Link to comment Share on other sites More sharing options...
tintacreative Posted February 1, 2009 Share Posted February 1, 2009 SuccessI manage to upload it, and i do think using CSVed v1.4.8 (free software) is a better/secure way doing it, since my excel cannot assure me a success rate. LOLThanks jhnstcks.I will upload a tutorial/notes for others to read.i still have hicups here and there, i will upload details step once i got everything perfect.Give me some time. Link to comment Share on other sites More sharing options...
Guest Posted February 1, 2009 Share Posted February 1, 2009 I have a large Store With 6,000 items, all databased in excell, and I tried importing as a csv. I just need someone to add the needed fields and import the products. I"d be glad to pay 80.00 USD VIA paypal for this. I have tried exporting them, and I have the separators correct, but there field types I need to add ,and cant find out how. we sell books, so I need to add page numbers and one of the field types. Thanks. Doug Hieatzman[email protected] Send me the xcel sheet: https://my.ichidesk.com/contact.php Link to comment Share on other sites More sharing options...
tintacreative Posted February 2, 2009 Share Posted February 2, 2009 jhnstcks, i have a question that need clarifications.I did put the same text as my manufacturer.Let say i created a manufacturer within BO in the name of Malaysiaso in .csv files, under the manufacturer column I put Malaysia also, but instead of using the one i have, the imports create another manufacturer with the same name. Is there any way to prevent this?Thanks Link to comment Share on other sites More sharing options...
mystic_master Posted February 2, 2009 Author Share Posted February 2, 2009 I will upload my csv file later this evening. (when I"m not at a public computer) ! Wow thanks for the reply, you guys rock. Link to comment Share on other sites More sharing options...
mystic_master Posted February 2, 2009 Author Share Posted February 2, 2009 Here is the excel file. I'm having trouble adding (page, and authors as field types) as in each products should show the number of pages in the book, and who wrote them. I can't add these as "field types" so they show on each item. (I think I can rename the field types in the front end, or change the php so they display properly. I need help to get the items imported. THanks in advance. Doug [email protected]The csv file can be downloaded below (choose free download option 2) http://www.filefactory.com/file/a04f05a/n/web_inventory3_csvheaders from left to right areA ID Numberb Item namec Authord Publishere Year Publishedf Priceg Descriptionh Number of pagesi Binding Typej EMPTYk Catagory Link to comment Share on other sites More sharing options...
jhnstcks Posted February 2, 2009 Share Posted February 2, 2009 jhnstcks, i have a question that need clarifications.I did put the same text as my manufacturer.Let say i created a manufacturer within BO in the name of Malaysiaso in .csv files, under the manufacturer column I put Malaysia also, but instead of using the one i have, the imports create another manufacturer with the same name. Is there any way to prevent this?Thanks Use the manufacturer id instead of the name, in the same way as you use the category id Link to comment Share on other sites More sharing options...
jhnstcks Posted February 2, 2009 Share Posted February 2, 2009 Here is the excel file. I'm having trouble adding (page, and authors as field types) as in each products should show the number of pages in the book, and who wrote them. I can't add these as "field types" so they show on each item. (I think I can rename the field types in the front end, or change the php so they display properly. I need help to get the items imported. THanks in advance. Doug [email protected]The csv file can be downloaded below (choose free download option 2) http://www.filefactory.com/file/a04f05a/n/web_inventory3_csvheaders from left to right areA ID Numberb Item namec Authord Publishere Year Publishedf Priceg Descriptionh Number of pagesi Binding Typej EMPTYk Catagory Have you not got any images to add for your books? Adding 6000 images manually will take forever.You could add all your special fields as features on your books, these would appear in the datasheet section of the product page. Link to comment Share on other sites More sharing options...
mystic_master Posted February 2, 2009 Author Share Posted February 2, 2009 I think I understand, whats the difference between an attribute group, and a product feature? If I'm understanding correctly, I could have a group setup just for books, and then tag that in the csv database, and it would know that the books should have book attributes? Also, I don't know how to put image links in the database? Thanks again for your helpDoug Link to comment Share on other sites More sharing options...
jhnstcks Posted February 3, 2009 Share Posted February 3, 2009 You need to add the full image url into your csv file, and when you import the products prestashop will go and grab the image from whatever url you posted.I have tried importing features for products and can't get it to work properly, just sends back a hack attempt, apart from the binding type, all the other fields can be fitted into other prestashop fields.I'm just wondering if it would work creating an attribute for each of your special fields; pages, author, publisher etc, with only one attribute in each drop down menu, I think it might look ok.I will test it with part of your csv file. Link to comment Share on other sites More sharing options...
mystic_master Posted February 4, 2009 Author Share Posted February 4, 2009 what about using the stock items (or headers) that it lets you import, and the renaming then in the php files? Link to comment Share on other sites More sharing options...
Tito Posted February 5, 2009 Share Posted February 5, 2009 Anyone knows how the Features should be formated ?...;feature1:value1,feature2:value2;... ? Link to comment Share on other sites More sharing options...
jhnstcks Posted February 5, 2009 Share Posted February 5, 2009 I cant actaully get the features field to import correctly, just sends back a hack attempt error. Link to comment Share on other sites More sharing options...
jhnstcks Posted February 5, 2009 Share Posted February 5, 2009 mystic_master, yes you could use the other fields and just change their titles in the relevant files. Link to comment Share on other sites More sharing options...
Recommended Posts