CSV Import > Combinations

[bruce-rez]

Hi,
I made a separate CSV file for Combination.
I have these columns (attributes) in this csv file:

Size
Color
Minimum Quantity



Question:
How to match these columns with the below Prestashop Required Filed ?
Product ID*
Options (Group:Value)*
Reference
Supplier reference
EAN13
UPC
Wholesale price
Price
Ecotax
Quantity
Weight
Default

I need really help and I tried different thing to figure out this problem without any luck.
Thank you.

[bruce-rez]

Any help or guidance?

[Kelvin Koh]

Hi,
I made a separate CSV file for Combination. I have about 500 items.
I have these columns (attributes) in this csv file:

Size
Color
Minimum Quantity



Question:
How to match these columns with the below Prestashop Required Filed ?
Product ID*
Options (Group:Value)*
Reference
Supplier reference
EAN13
UPC
Wholesale price
Price
Ecotax
Quantity
Weight
Default

I need realy help and I tried different thing to figure out this problem without any luck.
Is there anybody from Prestashop Team to help? Or if there are any link or docs regarding this setup.
Thank you.

I'll try to make my explanation short and simple.

Product ID is how Prestashop identifies distinct products and links all other info. 1 product = 1 Product ID.

Color and size are 2 different attributes and you can make combinations.
Price is the Price Impact (price difference from base price of default combination)

You must have 1 combination as default (as a base) and set a base price (eg $20) in the main product data tab.

Let's say you are selling T-shirt with Gothic theme and offers 2 colors (Black & Red) in 2 sizes (S & M).
Then you probably have 4 combinations:
1. Black, Size S
2. Black, Size M
3. Red, Size S
4. Red, Size M

Putting 1st combination as default for Product Data import (before you import the combinations):
10 (Product ID); Gothic theme T-shirt; Wholesale Price = $12; Base Price = $20

You add the others as add on combinations.

Now you import the combinations.
In csv format for 1 product with 2 attributes giving 4 combinations (1st is default combination):
Product ID; Group1:Attr1, Group2:Attr2; Wholesale Price; Price; Quantity; Default

10; Color:Black, Size:S; 12; 0; 10; 1
10; Color:Black, Size:M; 15; 5; 10; 0
10; Color:Red, Size:S; 12; 0; 10; 0
10; Color:Red, Size:M; 15; 5; 10; 0

[bruce-rez]

Thanks calisyoda for the reply.
I am going to try your suggestion and see how I can create and import my csv file.
To be more specific I've posted another topic regarding the same subject. I would appreciate it if you can take a look and give your opinion. Here is the link:
http://www.prestashop.com/forums/viewthread/91272/#380698
Thank you.

[giuly]

Hi,
I made a separate CSV file for Combination. I have about 500 items.
I have these columns (attributes) in this csv file:

Size
Color
Minimum Quantity



Question:
How to match these columns with the below Prestashop Required Filed ?
Product ID*
Options (Group:Value)*
Reference
Supplier reference
EAN13
UPC
Wholesale price
Price
Ecotax
Quantity
Weight
Default

I need realy help and I tried different thing to figure out this problem without any luck.
Is there anybody from Prestashop Team to help? Or if there are any link or docs regarding this setup.
Thank you.

I'll try to make my explanation short and simple.

Product ID is how Prestashop identifies distinct products and links all other info. 1 product = 1 Product ID.

Color and size are 2 different attributes and you can make combinations.
Price is the Price Impact (price difference from base price of default combination)

You must have 1 combination as default (as a base) and set a base price (eg $20) in the main product data tab.

Let's say you are selling T-shirt with Gothic theme and offers 2 colors (Black & Red) in 2 sizes (S & M).
Then you probably have 4 combinations:
1. Black, Size S
2. Black, Size M
3. Red, Size S
4. Red, Size M

Putting 1st combination as default for Product Data import (before you import the combinations):
10 (Product ID); Gothic theme T-shirt; Wholesale Price = $12; Base Price = $20

You add the others as add on combinations.

Now you import the combinations.
In csv format for 1 product with 2 attributes giving 4 combinations (1st is default combination):
Product ID; Group1:Attr1, Group2:Attr2; Wholesale Price; Price; Quantity; Default

10; Color:Black, Size:S; 12; 0; 10; 1
10; Color:Black, Size:M; 15; 5; 10; 0
10; Color:Red, Size:S; 12; 0; 10; 0
10; Color:Red, Size:M; 15; 5; 10; 0

Hello I import combinations well on prestashop, so I see on my store correctly, but appears to me that clients can't add to their cart, appears send mail when available.
I solve on BO on every product clicking on generate attributes, and I solve, so clients cah buy that products.
Is there a way to generate attributes via csv file?
thanks

[Kelvin Koh]

Hello I import combinations well on prestashop, so I see on my store correctly, but appears to me that clients can't add to their cart, appears send mail when available.
I solve on BO on every product clicking on generate attributes, and I solve, so clients cah buy that products.
Is there a way to generate attributes via csv file?
thanks

Giuly,

I've already described in detail clearly how to create and import attributes & combinations via CSV in earlier posts.

If you're talking about just 1 attribute, it's as simple as:
ID; Attribute; Price; Quantity
3; Color: Red; 25; 100
4; Color: Blue; 30; 100


From your description, the most likely reason your clients can't add the product combinations to cart is because
1. They're out of stock (quantity = 0)! OR
2. You have set the minimum quantity or amount (in $$) to purchase higher than what your clients add into their carts.

Double check:
1. Your spreadsheet and CSV files that you have correctly entered the quantities (above ZERO of course!)
2. When you're importing the CSV file, you have selected the Quantity field and correctly matching the quantity column.
You can easily avoid this error by leaving the field names in the CSV file and skip the 1st line (field names) when you execute the import.

[giuly]

ah it is obvious I feel stupid, yes I don't set quantity.
Sorry You have reaseon, now I try again!
Thank you very very much!

[giuly]

hello sorry but it isn't so simple, so I uploaded correctly quantities and attributes, but I see on store product doesn't exist...send email when available.
if you want try for one product I give to you access to my backoffice and you can try. If you solve this problem, you will do to me a great favour.
If I don't solve I have to manually generate attribute via back office, product per product clicking on generate attribute.
Please...

[Kelvin Koh]

hello sorry but it isn't so simple, so I uploaded correctly quantities and attributes, but I see on store product doesn't exist...send email when available.
if you want try for one product I give to you access to my backoffice and you can try. If you solve this problem, you will do to me a great favour.
If I don't solve I have to manually generate attribute via back office, product per product clicking on generate attribute.
Please...

Seems like it may be caused by the module Mail Alerts. Did you set a Quantity Threshold for Out Of Stock?

[giuly]

can you say to me how to see quantity threshold for out of stock? effectively every order arrives to me email that out of stock also if there are many quantities for that product.
I see on module email alert, issue remains with words
product doesn't exist. Please choose another.