MIP & Label

Mango Report
Help Center

Search:

Contents

IndexBookmarkPrint

Home > Closeout Management > MIP & Label

Closeout Management - MIP & Label

The steps below take you through the (monthly) process of managing your closeout promotion in your store. Your system contacts Mango on the 2nd of the month to build the necessary pieces for COM which is why we'd advise waiting until the 3rd to process these instructions.

IMPORTANT: Your system must be on Eagle Level 29.0 or higher and have the MANGOAPI integration enabled to use these steps below. All steps must be completed at the same time to avoid pricing discrepancies at point-of-sale. Instructions for Eagle Level 28.1 and lower are at the very bottom.

Step 1: Deactivate the previous Promotional File

If this is your first month activating Mango's Closeout Promotion file then please skip this step.

VIDEO - Click Here

Open Eagle Browser
In the Launch Bar, type in MIP and press Enter
Verify the new promotion file is in your system, this usually doesn't happen until the 3rd day of the month.
In the Type drop-down select the currently active closeout promo, example CLEAR01 (01 represents the month, January. If it were August it would be CLEAR08)
If multi-store, you will need to select ALL in the Store dropdown.
In the top ribbon, click on Display (F6). A listing of SKUs should appear.
In the top ribbon, click on Misc Kpad (-)
Click on Make Global Changes to Promotions in the grid (1)
A new window will appear, set the end date to be yesterday and click OK
If you have more than 200 SKUs on promotion then a box may appear asking if you want to load more than 200, click Yes
In the top ribbon, click on Change (F5)
A new window (margin warning) will appear, click ALL and it will commit the change to all the SKUs in the list. This may take a minute or two depend on the number of stores and SKUs on Closeout Management.
Close out of MIP
In the Eagle Launch Bar, type in RUP and press Enter
Print Setup -> Print To -> S
Options -> Options -> F
If multi-store, From/To -> Store -> set to All Stores which is BLANK
From/To -> Promo Type -> Enter your currently active closeout Promo, example CLEAR01 to CLEAR01
From/To -> From/To Range is Correct -> Y
In the top ribbon, click on Run (F4)
Do you wish to exit, click Yes
The promotion is now deactivated

Step 2: Activate the New Promotional File

VIDEO - Click Here

Open Eagle Browser
In the Launch Bar, type in MIP and press Enter
In the Type drop-down select the new closeout promo, example CLEAR02 (02 represents the month, February. If it were September it would be CLEAR09)
If multi-store, you will need to select ALL in the Store dropdown.
In the top ribbon, click on Display (F6). A listing of SKUs should appear.
In the top ribbon, click on Misc Kpad (-)
Click on Make Global Changes to Promotions in the grid (1)
A new window will appear, set the start date to be yesterday and click OK
If you have more than 200 SKUs on promotion then a box may appear asking if you want to load more than 200, click Yes
In the top ribbon, click on Change (F5)
A new window (margin warning) will appear, click ALL and it will commit the change to all the SKUs in the list.
Close out of MIP
In the Eagle Launch Bar, type in RUP and press Enter
Print Setup -> Print To -> S
Options -> Options -> F and Y
If multi-store, From/To -> Store -> set to All Stores which is BLANK
From/To -> Promo Type -> Enter your currently active closeout Promo, example CLEAR02 to CLEAR02
From/To -> From/To Range is Correct -> Y
In the top ribbon, click on Run (F4)
Do you wish to exit, click Yes
The promotion is activated!

Step 3: Print and Label Items

A common question is why the Label # doesn't match the MIP # and this is because many SKUs will stay at their price for 2-3 months before moving to the next tier. The labeling process only has you print labels where the price is changing and we've found this can help reduce labor by up to 50% vs. print labels for every SKU in the promotion.

For stores on Eagle Level 30.1 and higher. Stores on a lower software level, please see the legacy instructions below

VIDEO - Click Here

From Eagle Browser, click Label Design & Printing Menu
Click Item Bin Labels (RBL)
Click #4 - Promotion File
Print Setup -> Print To -> S (spooler only)
Options -> Label to Use -> 2
If Multi-Store, From/ To -> Store -> select the store you're in/working on
From / To -> Promo Type -> type the active closeout promo, example CLEAR05 in the FROM and TO field (05 represents the month, May. If it were September it would be CLEAR09)
In the top ribbon, press Run (F4)
Return to Eagle Browser, click Label Design & Printing Menu
Click Print Inventory Labels
If there are any items listed, delete them from the view before continuing
In the top ribbon, click Import (F9)
A new window will appear, from the Source dropdown select Bin Label Report (RBL), click OK
Click the checkbox for COM LABELS FOR MANGO with a created date of today, then click To Label Mgr
This may take a few minutes to load. Be patient.
In the top ribbon, click All/None (+) and click Print
Select Ace Markdown Label and click Open
Select the correct printer and click Ok
Hang the labels and shelf talkers to start selling through your dead inventory!

