magzen Posted March 25, 2014 Share Posted March 25, 2014 Hello, I installed Prestashop 1.6 yesterday to try it out for the first time and make some tests, i normally use Opencart but wanted to give Prestashop a try since iam maybe going to use it in my new shop. First thing i tried out was to import CSV product files which i will need for my new shop importing 70,000 product. I bumped in to a few "problems" which i didnt find any solution on or managed to solve on my own. 1.To import the products with product import it wasnt possible to import product attributes at the same time, that is ok for me, but the question is if i would choose "combination csv import" after importing the products with "Product csv import" it would reimport all the products over again in my test, the only thing unique there would be "Product Id" which doesnt exist in the csv files, iam used that the "SKU" of a product is unique, or at least an option that would make it unique, so that made things complicated (not beeing able to update existing products instead they are reimported again). 2. My second "problem" i didn't find any answer to is if my current product attributes in the CSV files would be compatible with Prestashop, i have downloaded the "Combination CSV Sample" and the attributes looked differently there. Attributes in my csv file is Color in one column and Size in another column And the values would be like following in 1 cell (Red,Blue,Green) same for size (S,M,L,XL) is that compactible with Prestashop 1.6 CSV import? Thanks Link to comment Share on other sites More sharing options...
magzen Posted March 26, 2014 Author Share Posted March 26, 2014 No one with an answer to if my attributes would be compatible or work on Prestashop with a module? Link to comment Share on other sites More sharing options...
magzen Posted April 2, 2014 Author Share Posted April 2, 2014 I haven't tried Prestashop 1.6 yet, but it worked for 1.5.6. 1) When you create a product, you can force the Product_ID to be the SKU if you want (there's a checkbox for this). After, if you want to update the product information, you only have to import the CSV with the same Product_Id. 2) Yes, your attributes are compatible. Let's say you have these products: SKU 1000 - Color: red - Size: L SKU 1001 - Color: red - Size: XL SKU 1002 - Color: blue - Size: L SKU 1003 - Color: blue - Size: XL You would do the following: * Import a product CSV file with Product_Id 1000 * Import a combination CSV file with these lines: Product_Id; Attributes; Values; Reference 1000; Color:color:1,Size:select:2; Red:1,L:1; 1000 1000; Color:color:1,Size:select:2; Red:1,XL:2; 1001 1000; Color:color:1,Size:select:2; Blue:2,L:1; 1002 1000; Color:color:1,Size:select:2; Blue:2,XL:2; 1003 Where "color" and "select" means the way the attribute will be shown in Prestashop and the number means the position where it will appear. Hope it helps. Thanks for your answer, i have tried to import to Prestashop my csv file, but they arent compatible, there are several other added values that doesnt exist in my exported csv file, Prestashop want more complex attributes. My csv file exported from Opencart only includes name of the color under a column and name of size under another column, Prestashop needs the "Value Position". Another thing i find a little annoying is when importing a "CSV Combination Import", you have to fill in the "Product ID". After importing 40,000-50,000 products is one supposed to fill in the "Product ID" created by Prestashop manually to the CSV lists? It doesnt make sense to me, instead they should have made it possible to chose another unique column like "SKU Refrence". I really do like the new Prestashop 1.6, but with this problems to import my CSV files it looks like i maybe wont be able to use it since there would be lots of manual work. Link to comment Share on other sites More sharing options...
magzen Posted April 3, 2014 Author Share Posted April 3, 2014 I have attached an example on the csv file format. example.txt Link to comment Share on other sites More sharing options...
scriptnet Posted April 21, 2014 Share Posted April 21, 2014 try, field reference must fill unik Link to comment Share on other sites More sharing options...
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