Important: The importer is only intended to add new inventory to the system, it doesn't update existing inventory. Products with identical names as existing stock will be skipped.
To import a CSV or Excel file:
- Click Products from the main menu
- Click Import from the left sidebar
- Upload your file.
Note: The first line of your file should contain headers.
You can download a sample product CSV file to use as a template for creating your own. Remember to remove the example products.
Importing trackable and bulk products
Your products can be imported as bulk or individually trackable using one single spreadsheet.
To import trackable items of a product, create a row for each separate stock item. The items should have identical names, a quantity of 1, and a unique identifier (like a serial number).
Bulk items have no identifier and may have higher quantities.
Next, follow the steps to map your columns.
You can map additional columns after you completed the steps.
A name is needed for all products stored in Booqable.
Map an identifier to track products individually.
Determines the number of stock items in your inventory. Trackable stock items always have a quantity of 1.
Prices are imported as a flat rate (per day).
Tags (comma-separated) help you categorize your inventory.
SKU (Stock Keeping Unit)
A code that helps you to keep track of your inventory.
Padding time (in hours)
The time before and after each booking that the product remains unavailable for other bookings.
All barcodes are imported with as type Code 128 barcodes.
Description on documents
Product description for documents (you can list accessories here for example).
Description in Shop
Product description in your online store.
Any other information you map will be added as custom fields.