📥 Import: Product Compositions

A composed product (often called a kit or a set) consists of several underlying products or parts. For example, a camera body and a lens can be sold separately, but they can also be sold together as a kit. We call this kit a Composed Product.

While Optiply can purchase these items separately, we need to know exactly which parts make up a set so we can accurately predict the demand for those underlying products.

🔄 1. Supported Source Systems vs. Manual Import

Optiply automatically takes composed products into account if you use one of the following source systems:

Picqer
Picqer Fulfilment
Exact Online
QLS
BigQuery
Logic4
Odoo
Zoho Inventory
And several others ( please check the data mapping section of your integration for more details)

If your source system is not on this list, or if the composition information is simply not available in your source system, you can pass this information to us manually via a bulk CSV import.

🗂️ 2. The CSV File Structure

To import your compositions, your CSV file must contain the following four columns.

Column Header	Description
composed_skuCode	The specific SKU code of the overarching Set you sell.
part_skuCode	The specific SKU code of the underlying Part that you buy.
quantity	The number of times that this specific part occurs inside the set.
assembled	Enter `TRUE` or `FALSE` (or leave blank). Setting this to `TRUE` marks the product as assembled and will display a puzzle piece icon next to it in the Optiply frontend.

CSV Formatting Example:

In the example below, Set 123 consists of three single products (456, 567, and 890). The set 101 consists of two of product ABC and two of product DEF.

Code snippet

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

Note: Every single part of a composed product must have its own dedicated row in the file.

📥 Download the Composed Products CSV Template Here

Composed_products_template.csv

📥 3. How to Submit Your File

Unlike standard product or supplier imports, Product Compositions are processed directly by our team rather than through the frontend dashboard.

Once you have filled out your CSV file according to the formatting rules above, simply submit the list to us! You can send your completed .csv file to support@optiply.nl or drop it directly into our support chat, and our team will process the bulk composition link for you.

❓ 4. Frequently Asked Questions (FAQs)

Do the overarching set and the underlying parts need to exist in my system first?

Yes. Both the sets and the underlying products must already be available in your source system and be actively purchasable.

Best Practice Tip: To keep your purchasing overview clean, we recommend giving your "Set" products a specific supplier in your source system with a clear name like 'Compound Products' or 'Do Not Procure'. These products do not have to be purchased by Optiply.

Can I use EAN codes instead of SKU codes?

Yes! If you prefer to use EAN codes, simply change the column headers in your file to composed_eanCode and part_eanCode. However, you must only pick one type. Do not use both SKUs and EANs in the same file, as this will lead to confusion and upload errors.

How do I delete or break a product composition?

If you would like to delete compositions in bulk (i.e., those products are no longer composed together), you can send our support team a simplified CSV file. The file only needs to contain the composed_skuCode and part_skuCode (or EAN equivalents) of the links you want to remove. Send it to support@optiply.nl and we will process the deletions.