Dynamics 365 Business Central warranty SKUs

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

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 posting group and tax group plan sales use.
3. Imports the sheetYouThe SKUs become non-inventory items in Business Central.
4. Matches ordersYour order connectorPlan 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#

CheckWhy it matters
The SKU formatEach 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 seriesIf 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 groupsPick a Gen. Prod. Posting Group that posts to a dedicated income account, for example Warranty Income. Agree it with your accountant.
TaxPick the Tax Group Code (or VAT product posting group) your setup applies to service and warranty lines.
How your connector matches itemsThe 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#

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

  2. Paste the rows

    Sheet columnBusiness Central field
    InventoryIDNo.
    DescriptionDescription
    BasePriceUnit 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.

  3. Publish

    Click Publish in the Excel add-in. Rows with an error stay highlighted with the reason; fix them and publish again.

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#

SymptomCause and fix
Items were created with generated numbers instead of SKUsThe 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 setupNo Gen. Prod. Posting Group or tax group on the row. Set them and publish again.
Orders with a plan fail to importThe 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.