Sometimes it's a lot easier to make a lot of updates to your equipment data using your existing spreadsheet software, making the updates there and importing them back into CHEQROOM again.
Triggering updates instead of creating new items
- Upload your CSV like you normally would
- Map the CHEQROOM Id field, it's a random text like
Which fields can I update?
When importing Items from spreadsheet, you can import and update data in the following fields.
- Name (required – at least 3 characters)
- Purchase price
- Purchase date (formatted like 09/23/2016 )
- Barcode (between 4 and 24 alphanumeric characters)
- Custom fields you've set up
The following data cannot be updated by importing a spreadsheet yet:
- Kit - use the Bulk equipment update feature
- Category - use the Bulk equipment update feature
- Location - use the Bulk equipment update feature
- Reservation data
- Check-out data