Skip to main content
All CollectionsAssortment Planning Features
Applying MDQ Constraints in AP
Applying MDQ Constraints in AP

Toolio offers you to generate POs with MDQ Constraints where your PO includes to store shipments as well

Updated over a week ago

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.

  1. Go to Master Data > Location

  2. 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

  1. Go to any view you like and make sure you have enabled MDQ as an attribute on this view.

  2. Enter the MDQ for the Style-Color, Cluster Group and Size Scale

  3. Select the PO Strategy for the Style-Color

    1. For MDQ to be applied, select MDQs to Destination Remainder to Store option

    2. Otherwise, select POs to Source option

  4. Select the Style-Colors which will be included in your PO.

    1. Note that, Toolio lets you generate POs only if they have the same PO Strategy type.

  5. 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)

  6. 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

Related Articles

Did this answer your question?