Legacy Label Instructions - L30 and below

VIDEO

Find your COM Labels file attached to your Excel Reports email or in your Online Reports Excel directory (online report instructions).
Download / Save As the file named: " - COM Labels - ", e.g. "07205 - COM Labels - 0320.csv"
**Please don't open this file in Excel, it can cause formatting issues, use Eagle only.**
You will need to remember where this file is saved.
From Eagle Browser, click Label Design & Printing Menu
Click Print Inventory Labels
If there are any items listed, delete them from the view before continuing
In the top ribbon, click Viewer (F9)
A new window will appear, in the top ribbon click Misc Kpad (-)
Click Custom SKU List (2)
Click Import from CSV File (6)
Find the COM Labels file you downloaded earlier and select Open
A message may ask if you want to clear the grid before importing, click Yes
Let the SKU list load, this may take a minute or two
In the top ribbon, click Select (F4)
A message will ask "Select all records from viewer?" click Yes
This may take a few minutes to load. Be patient.
Double click on the Location header to have the label list print in order.
In the top ribbon, click All/None (+) and click Print
Ace Markdown Label and click Open
Select the correct printer and click Ok
Hang the labels and shelf talkers to start selling through your dead inventory!

Step 4: MIP Clean Up

How to check your Eagle Level & API

Promotion Type Name
January	CLEAR01	July	CLEAR07
February	CLEAR02	August	CLEAR08
March	CLEAR03	September	CLEAR09
April	CLEAR04	October	CLEAR10
May	CLEAR05	November	CLEAR11
June	CLEAR06	December	CLEAR12

LEGACY INSTRUCTIONS - Eagle Level 28.1 and lower

The steps below take you through the (monthly) process of managing your closeout promotion in your store.

IMPORTANT: All steps must be completed at the same time to avoid pricing discrepancies at point-of-sale.

Step 1: Deactivate previous Promotional File

If this is your first month loading Mango's Closeout Promotion file then please skip this step.

VIDEO

Open Eagle Browser
In the Launch Bar, type in MIP
In the Type drop-down select the currently active closeout promo, example CLEAR02 (02 represents the month, February. If it were August it would be CLEAR08)
If multi-store, you will need to select the correct store in the Store dropdown.
In the top ribbon, click on Display (F6). A listing of SKUs should appear.
In the top ribbon, click on Misc Kpad (-)
Click on Make Global Changes to Promotions in the grid (1)
A new window will appear, set the end date to be yesterday and click OK
If you have more than 200 SKUs on promotion then a box may appear asking if you want to load more than 200, click Yes
In the top ribbon, click on Change (F5)
A new window will appear, click ALL and it will commit the change to all the SKUs in the list.
Close out of MIP
In the Eagle Launch Bar, type in RUP
Print Setup -> Print To -> S
Options -> Options -> F
From/To ->Promo Type -> Enter your currently active closeout Promo, example CLEAR02 to CLEAR02
From/To -> From/To Range is Correct -> Y
In the top ribbon, click on Run (F4)
Do you wish to exit, click Yes
The promotion is now deactivated

Step 2: Retrieve the new Promotional File

Step 3: Load the new Promotional File

Note: Secure Access users, please use this alternative help content: Closeout Secure Access.pdf
Note: Large Format users, please use this alternative help content: Closeout Large Format.pdf
Note: For stores with Promotional Import (Option ID 1082 = Yes), please use this alternative help content: COM MIP Import

VIDEO

The steps below will guide you through creating a macro (programmable key) in Network Access and then using that macro to import your promotional file saved in Step 2 above.

In the Eagle Launch Bar type in NA (Network Access) and press Enter then log into Network Access
1. You may need to type "m" at the login: prompt, then enter your Eagle login credentials
In the FUNCTION line of Network Access type MIP and press Enter
NOTE: if your system says "Access not allowed when large field size enabled" please use this alternative help content: Closeout Large Format.pdf
In the top menu bar, click on Options
Under the Keys submenu, click Programmable Keys...

First Time Setup:

