Michigan Liquor Control Commission

Online Liquor Ordering

(Modified December 17, 2014)

 

 

 

INTRODUCTION

 

Welcome to the Michigan Liquor Control Commission’s (MLCC) online spirit ordering system.  This Internet site was designed to provide Michigan liquor licensees an alternative means to order all available spirits at one time from a single ordering site.  Licensees may continue to place their orders individually with State of Michigan Authorized Distribution Agents (ADAs) by telephone, EDI, or ADA Internet sites.

 

In order to use this Internet site, you must have an active Michigan liquor license that authorizes the sale of spirits.  In addition, you will need to request an online liquor ordering password from the Michigan Liquor Control Commission if you don’t already have one.

 

e-Mail:    mlccpasswordrequests@michigan.gov

 

NOTE:  All new licensees will automatically be issued a password with their initial license after November 2002.

 

 

HAVE QUESTIONS?

 

The State’s Internet ordering site provides for “normal” ordering with the following ADAs.  Questions regarding special delivery requests, distribution, adjustments, and any post order-period changes (after 6:00 am next day after your regularly assigned ordering day) should be directed to the ADA that delivers the liquor code(s) ordered:

 

      ADA#  ADA Name                            Phone

 

      221   General Wine and Liquor             888-860-3805

 

      321   NWS Michigan, Inc.                  888-697-6424 ext 2

888-642-4697 ext 2

 

      341   Chinese Import and Export           248-524-1382

 

If you have questions on how the system works or comments about the service you are receiving…call the MLCC Help line!  The lines are available Monday through Friday from 8:00 a.m. until 4:30 p.m.   Call 1-800-701-0513.

 

 

 

OVERVIEW

 

The MLCC has authorized several ADAs on behalf of the State of Michigan, to warehouse manufactured spirits, take orders from licensees, prepare invoices, and deliver liquor orders to licensees.  When liquor licensees successfully log on to this site, each ADA will be contacted to supply the next date they could provide normal delivery if an order is placed. 

 

Every three months a new Liquor Price List catalog is prepared and mailed to most Michigan licensees.  This catalog lists all spirits that are available for sale in Michigan along with bottle sizes, cost information, and which ADA is authorized to deliver it.  In addition, online spirit lookups may be performed from the following MLCC Internet site:  http://www.cis.state.mi.us/lcc_code/sr_lcc.asp.  There is also a button on the ORDER ENTRY page of this application to help locate any liquor code for ordering.  NOTE: Items may be discontinued or new items added on a monthly basis by MLCC.

 

Each ADA closes a licensee’s “ordering period” at 6:00 am on the following day of the licensee's regularly assigned ordering day so they can assemble the order.  An order may be created, deleted, or changed multiple times (before 6:00 am on the following day of your regularly assigned ordering day).  All ADAs do not have the same delivery schedules.  Therefore, if you placed an order for all three ADAs at once, you could see one ADA’s items disappear from your total order after 6:00 am on the following day of your assigned ordering day yet continue to see the other two ADA’s order items.  You may continue to add to or make deletions and changes to any pending orders you see.  As well, you could start a new order for the “missing” ADA for their next promised delivery date by adding new items for them to your current pending order.  To summarize, if you can see the items in your order, you may change or delete them at any time (as well as add new items for any and all ADAs) and confirm your order as many times as you want and be guaranteed that nothing will be duplicated.  Always know that the last “confirmation” you make is the one that each ADA considers deliverable on their next promised date. 

 

A series of 7 pages provide for the ordering process:

 

1) Log On

    Identifies and authorizes licensee to State of Michigan and ADAs.

2) How many items?

    Pick list of approximate number of items licensee will be ordering.

3) Order Entry

    Provides for data entry of all liquor codes and quantities.  And quantity verification.

4) Order Display

    Verified order is parsed into individual ADA categories and displayed.

5) E-mail confirmation

    Asks where the order confirmation notice should be e-mailed.

6) How many additional items?

    Pick list of number of items to add to current order.

7) Add Items

    Item entry page for adding additional items to order

 

