How to export your data from NetSuite

NetSuite is the most common cloud ERP we see people leaving, and it is well-behaved about it: several good export routes, all self-serve, no tickets to Oracle. The only real decisions are which route to use and how much of the catalogue is still alive.

1.Pin the cutover before you export anything

On-hand quantities are only true at an instant. Export stock on Monday, go live on Friday, and you have imported a week-old picture — every discrepancy afterwards gets blamed on the new system. Agree a freeze point, pull quantities after it, and either key the gap in by hand or reconcile with a cycle count on day one. Both are fine; drifting silently is not.

Whatever else you take, get these five things:

1. Item master, with the inactive flag included so you can filter rather than lose records.
2. On-hand quantity per item, as of a stated date and time.
3. Average cost per item — not last purchase price, if you can get both.
4. Customer and vendor master, with addresses and terms.
5. Open purchase and sales orders, if the cutover isn't on a quiet day.

2.Three routes, in the order worth trying them

Route A — Full CSV Export (fastest first look)

1. Sign in as a user with the Administrator role. This feature is Administrator-only.
2. Go to Setup → Import/Export → Export Tasks → Full CSV Export.
3. Select Items, Customers and Vendors.
4. The result downloads as a ZIP of CSV files.

Route B — Saved search (recommended)

This is the route when you want exactly the columns below and nothing else.

1. Lists → Search → Saved Searches → New, and choose Item as the record type.
2. On the Results tab, add the fields that map to the columns in §3.
3. On Criteria, filter to the item types you actually stock, and decide explicitly whether inactive items are in or out. Don't accept the default.
4. Save & Run, then Export → CSV from the results page.
5. Repeat with record type Customer, then Vendor.

Route C — SuiteAnalytics Connect (large accounts only)

ODBC, JDBC and ADO.NET access to NetSuite data — the most complete option available. It is also a paid add-on you must already own, and it times out on large tables, so pull in chunks. Only worth arranging when the catalogue is big enough that saved-search exports are genuinely failing. For most SMB migrations that never happens.

3.Field mapping into AegisSwift

4.Gotchas

Excel silently destroys long numbers

Internal IDs and UPCs of 16+ digits open in scientific notation and lose their tail. There is no warning and the damage is permanent in that file. Import the CSV through Excel's Text Import Wizard with those columns set to Text, or open it in LibreOffice. This is the single most common way a NetSuite export arrives broken.

Multi-location changes what "quantity" means

If you run several locations, quantity comes back per location. Decide up front whether AegisSwift launches with one consolidated balance or per-location stock, and sum or split accordingly — it is much cheaper to decide now than to unpick later.

One broken saved search fails the whole Full CSV Export

If the export errors out, look for a failing saved search somewhere in the account before assuming it's a permissions problem. The error rarely points at the real culprit.

Matrix and kit items expand into parent plus child records

Confirm which level you actually stock before importing both. Importing parents and children together is how a 4,000-item catalogue becomes 11,000 items.

5.What happens on our side

You upload two spreadsheets — items, and parties (customers and vendors) — and the importers match on sku and name, so a re-import updates rather than duplicates. Expect to import twice: once to see what breaks, once for real.

One accounting note. AegisSwift costs inventory on a moving average. Your opening cost column seeds that basis, which is why Average Cost is the better column to bring than Last Purchase Price. If your books use a different method the two won't agree penny-for-penny after the first receipt — worth telling your accountant before go-live, not after.

6.Questions people ask

Can I export my own data out of NetSuite?

Yes, by more than one route, and none of them need Oracle. Full CSV Export needs the Administrator role; saved searches give you precise control over the columns.

Why does my export have the wrong columns?

Because Full CSV Export follows the currently selected list view rather than the full record. Use a saved search and choose the columns explicitly.

How long does this take?

The exports are minutes. Building three saved searches and agreeing what counts as active is the real work — budget an afternoon, and expect to run the import twice.