Create and Update NetSuite Items from Excel
Create and update NetSuite items from Excel: inventory, non-inventory, service, kit and assembly items, in bulk.
Screen recording in Excel with on-screen callouts. On the Finsyte ribbon, Record Edit opens a menu with Budget, Journal Entry, Intercompany Journal Entry and Bulk Records, and the Bulk Records submenu lists the saved templates by record type. Callout: Record Edit › Bulk Records › Opportunities. Opportunities is clicked. Callout: A Bulk Records sheet for Opportunities. An Opportunities sheet is inserted, with body field columns (Date Created, Opportunity #, Company, status, Probability), item line columns (Line ID, Item, Quantity, Rate, Price Level) and a Status column. Start is set to 6/1/2026. Callout: Set the date range to download. End is set to 7/31/2026, filtering on Date Created. Download Opportunities is pointed at. Callout: Download pulls the records in. The banner reads Download in progress, then Download complete, 7 records. Callout: Every matching record, ready to edit. The sheet holds 7 opportunities, OPP68 to OPP74, with their 10 item lines. The quantity of Welding Regulator Gauge on OPP70 changes from 5 to 3. Callout: Edit them like any Excel data. The quantity of 25 HP Rotary Vacuum Pump on OPP73 changes from 2 to 1, and SAF200 on OPP68 from 20 to 15. Add/Edit Opportunities is pointed at. Callout: Add/Edit uploads the changes. The banner counts processing 0 of 3 to 3 of 3, then reads Upload complete, 3 updated. Callout: Each row reports what happened. The Status column reads Updated Opportunity OPP70 on both of its lines, Updated Opportunity OPP73 and Updated Opportunity OPP68, where NetSuite set the SAF200 rate to 460; the other rows read Skipped (no changes). Pointing at Updated Opportunity OPP68 shows its link to the record in NetSuite. Callout: Each row links to its record.
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 importsItems in Bulk Records: FAQ
- QCan 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.
- QWhich 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.
- QCan 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.
- QCan I add inventory, kit and assembly items in the same upload?
- Prepare them side by side in one workbook and upload each sheet. Each item type is its own record type, with its own template and sheet.
- QAre 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.