To add products to your inventory using an Excel spreadsheet, you can follow these simple steps:
First, go to the 'Inventory - Products' section. Once you're there, locate and click on the 'Excel operations' button located in the top-right corner of the screen. From the drop-down list that appears, select the 'Upload from Excel' option.
Next, open your Excel spreadsheet and copy the relevant product data that you wish to import. Then, paste this information into the input field and click the 'Upload' button to confirm and complete the import process.
In the new window that opens, match the data with the table headers:
- Name on bill
- Wholesale cost
- Units of measurement for sale
- Units of measurement for write-off
- How much write-off items in the sale unit
- Critical balance
- Preferable minimum
Click the Save button.
Please keep in mind the following when uploading products:
You are limited to uploading no more than 1000 table rows at a time.
After the initial upload, each product will automatically be assigned a unique identifier (ID).