Your rental inventory can be entered manually or uploaded via spreadsheet. In cases where you have a large inventory to upload, the most efficient way to upload your inventory is via spreadsheet, especially if you already have the information contained in a spreadsheet.
If you need to update, add to, or replace your existing inventory, Click Here for details.
In this article, we will discuss how to upload your rental inventory via spreadsheet.
Preparing the Spreadsheet:
Before uploading the spreadsheet of your rental inventory, make sure it meets the following requirements:
Spreadsheets must be in XLS, XLSX, or CSV format.
Spreadsheets must have only one worksheet.
The first row must have column headings (e.g., Tracking Id, Dexterity, Type, Set Composition, Additional Details).
Each row should only have the data for one rental.
If you wish to utilize the dexterity, type, and set composition field, you must set the KIND to "Rental Set" for that row.
Below is a screenshot of an acceptable spreadsheet.
When compiling the spreadsheet, you should include:
Tracking ID: This ID (must be unique) is displayed in the rental selector when checking out a rental, so it is important that the item can be easily identified by the Tracking ID. If you do not include Tracking IDs in the spreadsheet, they will be generated for you after the upload.
Kind: If multiple rental types are being entered into the inventory, this field should be included to identify the item type. If left blank, they will be considered general items. Note: The Kind "Rental Set" is the only KIND to utilize the dexterity, flex, and set composition fields.
Uploading the Spreadsheet:
Once the spreadsheet is prepared for upload, follow these instructions:
Go to Services > Rentals > Inventory.
Click "Choose File" and select the spreadsheet from your computer.
Click "Import Spreadsheet".
Match your columns with our system attributes. Some (or all) columns will automatically be matched (as shown below).
Below the columns that were automatically matched, you can manually match unmatched columns by selecting our attribute that matches your column. In the example below, the "Additional Details" column is being matched with our "Additional Details" attributes.
If your column does not have an appropriate attribute to match with, it will be skipped.
Once all of your columns have been matched, click "Import Spreadsheet," and your inventory will be uploaded.
