Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

Creating templates is a 5 step process as shown in the screenshot above.  To begin just click on left-hand menu option "Order Generation" and choose "Order Generator".  This will provide you with the screenshot above - not the tabs across the top.  To create a new template, choose the table "Create New Template".  When you're done with these 5 steps - your template will be added and available under the "Saved Template" tab.

Step

In Creation
  • Step 1 - Give a name for the template and an optional description.  When you're done - hit the next button or click on the step 2 accordion to open that step.
  • Step 2 -

    1 - Template Name

    This is quite simple - just give it a name and if you like enter some notes to remind you what the purpose of the template was for later.

    Image Added

    Step 2 - Select Stores

    The second step requires you to select one or more stores which you wish to order for.  You can use the normal region breakouts, custom regions, or even just a list of stores. You can combine the region selections and the stores chosen will be the intersection of stores present in all your selections.

    Image Added

    Select the stores you want to order for - you can use any of the familiar options - but a custom region is always the most preferred by users here.


    Step 3 - Select Order Criteria

    This is the most involved step, it involves choosing the basic rules by which the computer will attempt to generate orders.

    Order Assembly Metric - this is required.  Currently there are two options which dictate how the order is supposed to be tallied up.  You can set minimums and maximum amounts for each - you can either build based on dollar value of super packs.  For more information about super packs see Item Availability & Ordering Rules in the pack type section

    Pack Type - You need to choose a Pack Type rule set to let the computer know what the minimum order multiples are etc.  Note: You can change this value in any saved template later.

    Order to X WOS - One of the key drivers of the automated order is the WOS (Weeks of Supply) metric.  This tells the computer to target x number of weeks of expected demand.  Since demand changes during this year, this metric can remain constant and the amount needed to fulfill it will change. For high volume products where multiple orders are placed each week, this number will likely be 1 or less.

    Step 4 - Most clients only have one warehouse to select as the source of their ordered product. But if you have more - they will all be listed here and one must be chosen.

      For slower selling lines, you may wish to satisfy enough to cover the duration between re-orders. Note: You can change this value in any save template later.

    Zero-Out < X % of Min Units: This is simply a helper setting.  When the computer attempts to generate an order, the minimum amount you set in step 2 may or may not be met.  If a store only needs some items, its possible the computer will stop before it can reach your minimum.  In some instances you may wish to manually adjust partial orders to reach the valid minimum afterward, in cases where the order is only a small fraction of the target - say 25% or less - you may wish to have the computer just give up and zero out the order to save you time.  This setting lets you configure the 25% level to be whatever percent you wish.  

    Example - if Min Units = $1000, then setting this to 50% means any order that could not reach at least $500 in needed product would be rolled back.  Any order above $500 would be retained allowing you to manually "finish off" the order if desired.

    Remove Zeroed Orders?:  This setting in conjunction with the above setting tells the generator to discard and don't even display stores that could not reach your threshold.  This makes the results smaller and more concise while eliminating failed order noise data.

    Limit on WH Inventory?:  This is a key setting - if you choose "YES" then the computer will not order more units that are stated in the warehouse inventory. This ensures that if more than one person is ordering or multiple templates are run - if inventory is exhausted, you won't "over write" your available inventory.  Setting this to "NO" will order whatever is deemed appropriate and will not pull the inventory away from other users.


    Hide Out-of-Stock WH Items?: This causes the results for any item which is not in stock in the warehouse is either shown or hidden.  This can cut down on the number of rows in the results.


    Use Presence Qtys?: This lets you take into account or ignore the market availability presence quantity recommendations.

    Finally - you can limit the items being considered to only include items in an item group or a CSV list of items.  Show below - this lets you order certain products while ignoring items which may be needed.

    Image Added


    Step 4 - Select Warehouse Source

    This is simple, but important.  If you're generating orders, we need to know where its coming from to judge if the inventory exists or not.

    Image Added


    Step 5 - Choose Items & Quantities

    -

    this is a legacy step and may be eliminated in the future, for now just hit Create Template!  You can then run the template or click on the "Saved Template" tab to view this new template with all your other templates.


    Panel
    borderStylesolid
    titleTable of Contents

    Table of Contents

    Panel
    borderStylesolid
    titleRelated Links