Odoo warranty SKUs

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). 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#

StepWhoWhat happens
1. Downloads the SKU CSVYouProducts > Download plan SKUs in the Merchant Portal. One row per SKU, UTF-8.
2. Agrees the accountingYou, oncePick the product category, income account and tax plan sales use.
3. Imports the CSVYouThe SKUs become service products in Odoo.
4. Matches ordersYour order connectorPlan 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#

CheckWhy it matters
The SKU formatEach 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 categoryCreate a category for plans, for example SureBright Plans, whose income account is a dedicated one, for example Warranty Income. Agree it with your accountant.
TaxPick the customer tax your setup applies to service and warranty lines.
How your connector matches productsMost store connectors match order lines to products by Internal Reference. Confirm yours does.

Import the SKUs#

  1. Open the product list

    In Sales (or Inventory), open Products > Products and switch to the list view.

  2. 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.

  3. Map the columns

    CSV columnOdoo field
    InventoryIDInternal Reference
    DescriptionName
    BasePriceSales 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.

  4. Test, then import

    Click Test first. Odoo lists any row it cannot read without saving anything. When the test is clean, click Import.

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#

SymptomCause and fix
A delivery order is created for the plan lineThe product type is not Service. Change it on the plan products.
Revenue posts to the wrong accountThe product category's income account points elsewhere. Fix it on the category.
Descriptions show mangled charactersThe import ran with a non-UTF-8 encoding. Re-import with UTF-8.
Orders with a plan fail to importThe 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.