Jump to content

Import csv / products & combinations


Naturel Deluxe

Recommended Posts

Whats wrong with my import? 

I only have one combinations (size) active on the product: 

 

Import 1 - single products: 

Product_ID Active (0/1) Name * Category ID Price Tax rule ID Wholesale price On Sale (0/1) Discount to Discount amount Discount percent Discount from Reference # Supplier Reference Supplier Manufacturer EAN13 UPC Ecotax Width Height Depth Weight Quantity Minimal Quantity Visibility Additional shippingcost Unity Unit price Short Description Description Tags (x,y,z, ...) Meta keywords Meta description URL rewritten Text when in stock Available for order (0/1) Product available date Product creation date Show price Images (x,y,z, ...) Alt images Delete existing images Product Features Only available online (0/1) Condition Customizable (0/1) Uploadeble files (0/1) Text felds (0/1) Out of stock ID name of shop Advanced stock management Depens on stock Warehouse
2122 1 Cool Water Night Dive Eau de toilette 56,5,4 36.95 53 24 0         3607347580775 unique supplier reference supplier Davidoff 3607347580775   0 0 0 0 0 24 1 both 0     Davidoff Night Dive <h2>Cool Water Night Dive Eau de toilette</h2><p>Davidoff Night Dive</p> Cool Water Night Dive Eau de toilette,Davidoff,Eau de toilette Cool Water Night Dive Eau de toilette,Davidoff,Eau de toilette Davidoff Night Dive   Voor 20.30 uur besteld, morgen in huis 1     1 image url.... Davidoff Cool Water Night Dive Eau de toilette 1 Merk:Davidoff,Type:Eau de toilette,Geslacht:Heren parfum,Inhoud:125ml 0 new 0 0 0   1 0 0  

 

Import combinations:

Product_ID Attribute (Name:Type:Position)* Value (Value:Position)* Supplier Reference Reference EAN13 UPC Wholesale price Ecotax Quantity Minimal quantity Aantal.Afbeelding Aantal.PrijsPC ID / Name of shop Advanced stock management Depends on stock Warehouse Impact on Price Default (0 = No, 1 = Yes) Product Reference
2122 Inhoud:select:0,Type:select:1 125ml:0,Eau de toilette:1 unique supplier reference 3607347580775 3607347580775   24 0 24 1 image url 36.95 1 0 0   0 1  3607347580775
2122 Inhoud:select:0,Type:select:1 200ml:0,Eau de toilette:1 unique supplier reference 3614220175645 3614220175645   24.5 0 3 1 image url 37.95 1 0 0   0.79 0  3607347580775

 

 

I do not understand why the product is shows only 200 ml. size ... 

Is this because of the unique product reference? 

The product is created with the information of the smallest size (125ml) so the combination with size 125ml has the same reference... Is this the problem? 

 

When I import the combinations, I'm using product reference as key.

 

Thanks in advance !

 

product example.csv

combinations example.csv

Edited by Naturel Deluxe
file upload (see edit history)
  • Like 1
Link to comment
Share on other sites

I really can't believe a simple question as "schould the reference for the product & the combination be both unique or schould they match" stays un-answered... 

No one who can tell me why I only have one combination, while I'm importing 2.... 

No one who can tell me how to do it better, or how I schould do it ... 

Unbelieve able ... 

  • Like 1
Link to comment
Share on other sites

Okay thanks a lot... In case of someone need it...

Here is the only correct answer: 

There are 2 references needed. 

Product reference = only used to match combination and product. 

Combination reference (or just reference) = unique number for each combination. The combination reference must be unique & must be different then product reference... 

Link to comment
Share on other sites

  • 2 years 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...