Licensees may enter their entire liquor order (for all ADAs) in any order to the ORDER ENTRY page.  After data entry is completed, the entire order must be “verified” by the individual ADA(s) responsible for distribution.  A button on the ORDER ENTRY page initiates the verification process, which involves splitting the entered order into separate ADA categories and each ADA verifying that the quantities of liquor ordered are available.  The verified order is then reassembled and displayed on the ORDER DISPLAY page.  The licensee must then review the order for potential shortcomings and final calculations.  Licensees may make additional changes at that point or actually “confirm” (or place) the order with the ADA(s). 

 

NOTE:  The order may be changed and quantities verified multiple times, but an order does not exist with an ADA until it is actually placed (or confirmed) from the ORDER DISPLAY page at least once.  Until the order is actually confirmed (or placed) there is the potential of totally losing all data entered if connection is lost during the item entry/verification process.  The confirmation of the order is the action that will allocate the stock for each ADA that is involved in the order and place an order on their delivery schedule.

 

Licensees may log off and on many times to the MLCC Liquor Ordering Internet site.  As alterations are “confirmed,” the latest confirmation will become the licensee’s final order (i.e., any prior confirmations no longer exist and ADA stock has been reallocated accordingly).  At 6:00 am next day after the assigned ordering day, the last confirmation is considered the final order and the licensee should expect deliveries from the respective ADAs on their designated delivery dates.  Licensees must contact the ADA directly (after 6:00 am next day after their regular ordering day) if they wish to alter the final order or make special delivery arrangements (see page 1 of this document). 

 

It is recommended that licensees establish an e-mail account with an Internet service provider.  Every time an order is placed/confirmed via the ORDER DISPLAY page, the licensee will be prompted for their e-mail address.  A written confirmation will be e-mailed and should be retained for actual invoice comparisons.  Any discrepancies (other than expected adjustments) should be reported to the ADA. 

 

 

ORDERING PROCESS

 

We recommend you save the Online Liquor Ordering web address as a browser Favorite for quick access in the future:  https://www2.dleg.state.mi.us/olo

 

The ordering process involves 3 basic steps: 

·         Enter the order

·         Verify the bottle quantities are available in each ADA’s warehouse

·     Place (or confirm) the order for ADA delivery commitment

 

 

