# Importing and exporting products with Excel

Section: Products and prices. Address: https://vende.id/docs/produk-dan-harga/impor-ekspor-produk?lang=en

Bring in hundreds of products at once from an Excel file, update their prices, and download the product list to Excel.

Have many products? Bring them in at once from Excel instead of one by one.

## Importing products

1. Open **Master Data → Products**, then press **Import Products**.
2. Download the example file: **Excel example** or **CSV example**.
3. Fill in that file, one row per product. Do not change the column headings in the first row.
4. Go back to the **Import Products** window, then upload the file.
5. Check the column pairs shown, then press **Import**.

The import runs in the background. The outcome comes to the bell, for example "480 of 500 rows were imported." One file holds at most 5.000 rows.

## Columns in the example file

Only **name** is required for a new product. Other columns may stay empty.

- **code**: the product's code or barcode.
- **name**, **category**, **brand**, **unit**: categories, brands and units that do not exist yet are created. Without a unit, the product uses pcs.
- **bulk_price_group** (only while the Bulk price groups feature is on): the name of the product's Bulk Price Group (see [Quantity prices](https://vende.id/docs/produk-dan-harga/harga-beli-banyak?lang=en#several-products-added-together-bulk-price-group)). A group that does not exist yet is created. Products of one group must share a base unit; a row that breaks this is refused with the reason.
- **printed_name**: the name printed on the buyer's note, for example AQUA 600ML for the product AQUA 600ML (PPN). See [Printed name](https://vende.id/docs/produk-dan-harga/menambah-produk?lang=en#printed-name). On a variant row this column is skipped, because it follows the parent.
- **type**: write finished goods or raw material.
- **cost_price**, **sell_price**, **min_stock**: numbers only, for example 12000. The **cost_price** column is only read from the file of a holder of Sensitive Reports. For anyone else it is skipped: a new product starts at a cost price of 0 (a new variant takes its parent's cost price) and an existing product keeps its cost price. See [Cost price of goods](https://vende.id/docs/pengaturan/peran-dan-hak-akses?lang=en#cost-price-of-goods).
- **active**: write yes.
- **factory_barcode**: write yes when the **code** is the barcode the maker printed on the pack (digits only), no when it is a code the shop made. Empty = unchanged. **factory_barcode_2** and **factory_barcode_3** do the same for the barcodes of units 2 and 3. A code that is not digits cannot be ticked: the row is refused with the reason.
- **unit_2**, **contents_2**, **barcode_2**, **sell_price_2**: another unit, for example a box of 24. The same columns exist for a 3rd unit.
- **main_unit**: the base unit or one of the product's other units.
- **selling_unit**: the unit a sales line starts in, the base unit or one of the product's other units. Empty = left as it is.
- **variant_parent**, **variant**: while the Product variants feature is on, the row is a variant of the parent product whose code or name is in **variant_parent**, for example the variant Size: S; Colour: Black. A parent not there yet is made from its first row. A variant's name, category and unit are its parent's, and other units go on the parent's row. See [Product variants](https://vende.id/docs/produk-dan-harga/varian-produk?lang=en).

- **registration_number**, **halal_certificate_number**, **halal_valid_until**: the BPOM registration number, the halal certificate number and the day it is valid until (2027-03-03). These columns are only there while the Registration & certificates feature is on; see [Registration numbers, halal certificates and customer licences](https://vende.id/docs/produk-dan-harga/izin-edar-dan-sertifikat?lang=en). On a variant row they are skipped, because a variant follows its parent.

Example of one row: code 8991002101234, name Beras Pandan Wangi 5 kg, category Groceries, unit pcs, cost_price 9000, sell_price 12000, unit_2 box, contents_2 24.

## Updating existing products

- A row with the same **code** updates that product.
- A row without a code updates the product with the same **name**.
- An empty cell does not change what the product already has.

So an import can also update the prices of many products.

## When some rows fail

Failed rows are reported one by one, with the reason. The other rows still go in. Examples of reasons:

- the base unit is changed while the product already has stock history;
- the code is already used by another product or a service.

The history of all imports, with the **Download failed rows** button, is under **Settings → Import History**. Fix the failed rows, then import again.

> **Important:** Staff who only hold certain branches cannot change the selling price of existing products through an import, because that price applies in every branch.

## Exporting products to Excel

1. Under **Master Data → Products**, search or filter the list as you need.
2. Press **Export to Excel**.
3. The download link comes to the bell once the file is ready.

The file holds, among others, the code, factory barcode (yes or no), name, printed name, type, category, brand, Bulk Price Group (while its feature is on), tax, base unit, main unit, selling unit, selling price, cost price, minimum stock and active status, plus the registration number and halal certificate while the Registration & certificates feature is on. The list filters, including **Factory barcode / shop code**, decide which products come along. The **Export to Excel** button only shows when the extra Excel export feature is on.

> **Tip:** The opening stock of products is imported separately under **Settings → Opening Balances → Opening Stock**.
