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#
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#
Import the SKUs#
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.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.
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#
If an issue persists, send SureBright the error text, the SKU involved and a screenshot of the item.
Related#
Plans in your order tools: what plan SKUs are and what to ask SureBright for.
Supported platforms: every ERP SureBright works with.