Add your files
Three spreadsheets. Choose each one below — order doesn't matter.
The customer's request sheet — item numbers, colors, names, and store prices.
No file selected.
The full vendor/catalog sheet(s). You can pick more than one — all are searched by item number and color.
No file selected.
Your existing NetSuite item list. Matched rows keep their Internal ID and get updated prices.
No file selected.
Pricing & rules
Most people can leave these exactly as they are.
Size price add‑ons
| Size | Add‑on |
|---|
Base sizes not listed use a $0 add‑on. Change these only if a customer uses a different pricing rule.
Item‑specific add‑ons
Optional. These exact item/color/size rows are priced before the size table above — for one‑off pricing on specific products.
| Item number | Color | Size | Add‑on |
|---|
Build your import files
Creates the new‑item, price‑update, and review CSVs.
New items are split into one file per vendor (the catalog each item came from). Price updates and the review list are single files.
Summary
Unmatched colors
These items are in the catalog, but the ordered color name didn't match any catalog color. Pick the catalog color it should map to — the rows are rebuilt right away. Leave as — pick a catalog color — to keep it in Needs review.
Categories
Each new item is auto-assigned a NetSuite category from its name. Adjust any below before downloading — blank ones are highlighted. Changes apply to new.csv right away.