Select an open (without a macro already assigned) Programmable Key, Ctrl+F10 for example
Type Mango Closeout for the Description
Click on the ". . ." button after Data File Name and a new window will open
Find the Closeout_MACRO.txt file you saved in Step 2, click on the file then click the Open button
Make sure the Field Separator says , Comma
----- (steps 7 - 10 are a one-time setup) -----
Select the text between the asterisks (DO NOT SELECT THE asterisks) then right-click and select copy:
**{Column 1}{ENTER}{ENTER}{Column 2}{ENTER}{ENTER}{ENTER}{ENTER}{ENTER}{ENTER}{ENTER}{ENTER}{Column 3}{Column 4}{Column 5}{ENTER}{Column 6}{Column 7}{Column 8}{ENTER}{Column 9}{ENTER}{ENTER}{ENTER}{ENTER}{F4}A{ENTER}{F12}**
Note: if using printed instructions, then please visit mangoreport.com/help and click Closeout Management from the leftside Contents list, then click MIP & Label, Step 3; this will show you to the asterisks text for this step.
Under Macro Definition, right-click on the white space and select Paste
NOTE: if your system doesn't not allow you to paste then it is because you have Secure Access. Please use this alternative help content: Closeout Secure Access.pdf
IMPORTANT: uncheck the box that says "Macro playback follows keyboard focus"
Click OK
Press F12 to clear the MIP screen
Now press Ctrl+F10 (or the programmable key you chose in step 6) and the macro will begin to run.
Let the macro completely finish before closing Network Access, this can take several minutes depending on the size of your closeout file.
Once the macro is finished, close Network Access.

Repeat Users:

Select the previously assigned Programmable Key, Ctrl+F10 for example
Click on the ". . ." button after Data File Name and a new window will open
Find the Closeout_MACRO.txt file you saved in Step 2, click on the file then click the Open button
Click OK
Press F12 to clear the MIP screen
Now press Ctrl+F10 (or assigned the programmable key) and the macro will begin to run.
Let the macro completely finish before closing Network Access, this can take several minutes depending on the size of your closeout file.
Once the macro is finished, close Network Access.

Note: you may see "THIS SKU IS NOT IN THE INVENTORY FILE-NOT ALLOWED" messages at the bottom of the MIP screen when the macro is running; this behavior is desired and your macro is running correctly.

Multi-store: this process will need to be completed for each store in your organization.

Step 4: Inspect the new Promotional File

VIDEO

Review the promotional file loaded in the previous section to make sure your closeouts file loaded correctly.

In the Eagle Launch Bar, type in MIP and press enter
Click the drop-down for the Type field, select the correct promotion file, and click Display (F6). These instructions reference the month of February which means the Type will be CLEAR02 because it is the 2nd month of the year. March's Promo file will be called CLEAR03 and so on.
Review the items to be placed on promotion. If you decide to remove an item, delete the line, but also take preventive action so that it doesn't appear again next month:
1. If it should not be closed out then change its store closeout flag in IMU back to "No"
2. If you want it to remain in a closed out status but not be a part of Mango's Closeout Management file then change its Location 2 (in IMU) from MDR to something else like XDR and the year. (Example: XDR16) Review the Location Strategies here if needed.

Step 5: Activate the new Promotional File

Step 6: Print and Label Items

A common question we get asked is why we provide a separate label file. This is because many SKUs will stay at their price for 2-3 months. The label file only has you print labels where the price is changing. We've found this can help reduce labor by up to 50% vs. print labels for every SKU in the promotion.

VIDEO

Find your COM Labels file attached to your Excel Reports email or in your Online Reports Excel directory (online report instructions).
Download / Save As the file named: " - COM Labels - ", e.g. "07205 - COM Labels - 0216.csv"
**Please don't open this file in Excel, it can cause formatting issues, use Eagle only.**
You will need to remember where this file is saved.
From Eagle Browser, click Label Design & Printing Menu
Click Print Inventory Labels
If there are any items listed, delete them from the view before continuing
In the top ribbon, click Viewer (F9)
A new window will appear, in the top ribbon click Misc Kpad (-)
Click Custom SKU List (2)
Click Import from CSV File (6)
Find the COM Labels file you downloaded earlier and select Open
A message may ask if you want to clear the grid before importing, click Yes
Let the SKU list load, this may take a minute or two
In the top ribbon, click Select (F4)
A message will ask "Select all records from viewer?" click Yes
This may take a few minutes to load. Be patient.
Double click on the Location header to have the label list print in order.
In the top ribbon, click All/None (+) and click Print
Locate the Mango Closeout label or Ace Markdown Label (Eagle 26.1 or higher) and click Open
Select the correct printer and click Ok
Hang the labels and start selling through your dead inventory!

Click here to download a PDF version of these instructions

Promotion Type Name
January	CLEAR01	July	CLEAR07
February	CLEAR02	August	CLEAR08
March	CLEAR03	September	CLEAR09
April	CLEAR04	October	CLEAR10
May	CLEAR05	November	CLEAR11
June	CLEAR06	December	CLEAR12