Import products, components, and leads in bulk using CSV files.
Bulk Upload lets you import many records at once using a CSV spreadsheet file. Instead of creating products, components, or leads one by one, you can prepare your data in Excel or Google Sheets and upload everything in a single step.
Bulk Upload is available on the Products, Components, and Leads pages. Look for the Bulk Upload button next to the create button.
The easiest way to get started is to download the CSV template. Click Bulk Upload on any supported page, then click Download CSV template. The template includes:
Open the template in Excel, Google Sheets, or any spreadsheet app. The file is formatted to work correctly with these programs.
Replace the example row with your own data. Add as many rows as you need (up to 500 per upload). Each row becomes one record in your account.
Each entity type has a small number of required fields. If a required field is left blank, that row will not be imported.
You can leave optional fields blank and fill them in later from the detail page. Some fields have automatic defaults:
Some fields only accept specific values. Don't worry about capitalization — "active", "Active", and "ACTIVE" all work the same way.
Save your spreadsheet as a .csv file (in Excel: File > Save As > CSV). Then click Bulk Upload on the relevant page and either drag your file into the upload area or click to browse for it.
The file must be a .csv file, under 2MB, with no more than 500 data rows. Extra columns that don't match the template will be noted and safely ignored.
After uploading, AMS checks every row for errors. You'll see a summary showing how many rows are ready to import and how many have issues.
Common errors include missing required fields, invalid status values, and non-numeric values in number fields. Negative numbers are not allowed in cost and quantity fields.
If you have errors you want to fix, click Re-upload to go back and upload a corrected file. You can also continue with just the valid rows — the invalid ones will be skipped.
For fields like Category, Collection, Material, and Supplier, AMS compares your uploaded values against values already in your account. If it finds a close match, it will ask if you meant the existing value.
For example, if you type "Necklace" but you already have "Necklaces" as a category, AMS will ask: Did you mean "Necklaces"? You can choose to use the existing value or keep your new one.
This prevents duplicate entries like "Necklace" and "Necklaces" showing up separately in your filters and dropdowns. Exact matches with different capitalization (like "earrings" vs "Earrings") are corrected automatically.
If no similar values are found, this step is skipped entirely.
Before importing, AMS shows a confirmation with the number of records that will be created. Click Yes, Import to proceed. The import is all-or-nothing — either all valid rows are imported successfully, or none are (no partial imports).
For products with blank SKU fields, SKUs are automatically generated in sequence using your business's SKU prefix.
After a successful import, you'll see a summary of how many records were created. Click Done to close the modal — the table will refresh automatically to show your new records.
If some rows had errors and were skipped, the results screen offers a Download Failed Rows button. This downloads a CSV containing only the rows that failed, with an extra "Error" column explaining what went wrong in each one.
You can fix the issues in this file and upload it again to import the remaining records.