---
title: "How to import collections through Import Excel"
slug: "how-to-import-collections-through-import-excel"
updated: 2026-03-24T15:23:49Z
published: 2026-03-24T15:23:49Z
canonical: "docs.retailvista.net/how-to-import-collections-through-import-excel"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.retailvista.net/llms.txt
> Use this file to discover all available pages before exploring further.

# How to import collections through Import Excel

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).

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1774365731277.png?sv=2026-02-06&spr=https&st=2026-10-28T01%3A18%3A23Z&se=2026-10-28T02%3A18%3A23Z&sr=c&sp=r&sig=QN7flhXBSBw5EUAVOuNxV%2BPhRNMUvHKI%2F7ABcgwsb8o%3D)

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1774365816600.png?sv=2026-02-06&spr=https&st=2026-10-28T01%3A18%3A23Z&se=2026-10-28T02%3A18%3A23Z&sr=c&sp=r&sig=QN7flhXBSBw5EUAVOuNxV%2BPhRNMUvHKI%2F7ABcgwsb8o%3D)

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

![](https://cdn.document360.io/9cfe1b80-9c32-4b2a-9328-1df667cdd950/Images/Documentation/image-1763409068679.png?sv=2026-02-06&spr=https&st=2026-10-28T01%3A18%3A23Z&se=2026-10-28T02%3A18%3A23Z&sr=c&sp=r&sig=QN7flhXBSBw5EUAVOuNxV%2BPhRNMUvHKI%2F7ABcgwsb8o%3D)