For the main product, a “collection identification” is entered in the purchase details of the collection (see image 1). For the component products, this collection identification is entered as the “collection barcode” (see image 2).
It is advisable to use a separate purchase status for the purchase details of the main product, for example “collection”.
The component products should be assigned a purchase status that is not orderable. This is because the collection purchase record of the collection cannot be ordered separately.
If a component product can be ordered separately, it must have an additional purchase record that can be used to order the product individually.
In the example, a purchase status named “collection” with the code collectie (column H) is used, and a purchase status named “not orderable” with the code nb (column H).
The sample Excel file below, containing a collection, can be imported using the following columns:
A: product description
B: POS barcode
C: gross sales price incl. VAT
D: net purchase price
E: collection quantity
F: collection identification
G: collection barcode
H: purchase status code
