Operators in British Columbia and Ontario, learn how to receive inventory using bulk inventory in Dutchie POS.
British Columbia: Log into your cannabis wholesale portal (British Columbia Cannabis Store) and download the Advanced Shipping Notice (ASN) in a .xml format.
Ontario: Log into your cannabis wholesale portal (Ontario Cannabis Store - OCS) and download the Advance Shipping Notice (ASN) as a .csv (Comma Separated Values) file.
Log onto Dutchie POS, and confirm you are in the appropriate live environment.
Upload a file
- Go to Products > Inventory.
- From the Source dropdown, choose Bulk CSV upload.
- Select Choose File, and select the ASN you want to upload.
- Select Import.
- You may be prompted with a window to Copy Products from the Provincial Catalog that doesn't yet exist in your Dutchie POS Catalog (i.e. new SKUs).
- You may be prompted with a window to Copy Products from the Provincial Catalog that doesn't yet exist in your Dutchie POS Catalog (i.e. new SKUs).
- Select Copy all.
- Please ensure you are updating your Retail Prices for the new products. *Remember this is done in the Catalog - you can also set location-specific pricing here.
- Fill out the required Receiving Details.
- Vendor - Select the BCLDB.
- Order Title - Defaults as Receive Upload & Date. Enter your ASN SO# and the date (best practice for searching and reviewing at a later date).
- Room - Select the room you want your inventory to go into.
- Scroll down to the list of products, select a product line, and a worksheet will appear.
- Ensure a Catalog Product entry has been associated with the Listed Product.
- Select the Package ID field and scan in the Package ID (long barcode = GTIN + Package Date + Batch/Lot).
- Do NOT scan the barcode on the case of the products. This will cause your products to not scan properly at the Point of Sale (POS).
- Select Save package.
- Repeat the process of connecting a catalog entry for all items with a warning symbol associated with them.
- Once done, Select Receive.
Troubleshooting tips
Tip #1: File types
Ontario:
- ASNs from the OCS need to be uploaded in a .csv format.
- The original file type the ASN often comes in is a .xls file, and this file type is not supported through the Bulk CSV Upload.
British Columbia:
- ASNs from the BCLDB must be uploaded in a .xml format.
- These files can be downloaded from your BCLDB account.
- Steps attached in page 2.
Troubleshooting Tip #2 (ON specific): FlowThru Order
- Is this a FlowThru Order?
- FlowThru Orders are formatted differently than your original Advanced Shipping Notice and need an extra column added before being uploaded.
- Please see this SOP specific for FlowThru orders:
- It is easiest to work with these files in Google Sheets.
Troubleshooting Tip: Advanced shipment notice
- Ensure that you are uploading your Advance Shipment Notice and not your Order Confirmation file.
- ASN and an Order Confirmation emails can look very similar and can sometimes be mistaken for one another. See below for the OCS email framework that has your ASN attached. Note: this is the email that operators receive after their order confirmation.