How to: Set up Warehouse Management

How to: Set up Warehouse Management

Before enabling Warehouse Management, please read through this guide completely. Multiple steps are required and misconfigurations may produce adverse effects. You must have Admin privileges to complete some tasks. 


Step A: Direct Sales Products

If you haven’t already done so, your account will require Direct Sales Products to be uploaded. Each LCBO and TBS product will need to have a linked Direct Product. DigThisData provides templates to batch import products (see: How to: Set Up Direct Sales Products and Customers) or alternatively, you can create products individually using the tools provided.

Step B: Enable Warehouse Management
  1. Navigate to Account Settings → Global Options.
  2. Toggle the Enable Orders Deplete Warehouse Stock pulldown to "Enabled Full" to use Warehouse Management for all channels including OnTap, or "Online Store Only" for OnTap integration only.

Step C: Link Retail Products to Direct Sales Products 

(Note: Only required if you would like to warehouse manage LCBO and/or TBS products)
The LCBO typically sells individual units, however, when sold and shipped to the LCBO, typically cases are used. This step enables DigThisData to determine how you warehouse and ship your products to the retail channel. Make certain that any LCBO or TBS SKU is linked to the appropriate shipping case size as defined in your Direct Sales Products.
  1. Navigate to Data → Manage Products.
  2. Select the Direct tab.
  3. Click on each product to spawn the edit window.
  4. If not already selected, select a corresponding LCBO and/or TBS product from the provided (LCBO Product/TBS Product) pull-downs.
  5. Click Save.

Step D: Enable Warehouse Management for Products
  1. For each channel (LCBO/TBS/Direct), select each product you would like to deplete warehouse inventory individually.
  2. Click on the Warehouse Stock Management: Enabled button at the top of the edit window.
  3. If successful, the “Enabled” button should turn green. If unsuccessful, follow Step C above to make sure the retail product is linked to a corresponding Direct Product. 
Note: Direct Products can be enabled without any linking.

Products that are not inventory products, such as discounts or keg deposits, can be left without enabling warehouse management. They will still be available to add to orders.

Step E: Warehouse Creation
  1. Navigate to Data → Manage Warehouses.
  2. Click the Add New button in the options panel.
  3. Fill in the required form fields and click Save. Note that Warehouse Codes must be unique.
  4. Repeat for additional warehouses.

Step F: Add Inventory to Warehouses
  1. Navigate to Data → Warehouse Inventory.
  2. Click the Add New button in the options panel.
  3. Select the desired warehouse from the pull-down menu and fill in the remaining form fields. Select New as the type.
  4. Once complete, click Save and confirm your inventory addition.

Step G: Assign Supply Warehouses to Retail Locations and Customers
  1. Navigate to Data → Configure Stores.
  2. Select a desired store.
  3. From the Supply Warehouse pull-down, select the desired warehouse that will service this location.
  4. Click Save.
You can select multiple locations by clicking the checkbox next to each location, and then clicking on the dark blue Batch Edit button in the options panel. Selecting the top-most checkbox will auto-select all locations in view.

The same process is used to assign warehouses to Direct Sales customers.
  1. Navigate to Data → Manage Customers.
  2. Select a desired customer.
  3. From the Supply Warehouse pull-down, select the desired warehouse that will service this customer.
  4. Click Save.
You can select multiple customers by clicking the checkbox next to each customer, and then clicking on the dark blue Batch Edit button in the options panel. Selecting the top-most checkbox will auto-select all customers in view.

Step H: Validate

Validate your changes by creating an order for a retail location or customer. The available warehouse inventory should be displayed and will update in real-time if another user creates an order with the same supply warehouse.
    • Related Articles

    • How to: Set Up and Configure Product Groups

      Product Groups are DigThisData's tool for creating custom product selections. Product Groups can be used as either a default setting, e.g. Core Products, Seasonals, etc. If using DigThisData for Order Management, they can be assigned directly to a ...
    • How to: Set up and Configure Call Days

      Call Days is DigThisData's basic Customer Relationship Management (CRM) application. Available to both Advanced and Premium plan users, it provides a way for sales teams to organize their week and store and share critical information for future ...
    • How to: Set up Direct Sales Products and Customers (UPDATED)

      UPDATED: Nov 23, 2023 DigThisData enables companies to manage and process orders for on-premise, licensee, and even grocery customers through the Direct Sales channel. Getting set up can take some effort, however once complete, DTD provides tools to ...
    • FAQ: My Products are not showing up on my order forms. What is causing this?

      There are several configurations that may cause this to happen: 1. If you use QuickBooks/Xero/Sage accounting Integrations: Check that your product has a valid Product Sync under Operations -> Product Management -> QuickBooks/Xero/Sage Product Sync ...
    • How to: Setup Shopify Integration

      The DigThisData Shopify App provides seamless integration from Shopify to DigThisData. Orders are automatically sent from Shopify to DigThisData for processing. Once within the DigThisData platform, modules such as warehouse management, accounting ...