Jump to content
admin@wolfkanat

Combinations Import

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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Change dropdown to select.

 

The types available are:

  • select for drop-down menus,
  • radio for radio buttons
  • color for color boxes

Share this post


Link to post
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

Share this post


Link to post
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.

Share this post


Link to post
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! 

Share this post


Link to post
Share on other sites

Hi, Im trying to set up the ring size for my products on prestashop, and you can see how I've set the csv file attached,

For you  where is the issue?

Thank you very much

 

Untitled-1.gif

Share this post


Link to post
Share on other sites

I found out that the sample file delivered with PS1.6 is wrong, in column B it should be the reference of the product not the attribute. In fact you must insert this column in B

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More