---
title: "NetSuite warranty SKUs"
description: "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](/erp/download-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

| Step | Who | What happens |
|---|---|---|
| 1. Downloads the SKU CSV | You | **Products > Download plan SKUs** in the Merchant Portal. One row per SKU, UTF-8. |
| 2. Agrees the accounting | You, once | Pick the income account and tax schedule plan sales post to. |
| 3. Imports the CSV | You | The SKUs become non-inventory items for sale in NetSuite. |
| 4. Matches orders | Your order connector | Plan 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

| Check | Why it matters |
|---|---|
| **The SKU format** | Each 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 account** | Use a dedicated account, for example `Warranty Income`, so plan revenue stays separately reportable. Agree it with your accountant. |
| **Tax** | If you use tax schedules, pick the one your tax setup applies to service and warranty lines. |
| **How your connector matches items** | Most 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

<Steps>
  <Step title="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)**.
  </Step>
  <Step title="Choose Add">
    On **Import Options** select **Add**. Running it again later with **Update** changes prices without creating duplicates.
  </Step>
  <Step title="Map the columns">
    | CSV column | NetSuite field |
    |---|---|
    | `InventoryID` | **Item Name/Number** |
    | `Description` | **Display Name/Code** and **Sales Description** |
    | `BasePrice` | **Base Price** (Pricing) |

    Then set default values for every row: your **Income Account**, your **Tax Schedule** if you use one, and **Subsidiary** in OneWorld accounts.
  </Step>
  <Step title="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.
  </Step>
</Steps>

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

| Symptom | Cause and fix |
|---|---|
| A row fails with an account or tax error | No default **Income Account** or **Tax Schedule** was set in the mapping. Add them and re-run that row. |
| Descriptions show mangled characters | The import ran with a non-UTF-8 encoding. Re-run with **Unicode (UTF-8)**. |
| Orders with a plan fail to import into NetSuite | The 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 appear | The 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.

## Related

- [Plans in your order tools](/learn/plans-in-your-order-tools#plan-skus-for-your-erp-or-3pl): what plan SKUs are and what to ask SureBright for.
- [Supported platforms](/platforms/overview#erp): every ERP SureBright works with.