I.      PLACING A NEW ORDER

 

        A)     The LOG ON page will be the first page to appear.

 

                1.     Enter your license number (1-6 numeric digits) in the User ID field.

                        This should be the license that allows you to purchase spirits.

 

                2.     Tab to the Password field and enter the liquor ordering password received from MLCC. 

                        NOTE:  The password is case sensitive (i.e., if letters are lower case letters, they must be entered that way).

 

                3.     Mouse-click on the blue [Login] button.

 

        B)     How many items will you be ordering?

                If you have been authorized, you will be prompted to choose from a pick list (or dropdown) of a range of numbers.  This range will be used to give you the most efficient number of blank fields for liquor code and quantity data entry to the ORDER ENTRY page.  

 

                1.     Mouse-click on the arrow on the dropdown list to expand it and show available ranges.

 

        2.     Mouse-click on the range that contains the maximum number of items you will be entering.

 

        3.     Mouse-click on blue [Go] button.

 

        C)     Enter your complete order to the ORDER ENTRY page. 

 

                1.     Type your order to available fields.

                        The order in which you enter the liquor codes and quantities (number of bottles, not cases) is not important.  Use your tab key to tab to the next entry field until all codes and quantities have been entered. 

 

                2.     When you have finished entering your order (or at any time during the data entry process), press the [Refresh Totals] button. 

                        This button causes the order to be redisplayed with item descriptions and bottle sizes for your review.  The potential order is also summarized by ADA into total standard case equivalent and expected total cost and displayed at the top of the page.  A valid order must contain a minimum of 1.0 standard case equivalent (9000 ml) for any single ADA.

 

                        If errors are present, you must correct and click [Refresh Totals] until the page is error free.  NOTE: At this point you cannot physically remove items from the order.  You can change the quantity to 0 (zero); essentially the same as removing the item from the order.  This is required for proper ADA electronic communications.

 

                        Two new buttons will become visible:

                        [Add New Items]                      

                        If you have not finished entering your order and wish to add more items to the order, you will need to press the blue [Add New Items] button to obtain additional item entry fields.

                        [Verify ADA Inventory]

                        This button will be visible only if the page is error free.  Pressing this button will parse your entered order into separate ADA categories.  Individual ADAs will be electronically contacted to verify the number of bottles ordered is available in their warehouse. 

 

                3.     Press the [Verify ADA Inventory] button when you are satisfied with your order. 

                        The results will be redisplayed by ADA on the ORDER DISPLAY page with verified amounts in ADA warehouse and individual cost breakdown.

               

                4.     Review available quantities.

                        If, after reviewing available quantities, your order is still agreeable (and still meets minimum standard 1 case requirement), go on to step D) below.  Otherwise, you will need to return to the ORDER ENTRY page by pressing the [Return to Order] button.  Repeat step C) again.

 

                        An order does not exist with an ADA until it is actually placed (or confirmed) from the ORDER DISPLAY page. 

 

                        NOTE:  Until the order is actually placed, there is the potential of totally losing all data entered if connection is lost during the item entry/verification process. 

 

        D)     Place (or confirm) the order from the ORDER DISPLAY page.

 

                1.     Press the [Place/Confirm Order] button. 

                        This action initiates the allocation/depletion of stock in each ADA’s warehouse that is involved in the order and places your order on their delivery schedule.

 

                2.     You will be prompted for your e-mail address. 

                        You should replace the default e-mail address with your e-mail address if you have one (otherwise leave default e-mail address as is).  A written confirmation with individual ADA confirmation numbers will be e-mailed to you (or the default address) and should be retained for actual invoice comparisons upon delivery.  It is to your advantage to provide an e-mail address.  This is your only copy and proof that an order was placed. 

 

                        This order is now considered final and deliverable.  Until 6:00 am next day after your regularly assigned ordering day, you may change or cancel this order via the Internet (see “CHANGING AN ORDER” and “CANCELING AN ORDER” procedures below).  At that time your order will be pulled by the ADA for processing and can no longer be reviewed via the State’s Internet site; any changes or cancellations must be taken up with the individual ADAs (see page 1 of this document for contact information). 

 

                3.     Please review order ONE MORE TIME and log out of application.

                        It is necessary to make one more review.  There is a remote chance that another licensee could have placed an order between the time you verified availability and the time you actually confirmed your order that depleted ADA stock.  Also note that ADAs may hold your order if a shortage caused you to fall below the 9000 ml minimum.

                        Press the [Exit/Logout] button.

 

 

