---
title: "Odoo warranty SKUs"
description: "Add the SureBright warranty SKUs to Odoo as service products from the plan SKU CSV you download from the Merchant Portal, so plan sales from your store reconcile in Odoo."
---

Use this page when you run Odoo and sell SureBright plans through an online store or point of sale that syncs orders into it. You download the warranty SKUs and their prices from the Merchant Portal as a CSV (see [Download your plan SKUs](/erp/download-plan-skus)). You load it into Odoo once. From then on every plan line on an order that reaches Odoo matches a product you already have, and nothing is reserved or delivered for it.

Field names below are from current Odoo versions. Some changed between versions; for example, the product type choices differ between Odoo 17 and later versions. If a screen does not match, send SureBright a screenshot.

## Who does what

| Step | Who | What happens |
|---|---|---|
| 1. Downloads the SKU CSV | You | **Products > Download plan SKUs** in the Merchant Portal. One row per SKU, UTF-8. |
| 2. Agrees the accounting | You, once | Pick the product category, income account and tax plan sales use. |
| 3. Imports the CSV | You | The SKUs become service products in Odoo. |
| 4. Matches orders | Your order connector | Plan lines on incoming orders map to these products by SKU. |

Everything you add is standard products, created with Odoo's own import. No existing product, category or account is changed, and any SKU can be archived at any time.

## Before you import

| Check | Why it matters |
|---|---|
| **The SKU format** | Each plan SKU encodes the plan length, region, coverage type and price band, for example `SBW-1U-CEAD-49999`. The same SKU must appear on your store's plan products, on each order's plan line and as the **Internal Reference** in Odoo. |
| **Product category** | Create a category for plans, for example `SureBright Plans`, whose income account is a dedicated one, for example `Warranty Income`. Agree it with your accountant. |
| **Tax** | Pick the customer tax your setup applies to service and warranty lines. |
| **How your connector matches products** | Most store connectors match order lines to products by **Internal Reference**. Confirm yours does. |

## Import the SKUs

<Steps>
  <Step title="Open the product list">
    In **Sales** (or **Inventory**), open **Products > Products** and switch to the list view.
  </Step>
  <Step title="Import the CSV">
    Open the **gear** menu (or **Favorites** in older versions) and choose **Import records**. Upload the CSV and set the encoding to **UTF-8**.
  </Step>
  <Step title="Map the columns">
    | CSV column | Odoo field |
    |---|---|
    | `InventoryID` | **Internal Reference** |
    | `Description` | **Name** |
    | `BasePrice` | **Sales Price** |

    Add columns to the CSV for the fields every plan shares, or set them afterwards in bulk from the list: **Product Type** = **Service**, **Product Category** = your plan category, **Customer Taxes** = your service tax, **Can be Sold** ticked, **Can be Purchased** cleared.
  </Step>
  <Step title="Test, then import">
    Click **Test** first. Odoo lists any row it cannot read without saving anything. When the test is clean, click **Import**.
  </Step>
</Steps>

If you run Odoo eCommerce, keep the plan products unpublished on the website. Shoppers add plans through the SureBright offer, not from a product page.

## Verify the import

Search products for `SBW` in **Internal Reference**. Each one should be a service product with the full SKU, the right price and your plan category. Count them: the number of products must equal the number of rows in the sheet. Then place a test order with a plan in your store and check that the plan line lands on the Odoo sales order against the matching product, with no delivery created for it.

## Troubleshooting

| Symptom | Cause and fix |
|---|---|
| A delivery order is created for the plan line | The product type is not **Service**. Change it on the plan products. |
| Revenue posts to the wrong account | The product category's income account points elsewhere. Fix it on the category. |
| Descriptions show mangled characters | The import ran with a non-UTF-8 encoding. Re-import with **UTF-8**. |
| Orders with a plan fail to import | The connector cannot find a product with the plan line's SKU. Compare the SKU on the order to the **Internal Reference** character for character. |

If an issue persists, send SureBright the error text, the SKU involved and a screenshot of the product.

## Related

- [Plans in your order tools](/learn/plans-in-your-order-tools#plan-skus-for-your-erp-or-3pl): what plan SKUs are and what to ask SureBright for.
- [Supported platforms](/platforms/overview#erp): every ERP SureBright works with.
