AI-Powered Bulk Import
Save time by bringing your existing inventory spreadsheet into Sortly as it is, with no prep work. Upload your file and Sortly Assistant matches your columns, creates any missing fields, and flags errors for you to review, all in one session. This article walks you through uploading your file, reviewing the field mapping, fixing errors, and completing your import.
In this article
How it works
Upload your existing spreadsheet as it is and Sortly Assistant does the heavy lifting. There's no reformatting, no template, and no prep work.
Here is what Sortly Assistant does for you:
- It matches your columns to Sortly fields. Sortly Assistant reads your column headers and works out what goes where, even when the names are different. For example, "Product Name" maps to "Item Name".
- It creates custom fields for you. If your file has columns that Sortly doesn't have a field for yet, Sortly Assistant creates them so nothing gets left behind.
- It spots and fixes errors. Sortly Assistant flags data issues and suggests fixes you can review and apply in one step.
- It works with imperfect files. If some rows still have issues, you can import the good ones now and come back to fix the rest later.
Who can use this feature
Owners and Admins can use AI-powered Bulk Import. Team Members and people with Limited Access can't.
Step 1: Upload your file
Step 2: Review field mapping
The Map Fields screen shows each Sortly field next to the column from your file that Sortly Assistant matched to it, plus a sample value. If Sortly Assistant created new custom fields for columns that didn't match an existing Sortly field, a blue banner appears at the top with a Review fields button.
Step 3: Preview and fix your data
The Preview Data screen shows all your items in a spreadsheet-style table. At the top you can see how many items are ready to import and how many have errors. Rows with errors won't be imported, so fix them here before you continue. Select Only show errors to see only the rows that need attention.
Edit a cell
Need to correct one or two values, such as a typo or a unit? You can edit any cell directly in the table.
Fix errors with Sortly Assistant
Have several errors to fix? Sortly Assistant can suggest a correction for each one so you can fix them all at once.
Step 4: Complete your import