Skip to main content

🟦 Product Registry Import & Export

L
Written by Lassi kähkönen
Updated over a week ago

How to Export Products as CSV and Reimport Them into Eemel


✅ Activating the Product Registry

  1. Go to Settings (gear icon in the top menu).

  2. Select Available Features.

  3. Check the box for Product Registry.

  4. If the option is not visible, verify that your subscription includes the product registry feature on the Your Subscription page.


📤 Exporting Products to Excel (CSV)

  1. Navigate to Sales → Products.

  2. Click Save search results as CSV.

  3. Open the file in Excel. Note: the file uses UTF-8 encoding.


📥 Importing Products from Excel (CSV) into Eemel

  1. Go to Sales → Products → Import Products.

  2. Choose the CSV file from your device.

  3. Set the delimiter (typically a semicolon ;).

  4. Click Continue.

  5. Match CSV columns with the Eemel fields.

    • If the column names match Eemel's export format, the mapping will be automatic.

  6. Complete the import and fix any validation errors.

Notes:

  • If a supplier name is included in the CSV, Eemel will either assign it or create a new supplier if it doesn't exist in Purchases → Suppliers.

  • VAT codes must be entered as:

    • alv24 → 24% VAT

    • alv14 → 14% VAT

    • alv10 → 10% VAT

  • VAT % should be entered as a number only (e.g., 24), without the % symbol.

  • We recommend importing no more than 500 products at a time. If necessary, split your file into smaller ones.

  • Ensure the CSV file is in UTF-8 format.

Did this answer your question?