Toolio offers you to set a specific Minimum Display Quantity (MDQ) for your all sizes per Style Color and lets you create a Purchase Order (PO) which includes direct to store shipments for these MDQs. As a final product your PO includes to warehouse as well as to store items.
Use case:
You want your stores to always maintain a MDQ no matter what you'd receive in the warehouse
Note: If you want to learn more on how to enable Applying MDQ Constraints on your account, please get in touch with your Customer Success manager.
Please see below on how to configure and set MDQs and generate POs according to these specifications.
Configuring your Locations
First, you need to configure which locations will apply MDQ as you may not want to define MDQ for your online channels such as your e-commerce site, Amazon, Walmart, etc.
Go to
Master Data > Location
Set Supports MDQ to true for the locations which will receive MDQ, and set false for locations will not receive MDQ like your e-commerce site.
Setting MDQs and Generating POs on Assortment Plan
Go to any view you like and make sure you have enabled MDQ as an attribute on this view.
Enter the MDQ for the Style-Color, Cluster Group and Size Scale
Select the PO Strategy for the Style-Color
For MDQ to be applied, select MDQs to Destination Remainder to Store option
Otherwise, select POs to Source option
Select the Style-Colors which will be included in your PO.
Note that, Toolio lets you generate POs only if they have the same PO Strategy type.
Then right click on the grid, select
Generate Purchase Orders > Toolio CSV
or other options to push to Netsuite (note that Netsuite will be enabled soon)The PO CSV will be downloaded to your device.
NOTE: Applying MDQ Profiles Constraints will be available in future iterations in 2023.
Understanding your POs
For Size 10 M, at Location 1, MDQ is set to 1 and BOP units at the store is 1, therefore 0 is sent to the store, and all 6 planned receipts will be sent to the Warehouse
For Size 10 M, at Location 6, MDQ is set to 1 and BOP units at the store is 0, therefore 1 is sent to the store, and other 3-1=2 planned receipts will be sent to the Warehouse
For all sizes, at Location Amazon, Amazon FBA, Walmart, .com, eBay, MDQ is set 0 as we configured at step 1, that these channels will not receive any MDQs.
SKU | Full Size | Location Name | Receipts Units | MDQ | Gross Sales Units | BOP Units | Final Receipts |
183005-WHT-10 M | 10 M | 1 | 6 | 1 | 6 | 1 | 0 |
183005-WHT-10 M | 10 M | 2 | 11 | 1 | 13 | 1 | 0 |
183005-WHT-10 M | 10 M | 4 | 6 | 1 | 6 | 1 | 0 |
183005-WHT-10 M | 10 M | 5 | 11 | 1 | 13 | 1 | 0 |
183005-WHT-10 M | 10 M | 6 | 3 | 1 | 3 | 0 | 1 |
183005-WHT-10 M | 10 M | 7 | 3 | 1 | 3 | 0 | 1 |
183005-WHT-10 M | 10 M | Amazon | 14 | 0 | 16 | 1 | 0 |
183005-WHT-10 M | 10 M | Amazon FBA | 14 | 0 | 16 | 1 | 0 |
183005-WHT-10 M | 10 M | .com | 6 | 0 | 6 | 1 | 0 |
183005-WHT-10 M | 10 M | Walmart | 14 | 0 | 16 | 1 | 0 |
183005-WHT-10 M | 10 M | eBay | 14 | 0 | 16 | 1 | 0 |
183005-WHT-6 M | 6 M | 1 | 3 | 1 | 3 | 0 | 1 |
183005-WHT-6 M | 6 M | 2 | 6 | 1 | 6 | 1 | 0 |
183005-WHT-6 M | 6 M | 4 | 3 | 1 | 3 | 0 | 1 |
183005-WHT-6 M | 6 M | 5 | 6 | 1 | 6 | 1 | 0 |
183005-WHT-6 M | 6 M | 6 | 1 | 1 | 2 | 0 | 1 |
183005-WHT-6 M | 6 M | 7 | 1 | 1 | 2 | 0 | 1 |
183005-WHT-6 M | 6 M | Amazon | 7 | 0 | 8 | 1 | 0 |
183005-WHT-6 M | 6 M | Amazon FBA | 7 | 0 | 8 | 1 | 0 |
183005-WHT-6 M | 6 M | .com | 3 | 0 | 3 | 0 | 0 |
183005-WHT-6 M | 6 M | Walmart | 7 | 0 | 8 | 1 | 0 |
183005-WHT-6 M | 6 M | eBay | 7 | 0 | 8 | 1 | 0 |
Warehouse section
Your Receipts Units, Gross Sales Units and BOP units are the total of your store locations, as in previous PO settings. However, these metrics are not used to calculate the final receipts.
Final Receipts are calculated by the total of non-MDQ set channels (Amazon, eBay etc) Receipt Units plus the ones that are calculated from Receipts - MDQ for each store location.
NOTE: Due to rounding of quantities, your final receipt totals might not be equal to the sum of receipts at locations.
SKU | Full Size | Location Name | Receipts Units | MDQ | Gross Sales Units | BOP Units | Final Receipts |
183005-WHT-10 M | 10 M | Available 800 | 103 | 0 | 113 | 10 | 101 |
183005-WHT-6 M | 6 M | Available 800 | 51 | 0 | 57 | 5 | 47 |