> For the complete documentation index, see [llms.txt](https://docs.rishvi.co.uk/linnworks/llms.txt).
> Use it to discover all available pages before exploring further.
# Import products
The Odoo **Sales** app allows users to import products, including categories and variants, using a spreadsheet template compatible with Microsoft Excel, OpenOffice, Google Sheets, and similar software. Once correctly filled, this template can be uploaded to Odoo, making all products and their variants available in the product catalog within minutes.
## **Download template**
To start importing products:
1. Navigate to **Sales app ‣ Products ‣ Products**.
2. Click the **(Action)** icon in the upper-left corner of the page.
3. Select **Import records** from the drop-down menu.
4. On the next page, download the **Import Template for Products** link.
Open the spreadsheet to customize it.
## **Customize product import template**
When editing the template:
- Keep the **Internal Reference** column. While optional, unique identifiers (e.g., `FURN_001`) simplify updates and prevent duplicates.
- Do **not** rename existing column headers; Odoo requires them for automatic mapping.
- New columns may be added if the corresponding fields exist in Odoo. During import, columns that cannot be automatically matched can be manually mapped.
## **Upload and test spreadsheet**
1. Return to **Import records** in the **Products** page.
2. Click **Upload File** and select the completed spreadsheet.
3. Review all columns, map manually if needed, and click **Test**.
- If correctly mapped, Odoo shows a blue banner: **Everything seems valid**.
- If errors exist, a red banner displays instructions to fix them.
4. Once valid, click **Import**. The products are added, and a success pop-up confirms the number of products imported.
## **Import relation fields, attributes, and variants**
### **Relation fields**
Products are linked to categories, vendors, and other objects. Relation fields can only be imported if the related record exists in Odoo.
- Add the field name as a column header.
- Enter the desired relation for each product row.
- Upload the spreadsheet via **Sales app ‣ Products ‣ Products ‣ Import records**.
### **Attributes and values**
Attributes define variations like size or color. Upload attributes and values before applying them to products. Spreadsheet columns:
- **Attribute** – e.g., `Size`
- **Display Type** – `Radio`, `Selection`, or `Color`
- **Variant Creation Mode** – `Instantly`, `Dynamically`, or `Never`
- **Values / Value** – possible attribute values (one per line for multiple values)
Import via **Sales app ‣ Configuration ‣ Attributes ‣ Import records**.
### **Product variants**
Once attributes and values exist:
- Use columns **Name**, **Product Attributes / Attribute**, and **Product Attributes / Values** in the import spreadsheet.
- Multiple values in a cell should be comma-separated **without spaces** (e.g., `furniture,couch,home`).
After import, variants are visible and editable under **Attributes & Variants** in the product form.
**Example**
- **Customizable Desk** – Color: White, Black; Legs: Wood, Steel
- **Stool** – Color: Green, Navy; Seat: Leather, Wood