II.     CHANGING AN ORDER

 

        Until 6:00 am next day after your regularly assigned ordering day for an ADA, you may review and change that ADA order.  At that time your order is considered final and can no longer be reviewed via the State of Michigan’s Internet ordering site.  You must rely on your e-mailed confirmation memo to review your full, multi-ADA order.  Any changes, cancellations, or special delivery arrangements must be taken up with the individual ADAs after 6:00 am next day after your regularly assigned ordering day (see page 1 of this document for contact information).  NOTE: ADAs may individually provide Internet order review sites, but each ADA is responsible for their own confirmed portion of the order after 6:00 am next day after your regular order day for that ADA.

 

        A)     Log onto the application again (as you did when creating the order).  See step A above in PLACING A NEW ORDER procedure.

 

                Instead of a page prompting you for how many items you want to enter, your pending order (for all items and ADAs) will automatically be displayed on the ORDER ENTRY page.

 

        B)     TO ADD ADDITIONAL ITEMS TO ORDER

 

                1.     Press [Add New Items] button on bottom of ORDER ENTRY page. 

 

                2.     How many items will you be adding?

 

                You will be prompted to choose from a pick list (or dropdown) of a range of numbers.  This range will give you the most efficient number of blank fields for liquor code and quantity data entry to the ADD ITEMS page.  

 

                        a.   Mouse-click on the arrow on the dropdown list to expand it and show available ranges.

                        b.   Mouse-click on the range that contains the maximum number of items you will be entering.

                        c.   Mouse-click on blue [Go] button.

 

                3.     Enter your additional items to the ADD ITEMS page. 

 

                        Enter your new codes and quantities to the blank page fields.  The order in which you enter the liquor codes and quantities is not important.  Use your tab key to tab to the next entry field until all additional codes and quantities have been entered.

 

                4.     Press [Add Items/Return] button.

 

                        Returns to ORDER ENTRY page.  Combines new codes (if any were entered) with previously entered items and redisplays a combined potential order with descriptions.  The potential order is also re-accumulated by ADA as to total standard case equivalency (1 case = 9000 ml) and expected total cost and displayed at the top of the page. 

                        Review entries and totals before verifying spirit availability with ADAs.

                       

                5.     Confirm the new additions to Order (skip to Step E below).

 

 

        C)     TO DELETE ITEMS FROM YOUR ORDER

 

                1.     Enter 0 (zero) in the quantity column for any items you wish to delete.

                        Do not space the values out or use your delete key to remove them from the page.

 

                2.     Skip to step E) to re-verify and complete ordering process.

 

        D)     TO CHANGE ITEMS IN YOUR ORDER

 

                1.     Sorry, you cannot “change” any codes.  However, you may alter quantities ordered.  If you no longer want an item, you must change the quantity to 0 (zero).  If you want to add new items to the existing order, you need to use the [Add New Items] button (see item B above if necessary).

 

                2.     Skip to step E) to re-verify and complete change process.

 

 

        E)     ALWAYS RE-VERIFY TO COMPLETE ORDER CHANGE (ADDS/CHANGES/DELETES)

 

                1.     If you have an error-free page, press the [Verify ADA Inventory] button when you are once again satisfied with your order.  This will reorganize your order into separate ADA categories.  Individual ADAs will be electronically contacted to verify that the number of bottles ordered is available in their warehouse.  The results will be redisplayed on the ORDER DISPLAY page.

 

                        If there are errors, you must correct them and press [Refresh] button until page is error-free.  Then press the [Verify ADA Inventory] button to continue the ordering process.

 

                2.     Review available quantities displayed on ORDER DISPLAY page.

 

                        If, after reviewing available quantities, your order is still agreeable (and still meets minimum standard 1 case requirement), go on to step 3 below.  Otherwise, you will need to return to the ORDER ENTRY page by pressing the [Return to Order] button to continue alteration process again.

 

                        Your revised order does not exist with any ADA until it is actually placed (or confirmed) from the ORDER DISPLAY page.  Until the order is actually placed, there is the potential of totally losing all alterations if connection is lost. 

 

                3.     Press the [Place/Confirm Order] button. 

                        This action initiates the allocation/depletion of stock in each ADA’s warehouse that is involved in the order and places your order on their delivery schedule.

 

                        You will again be prompted for your e-mail address. 

                        You should replace the default e-mail address with your e-mail address.  A written confirmation will be e-mailed to you and should be retained for actual invoice comparisons upon delivery.  It is to your advantage to provide an e-mail address, as this is your only copy and proof that your previous order was replaced. 

 

                        This latest order is now considered final (and deliverable if non-zero quantities).  This new order replaces and nullifies all other orders.

 

                4.     Please review final order and log out of application.

                        It is necessary to make one more review.  There is a remote chance that another licensee could have placed an order that depleted ADA stock between the time you verified availability and the time you actually confirmed your order.  Also note that ADAs may hold your order if this caused you to fall below the 9000 ml minimum.

                        Press [Exit/Logout] button.

 

 

III.    CANCELING/DELETING AN ORDER

 

        Until 6:00 am next day after your regularly assigned order day, you may review, change, or delete any ADA order.  At that time your order is considered final and can no longer be reviewed via the State of Michigan’s Internet ordering site.  You then must rely on your latest e-mailed confirmation memo to review your full, multi-ADA order.  Any changes, cancellations, or special delivery arrangements must be taken up with the individual ADAs after 6:00 am on next day of your assigned order day (see page 1 of this document for contact information).  NOTE: Individual ADAs may provide an Internet order review site, but each ADA is responsible for their own confirmed portion of the order after 6:00 am the next day of your assigned ordering day for that ADA.

 

        A)     Log on to the application again (as you did when creating the order).  See step A above in PLACING A NEW ORDER procedure.  Instead of a page prompting you for how many items you want to enter, your pending order (for all items and ADAs) will automatically be displayed on the ORDER ENTRY page.

 

        B)     Enter 0 (zero) in the quantity column for ALL items ordered.

 

        C)     Press the [Verify ADA Inventory] button when you are satisfied with your “zero-quantity” order.  The results will be redisplayed on the ORDER DISPLAY page.

 

                IMPORTANT!  You must place (or confirm) the zero-quantity order (Step D).

                At this point, your original order has not been altered for any ADA.  Until the new “zero-quantity order”/cancellation is actually placed (or confirmed) from the ORDER DISPLAY page, your original confirmed order still exists.

 

        D)     Press the [Place/Confirm Order] button. 

                This action initiates the reallocation/addition of the original order’s stock back into each ADA’s warehouse that is involved in the order and deletes your prior order from their delivery schedule.

 

                You will be prompted for your e-mail address. 

                You should replace the default e-mail address with your e-mail address.  A written confirmation will be e-mailed to the entered address and should be retained for proof of cancellation.  It is to your advantage to provide an e-mail address.  This is your only copy and proof that your zero-quantity order was confirmed to replace your previous order. 

 

                This “zero-quantity order”/cancellation order is now considered final and replaces and nullifies all other orders made during this order period.

 

        E)     Please review final order and log out of application.

                Press the [Exit/Logout] button.


