Skip to main content
Import Product Compositions

A composed product consists of several parts. To get this right in Optiply, you can submit this to us in bulk through a CSV file.

Marc de Graaf avatar
Written by Marc de Graaf
Updated over 4 months ago

A composed product consists of several products or parts. Hereby you can think about a camera body and a lens. Both can be sold separately, but also as a kit. We call the kit of body and lens, Composed Products.

Optiply can purchase products that are sold in a set separately. To properly predict the demand for the underlying products we need to know what products a set consists of.

Optiply takes into account composed products from the following source systems:
​

- QLS


If the information is not available in your source system, you can pass this on to us. Please submit this list in a CSV format.

Attention!
Both the sets and the underlying products must be available in your source system and can be actively purchased.

​

The list that can be sent to us consists of four columns:

  • composed_skuCode: these are the sku-codes of the sets of composed products you sell. You can also provide an ean code but then change the column to composed_eanCode.

  • part_skuCode: these are the sku-codes of the underlying products of which the set is composed. These are the products you buy. You can also provide an ean code but then change the column to part_eanCode.

  • quantity: this is the number of times that a part occurs in the composite product

  • assembled: TRUE/FALSE will set this product as assembled and appear as a puzzle piece in the frontend

composed_skuCode,part_skuCode,quantity,assembled
123,456,1,TRUE
123,567,1,FALSE
123,890,1,FALSE
101,ABC,2,,
101,DEF,2,,
...


In this example, set 123 consists of products: 456, 567, and 890. Set 101 consists of the following products: 2 x ABC and 2 x DEF. As you can see, each part of a composed product (set) has its own line in the overview. Make sure that the SKU-codes are unique in your system and that they exactly match the SKU-codes in the list.

For more overview, it is easy to give the set products a supplier in the source system that has a clear name, such as 'Compound Products' or 'Not Procure'. These products do not have to be purchased by Optiply.

Deleting Compositions:

If you would like to delete compositions in bulk, i.e. those products are no longer composed, a csv can be provided with the composed_skuCode and part_skuCode.


​

If you use ean code instead of sku code you can replace the information in the file so skuCode changes to eanCode.

We only pick one column so there is no point in using both columns as this can lead to confusion and errors.

Did this answer your question?