Book a meeting

Import products

Estimated reading: 3 minutes 248 views

Odoo Sales includes an import template for adding or updating many products at once, including their categories and variants. This guide covers how to download, fill in and import it.

How to download the import template

  1. Go to Sales > Products > Products.
  2. Click the gear icon in the upper-left corner and select Import records.
  3. Click the link to download the Import Template for Products.

How to customise the template

Remove columns you do not need, and only add new columns for fields that already exist in Odoo, otherwise they must be mapped manually during import. It is strongly recommended to keep the Internal Reference column, since a unique reference lets the same file be re-imported later to update products without creating duplicates.

When mapping columns, review the Column and Odoo Field pairing. If a column is not matched automatically, use the Odoo Field drop-down to select the right field.

How to upload and test the file

  1. On the Import Records page, click Upload File and select the spreadsheet.
  2. Review the column mapping, then click Test to validate it.
  3. If successful, an “Everything seems valid” message appears. If errors are shown, correct the file and retest.
  4. Click Import to complete the process. A confirmation pop-up shows how many products were imported.

How to import attributes for variants

Attributes such as Size or Colour must be imported before they can be used in a product import. The spreadsheet needs an Attribute name, a Display Type (Radio, Selection or Color), a Variant Creation Mode (Instantly, Dynamically or Never), and one row per Value.

  1. Go to Sales > Configuration > Attributes.
  2. Click the gear icon, Import records, then Upload File.
  3. Click Import to finish. The attributes can now be assigned to new or existing products.

How to import product variants

With attributes and values already in the system, include the product name and its attributes and values in the product import template to create variants directly.

  1. Go to Sales > Products > Products, click the gear icon, Import records, then Upload File.
  2. Upload the product variant spreadsheet and click Import.
  3. Open an imported product and check the Attributes & Variants tab to verify the variants.

Frequently asked questions

Which spreadsheet software works with the import template?

Microsoft Excel, OpenOffice and Google Sheets all work, since the template is a standard spreadsheet.

Do product attributes need to be imported separately?

Yes. Attributes such as Size or Colour must be imported first, before they can be used when importing products with variants.

What happens if the import file has errors?

Odoo shows a red banner explaining what to fix. Correct the file, re-upload and test again before importing.

Need help?

Need help importing products into Odoo Sales? Contact support@thoughtlogik.com or see our Odoo implementation services.

Import products - PreviousManage your productsNext - Import productsProduct variants

Recently Viewed articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Learn how we helped 100 top brands gain success

Subscribe

×
Cancel