FREQUENTLY ASKED QUESTIONS

 

1.     What is a User ID?

        This is just a computer term for information that helps identify who is logging onto an application.  In this application, it is a valid Michigan license number that permits purchase of spirits.

 

2.     How can I get my password changed…It’s too difficult to remember.

        You cannot choose your own password.  It is a security requirement by this application.

 

3.     I’m not sure if my order took.  I don’t have e-mail (or I didn’t get an e-mail confirmation).

        Note that a “default” e-mail address is displayed to receive your confirmation if you don’t have one.  If you entered your own valid e-mail address and didn’t get a confirmation memo, there may just be a problem with the e-mail system. 

 

        If you have not gotten an e-mail order confirmation within 15 minutes, you can verify that your order exists by exiting the application and then logging back onto the application.  If your order comes up immediately after you press the [login] button, then your order exists as displayed with respective ADAs.  You may want to verify ADA inventory and confirm the order again to attempt to force a second e-mail generation. 

 

4.     What if I get busy with a customer in the middle of entering my order?

        For security reasons there is a timeout on the application.   You will be automatically disconnected after 120 minutes of inactivity.  You must verify your order at least once before the 120 minute time period elapses.   If you have not confirmed your order prior to disconnect, all data will be lost.  Please note that if your own Internet service provider times you out for inactivity prior to the application’s 120-minute timeout, you will also lose all data entered to an unconfirmed order.

 

5.     My screen display is not clear or appears to be the wrong size.

        This application has been verified for most Internet browsers and is best viewed at a resolution of 800 by 600 pixels.  Please attempt to adjust the resolution of your computer. 

 

        Windows users…To change your screen resolution:

        1.  Open Display in Control Panel

        2.  On the Settings tab, under “Screen area”, drag the slider to 800 by 600, and then click apply.

 

        NOTES:

·     To open a Control Panel item, click Start, point to Settings, click Control Panel, and then double-click the Display icon.

·     A higher screen resolution reduces the size of items on your screen and increases the size of your desktop.

 

6.     What happens if an ADA becomes temporarily unavailable in the middle of my order?

If an ADA was initially available to take orders, but then could not be electronically contacted when you tried to “verify” warehouse stock or “confirm” the order, you will see a message saying “No orders for ADA.”  If this happens when you have entered items for that ADA, we suggest you do the following:

 

a)  Click [Place/Confirm Order] button now so you don’t lose items entered for any other ADAs. 

b)  Click [Return to Order] button after the confirmation process is complete for other ADAs.

c)  Click [Verify ADA Inventory] again (i.e., make another attempt to verify the whole order).

d)  Confirm the whole order again if ADA is now showing your items available.

 

If the ADA could still not be contacted, you may continue to return to order and try re-verifying again as many times as you like….Or abandon the process (Exit/Logout) and contact the ADA by phone (see page 1 of this document) to see when they might be available again.  NOTE: If you have another telephone line, you may wish to remain connected to the order while you find out if their system will be down for an extended length of time.  Otherwise, you will be forced to re-enter the items for that ADA.

 

7.     What does “1.0 Std Case Required” mean?

        A valid order must contain a minimum of 1.0 standard case equivalent (9000 ml) for any single ADA.