CSV import tool for orders, customers, and inventory
Import your operational history from a CSV file: a mapping wizard checks column headers, previews rows and imports the data safely.
In short
The CSV import tool in StoreChart allows businesses to migrate historical orders, customer directories, and product catalogs from previous systems or spreadsheets smoothly. The step-by-step wizard parses file headers, enables flexible field mapping, previews records, and validates data formats to prevent duplicates and syntax errors prior to database import.
Import from Excel / CSV into StoreChart
Upload CSV files step by step; each is checked before saving.
- Import customers, products, orders and order items, each type in its own step.
- Each step has a downloadable sample file with the right columns.
- Files are checked before writing, and errors are shown before anything is saved.
- Especially useful for a first migration from another system or an existing spreadsheet.
Import data in four steps
From a sample file to the import summary.
Choose a store, and for each step (customers, products, orders and order items) download a sample file with the columns StoreChart expects.
Copy your data into the template, save it as CSV and upload it. Save Excel files as CSV before uploading; the delimiter (comma, semicolon or tab) is detected automatically.
StoreChart shows a preview and checks the file before anything is written, so you can fix the file and upload it again.
At the end you see how many records were created and how many were skipped, for example orders that already exist by order number or products with an existing SKU.
CSV import and export
Import
Customers, products, orders and order items go into the store you choose, each type in its own step.
Export
Export your orders list and your customers list to a CSV file that opens in Excel, based on the filters you've applied.
Sample files
Each step has a sample file with the right columns, so you don't have to guess the structure.
Validation
Every file is checked before anything is saved, and errors are shown so you can fix the file and upload it again.
Duplicate skipping
Orders are identified by order number and products by SKU, and a record that already exists is skipped, so importing the same file twice doesn't create duplicates.
Customer matching
Customers on orders are matched by phone first and email second, so a returning buyer isn't created twice.
Excel / CSV import: moving to StoreChart
The import order
CSV import is most common in a store's first week on StoreChart, when data moves over from a spreadsheet, a legacy system or a platform with no direct connection. The wizard runs in steps, and the order matters:
- Customers
- Products
- Orders
- Order items
That way each order links to the right customer and products.
Validation before import
- Sample file: one per step, with the right columns.
- Preview: see your file before importing.
- Validation: problems surface before anything reaches the system.
- Excel files: save as CSV before uploading; the delimiter is detected automatically.
- Large files: split by date range so each import is checked separately and a problem row is easy to find.
Duplicates and existing records
During a migration it's common to upload the same file twice or export overlapping date ranges from an old system.
- Orders: identified by order number, and an existing order is skipped.
- Products: identified by SKU, and an existing product is skipped.
- Customers: matched by phone first, then email, so a returning buyer attaches to their existing record.
- No updates: imports don't update existing records. Change an existing product's price or stock in the products and inventory screens.
CSV export
In the other direction, data goes out to a file that opens in Excel.
- What you can export: your orders list and customers list, based on your filters.
- What it's for: backups, your accountant or spreadsheet analysis.
- Not included: products and stock can't be exported from this tool today.
Frequently asked questions
Which file formats are supported?
CSV files. Save Excel files as CSV before uploading; the delimiter, comma, semicolon or tab, is detected automatically.
Is there a limit on file size?
Large files are supported, but for very large catalogs or histories it's best to split the data into several files by date range or category, so each import is checked separately and errors are easy to find.
What happens if there's an error in the file?
StoreChart shows the errors before anything is saved, so you fix the source file and upload it again without bad data being written to the system.
Can I export data to a file?
Yes, your orders list and your customers list, based on the filters you've applied, to a CSV file that opens in Excel. Products and stock can't be exported from this tool today.
What if I import the same file twice?
Orders are identified by order number and products by SKU, so a record that already exists is skipped rather than created twice. It's safe to upload a file again after fixing errors.
How do I migrate a large product catalog?
Import in order: customers and products first, then orders and order items, so every order links to its customer and products. For a very large catalog, split the data into several files.
Can an import update existing prices or stock?
No. Imports create new records and skip what already exists, such as a product with the same SKU. Updating existing products is done in the products and inventory screens.
Import your first data
Download a sample, fill it in and upload. StoreChart checks it first.
