Retail items are any item that your facility sells to either tenants or walk-in customers as a one-time transaction, such as disc locks, boxes, soda, etc. Your facility-level Retail settings allow you to upload retail items to your software, make edits to retail items, and keep track of inventory.
Accessing your Retail items settings
Your software has two sets of Retail items settings. If you have more than one facility, your Corporate retail settings will allow you to edit multiple facilities at once. Your facility-level retail settings section lets you import multiple retail items via CSV for a single facility.
To access your facility’s retail items settings:
Click the Settings tab in the lower left of your screen.
Under the Billing section, click the Retail Items button. The retail items setting screen will appear.
Adding retail items to your software
To add a list of retail items:
-
Create a CSV file with 9 columns using a program such as Excel or Google Sheets. Each column header should match the image below, including case sensitivity:
There are 9 potential data points for each retail item entered in the CSV. Anything marked with an asterisk (*) is a required field in the CSV file.Column
Format for CSV file
Example
Product Code*
Text
Box - Large
Item*
Text
Box - Large 18x18x18
Quantity
Number
10
Price
Number
3.99
Tax Rate 1
Y or N
Y
Tax Rate 2
Y or N
N
Cost*
Number
0.79
Account Code*
Number
4201
Order Point*
Number
2
⚠ The Rate Columns need to have a Y or N to indicate whether or not the tax rate is applied to the item. Y=yes; N=No. The Account Code required in the CSV upload is the Internal Code found in Settings > Account Codes.
Click the + Upload CSV button.
Select the tax rates that will be used on the retail items. Having one or both tax rates set to 0% is acceptable, but two tax rates are required. For more information on setting up tax rates, visit the tax rates article.
Click the Choose File button to select the CSV file that is your list of retail items from your computer's hard drive.
Click the Upload button.
⚠ Using the Upload CSV process will only add new retail items. It will not update existing retail items. Additionally, remove all inches symbols (") or feet symbols (') from your CSV prior to import. Using these symbols will cause the import to fail.
Adjusting Retail Items
Adjusting retail items lets you change the quantity, price, and cost of an item. You will also need to specify a reason for the adjustment and can add a note about it.
To adjust a retail item:
Click the Adjust button on the line item you wish to adjust. A new screen will appear, allowing you to adjust the quantity, price, and cost per item.
Adjust Qty: Use this field to adjust the inventory for the selected item. This new amount will be added or subtracted from the current quantity.
New Price: Use this field to adjust the retail price of the selected item.
Cost Per Item: Use this field to adjust the wholesale cost of the selected item.
Reason: Choose a reason for the adjustment from the drop-down menu provided. Note that the reason must match the action being applied. For example, if you adjust the quantity by 5, you cannot enter Receive as the reason. If you are making more than one adjustment, choose Other.
Add note: Use this field to add a reason for the adjustment.
Click the Save button to confirm your adjustments.