Export locations when you need IDs, slugs, fulfillment flags, addresses, and phone numbers in a spreadsheet. Import creates new locations; update changes existing locations by ID. App-managed locations are included in the export for reference and are skipped on update.
Create imports
Create CSVs require: Name. The create CSV has no slug column — every new location gets a slug generated from its name automatically. Existing location names are skipped and reported. Fulfills Online Orders defaults to true when that column is blank, so a new fulfilling location must include a complete service address. Set Fulfills Online Orders to false for storage-only rows.
| Name | Fulfills Online Orders | Address Line 1 | Address Line 2 | City | State/Province | Postal Code | Country Code | Phone |
|---|---|---|---|---|---|---|---|---|
| Main Warehouse | true | 123 Market Street | Suite 4 | San Francisco | CA | 94105 | US | '+14155550100 |
Update imports
Update CSVs use the ID column from an export. The ID identifies which location each row updates. A blank Slug keeps the current slug, blank optional text fields clear their current value, and blank boolean fields keep their current value. Clearing address fields on a location that still fulfills online orders fails; set Fulfills Online Orders to false in the same row if the location should become storage-only. App-managed rows are skipped and reported rather than changed.
| ID | Slug | Name | Fulfills Online Orders | Address Line 1 | Address Line 2 | City | State/Province | Postal Code | Country Code | Phone |
|---|---|---|---|---|---|---|---|---|---|---|
| loc_01JZ8DFR4S8AVZ7GN9Y4YVJ9Q2 | main-warehouse | Main Warehouse | true | 123 Market Street | Suite 4 | San Francisco | CA | 94105 | US | '+14155550100 |
CSV file format
CSV files use UTF-8. Exports start with a byte order mark (BOM) so spreadsheet apps recognize the encoding, and imports accept files with or without one. A file with text that isn't valid UTF-8, such as one saved in another encoding, is rejected with the line of the first problem. Save it as UTF-8 (in Excel, CSV UTF-8) and upload it again.
A value that starts with =, +, @ or %, or with a tab or line break, is exported with an apostrophe in front so spreadsheet apps show it as text instead of running it as a formula. So is a value that starts with -, except a plain number such as -12.50, which stays a number. A value that really starts with an apostrophe is exported with a second one. Importing the file removes the added apostrophe, so these values come back unchanged.
A value that is exactly __CLEAR__ is also exported with an apostrophe in front, and so is none in a column where it clears a value, such as Quantity Pricing. On import it is read as that text, not as an instruction to clear a value. In other columns none is exported as it is.