---
title: "SAP Business One warranty SKUs"
description: "Add the SureBright warranty SKUs to SAP Business One as non-inventory sales items from the plan SKU CSV you download from the Merchant Portal, so plan sales from your store reconcile in SAP Business One."
---

Use this page when you run SAP Business One 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 SAP Business One once. From then on every plan line on an order that reaches SAP Business One matches an item you already have.

Menu paths below are from current SAP Business One releases. They vary slightly between the SQL and HANA versions and by localisation. 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 item group and G/L accounts plan sales post to. |
| 3. Imports the sheet | You | The SKUs become sales items that are not inventory items. |
| 4. Matches orders | Your order connector | Plan lines on incoming orders map to these items by SKU. |

Everything you add is standard item master data, created with SAP Business One's own import tools. No existing item, price list or account is changed, and any SKU can be made inactive 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 **Item No.** in SAP Business One. |
| **Item group** | Create or pick an item group for plans, for example `SureBright Plans`, whose G/L accounts post to a dedicated revenue account. Agree it with your accountant. |
| **Price list** | Decide which price list carries the plan prices, usually your base sales price list. |
| **How your connector matches items** | Most store connectors match order lines to items by **Item No.** Confirm yours does. |

## Import the SKUs

<Steps>
  <Step title="Prepare the sheet">
    Keep one row per SKU with three columns: **Item No.** (`InventoryID`), **Item Description** (`Description`) and the price (`BasePrice`). Save it as a text file, tab separated, which is what the import expects.
  </Step>
  <Step title="Open Import from Excel">
    Go to **Administration > Data Import/Export > Data Import > Import from Excel**. Set **Business Object** to **Items**. Map the columns to **Item No.**, **Item Description** and the price list price, then choose the file.
  </Step>
  <Step title="Set the item flags">
    For the imported items, clear **Inventory Item**, keep **Sales Item** ticked and clear **Purchase Item**, and assign your plan **Item Group**. A plan has no stock to count, pick or receive. Your administrator can do this in the same import with the matching columns, or afterwards in **Item Master Data**.
  </Step>
</Steps>

For large catalogues your partner may prefer the **Data Transfer Workbench (DTW)**, using the **Items** template with the same fields.

## Verify the import

Open **Item Master Data** and search **Item No.** `SBW*`. Each item should have the full SKU, the right price, **Inventory Item** cleared and your plan item group. Count them: the number of items 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 sales order against the matching item.

## Troubleshooting

| Symptom | Cause and fix |
|---|---|
| Plan lines ask for stock or a warehouse | **Inventory Item** is still ticked on the item. Clear it. |
| Revenue posts to the wrong account | The item group's G/L accounts point elsewhere. Fix them on the item group. |
| Orders with a plan fail to import | The connector cannot find an item with the plan line's SKU. Compare the SKU on the order to the **Item No.** character for character. |

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

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