admin@wolfkanat Posted April 10, 2017 Share Posted April 10, 2017 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 More sharing options...
JeredBolton Posted April 10, 2017 Share Posted April 10, 2017 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 More sharing options...
admin@wolfkanat Posted April 10, 2017 Author Share Posted April 10, 2017 Thanks Jared, I put commas in the original file but when its saved as csv its been taken away . I will double check it thanks! Giulia Link to comment Share on other sites More sharing options...
admin@wolfkanat Posted April 11, 2017 Author Share Posted April 11, 2017 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 Link to comment Share on other sites More sharing options...
JeredBolton Posted April 11, 2017 Share Posted April 11, 2017 Change dropdown to select. The types available are: select for drop-down menus, radio for radio buttons color for color boxes Link to comment Share on other sites More sharing options...
admin@wolfkanat Posted April 12, 2017 Author Share Posted April 12, 2017 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 More sharing options...
JeredBolton Posted April 12, 2017 Share Posted April 12, 2017 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,08, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;100R:1,Autograf Jacket,7WK4236 Black ,9314781222836,3,3,08, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;100S:1,Autograf Jacket,7WK4237 Black ,9314781223680,3,3,08, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;104L:1,Autograf Jacket,7WK4238 Black ,9314781223659,3,3,08, Color:color:0; Jacket & Vest Sizes:select:1, Black:0;104R:1,Autograf Jacket,7WK4239 Black ,9314781222843,3,3,08, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;100L:1,Autograf Jacket,7WK5235 Pink ,8314781223642,3,3,08, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;100R:1,Autograf Jacket,7WK5236 Pink ,8314781222836,3,3,08, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;100S:1,Autograf Jacket,7WK5237 Pink ,8314781223680,3,3,08, Color:color:1; Jacket & Vest Sizes:select:1, Pink:1;104L:1,Autograf Jacket,7WK5238 Pink ,8314781223659,3,3,08, 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 More sharing options...
admin@wolfkanat Posted April 12, 2017 Author Share Posted April 12, 2017 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 More sharing options...
c.cristinziano Posted March 5, 2019 Share Posted March 5, 2019 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 Link to comment Share on other sites More sharing options...
PatriceJV Posted April 9, 2019 Share Posted April 9, 2019 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 Link to comment Share on other sites More sharing options...
nikos83 Posted March 20, 2021 Share Posted March 20, 2021 (edited) 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 March 20, 2021 by nikos83 (see edit history) 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