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#

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 income account and tax schedule plan sales post to.
3. Imports the CSVYouThe SKUs become non-inventory items for sale in NetSuite.
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 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#

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 the plan line of each order and in NetSuite, or orders will not reconcile.
The income accountUse a dedicated account, for example Warranty Income, so plan revenue stays separately reportable. Agree it with your accountant.
TaxIf you use tax schedules, pick the one your tax setup applies to service and warranty lines.
How your connector matches itemsMost Shopify, BigCommerce and other store connectors match order lines to NetSuite items by SKU (Item Name/Number). Confirm yours does, and which field it reads.

Import the SKUs#

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

  2. Choose Add

    On Import Options select Add. Running it again later with Update changes prices without creating duplicates.

  3. Map the columns

    CSV columnNetSuite field
    InventoryIDItem Name/Number
    DescriptionDisplay Name/Code and Sales Description
    BasePriceBase Price (Pricing)

    Then set default values for every row: your Income Account, your Tax Schedule if you use one, and Subsidiary in OneWorld accounts.

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

SymptomCause and fix
A row fails with an account or tax errorNo default Income Account or Tax Schedule was set in the mapping. Add them and re-run that row.
Descriptions show mangled charactersThe import ran with a non-UTF-8 encoding. Re-run with Unicode (UTF-8).
Orders with a plan fail to import into NetSuiteThe connector cannot find an item with the plan line's SKU. Compare the SKU on the order to the Item Name/Number character for character.
Duplicate plan items appearThe import was re-run with Add instead of Update. Make the duplicates inactive.

If an issue persists, send SureBright the error text, the SKU involved and a screenshot of the item.