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:
- Picqer
- QLS
- BigQuery
- Logic4
- Odoo
- Zoho Inventory
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,,
...
Download the template here
Composed_products_template.csv
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.