SAP Business One warranty SKUs

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

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 item group and G/L accounts plan sales post to.
3. Imports the sheetYouThe SKUs become sales items that are not inventory items.
4. Matches ordersYour order connectorPlan 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#

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 Item No. in SAP Business One.
Item groupCreate 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 listDecide which price list carries the plan prices, usually your base sales price list.
How your connector matches itemsMost store connectors match order lines to items by Item No. Confirm yours does.

Import the SKUs#

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

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

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

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#

SymptomCause and fix
Plan lines ask for stock or a warehouseInventory Item is still ticked on the item. Clear it.
Revenue posts to the wrong accountThe item group's G/L accounts point elsewhere. Fix them on the item group.
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.