Jump to content

Combinations Import


admin@wolfkanat

Recommended Posts

Hi All, 

Looking for some feedback and help asap. 

 

I'm currently on the test site trying to get the online store up and going. Im running version 1.6.1.12 

 

All the info i have read has said to have all colours and size attributes already configured in the BO before importing the combinations file, which i have done. 

I have then prepared (painstakingly) the CSV file to upload. We sell clothing, suits shoes etc. so there are many colour and size combos. 

I have uploaded the csv to the test site and i'm only getting one combination! and no size drop down etc. I have matched the product id across both the product file and combinations file so they all match up, the reference and eans also didnt import ! Basically hardly any of the info imported ! However it made all new attribute groups instead of using the ones listed in BO !  ARGH!

 

I followed this clip  as well and on import everything was fine.... 

 

 

Product ID*;Attribute Group:(Name:Type:Position)*;;Supplier reference;Reference;EAN13;VALUE;Quantity;Minimal quantity;Impact on weight;Default (0 = No 1 = Yes)
 
101;Color:select:0 jacket&vestsizes:dropdown:0;Black:0 88R:0;Autograf Jacket;7WK4235 Black ;9314781223574;;3;3;;0
 
 
any help or tips appreciated! 
 
thanks Giulia
Link to comment
Share on other sites

Your heading line's missing the Value field:

 

Product ID*;Attribute (Name:Type:Position)*;Value (Value:Position)*;...

 

You need some commas to separate attribute and value combinations:

 

101;Color:select:0, jacket&vestsizes:dropdown:0;Black:0, 88R:0;Autograf Jacket;7WK4235 Black ;9314781223574;;3;3;;0

Link to comment
Share on other sites

Your heading line's missing the Value field:

 

Product ID*;Attribute (Name:Type:Position)*;Value (Value:Position)*;...

 

You need some commas to separate attribute and value combinations:

 

101;Color:select:0, jacket&vestsizes:dropdown:0;Black:0, 88R:0;Autograf Jacket;7WK4235 Black ;9314781223574;;3;3;;0

 

Ok so i have checked and had various (a lot) of attempts at getting the csv to upload correctly! The issue seems to be - 

Where there is a product that has multiple colours and sizes, the colours are visible, however only one size option shows instead of the correct size range. 

It creates the sizes in the attributes, but when you look at the product combination the sizes are not there... 

 

Any ideas anyone ? Does anyone have a fashion CSV that has products with multiple colours and sizes / eans? that i can look at as an example? 

 

I've uploaded a snippet of mine - which shows the main content  area - 

 

 

HELP!! 

 

thanks

Giulia

post-1321923-0-33015900-1491883714_thumb.png

Link to comment
Share on other sites

thanks jared - Still not working even with the above change. Its also re writing the size attribute groups, and added a second file of the same group.  

these are some of the lines -  just so your aware i'm using , as the field separator and the ; as the multiple value - 

 

Product ID*,Attribute Group:(Name:Type:Position)*,Value:Position,Supplier reference,Reference,EAN13,Quantity,Minimal quantity,Default (0 = No; 1 = Yes)
101,Colour:colour:1;Jacket & Vest Sizes:select:12,Black:1;100L:12,Autograf Jacket,7WK4235 Black ,9314781223642,3,3,0
101,Colour:colour:1;Jacket & Vest Sizes:select:4,Black:1;100R:4,Autograf Jacket,7WK4235 Black ,9314781222836,3,3,0
101,Colour:colour:1;Jacket & Vest Sizes:select:17,Black:1;100S:17,Autograf Jacket,7WK4235 Black ,9314781223680,3,3,0
101,Colour:colour:1;Jacket & Vest Sizes:select:13,Black:1;104L:13,Autograf Jacket,7WK4235 Black ,9314781223659,3,3,0
101,Colour:colour:1;Jacket & Vest Sizes:select:5,Black:1;104R:5,Autograf Jacket,7WK4235 Black ,9314781222843,3,3,0
 
I have tried a few variations but still - its like something is overriding it as only one size of each colour comes up visible. 
 
any other suggestions? i'm not sure what to try next! 
I really don't want to manually set the products up as its hundreds of lines! 
 
thanks 
 
Giulia
Link to comment
Share on other sites

