Spring 2025 Report Schedule

• 02/18 - Show Buying Report emailed to stores 
• 02/18 - Easy Button and Review available on Acenet Show Buying Guide. (Digital Convention starts)
• 04/03 - Order window closes

Mango's Show Buying Report scores across the two major convention event types: Power Buys and Show Specials. All Power Buys are scored in your workbook; only Show Specials scoring 1 and above are included.

Score Category column defined: 

• Easy Button - Your top-scoring easy-to-order deals:
  • Your store carries at least 95% of the SKUs.
  • Store Closeout = N for at least 95% of the SKUs.
  • There is only one ship date.
  • SKUs do not have a special order nor spike sales signature. 
  • Deal cost, savings per cubic foot, and total cubic feet conditions are met.​

• Review - Great deals for your store, but need your review: 
  • Multiple ship dates. Mango tries to pick the best date for your store, but you might want to spread the deal out or pick a different date.
  • High cost, exceeding $3,000.
  • Under $2.13 savings per cubic foot. These are great deals, but your store might not have room.
  • Deals where you do not carry every SKU, or some SKUs in the deal are Store Closeout = Y.

• Fill Shelf - Small deal quantities that should fit on your hook without causing back stock:
  • SKUs with Shelf Capacity (Loc3) - fills your shelf up to a 40-week supply without going overcapacity.
  • SKUs without Capacity (Loc3) - Small cube deals should not create back stock.​

• Opportunity - these SKUs sell well in peer stores, but you do not (or have stopped) carrying the SKUs.
• Low Score - these deals will likely create too much overstock based on your store's sales history and offer OM.

You can download Mango’s Show Buying Report in 2 ways 

1. Locate your Show Buying Report email (emailed 02/18/25 in the afternoon/evening)
2. In the body of the email, locate the section titled Direct Download.
3. Click the "Show Buying Report" link.
4. The file will automatically download using your web browser.

OR​ (after 02/18/25) 

1. Log into your Online Reports.
2. Click on the Data Import + Multi-Store Folder.
3. Locate the file named " - Show Buying Report - " e.g. "7205 - Show Buying Report - 0225.xlsm". 
4. Download and then open the file.​

The Deals tab scores convention Show Specials and Power Buy deals. Deals are ranked by a Score Category and Deal Score. Higher scoring deals have the most relevance, produce the least overstock, and have the best savings for your store. Suggested order quantities are calculated to maximize savings while minimizing overstock. Using this report allows you to quickly pick out your best deals and copy/paste the orders into Event Planner on Acenet.  

• • Easy Button - Your top-scoring easy-to-order deals:
    • Your store carries at least 95% of the SKUs.
    • Store Closeout = N for at least 95% of the SKUs.
    • There is only one ship date.
    • SKUs do not have a special order nor spike sales signature. 
    • Deal cost, savings per cubic foot, and total cubic feet conditions are met.​
  • Review - Great deals for your store, but need your review: 
    • Multiple ship dates. Mango tries to pick the best date for your store, but you might want to spread the deal out or pick a different date.
    • High cost, exceeding $3,000.
    • Under $2.13 savings per cubic foot. These are great deals, but your store might not have room.
    • Deals where you do not carry every SKU, or some SKUs in the deal are Store Closeout = Y.
  • Fill Shelf - Small deal quantities that should fit on your hook without causing back stock:
    • SKUs with Shelf Capacity (Loc3) - fills your shelf up to a 40-week supply without going overcapacity.
    • SKUs without Capacity (Loc3) - Small cube deals should not create back stock.​
  • Opportunity - these SKUs sell well in peer stores, but you do not (or have stopped) carrying the SKUs.
  • Low Score - these deals will likely create too much overstock based on your store's sales history and offer OM.

