Importing Items
This document serves as a comprehensive guide for importing items into the HirePOS system. It details the necessary prerequisites and the correct data format to ensure a seamless import process.
Prerequisites for Importing Items
Before initiating the import of items, it is crucial to complete the following steps and added the following mandatory fields to the import file:
Ensure a suitable Item Type exists in Setup > Item Related > Item Types. For more information on Item Types: https://docs.hirepos.com/en/articles/2306049
For Hire Item types an Item Quantity is required in the import file.
Ensure you have assigned a unique Item Code for every item. For more information on Item Code see here: https://docs.hirepos.com/en/articles/2334145#item_code
Ensure you have assigned a Description for every item.
Note: while not required for item creation, both Item Category and Item Sub-Category can be created during import. For existing Item Categories, the name must match exactly. For more information, see: https://docs.hirepos.com/en/articles/2306177
CSV Upload Guidelines
When preparing your CSV files for upload, adhere to the following guidelines:
Avoid commas, quotation marks, and line breaks in any field.
Prices should be in a fixed format with no commas or currency symbols, for example, 2345.50 and not $2,345.50.
Avoid special or unusual characters; stick to standard character sets.
Limit each CSV file to a maximum of 5,000 rows.
Save your spreadsheet as a .csv file ready for import.
Steps to Import
To import items, follow these steps:
Go to Setup > Items.
Click the Options button dropdown at the top-right.
Select Import Items CSV.
Browse for the items CSV file you prepared earlier.
Click the Preview Data button. Your data will upload, and a preview will be displayed.
Select the Import Mode, i.e. Add New or Update.
Match the columns from your CSV with the relevant columns in HirePOS.
For "Add New" mode the columns will be auto-matched if they are labelled identically.
For "Update" mode the matched columns will be cleared and you will need to manually choose the columns to be updated.Check and review the matching, then click the Import Data button located towards the bottom-left. The import will be completed, and you will be redirected back to the Items list screen.
