Jump to content

Prestashop 1.6 CSV Attribute Import


Recommended Posts

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

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

  • 3 weeks later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...