graisbeck Posted September 29, 2014 Share Posted September 29, 2014 Hi, My supplier has sent me a csv example of their products to import into my Prestashop 1.6, but I'm unsure as to what I'm meant to do with it. Can someone please point me in the right direction? CSV File Thanks for any help given! Link to comment Share on other sites More sharing options...
graisbeck Posted September 30, 2014 Author Share Posted September 30, 2014 Why is it so difficult to import products into Prestashop? This is so frustrating! even the guide in the documentation is not straight forward for someone who is new to Prestashop. Link to comment Share on other sites More sharing options...
rvzoest Posted September 30, 2014 Share Posted September 30, 2014 (edited) Totally understandable, I had the same problem as well. Just try it with 1 product, soon you find uout which is what. Then use that format to convert it to PS. The CSV provided is a categories csv, you don't have an product list? Edited September 30, 2014 by rvzoest (see edit history) Link to comment Share on other sites More sharing options...
graisbeck Posted September 30, 2014 Author Share Posted September 30, 2014 Hi, The CSV has a product tab along the bottom. I did ask my supplier to email me with a sample CSV and that is what they sent. Link to comment Share on other sites More sharing options...
graisbeck Posted September 30, 2014 Author Share Posted September 30, 2014 (edited) Ok, I have created a new CSV using every field listed of the available product fields. When I upload the CSV (which contains 1 product) and click "next step", I then get the "View Your Data" page and the message: "Please match each column of your source CSV file to one of the destination columns." Has something gone wrong, or do I have to do this every time I import a CSV? Edit: After typing in all matching fields I got this error: 2 errors No Name (ID: No ID) cannot be saved Property Product->name is empty Rewrite link for (ID: null) was re-written as friendly-url-autogeneration-failed. Edited September 30, 2014 by graisbeck (see edit history) Link to comment Share on other sites More sharing options...
rvzoest Posted September 30, 2014 Share Posted September 30, 2014 Ok, I have created a new CSV using every field listed of the available product fields. When I upload the CSV (which contains 1 product) and click "next step", I then get the "View Your Data" page and the message: "Please match each column of your source CSV file to one of the destination columns." Has something gone wrong, or do I have to do this every time I import a CSV? Edit: After typing in all matching fields I got this error: 2 errors No Name (ID: No ID) cannot be saved Property Product->name is empty Rewrite link for (ID: null) was re-written as friendly-url-autogeneration-failed. The first error is the most important. It seems you didn't use the name column which is required. Thats the name of your product. The second isn't big of a deal I get that all the time. Link to comment Share on other sites More sharing options...
graisbeck Posted September 30, 2014 Author Share Posted September 30, 2014 I've now got these errors: 2 errors 1. No Name (ID: 1124,1,Black Fashion bag,Handbags,,,7,0,,,,,,,,,,,,,,,0.9,20,1,Everywhere,,1,14.99,sdfsdf sdf sdf fd sf df dsf sdf,re rwer r ef ee wf ef sef sefse fsef sefs efs ef sef sef se efsef sefjsklefjs efsfj sef sjfskl ejf sef sf s,,,,,,,,1,,,1,http://bagsnbracelets.co.uk/images/uploads/HB00105-BRN.jpg,0,,0,New,0,0,0,Default: De ny orders,,,,) cannot be saved 2. Property Product->name is empty I have the product name as you can see, yet I'm still getting No Name errors, Please help!! Link to comment Share on other sites More sharing options...
graisbeck Posted September 30, 2014 Author Share Posted September 30, 2014 (edited) Ok, now I've sorted the errors and received the import successful message, but the product is not showing anywhere! Also, does the Categories column use the category ID or category name, as I've tried both ways just in case that was the problem. Back to the product not showing, I also tried resetting the product search index etc, but that didn't work either. Edited October 1, 2014 by graisbeck (see edit history) Link to comment Share on other sites More sharing options...
graisbeck Posted October 1, 2014 Author Share Posted October 1, 2014 (edited) I've saved my test csv as UTF-8 and imported it again. I now get the error: The category ID cannot be the same as the Root category ID or the Home category ID. The category I have in the test CSV is Handbags, and I have a Handbags category within my store, so does that mean it's a root category? Edited October 1, 2014 by graisbeck (see edit history) Link to comment Share on other sites More sharing options...
graisbeck Posted October 2, 2014 Author Share Posted October 2, 2014 I could do with some help on this, please!! Link to comment Share on other sites More sharing options...
agenceweb74 Posted October 2, 2014 Share Posted October 2, 2014 The root category (ie. the parent category of all top categories you can create in Prestashop) already has the id 1. Have you categories ids in your csv file ? If so you cannot use 1. Since you already have other categories, please note that you risk to update the existing ones if you reuse some ids. About column matching during import, you can save your "import configuration" during the import for reusing it later. It works well (except for caracteristics) Link to comment Share on other sites More sharing options...
graisbeck Posted October 2, 2014 Author Share Posted October 2, 2014 When I go to Catalog > Categories in admin, I see my list of categories. Which is listed as having ID's of 14, 15, 16 and so on. The category ID I'm trying to import to is 14. I already have a product with the product ID of 1, so I gave this test product a product ID of 2 I'm now getting these errors: 2 errors 1. No Name (ID: 2,1,Black Fashion bag,14,,,7,0,,,,,1124,,,,,,,,,,0.9,20,1,Everywhere,,1,14.99,sdfsdf sdf sdf fd sf df dsf sdf,re rwer r ef ee wf ef sef sefse fsef sefs efs ef sef sef se efsef sefjsklefjs efsfj sef sjfsklejf sef sf s,,,,,,,,1,11/05/2014,,1,http://bagsnbracelets.co.uk/images/uploads/HB00105-BRN.jpg,0,,0,New,0,0,0,Default: Deny orders,,,,) cannot be saved 2. Property Product->name is empty I have attached the data I'm trying to import. Thanks. test1.txt Link to comment Share on other sites More sharing options...
agenceweb74 Posted October 2, 2014 Share Posted October 2, 2014 Your file looks correct (I did not check every fields) and you have a name column. Do you associate name column with name attribute in second step of import ? Link to comment Share on other sites More sharing options...
graisbeck Posted October 2, 2014 Author Share Posted October 2, 2014 I've associated the name column again, and now get these errors: 1. 2,1,Black Fashion bag,14,,,7,0,,,,,1124,,,,,,,,,,0.9,20,1,Everywhere,,1,14.99,sdfsdf sdf sdf fd sf df dsf sdf,re rwer r ef ee wf ef sef sefse fsef sefs efs ef sef sef se efsef sefjsklefjs efsfj sef sjfsklejf sef sf s,,,,,,,,1,11/05/2014,,1,http://bagsnbracelets.co.uk/images/uploads/HB00105-BRN.jpg,0,,0,New,0,0,0,Default: Deny orders,,,, (ID: No ID) cannot be saved 2. Property Product->link_rewrite length (276) must be between 0 and 128 Link to comment Share on other sites More sharing options...
agenceweb74 Posted October 2, 2014 Share Posted October 2, 2014 (edited) You need to associate all columns, ID, name and so on... is it the case ? Edited October 2, 2014 by agenceweb74 (see edit history) Link to comment Share on other sites More sharing options...
graisbeck Posted October 2, 2014 Author Share Posted October 2, 2014 You need to associate all columns, ID, name and so on... is it the case ? I already did this yesterday. Do I need to delete and re-associate columns every time I want to import products? as that is a lengthy task having to retype all column headers. Link to comment Share on other sites More sharing options...
agenceweb74 Posted October 2, 2014 Share Posted October 2, 2014 I do not understand when you say "delete [...] columns", but yes you need to associate each column of your CSV file to each field of prestashop table, each time you process to an import. Hopefully, on the right side of the screen you can save the "import configuration", which will avoid you a manual assocation. You can save several patterns according to your input files (one for products, categories, etc... or one for supplier A, supplier B, etc...) Link to comment Share on other sites More sharing options...
graisbeck Posted October 2, 2014 Author Share Posted October 2, 2014 In the "View Your Data" page it has load, delete & save. So to redo the association don't I have to delete the old associations first? Link to comment Share on other sites More sharing options...
agenceweb74 Posted October 2, 2014 Share Posted October 2, 2014 In the "View Your Data" page it has load, delete & save. So to redo the association don't I have to delete the old associations first? You need to delete only if your patterns of association are wrong (ie. the import does not work). When you arrive on that page, you can select a previously used pattern then click load and the association is ok. On this page you need: either to click on load in order to get a valid association either manually associate each product column either use a CSV file that match the preset associations. I do not remember if on some versions of Prestashop the association is "preset" without clicking on load. Link to comment Share on other sites More sharing options...
graisbeck Posted October 2, 2014 Author Share Posted October 2, 2014 I don't know what you mean by pattern? I've attached a screenshot of the View Your Data page. Link to comment Share on other sites More sharing options...
agenceweb74 Posted October 2, 2014 Share Posted October 2, 2014 (edited) I don't know what you mean by pattern? I've attached a screenshot of the View Your Data page. According to your screenshot you are using the wrong separator. Change the separator when you import your file from ; to , or when you export your file from excel (or whatever) Edited October 2, 2014 by agenceweb74 (see edit history) 1 Link to comment Share on other sites More sharing options...
agenceweb74 Posted October 2, 2014 Share Posted October 2, 2014 by pattern of import I mean the list of association between the columns of a specific CSV file and the fields of prestashop. Link to comment Share on other sites More sharing options...
graisbeck Posted October 2, 2014 Author Share Posted October 2, 2014 Hooray!! I've got it at last Thanks agenceweb74 & rvzoest for all your help and patience. 1 Link to comment Share on other sites More sharing options...
agenceweb74 Posted October 2, 2014 Share Posted October 2, 2014 Hooray!! I've got it at last Thanks agenceweb74 & rvzoest for all your help and patience. You're welcome ! Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now