Help

Help›Settings›Data

Data

Reviewed Oct 29, 2026

View as Markdown
Words
TierEvery tier
SeatAny seat reads it
WhereSettings, under Tenant, the Data page

The question this page answers ​

Did my import complete, how do I fix refused rows, and where can I download data or manage custom fields?

What you see ​

Data, with Imports and Custom fields marked 1 and 2.
  1. Imports, files newest first with counts and who imported them.
  2. Custom fields, product and variant attributes and whether each is on.

The page has Imports, Exports and Custom fields.

Imports lists files newest first, with type, date, row counts, recorded and refused rows, and who imported them. Open a file to see its status and counts, download the original or failure report, resolve refused rows or retry a failed import. Running and unmeasured counts are identified separately.

Exports offers a template for each supported type. Current data can be downloaded for supplier overrides, suppliers, and products and variants. Sales orders and purchase orders offer templates only.

Custom fields lists product and variant attributes, their type, source, usage and whether they are on. Up to 50 fields can be on at once. Turn one off or delete one before adding another at that limit.

What to do ​

Product corrections retain their originating view. Return after the import receipt confirms success; partial or unconfirmed outcomes remain unresolved.

  1. Press Import, choose Type (what the file holds; each carries a Sample file), then Prepare: Update what Tightly holds, or I have my file ready.
  2. Press Upload for a .csv or .xlsx of up to 25 MB.
  3. Under Map, line up each Tightly field with a column from the file; a column is used once.
  4. Press Start import once every required field names a column.
  5. For sales orders, choose Import history before a connector cutover and set both dates to add history from before a connector started.
  6. Press Resolve the refused rows to upload corrected rows and map them again.
  7. Press Retry to re-run a failed import when its outcome is confirmed. An Unconfirmed outcome does not offer Retry.
  8. Press Add field, set Key, Description, Type and Grain (Product or Variant), then turn its switch on or off.

Start import reads "Map every required field to start." until every required field names a column, and once ready, "Once started, this import can’t be undone."

For sales orders, review how channels, accounts and locations match before importing. Sales must fall on or after History starts and strictly before Connector starts, in UTC; the importer checks mapped dates again when it runs. Resolving refused rows and retrying retain that original coverage; widening it requires a newly reviewed import. Keep the original order ID and variant code: re-importing the same sales line updates it. The date boundary prevents overlap with the connector period you declare; it does not automatically identify the same sale under unrelated connector IDs.

Quantity means positive whole ordered units before returns. Optional financial columns record gross sales excluding tax, discounts excluding tax, returns excluding tax, tax amount and historical unit cost. Map only evidence you have: a measured zero is different from an empty cell. Return amounts record refunded money, not returned units. Missing historical money or cost remains unmeasured in Finance; current catalogue prices or costs must not be treated as historical evidence.

The completion view names the file, its status and reported counts, with View import history as the next step. Processing means the file is still running. A completed import records its source rows; it does not confirm that forecast refresh has finished. Check the resulting sales and Finance figures, then the forecast after its refresh. Retry follows its status in Imports; neither it nor Resolve the refused rows should be treated as success until its result is shown.

An Unconfirmed product import may have saved changes even though its result could not be confirmed. Counts read Not confirmed. Open the file, use Download the file and View products, and compare saved products and prices with the original file before importing again. Retry, failure reports and refused-row resolution are withheld for this outcome. Viewing products does not automatically reconcile the import or clear its unconfirmed state.

A field's drawer shows its source, connection path, grain and usage. Edit your own field's description or delete it after reviewing the consequence: deletion removes it from variants, plans, views and saved columns. A connection-created field no longer filled by its connection offers Read only or Read and write access.

Members import, download current data and change fields. A read-only seat reads the tables, downloads templates, imported files and failure reports, and reads one reason beside the page's title: "Only a member can import or change fields." The Exports card tells it "Only a member can download your data." and drops its Current data column.

An empty import cell keeps the existing value.

When it is empty or failed ​

Use Try again if imports or custom fields fail to load. Empty tables show “No imports yet” or “No custom fields yet”. Upload CSV or XLSX files up to 25 MB. Custom-field refusals explain the problem beneath the form.

An import refusal appears above the mapping table. Read the specific reason before trying again; processing failures also retain their message in the completion view and import history. When asked to contact support, include the import ID.

For supplier overrides, keep subsidiary supplier preferences separate from warehouse delivery rows. A warehouse lead-time row uses the variant code, supplier and warehouse; leave subsidiary ID, connection ID, currency, preferred supplier and supplier enabled blank on that row. Update ERP-owned case-pack definitions in the source system; unchanged exported references may be retained.