• You can download Mango’s Show Buying Report in 2 ways:

  1. Locate your Show Buying Report email.
  2. In the body of the email, locate the section titled Direct Download.
  3. Click the "Show Buying Report" link.
  4. The file will automatically download using your web browser.

  OR​ 

  1. Log into your Online Reports.
  2. Click on the Data Import + Multi-Store Folder.
  3. Locate the file named " - Show Buying Report - " e.g. "7205 - Show Buying Report - 0225.xlsm". 
  4. Download and then open the file.​

Steps to process this worksheet:

1. Once the Excel file is open, be sure to Enable Content 
2. The file is sorted by Score Category then Deal Score to bring the best deals for your store to the top.
3. Zero in on a Score Category to process. 
4. Use Total Order Cost and Cubic to determine how many deals you can purchase within your budget.
5. Select the Order Qty (Col B) and Deal Number (Col C) for the deals you've decided to purchase
6. Copy the cells (Ctrl + C)
7. Open Event Planner on Acenet (Find & Order Product -> Order Product -> Event Planner)
8. Select the Import/Quick Entry button
9. Right-click in the first Qty field and select Paste
10. This loads the values from Excel into Event Planner.
11. Click Validate & Save and then checkout!

• Column B - Order Qty: shows how much of a deal to order. Mango will suggest a ~25-week supply (~32-week for seasonal) so that your store should sell through before the next show. Obviously, you may want to adjust this suggestion up or down based on your store's budget and storage capacity.

  Column C - Deal (or Bulletin): shows the bulletin number associated with the deal.  

  Column F - SKU: ​lists the deal's associated SKU, and (Asst) if the deal is an assortment of SKUs (you can use the SKUs tab to drill further into the deal).

  Column G - Discount: shows the deal's average savings as a percentage of regular cost.

  Column H - Max Weeks Supply Order Qty + QOH: - shows the maximum weeks supply at the suggested order quantity for your store. This column will show you how long the slowest-moving SKU in the deal will take to sell through in your store.  Also includes current quantity-on-hand position.

  Column I - Weeks Supply Order Qty + QOH: this column shows the deal's average weeks supply at the suggested order quantity (column B).

  Column J - Number of SKUs: shows the number of SKUs included in the deal.

  Column K - % Carried in Store: shows the percentage of deal SKUs already carried by your store.

  Column L - 1 OM Cost: the deal's cost per 1 deal offer OM (deal order multiple).

  Column M - 1 OM Savings: the deal's dollar savings per 1 deal offer OM.

  Column N - Order Qty Cost: the deal's total cost for the suggested order qty (column B).

  Column O - Order Qty Savings: the deal's dollar savings for the suggested order qty (column B).

  Column P - Deal Score: this column is derived from Weeks Supply (column I & H), % Carried in Store (column K), and Order Qty Savings (column O). Higher numbers indicate deals with the fastest turns, carried in your store, and with the biggest dollar savings. -99,999 indicate new SKUs/Deals that do not have enough sales history in your store (and in your peer group) to score.

  Column Q - Score Category: deals are grouped into categories to help you order more intelligently (see top of this page for more detail).

  Column R - Number of Ship Dates: indicates if the deal has multiple shipping dates to accommodate your store's season or to stagger inventory throughout the year.

  Column S - Ship Date: the deal's ship date for the bulletin (deal) listed. Note: Mango will try and select the most relevant ship date for your store if there are multiple shipping date options.  But you should review!

  Column T - Bulletin Dating: the deal's anticipated statement due date.

  Column U - Drop Ship: Y = a Drop Ship deal. 

  Column V - Dept: shows the department the majority of the SKUs within the deal are based. 

  Column W - Event Type: shows Ace's convention event category for the deal.

  Column X - Savings Per Cubic Ft.:  the deal's dollar savings per cubic foot of inventory space ordered.

  Column Y - Order Qty Cubic Ft.: the deal's cubic feet at suggested Order Qty.

This tab shows Show Specials and Power Buy deals at the SKU level. It is sorted by Score Category then Deal Score.  

