NetSuite warranty SKUs
Add the SureBright warranty SKUs to Oracle NetSuite as non-inventory items for sale from the plan SKU CSV you download from the Merchant Portal, so plan sales from your store reconcile in NetSuite.
Use this page when you run Oracle NetSuite 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 that file into NetSuite once. From then on every plan line on an order that reaches NetSuite matches an item you already have, so orders import cleanly and plan revenue is reported on its own.
Menu paths below are from current NetSuite releases. Labels vary slightly by edition and by the roles and features enabled in your account. If a screen does not match, send SureBright a screenshot.
Who does what#
Everything you add is standard: non-inventory items, created with NetSuite's own CSV import. No existing item, workflow, chart of accounts or saved search is changed, and any SKU can be made inactive at any time.
Before you import#
Import the SKUs#
Open the Import Assistant
Go to Setup > Import/Export > Import CSV Records. Set Import Type to Items and Record Type to Non-inventory Item for Sale. Choose the CSV SureBright sent and set the character encoding to Unicode (UTF-8).
Choose Add
On Import Options select Add. Running it again later with Update changes prices without creating duplicates.
Map the columns
Then set default values for every row: your Income Account, your Tax Schedule if you use one, and Subsidiary in OneWorld accounts.
Run the import
Save the mapping so it can be reused, then click Run. Watch the job under Setup > Import/Export > View CSV Import Status and open the response file if any row failed.
Keep the plan items out of your web store and catalogue browsing. Shoppers add plans through the SureBright offer, not from a product page. If your account has web store fields on items, leave Display in Web Store cleared.
Verify the import#
Search items for the prefix SBW. Each one should be a non-inventory item for sale with the full SKU, the right price and your income account. 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 NetSuite 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.