Have a Question?

Categories

Contact us if you still have questions

Import New Inventory

What is Inventory?

Inventory is the stock levels you have of each herb, premix formula or product. It ONLY deals with how much you have of everything and tracks how you consume it.

 

 

This section deals with adding inventory/stock levels to your dispensary by uploading it in BULK. 

 

Generally when you first start your dispensary, its easier to upload your current stock levels all at once, instead of adding it one by one. 

 

For most dispensaries, they add it manually one by one when receiving new inventory on an ongoing basis.

How to Upload Inventory

 
Go to Admin > Settings > Data > Import New Data > Inventory

 

When you upload your inventory quantities/stock levels, the system needs to know which herb, premix formula or product to add the inventory to.   Each item in your dispensary has a unique ID associated with, which needs to be included in the upload file.   For this reason, we have created functionality to automatically create the file for you and all you need to do is add the lot number and quantity to the file.

 

On this page, you can create the CSV file by choosing the following 

 

Item Type
Herb Type
Name Type

 

Then click on the download button and the CSV file you need to use will be generated for you.    

 

 

Video Demonstration

 

 

Watch this demonstration to save yourself some headache when uploading Inventory / Stock amount.

 

 

https://youtu.be/F6OIY0zK0sc

Fill out CSV File

 
Open up the CSV file we just created and it will look similar to the example to your right.  
 
Column A shows you the item ID, which has been generated by the system.   Do not change this number and always ensure the product associated with this number stays constant.  If you need to sort the excel columns, make sure you sort all the columns and not just one or you will add stock amounts to the wrong item.  OOOPS!   
 
1.  Enter the Qty per Item you have on hand
 
2.  Enter the Lot# for the item.  If you do not have a lot number, you will need to make one up or it will not import properly.  
 
3.  If you have more than one lot number for an item, duplicate the row contents, ensuring the ID is the same, and enter the qty and lot number for the second lot.  

 

Remove Blanks

 
If there are items in the spreadsheet that do not have a qty, you need to remove these rows from your CSV sheet before you upload it.   The system will not allow items to be uploaded that do not have a quantity or lot number.   

 

Upload File

 
Go to Admin > Settings > Data > Import New Data > Inventory

 

 

where it says “Upload CSV File”  select the button “Choose File” and find the saved file on your computer. 

 

Review Data

 
Go to Admin > Settings > Data > Import New Data > Inventory

 

where it says “Upload CSV File”  select the button “Choose File” and find the saved file on your computer. 

 

The system will analyze your CSV file to ensure all the required information is there, and that all the ID’s exist in the system.   If everything is good, the screen will look completely white, and the “Confirm and Upload” green button will be shown at the BOTTOM of the screen.  

 

Click on “Confirm and Upload” and your data will be uploaded.  

 

You can check that the data was uploaded by going to Admin > Inventory > Inventory Levels

 

You can also check that the data was uploaded by going to Admin > Inventory > Inventory History