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

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

Page names below are from current Business Central releases. Use the search (the magnifier, or **Alt+Q**) to find a page by name. If a page 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 posting group and tax group plan sales use. |
| 3. Imports the sheet | You | The SKUs become non-inventory items in Business Central. |
| 4. Matches orders | Your order connector | Plan lines on incoming orders map to these items by SKU. |

Everything you add is standard: non-inventory items, created with Business Central's own Excel tools. No existing item, setup or posting configuration is changed, and any SKU can be blocked 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`. It is 17 characters, inside Business Central's 20-character limit for an item **No.** The same SKU must appear on your store's plan products, on each order's plan line and in Business Central. |
| **Item number series** | If your item **No.** comes from a number series without **Manual Nos.**, allow manual numbers for the import, or the SKUs are replaced with generated numbers. |
| **Posting groups** | Pick a **Gen. Prod. Posting Group** that posts to a dedicated income account, for example `Warranty Income`. Agree it with your accountant. |
| **Tax** | Pick the **Tax Group Code** (or VAT product posting group) your setup applies to service and warranty lines. |
| **How your connector matches items** | The Shopify connector and most other store connectors match order lines to items by SKU or item number. Confirm which field yours reads. |

## Import the SKUs

<Steps>
  <Step title="Open the Items list and Edit in Excel">
    Open **Items**, then **Edit in Excel**. Business Central opens the list in Excel with its add-in, so rows you add are published back as new items.
  </Step>
  <Step title="Paste the rows">
    | Sheet column | Business Central field |
    |---|---|
    | `InventoryID` | **No.** |
    | `Description` | **Description** |
    | `BasePrice` | **Unit Price** |

    On every row also set **Type** to **Non-Inventory**, **Base Unit of Measure** to `PCS` or the unit you use for services, your **Gen. Prod. Posting Group** and your **Tax Group Code**.
  </Step>
  <Step title="Publish">
    Click **Publish** in the Excel add-in. Rows with an error stay highlighted with the reason; fix them and publish again.
  </Step>
</Steps>

For a large catalogue, or if your administrator prefers it, a **Configuration Package** on the **Item** table does the same job.

## Verify the import

Filter **Items** on **No.** `SBW*`. Each one should be a non-inventory item with the full SKU, the right price and your posting 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 Business Central sales order against the matching item.

## Troubleshooting

| Symptom | Cause and fix |
|---|---|
| Items were created with generated numbers instead of SKUs | The item number series does not allow manual numbers. Turn on **Manual Nos.**, delete the generated items and publish again. |
| A row will not publish because of posting setup | No **Gen. Prod. Posting Group** or tax group on the row. Set them and publish again. |
| 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 card.

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