• • Easy Button - Your top-scoring easy-to-order deals:
    • Your store carries at least 95% of the SKUs.
    • Store Closeout = N for at least 95% of the SKUs.
    • There is only one ship date.
    • SKUs do not have a special order nor spike sales signature. 
    • Deal cost, savings per cubic foot, and total cubic feet conditions are met.​
  • Review - Great deals for your store, but need your review: 
    • Multiple ship dates. Mango tries to pick the best date for your store, but you might want to spread the deal out or pick a different date.
    • High cost, exceeding $3,000.
    • Under $2.13 savings per cubic foot. These are great deals, but your store might not have room.
    • Deals where you do not carry every SKU, or some SKUs in the deal are Store Closeout = Y.
  • Fill Shelf - Small deal quantities that should fit on your hook without causing back stock:
    • SKUs with Shelf Capacity (Loc3) - fills your shelf up to a 40-week supply without going overcapacity.
    • SKUs without Capacity (Loc3) - Small cube deals should not create back stock.​
  • Opportunity - these SKUs sell well in peer stores, but you do not (or have stopped) carrying the SKUs.
  • Low Score - these deals will likely create too much overstock based on your store's sales history and offer OM.

• You can download Mango’s Show Buying Report in 2 ways:

  1. Locate your Show Buying Report email.
  2. In the body of the email, locate the section titled Direct Download.
  3. Click the "Show Buying Report" link.
  4. The file will automatically download using your web browser.

  OR​ 

  1. Log into your Online Reports.
  2. Click on the Data Import + Multi-Store Folder.
  3. Locate the file named " - Show Buying Report - " e.g. "7205 - Show Buying Report - 0225.xlsm". 
  4. Download and then open the file.​

• Column A - Deal Score:  this column is derived from Weeks Supply (column I & H), % Carried in Store (column K), and Order Qty Savings (column O). Higher numbers indicate deals with the fastest turns, carried in your store, and with the biggest dollar savings. -99,999 indicate new SKUs/Deals that do not have enough sales history in your store (and in your peer group) to score.

  Column B - Score Category: deals are grouped into categories to help you order more intelligently (see top of this page for more detail).

  Column C- Deal: shows the bulletin number associated with the deal. 

  Column G - Store QOH + QOO + FOQ: shows your store's quantity-on-hand (including Quantity-On-Order and Qty. on Future Order) as of the last Mango report date (last month-end).

  Column H - Offer OM: shows the number of units ships with the deal. 

  Column I - Sugg Order Qty: show the quantity Mango is suggesting to order

  Column J - Order Qty + QOH: column G + column I

  Column K - Shelf Capacity: shows your store's floor shelf capacity if using Mango's Back Stock system (location 3). More info here.

  Column L - Store TTM Sales Units: shows your store's twelve trailing months (TTM) sales units, including promotional sales.

  Column M - Weeks Supply:shows the number of weeks supply the deal will bring in at the suggested order quantity, (also takes into account your store QOH).

  Column N - Offer Cost: shows the deal's discounted cost.

  Column O - Discount: shows the offer discount from regular cost.

  Column P - Future Cost: shows the SKU's regular or future cost.

  Column Q - Peer Sales Units: shows the number of units peer stores sell the SKU annually. This column is adjusted for your store's size within the peer group and is an indicator of how many units your store is likely to sell annually.

  Column R - % Peers Selling: shows the percentage of stores in your peer group selling the SKU. Peer groups are typically between 20 and 60 stores. 

  Column S - Offer Description: shows the deal's description.

  Column T - Drop Ship: Y = Drop Ship Deal.

  Column U - Ship Date: the deal's ship date for the bulletin (deal) listed. Note: Mango will try and select the most relevant ship date for your store if there are multiple shipping date options.  But you should review! 

  Column V - Bulletin Dating: the deal's anticipated statement due date.

  Column W - Store Closeout: shows if the SKU in your store is set to Store Closeout Y/N.

  Column X - Allocation Qty: limit set by Ace for the number of units your store can order. If blank then it's unlimited.

  Column Y - Event Type: shows Ace's convention event category for the deal.