a year ago
Bulk updating via import
You can update data on your account in bulk by importing CSV or Excel files using the same powerful features that are available in the new importer experience. The bulk update is enabled for these imports:
- Menu → Categories
- Inventory → Suppliers
In order to be able to use the bulk import, you can follow these steps:
- Export the data from your account
- Open the exported file and do the needed changes and save the file (make sure to keep the ID column as-is to update the records)
- Import the updates using the updated file
A few important things to keep in mind while using the importer:
The same file can be used for creating and updating your data:
- If the ID column is filled, the row will be updating the data for the existing record
- If the ID column is empty, the row will be creating the data for the existing record
Updating replaces the existing data with the new one, so if you need to keep something unchanged, then keep the data like it was when exported:
- For example, if the original value when exported is 5, it should remain 5 when importing to keep it unchanged, if it has any other value, it will have that new value instead of 5, if it’s empty, it will remove the 5 and have an empty value instead