Data Import allows you to upload and update important operational data in bulk. Instead of editing products, suppliers, or purchase orders one by one, you can prepare a spreadsheet and import multiple records at once.
This feature is useful when you want to:
Update supplier information for multiple products
Fill missing replenishment data such as MOQ or lead time
Add new suppliers or update their contact details
Import purchase orders created outside of Tightly
Where to Access Data Import
You can access Data Import from the settings section.
Navigation path
Settings → Organization → Data Management → Data Import
Or open directly:
From this page you can:
Start a new import
Monitor existing imports
Download uploaded files
Review and fix import errors
Starting a New Import
Click Import New Data to begin.
A modal will open with the following steps:
Select Type
Prepare File
Upload File
Map Fields
Start Import
Supported Import Types
Tightly currently supports importing the following data types:
Variant Details
Suppliers
Purchase Orders
Each type has a slightly different preparation process.
Importing Variant Details
Importing Variant Details
Variant Details import allows you to update replenishment-related data for product variants.
Typical use cases include:
Adding missing MOQ values
Updating lead time
Adding or correcting unit cost
Updating batch size
Supported Fields
Field | Required | Description |
SKU | Yes | Used to identify the variant |
Supplier Name | Yes | Used to identify the supplier |
MOQ | No | Minimum order quantity |
Lead Time | No | Supplier lead time |
Unit Cost | No | Cost per unit |
Batch Size | No | Order batch size |
Supported file formats:
CSV
XLSX
Step 2: Prepare File
For Variant Details imports you can choose one of two options.
Option 1: I already have my file ready
Choose this option if you already prepared your spreadsheet outside of Tightly.
You can proceed directly to the upload step.
Option 2: Update my current data (Recommended)
This option allows you to export your existing data and update it easily.
You will see your current variant data and available columns.
You can also filter the export by:
Supplier
Variants with missing fields only
Example use cases:
Export only variants for a specific supplier
Export only variants with missing fields.
Once configured:
Download the exported file
Fill or edit the data and make it ready to upload back.
Step 3: Upload File
Upload your completed spreadsheet using the upload area.
Step 4: Column Mapping
Tightly automatically maps the uploaded columns to system fields.
If column names differ, you can manually map them.
When you're done, click Start Import to begin processing.
The import job will appear on the Data Import page, where you can track its progress.
Import Behavior
Each variant–supplier combination is exported as a separate row.
Supplier matching is case-sensitive.
Example:
ACME ≠ Acme
If a cell is empty in the uploaded file, the existing value will remain unchanged.
Skipped Records
The following rows will be skipped and reported as errors:
Duplicate rows
SKUs that do not exist
Suppliers that do not exist
Skipped rows will appear in the error report.
Importing Suppliers
Importing Suppliers
Supplier import allows you to create new suppliers or update existing supplier records in bulk. This includes basic supplier information, operational details, and contact information.
Typical use cases include:
Creating multiple suppliers at once
Updating supplier lead times or minimum order values
Adding supplier contact information
Updating supplier location or currency information
Supported Fields
Field | Required | Description |
Supplier Name | Yes | Used to identify and match suppliers |
City | No | Supplier city |
Country | No | Supplier country |
Zip Code | No | Supplier postal code |
Currency | No | Supplier currency |
Minimum Order Value (MOV) | No | Minimum order value required by the supplier |
Lead Time (Days) | No | Supplier lead time |
Contact Name | No | Supplier contact person |
No | Contact email | |
Phone | No | Contact phone number |
Preferred Contact Method | No | Preferred communication method |
Supported file formats:
CSV
XLSX
Step 2: Prepare File
For Supplier imports you can choose one of two options.
Option 1: I already have my file ready
Choose this option if you already prepared your spreadsheet outside of Tightly.
You can proceed directly to the upload step.
Option 2: Update my current data
This option allows you to export your existing supplier data and update it easily.
You will see your current supplier records and available columns.
You can filter the export by selecting specific suppliers or exporting only records with missing fields.
Once configured:
Download the exported file
Fill or update the necessary fields
Upload the updated file back to Tightly
Step 3: Upload File
Upload your completed spreadsheet using the upload area.
Step 4: Column Mapping
Tightly automatically maps uploaded columns to system fields.
If column names do not match exactly, you can manually adjust the mapping.
When mapping is complete, click Start Import to begin processing.
The import job will appear on the Data Import page, where you can monitor its progress.
Import Behavior
Supplier matching is case-sensitive.
Example:
ACME ≠ Acme
The Supplier Name column is used to match existing suppliers.
If a supplier already exists, the uploaded values will override the current data for that supplier.
Skipped Records
The duplicate rows will be skipped and reported as errors.
Skipped rows will appear in the error report.
Importing Purchase Orders
Importing Purchase Orders
Purchase Order import allows you to create purchase orders in bulk by uploading structured order data.
Typical use cases include:
Importing purchase orders created outside of Tightly
Migrating purchase order data from another system
Creating large purchase orders for multiple SKUs at once
Supported Fields
Field | Required | Description |
PO ID | Yes | Unique identifier of the purchase order |
Supplier Name | Yes | Supplier for the purchase order |
Warehouse | Yes | Destination warehouse |
SKU | Yes | Product variant identifier |
Ordered Qty | Yes | Quantity ordered |
Expected Delivery Date | Yes | Expected delivery date |
Unit Cost | No | Cost per unit |
Supported file formats:
CSV
XLSX
If Unit Cost is not provided, Tightly will automatically use the stored unit cost.
Step 2: Prepare File
For Purchase Order imports you can choose one of two options.
Option 1: I already have my file ready
Choose this option if you already prepared your spreadsheet outside of Tightly.
You can proceed directly to the upload step.
Option 2: Download Template
You can download a template file containing the required columns for purchase order import.
Fill the template with your purchase order data and upload it back to Tightly.
Step 3: Upload File
Upload your completed spreadsheet using the upload area.
Step 4: Column Mapping
Tightly automatically maps uploaded columns to system fields.
If column names differ from the system fields, you can manually adjust the mapping.
Once mapping is complete, click Start Import to begin processing.
The import job will appear on the Data Import page, where you can track its progress.
Import Behavior
Each PO ID creates a purchase order.
Rows with the same PO ID are grouped into the same purchase order.
Supplier Name and Warehouse must remain consistent for all rows within the same PO ID.
Matching is case-sensitive.
Example:
PO-123 ≠ po-123
ACME ≠ Acme
Main Warehouse ≠ main warehouse
If Unit Cost is not specified for a SKU, the system will automatically use the stored unit cost.
Skipped Records
The following rows will be skipped and reported as errors:
Purchase orders with an existing PO ID
Suppliers that do not exist in the system
Warehouses that do not exist in the system
Rows with the same PO ID but different warehouse–supplier combinations
Duplicate rows
Skipped rows will appear in the error report.
Monitoring Imports
All import jobs appear on the Data Import table.
Each import displays the following information:
Import ID
Date Created
Import Type
Uploaded File (downloadable)
User
Status
Imported Rows
Errors
Status
An import job can have the following statuses:
In Progress - import job is still in progress.
Completed - it's competed, you can check the Errors column to find out if there's any errors detected.
Failed - the import job is failed and none of the rows being ingested.
Handling Import Errors
If rows fail during import, the Errors column will show the number of failed rows.
Click the arrow icon to open the error report.
You can download a file containing:
The rows that failed
A failure_reason column explaining the issue
Example reasons:
SKU not found
Supplier not found
Duplicate row
Invalid PO configuration
Fixing and Re-Uploading Errors
You can correct failed rows directly from the error report.
Process:
Download the error report
Fix the issues in the file
Click Continue
Upload the corrected file
Map fields if necessary
Start the import again
Once an action is taken on the error report, the error indicator changes from red to gray, showing that the issue has been addressed.
