Skip to main content
Bulk Records: Items

Create and Update NetSuite Items from Excel

Create and update NetSuite items from Excel: inventory, non-inventory, service, kit and assembly items, in bulk.

Start Free TrialWatch Demo
What Teams Do With It

Items and merchandising in bulk, from Excel

Item lists are long and change often: a new product line, a vendor change, new descriptions for a catalog, reorder points after a season. Bulk Records puts the items you choose in an Excel sheet with the fields from your template, so a change across hundreds of items is a fill-down and an upload. Only the items you changed are sent, and anything NetSuite rejects is noted on the cell that caused it.

  • Load a new product line

    Add one row per SKU as a new inventory, non-inventory, kit or assembly item. Excel formulas can build names, descriptions and codes from your product list before anything goes in.

  • Update fields across many items

    Download the items to change, update any field your template includes, such as descriptions, preferred vendor or reorder points, and upload only the rows that changed.

  • Maintain item groups, numbers and revisions

    Item groups, inventory numbers and item revisions are record types of their own, so they can be listed, corrected and added from a sheet too.

  • Set up commerce data

    Commerce categories, coupon codes, promotion codes and merchandise hierarchy records load the same way, ready for a launch or a promotion.

Items and merchandising: every supported record type

30 record types that Bulk Records supports. Records with a line sublist are tagged with it.

Items

  • Assembly Item
  • Description Item
  • Discount Item
  • Download Item
  • Gift Certificate Item
  • Inventory Item
  • Inventory Number
  • Item Group
  • Item Revision
  • Kit Item
  • Markup Item
  • Non-Inventory Purchase Item
  • Non-Inventory Resale Item
  • Non-Inventory Sale Item
  • Other Charge Purchase Item
  • Other Charge Resale Item
  • Other Charge Sale Item
  • Payment Item
  • Service Purchase Item
  • Service Resale Item
  • Service Sale Item
  • Ship Item
  • Subtotal Item

Commerce

  • Commerce Category
  • Coupon Code
  • Merchandise Hierarchy Level
  • Merchandise Hierarchy Node
  • Merchandise Hierarchy Version
  • Promotion Code
  • Web Site

Instead of a CSV import

Update item records without exporting, editing and re-importing a CSV: download the items, change them in Excel and upload. Once a record is uploaded, its row links straight to that record in NetSuite, so checking it takes one click.

Bulk Records: a simpler alternative to CSV imports
Questions?

Items in Bulk Records: FAQ

Q
Can I import items into NetSuite from Excel?
Yes. Add a row for each new item, leaving Internal ID blank, and upload. Bulk Records creates the items in NetSuite and flags any value NetSuite rejects on its cell.
Q
Which item types are supported?
Inventory, non-inventory, service, other charge, kit, assembly, description, discount, download, gift certificate, markup, payment, ship, subtotal and item group items, plus inventory numbers and item revisions.
Q
Can I change just a few fields?
Yes. A template includes only the fields you chose, and an upload sends only the records you changed. Sublists the template has no columns for are left as they are.
Q
Can I add inventory, kit and assembly items in the same upload?
Each item type is its own record type, so each has its own template and sheet. Prepare them side by side in one workbook and upload each sheet.
Q
Are custom item fields included?
Yes. Templates can include your custom fields as columns, so they download and upload with the rest of the item.

Try Bulk Records with your own NetSuite data

30-day free trial with every Finsyte feature included. No credit card required.

Start Free TrialWatch Demo

More Bulk Records