For a simple product import without variants, use the standard import template to prepare your import file. This covers an import without variants, without eCommerce and without other extras. If you need something more specific, we can build a tailored import template.
Download: Product import template, no variants (XLSX)
Available templates
- Product import template (no variants) - the base template for a simple import.
- Product (product.template) including eCommerce - the same import, with the eCommerce fields added.
- Odoo product import template ENG (No Variants) - the same template with English notes, including eCommerce.
The template headers contain notes with further explanation. If you need to add extra product properties (such as length, width, m2), simply add extra columns.
Import in two steps
- The import of the products themselves via the Inventory module.
- (Where applicable) The import of the related vendors, prices and vendor product codes via the Purchase module (Vendor Pricelists).
Warehouse locations
A question that comes up regularly: how do you handle warehouse locations? You do not link them to a product. That works through putaway rules, which set the suggested location on receipt. For extra flexibility, you can store a product across multiple warehouse locations, for example when the default location is full.
So you do not specify warehouse locations at import. You enter them when you post the stock quantities.
Product variants and product images
An import with product variants is a bit more involved. There is a separate guide for that: Importing products with variants.
To import product images, follow the guide Importing product images.
Need a hand with your import?
Stuck preparing your import file, or want a tailored template? Book an Odoo scan or get in touch - we will take a look with you.