Here's a version of your sample that I've extended to include another colour:

 

Product ID*,Attribute Group:(Name:Type:Position)*,Value:Position,Supplier reference,Reference,EAN13,Quantity,Minimal quantity,Default (0 = No; 1 = Yes)
8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;100L:1,Autograf Jacket,7WK4235 Black ,9314781223642,3,3,0
8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;100R:1,Autograf Jacket,7WK4236 Black ,9314781222836,3,3,0
8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;100S:1,Autograf Jacket,7WK4237 Black ,9314781223680,3,3,0
8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;104L:1,Autograf Jacket,7WK4238 Black ,9314781223659,3,3,0
8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;104R:1,Autograf Jacket,7WK4239 Black ,9314781222843,3,3,0
8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;100L:1,Autograf Jacket,7WK5235 Pink ,8314781223642,3,3,0
8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;100R:1,Autograf Jacket,7WK5236 Pink ,8314781222836,3,3,0
8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;100S:1,Autograf Jacket,7WK5237 Pink ,8314781223680,3,3,0
8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;104L:1,Autograf Jacket,7WK5238 Pink ,8314781223659,3,3,0
8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;104R:1,Autograf Jacket,7WK5239 Pink ,8314781222843,3,3,0

 

A few observations:

  • You have to spell color the American (incorrect) way, otherwise prestashop doesn't pick up the off-the-shelf Color Attributes.
    You could create your own Product Attributes called Colour and define each colour yourself, but it makes sense to pick up the existing ones.
     
  • I've kept the Position value simple, 0 or 1.
     
  • I've made the Reference unique. In your example all combinations have the same reference (7WK4235 Black) which is why you're only getting one of each colour group.
Link to comment
Share on other sites

 

Here's a version of your sample that I've extended to include another colour:

 

Product ID*,Attribute Group:(Name:Type:Position)*,Value:Position,Supplier reference,Reference,EAN13,Quantity,Minimal quantity,Default (0 = No; 1 = Yes)

8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;100L:1,Autograf Jacket,7WK4235 Black ,9314781223642,3,3,0

8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;100R:1,Autograf Jacket,7WK4236 Black ,9314781222836,3,3,0

8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;100S:1,Autograf Jacket,7WK4237 Black ,9314781223680,3,3,0

8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;104L:1,Autograf Jacket,7WK4238 Black ,9314781223659,3,3,0

8, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;104R:1,Autograf Jacket,7WK4239 Black ,9314781222843,3,3,0

8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;100L:1,Autograf Jacket,7WK5235 Pink ,8314781223642,3,3,0

8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;100R:1,Autograf Jacket,7WK5236 Pink ,8314781222836,3,3,0

8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;100S:1,Autograf Jacket,7WK5237 Pink ,8314781223680,3,3,0

8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;104L:1,Autograf Jacket,7WK5238 Pink ,8314781223659,3,3,0

8, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;104R:1,Autograf Jacket,7WK5239 Pink ,8314781222843,3,3,0

 

A few observations:

  • You have to spell color the American (incorrect) way, otherwise prestashop doesn't pick up the off-the-shelf Color Attributes.

    You could create your own Product Attributes called Colour and define each colour yourself, but it makes sense to pick up the existing ones.

     

  • I've kept the Position value simple, 0 or 1.

     

  • I've made the Reference unique. In your example all combinations have the same reference (7WK4235 Black) which is why you're only getting one of each colour group.

 

 

Thanks Jared, Being in Australia we dont use the same spelling - i specifically change the attribute name so it all matches  - i dont think thats a problem as it seems to match for the other products that dont have size combinations.  I will however try the other changes and see what happens :) thanks appreciate your help! 

Link to comment
Share on other sites

  • 1 year later...
  • 1 month later...
  • 1 year later...

Hi! I use 1.7.7.2 and I have problem with my import:
I have products with combination color and size

All products with same color have the same index (reference) so for example if I have 10 sizes then their will have same index.

It is possible to have same index for this products - at the moment on import I only have imported one of each colors - it means presta takes index as unique.

Any idea how can we change this? It should be possible to have product with the same index ... ?
Index as a key is not selected on import so it must not be unique ?

Edited by nikos83 (see edit history)
Link to comment
Share on other sites

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...