Mango Report® Change Log

June 2025 Report Run

  • OM Analysis
  • Data Connector upgrades for Eagle Level 35
  • Fixed Order Qty Exception Report - Beta Testing
  • Safety Stock Exception Report
  • DM Report retooling
  • Show Buying Report enhancements
  • Assortment Report Metric Reset
  • Propello Bug Fixes - Track Inventory and Prime Vendor

May 2025 Report Run

  • Obsolete Class Intelligence
  • Overstock Valuation 2yr Excess
  • Delete Report is now compatible with Propello
  • Analysis on Fill Shelf Report from January - In Progress

April 2025 Report Run

  • Switched Online Report Access providers
  • Smart Obsolete refactoring - Alpha Stage
  • Decommissioning old Help Center

March 2025 Report Run

  • Integrated Assortment snoozes into the metric and reporting
  • Fill Shelf Report tweaks and enhancements for future release
  • Show Buying Report - released
  • New FTP site for Online Report Access

February 2025 Report Run

  • ROP Protect on RAD Release
  • Assortment Snooze Button Enhancement

January 2025 Report Run

  • Fill Shelf Report - released
  • Count Sheets - new Count Type = ICM, catching phantom replaced SKUs that are blocking replacement reorders
  • Floor Exceptions - new exception, Special Order SKU check
  • Floor Exceptions - new exception, ICM pairs with QOH
  • Ace Min OP - 2025 list released

December 2024 Report Run

  • Refactored XX Count Type to better catch phantom inventory and upcoming COM-status SKU
  • Preseason fill Shelf Report work
  • Propello - enhanced store daily loading and QA 
  • Propello - new file-gathering technology
  • User Files - testing new online file platform for retailer files

November 2024 Report Run

  • COM delay accelerated for slow-moving SKUs - higher sales threshold
  • Minimum Order Point engine - refactored for paint and high ATX SKUs
  • Count Sheets - increased XX Count Type SKUs for stores with a high amount of Obsolete SKUs
  • COM SKU list - tune the list to consider LPI date as a factor
  • COM SKU list - increased the SKUs reported to 125 up from 100
  • Preseason Fill Shelf concept report testing
  • Report run reliability data exchanger

July 2024 Report Run

  • Show Buying Report - increased Fill Shelf Deals
  • Show Buying Report - Fill Shelf and Opportunity deals sent to Acenet
  • Help Center - more Propello content 

June 2024 Report Run

  • EOQ Engine - increased item selection 
  • Help Center - new Help Center content move 

May 2024 Report Run

  • EOQ Engine - increased item selection 
  • Help Center - new Help Center content move almost complete
  • MEGA - OM Variances to include Variable Order Multiple details (VOM)
  • Continued work with Ace/Epicor to identify hotsheet issues​
  • Internal - automatic initial data QA processes.
  • New Live Goods class = 152
  • Propello - COM integration work
  • AOS Decline analysis
  • Propello - report duplicate SKUs (non-unique within the first 14 characters)

April 2024 Report Run

  • EOQ Engine - increased item selection (cost threshold increased to account for inflation, lowered item gap by 1 unit)
  • Help Center - new Help Center content move almost complete
  • Worked with Ace/Epicor to identify hotsheet issues

March 2024 Report Run

  • Master Exceptions - Order Multiple - Variable Order Multiple (VOM) engine exposed
  • Count Sheets - New Count Type: OT AOS for canceled  AOS orders with no sales nor shrink
  • Spring '24 Show Buying Report and Digital Convention deals scored and report emailed

February 2024 Report Run

  • MEGA Report - Key Metrics - added IRA Validation 
  • Help Center - Winter Webinar Series Videos 
  • Master Exceptions - New Vend/Alt part # report
  • ​Internal - network rebuild 
  • Internal - new AOS Decline data feed loading 
  • Internal - new Help Center content/format transition work
  • Internal - Variable Order Multiple (VOM) engine should be ready for March report run

January 2024 Report Run

  • MEGA Report - added Shrink Variance Worksheet tab
  • MEGA Report - export files now build store specific files
  • ​Internal - rebuild of Ace daily file processing
  • Internal - new AOS Decline data feed for future Count Sheet and Outs reporting, etc
  • Internal - new Help Center content/format transition work
  • Internal - physical server upgrades

  •  December 2023 Report Run

    • Internal - reworking of daily data gathering system and daily QOH collection 
    • Internal - MEGA Report rewrite using new Excel engine
    • Internal - new Help Center content/format transition work

    November 2023 Report Run

    • Significant internal data loading, report processing, and reliability upgrades 
    • New Excel building engine upgraded for all online Excel reports 
    • New internal online report delivery process 
    • Total Report Run time reduced by 24 hours.

    October 2023 Report Run

    • UPC - added "Delete URL from SKU" to UPC exceptions when UPC is a URL (a.k.a a QR code).
    • Large format retail and costs are incorporated (retails and costs above $9,999.99).
    • Significant internal data processes upgraded.

    September 2023 Report Run

    • Help Center migration work
    • Show Buying Report
      • F23 deal review & analysis
      • Incorporate VOM (match discount tier to store OM)
      • Refactor spike sales and unusual demand engine
    • Westlake daily data feed
    • EOQ Tier 2 work 

    June 2023 Report Run

    • New Video - Onboarding Month 1 welcome
    • New Video - Report Packet Overview
    • New Video - Master Exception Intro
    • ARMA App - Max Stock Tier 2 Pilot
    • Variable Order Multiple (VOM) - data feed and engine work
    • AOS Inventory Accuracy Decline - data feed and analysis work

     May 2023 Report Run

    • MEGA Report - Overstock Tab - added transfer stores candidates for chains 
    • IRA - replaced calculated IRA with ?? for stores with completion less than 95%
    • Propello - improved sales data alignment and GAP analysis
    • Propello - incorporated bulk value as placeholders for skus using this option
    • ARMA App - Max Stock Tier 2 development work

    April 2023 Report Run

    • Spring 2023 Show Buying Report support
    • Internal infrastructure improvements ​

    March 2023 Report Run

    • Spring 2023 Show Buying Report deal QA, analysis and build. 
    • Show Buying Report automation work. 
    • Internal infrastructure improvements 

    February 2023 Report Run

    • New Office Exception - Location 2 = MDR and Store Closeout = N
    • Count Sheets - WD Rtn/Def engine refactored to target fewer but a higher risk pool of SKUs
    • Count Sheets - OT Neg engine refactored to target better SKU population.
    • Internal infrastructure upgrades
    • Added Misc Issues tab to MEGA Report to address random Office Exceptions

    January 2023 Report Run

    • Excel - New Product Analysis Workbook updates and combines previous Vendor Analysis and Class & Productivity Analysis.
    • New Office Exception - Store Closeout = U (on temporary closeout in your Eagle but available at RSC).
    • Count Sheets - Refactored MC Count Type engine.
    • Eagle PIP - Mango Count Type column and grid layout testing/optimization (future Eagle release).

  • December 2022 Report Run

    • UPC engine upgrade - better blank UPC detection, deeper x-link detection
    • EOQ engine upgrade - fewer oscillating suggestions for stores with a lot of shelf cap. (Loc 3)
    • New Office Exception - Blank QOH
    • New Office Exception - Zero Max Stock
    • New Floor Exception - Missing Shelf Capacity, for stores utilizing back stock.  

    November 2022 Report Run

    • ARMA - Priority button and dept. filters added.
    • MEGA - New worksheet - SKUs Missing Shelf Cap (loc3).
    • MEGA - New worksheet - Inventory Value Changes.
    • MEGA - Can/Rep report - added peer selling % and estimated annual sales units for replacement SKUs.
    • Westlake Eagle integration.

    October 2022 Report Run

    • New ​Daily Metrics site for stores.
    • Variable Order Multiple (VOM) data feed work. 
    • Back stock without Loc3 report work.
    • ARMA Back Stock work - Priority list, additional filters, etc.

    September 2022 Report Run

    • ​Launch of Back Stock on ARMA
    • Work on VOM (variable order multiple) engine.
    • Propello integration work.
    • 90 new stores added to the program

    ​

    August 2022 Report Run

    • ​Show Buying Report work
    • Pilot testing for back stock on ARMA
    • New backstock videos and help content for the launch

     

    June 2022 Report Run

    • Back stock Ace Mobile App development and testing.
    • Variable Order Multiple Engine development and tuning.
    • New Office Exception Report - EOQ Shelf Capacity.
    • Excel Email - KIM Report depreciated. 
    • Excel Email - to be entirely depreciated for stores with sufficient Eagle levels to utilize automation and integrations. 

    May 2022 Report Run

    • Continued work to sunset the Mango_KIM file. More info can be found here.
    • MEGA Report -> In Stock tab now defaults to hide data that can be actioned on RAD.
    • MEGA Report -> Discontinued Mismatch to include SKUs not orderable in your RSC, with the wrong Disc flag.
    • Office Exceptions -> New RAD Checklist to replace In-Stock reports.
    • Office Exceptions -> Stopped building In Stock pages that can be actioned on RAD.
    • Help Center -> continued Propello Help.
    • Special Fee Codes - Paint Care - included New York Paint Care file, Updated ME Pesticide list.
    • ROP Protect Exceptions - enhanced engine. 
    • Backstock -> ARMA App. integration work.

     

    March 2022 Report Run 

    • Show Buying Report work
    • Continued Propello work with Beta Stores
    • Launched EOQ on RAD

     

    February 2022 Report Run 

    • MEGA Report - Index worksheet updated.
    • MEGA Report - Key Metrics worksheet started.
    • KIM Report - This report will be discontinued in the future as functionality has been replicated and improved in the MEGA report. 
    • EOQ (min/max) - Integration live on Acenet RAD.
    • Propello integration:
      • Live stores.
      • Daily back stock.

    January 2022 Report Run 

    • MIN OP Reduction in RAD - updated help.
    • Overview video for Operational and Productivity Levels.
    • Add 2 new peer groups - TEXGC (Texas Gulf Coast) and BAMA (Alabama).
    • Cleaned up stores in mismatched peer groups.
    • Default NEW location - updated help to utilize Epicor utility.
    • MEGA -> Fixed small bug on macro open.
    • MEGA -> Location Exceptions -> Added new columns.
    • Updated Ace MOP list to reflect 2022 candidates.
    • Updated Paint Care to 2021 list.
    • Internal -> Propello integration work.
    • Internal -> better shelf capacity internals.

  • December 2021 Report Run 

    • Help Center - New Onboarding Training Module.
    • Charts - Inventory Accuracy Scorecard - Added Shooting Outs Metric.
    • Fixed Discontinued Flag Mismatch when chain served from multiple RSCs 
    • Testing Multi-Store RAD (future).
    • Testing EOQ/Max Stock RAD integration (future).
    • Min/Max engine tweaks (suggesting more inexpensive, low-cube items).
    • Epicor Propello integration work.

    November 2021 Report Run 

    • MEGA: Added check-boxes to index page.
    • MEGA: Added Invalid UPC, RPA Audit, and all other Master Exceptions.
    • Epicor Propello integration work.
    • Ace RAD integration work for Max Stock (EOQ), Min OP Reductions, etc.
    • Mobile Count Sheet assignment bug fixed.

    September 2021 Report Run 

    • MEGA: added prime vendor mismatch tab.
    • Future Acenet In-stock enhancement work.
    • Level 2 and 3 min order points incorporated into Min OP Reductions.

    July 2021 Report Run 

    • Closeout Management Labels update
    • Mobile Count Sheets via Zebra
    • Future enhancements with Ace

     

    May 2021 Report Run 

    • Excel MEGA Report - added Eternal Outs worksheet
    • Excel MEGA Report - added Item Setup Issues worksheet
    • Excel MEGA Report - added Cross Merchandise Suggestions worksheet
    • Back Stock - added intelligence to spot transfers and ID them on report
    • Executive Summary - renamed In Stock Fusion to OP Fusion to better reflect what the metric is measuring
    • Special Fee Code - won't report PDF when using Related SKU field instead

     

    April 2021 Report Run 

    • Paint Care - Added Washington State to Paint Care Fee audit. (Office Exceptions, MEGA).
    • AH.COM - Bug fix for Eagle Level 30 stores and .com transactions/dollars mapping into Mango.
    • MEGA Shooting Outs tab - added Dept. column.
    • Back Stock - Added Location 4 as Back Stock Location (optional).
    • Internal work to monitor/report Realtime Count Sheet Completion.
    • Product Mix Report - added Loc2-6, Dept, Mfg Num, Vendor Num, Item Detail Hyperlink, Google Search hyperlink

    March 2021 Report Run 

    • Show Buying Report
      • S21 deal set incorporated. Better internal deal set automation, QA, and analysis processes.
      • New "Fill Shelf" Scoring Category.
      • Excel - Show Buying Report updates (new columns, buttons).
      • Video and help documentation updated.
      • Direct Download link in Action, Review, and Excel email.
    • MEGA Report
      • MEGA Report - In Stock - Added ROP Protect too high to ROP Protect changes.
      • MEGA Report - Shooting Outs -Updated sort order and added print button.
    • Internal
      • Better UPC X-link QA processes.
      • Better multi-location sales suggestions engine for suggesting SKUs that sell better merchandised in multiple locations. 

    February 2021 Report Run 

    • Excel MEGA Report - Added Promo Residue worksheet - currently in an experimental phase.
    • Excel MEGA Report - minor bug fixes to the main macro.
    • Excel MEGA Report - added Times Reported column to In Stock tab, added outs data (times, days) to CTX min op type.
    • Excel MEGA Report - added CS XX - Store Closeout Check - consider setting store closeout = Y on some XX Count Type items.
    • Excel Non-Ace Product Mix - minor bug fixes to the macro.
    • Closeout Management - added a 4th step to MIP & Label to help keep MIP clean.
    • Excel Mango_IVA - usability upgrade with Avg/Rep Cost buttons, print button. Ability to see IVA Overview with either Avg. or Rep. cost.
    • Office Exception - Added Count Type XX - Store Closeout Check.  (SKUs you might want to set to SC=Y if zeroed when count sheet processing).
    • Excel Delete Report - now macro enabled with easy export button for data files.
    • Show buying report Spring 21 initial work on dealset. 
    • Stop Sales & Recalls - old data cleanup.
    • Work with Ace/Epicor to help with Acenet and AHCOM QOH quality. 
    • Underlying work for future Option ID report.
    • Eagle Mobile+ Physical List -  Mango list bug fixes and enhancements.

    January 2021 Report Run

    • Excel MEGA Report - Added ROP Protect Exceptions to In Stock tab (consumes the separate ROP Protect tab).
    • Excel MEGA Report - Added Back Stock Shelf Capacity tab.
    • Excel MEGA Report - Added Back Stock - Top Back Stock tab.
    • Office PDF - Refreshed ROP Protect Exceptions to include other exception types (blocking min op, max op mismatch), made report part of the In-Stock class.
    • Floor PDF - Eternal Outs shows ICMBlok when a persistent out is a replacement ICM SKU being blocked from replenishment due to the replaced SKU having quantity-on-hand.
    • Daily Back Stock Report - Shelf Capacity and Top Back Stock tabs moved to the Mega report.
    • Max Stock Engine - tweaked the bias towards increasing max on lower-cube units and less max on higher cube units, especially at the 1-Add / 2-Review threshold of 400 cu. in.
    • Excel - Promo Residue Report - Experimental version of a promotional residue report.  Located in the Data Import+Multi-Store directory.  

  • December 2020 Report Run

    • Excel MEGA Report - combined All Store Exception and All Store KIM into one report.
    • Excel MEGA Report - enabled "Direct Download". Allows report to be downloaded with one click from email or Action PDFs.
    • Excel MEGA Report - available at time of report email (no build delay).
    • Excel MEGA Report - combined all order point recommendations (including Max Stock) into In Stock tab.
    • Excel MEGA Report - added UPC x-links to report.
    • Max Stock Engine - further min/max refinement and a new recommended "Max Removal" engine.
    • Office/Master Exception PDFs - Direct Download of MEGA report by clicking on Excel icon.
    • Executive Summary/Key Metrics PDF - In Stock Fusion metric now includes Max Stock, and a 3-month in stock weighting.
    • Executive Summary PDF - new In Stock sub metric showing adoption of individual metrics (in stock, min op, and max stock).
    • OL0 - Count Sheet Completion metric to daily Back Stock email. 

    November 2020 Report Run

    • Excel - All Store Exception - New Missed SKUs tab. Shows Count Sheet SKUs not counted over the last three months.
    • Excel - Fiscal Shrink workbook now macro enabled for column formatting.
    • Excel - IVA workbook now macro enabled for column formatting.
    • Max Stock - Continued tweaking max engine: reduced suggested max on high-volume SKUs., Times Reported on Excel report.
    • Max Stock - Cubic Inches override QA process; where vendor data is bad.
    • Daily QOH from stores and quality check. 
    • Fixed API integration issue for very large chains.
    • Quarterly Paint Care fee listing update.

    October 2020 Report Run

    • Enhanced min and max order level engine.
    • Enhanced Max Stock Excel and PDF reports.
    • Better canceled/replaced SKUs with Suggested, Direct, Multi suggestion types.
    • Back Stock Replenishment now included in Mango subscription

    September 2020 Report Run

    • Fall 2020 Show Buying Reports 
      • New "Scoring Category" for score grouping 
      • Re-tuned scoring engine
      • Added Deal Cubic Foot and Savings per Cubic Foot data 
      • Report data integrated into Mobile and Acenet Digital Convention apps

    August 2020 Report Run

    • Acenet/Eagle Integrations are live!  
    • Assortment Report Engine tune up. 
    • Maine Pesticide Special Codes Listing

    July 2020 Report Run

    • Added AH COM Ship-To Transaction and Sales Units to Excel Product Mix and Excel KIM Assortment tab.
    • Added On Order but not Replenished to Excel - All Store Exceptions. Added Times Reported (TR) to Office Exceptions PDF.
    • Added Times Reported (TR) to Floor Exception PDF Store Closeout Check page. 
    • Added Number of Bin Labels (facings) to Floor Exception PDF Multi Location page.
    • Operational Level 0 Webinar - refreshed and live
    • Operational Level 1 Webinar - refreshed and live
    • New Integrations Sneak Peek Video
    • Mango Daily Back Stock Webinar

    June 2020 Report Run

    • Refreshed PO Season Code help.
    • ​Min/Max Order Point - Refreshed selection engine.
    • Office Exceptions - Reinstated Top Promo and Discount exception trap utilizing AHCOM transactions.

    May 2020 Report Run 

    • All Store Exceptions - added print buttons to many workbook tabs.
    • All Store Exceptions - added Discovery Code audit to the Cat Diff - SKUs tab.
    • Product Mix - converted to a macro enabled workbook.
    • Closeout Management RAD - step-by-step videos created for MIP & Label process.
    • Closeout Management - new video for printing bin labels using the COM Labels .csv file.
    • In Stock Webinar - new webinar video recorded and ready for launch of the Epicor/Acenet integrations.
    • Closeout Management Webinar - new webinar video ready for launch of Epicor/Acenet integrations.
    • AH.COM transaction history accumulation.
    • AH.COM added to Shrink Reason in Shrink Report if item was part of an AH.COM transaction recently.
    • AH.COM tab added to All Store Exceptions report.

    April 2020 Report Run 

    • Epicor/Acenet integrations and functionality tested and ready for release when appropriate.
    • All Store Exceptions - added "Ratings" tab showing Google store ratings and listed store hours.
    • Show Buying Report - rebuilt with March 31 store data. 

    March 2020 Report Run 

    • Bug Fixed - Office Exceptions RSC Discounts - Corrected RSC linking (was using wrong RSC for many stores). 
    • Assortment Report (KIM) - better filtering of state/county product restrictions.
    • Bug Fixed - Stop Sales & Recall - California light bulb bug fixed.
    • COM - MIP Import automation testing via Eagle Level 29.0 and 29.1. Cool!! 
    • Acenet - COM & In-Stock integration testing. Cool! 
    • Show Buying Reports built and updated.
    • Show Buying Report scoring integrated into Ace's retailer mobile app.
    • Metrics - Store's Google rating and number of ratings being captured (testing)
    • All Store KIM - Vendor Number column added to Assortment Tab. 
    • "RENT" Location Code forces SKUs to be treated as placeholders.

    February 2020 Report Run

    • Product Stewardship - WA Lightbulb codes corrected, paint 5-gal code corrected, Chalk Paint corrected.
    • Ace Data - Better National Central and Source RSC data.
    • Ace Min OP List - updated to Ace's new 2020 list.
    • Internal work -> Show Bulletin integration with Ace Ordering App., Show Bulletin scoring engine work.
    • Internal work -> Closeout (COM), Min OP, In-Stock integrations being tested with Acenet/Mango/Eagle integrations.
    • Mango Daily - Backstock report system available (extra monthly subscription).
    • Mango Daily - Help Center content created.
    • Mango Daily - Backstock report - Shelf Qty and Order Point suggestions report, top Back Stock and inventory dollar/number figures added.

    January 2020 Report Run

    • Excel - Catalog Differences merged into All Store Exceptions (to reduce the number of Excel files to open/manage).
    • Excel - All Store Exceptions: added "Export" buttons to easily export CSV files for the purpose of Data Import or Network Access Import.
    • Excel - All Store KIM: added "Export" button (In-Stock) to easily export CSV files for the purpose of Data Import or Network Access Import.
    • Floor Exceptions - added "RSC Days Out Percentage" to Shooting Outs tab for easier outs research.
    • Internal work -> Acenet In-Stock data quality and adjusting TRIDMT queues in affected organizations. 
    • Internal work -> COM integration! Coming soon! 
    • Internal work -> Acenet In-Stock integration.
    • Internal: better data gathering for organizations with over 2.1 million SKUs.
    • Daily Back Stock Replenishment Report in testing.

  • December 2019 Report Run

    • Shrink Report - Defective Listing - Changed sort order to Defective Policy first.
    • Office Exceptions - Added Store Closeout Check when a SKU is added from the Assortment Report but Store Closeout is set to Y.
    • Office Exceptions - Added exception looking for SKUs only differing by "oh" and zero. E.g. 0332 and O332. These types of SKUs can cause sales, shrink, and purchasing errors.
    • Paint Care and WA Lightbulbs lists updated for product stewardship states.
    • Internal work on Mango -> Acenet In-Stock integration.
    • Internal work on Mango -> Eagle COM integration.
    • Internal work on Mango -> Ace Show Ordering App integration (Show Bulletin).
    • Internal & remote store work on In-Stock and Shooting Outs data quality. Working with stores, Epicor, and Ace to improve data quality for nightly transmittal of inventory information. 

    November 2019 Report Run

    • Excel Show Bulletin - the next Show Bulletin report will include Merchant Specials along with an enhanced scoring engine: better deal scoring, better bulletin selection based on seasonal start date for store. 
    • Count Sheets - fixed a bug that was showing the same SKU multiple times for some stores. 
    • Master Exceptions - OM Variance, will not report SKUs with store OM higher than RSC when the store's OM is reasonable based on sales. This allows stores to set OM to case/pallet quantity without Mango suggesting to override. Note: all OM variances will still be reported on the All-Store Exception workbook. 
    • Excel Location and Class Productivity - added department to location tab, Related classes and finelines now show for non-Ace classes/finelines. 
    • Integrations - work continues on future Acenet and Eagle integrations of the Excel KIM workbook (assortment, in-stock, and COM tab), along with COM MIP and Label import. 

    October 2019 Report Run

    • Count Sheets - Refactored to re-report (TI, XX, MC) SKUs until counted, instead of skipping the SKU for several months.
    • Count Sheets - XX Count Type to focus less on in-process MDR/COM SKUs and more on SKUs about to become obsolete. 
    • Count Sheets - Better RC Count Type selection for stores with limited number of Ace SKUs. 
    • Acenet - Assortment Report integration to go live in mid October!
    • Excel All Store Exceptions - added columns to COM Pinned to also show removal candidates.
    • Eagle - Level 29 now has option ID 1876 which should be set to "Yes" so that SKUs in Physical Lists show as counted when RPI is run (even without the list designation). This change makes it much better for stores who use Directed Count and/or use Physical Lists in PIP to track completion progress! 

    September 2019 Report Run

    • Show Bulletin - Fall show deals loaded and scored.
    • Acenet - Assortment Report integration testing (upcoming integration that will be very cool). 

    August 2019 Report Run

    • RCIN - Shrink bug fixed.
    • Excel Catalog Differences Report - Vendor Number and Vendor Mfg# are now RSC-specific.
    • Charts PDF - Executive Summary: reworked "Margin Potential" to show margin point increase/decrease from last year. This metric shows if your store is keeping pace with cost inflation. 

    July 2019 Report Run

    • Shrink & RCIN - Enhanced Mango's ability to deal with RCINs and its impact on shrink reports and metrics. 
    • Delete Report - added help links to class, finelines, mvg vendors.
    • Multi-Store Resources - continued development for MS help. Not quite ready for prime time, stay tuned.

    June 2019 Report Run

    • Excel Catalog Differences Report - Added Acenet Direct tab.
    • Excel Catalog Differences Report - Added help on how to copy/paste SKUs into Acenet to request hotsheet updates. (this is a great feature!).
    • Excel Product Mix Report - Added Discovery ID and explicit Last Purchase and Last Sale dates for sorting and filtering.
    • COM - Built API for future closeout management integration into Eagle (automatic MIP import, automatic label file).
    • Worked on identifying and requesting fixes to various data quality issues surrounding catalog and drop ship catalog data.
    • Excel All Store Exceptions - Discontinued Flag Mismatches, updated help to show how to request hotsheets via Acenet.
    • Infrastructure upgrades.

    May 2019 Report Run

    • Fixed - Average Transaction showing incorrectly for some SKUs in CTX report. 
    • Option ID Audit Report - a lot of work was done develop an Eagle Option ID report, testing this month! 
    • Retail Pricing Analysis Report - work on developing a retail pricing analysis report...more work needed. 

    April 2019 Report Run

    • Excel All-Store Exception Can/Rep tab - worked on recommended actions, added columns.
    • Acenet Integration - worked on KIM integration with Retail Analytics Dashboard.
    • Excel Cat Diff Report - worked on hotsheet integration.

    March 2019 Report Run

    • Excel Show Bulletin - Spring Convention buying report created. Enhancements made to the scoring system.
    • Excel Show Bulletin - Direct email of the workbook when Power Buys are orderable. 
    • Count Sheets - Enhanced MC Count Type engine to be more sensitive and react more quickly.
    • Cat Diff Excel - Work in progress to include Dept. alignment.
    • Updated Paint Care and Light Bulb SKUs for states required to charge product stewardship fees.
    • Excel Multi-Store KIM - In Stock column simplification. 
    • Major internal database enhancements.

     

    February 2019 Report Run

    • Excel - Inventory Changes Refresh - Inventory changes workbook has been refreshed to make identifying large inventory change easier.
    • Ace Min OP - Updated "Ace Recommended" Minimum Order Points to Ace's 2019 List. 
    • Excel - Catalog Differences now includes Departments.
    • Excel - Catalog Differences Help updated.
    • Help Center - Updated RPA Audit help.
    • Internal - Upgraded servers and platforms!
    • Excel - Added "Blank Location or Class" tab to Location and Class Productivity report
    • Excel - Added "Blank Vendor" tab to Vendor Analysis report.

    January 2019 Report Run

    • Office Exceptions - New High Returns Ratio exception to ensure store policy is being followed in high-risk transactions.  
    • Excel All-Store Exceptions - Discontinued Flag Mismatches now show all mismatches.
    • Excel Catalog Differences - Updated Help for Data Import and Macros.

  • December 2018 Report Run

    • Help Center Best Practice - Updated content with Inventory Coordinator Checklist. 
    • Office Exceptions - Low Stock Check has a new section showing good RSC discounts. 
    • Master Exceptions PDF - fixed bug affecting some multi-stores not displaying all stores.
    • Master Exception PDF - is now located in Data Import & Multi-Store folder online. 
    • In Stock - corrected errant ROI calculation.

    November 2018 Report Run

    • Charts.pdf - Fixed GMROI TTM calculation bug.
    • Excel In Stock - incorporated all tabs into the All-Store Exceptions located in the Data Import directory (Excel In Stock file is no longer made)
    • Office Exceptions - added Canceled and Replaced Exception trap
    • Exception Report PDF - this file has now been broken into two files to help with processing workflow
      • Office Exceptions - exception taking office work to accomplish
      • Floor Exceptions - exceptions taking floor work to accomplish
    • Floor Exceptions - added Store Closeout Check exception report to identify errant Store Closeout flags.
    • Executive Summary - GMROI - fixed errant peer group calculation for some groups.
    • COM - increased discount delay for higher-priced SKUs and lowered the delay threshold.
    • Master Exceptions - Setup Issues: increased the sensitivity for this trap to report more issues.
    • Eagle Level 28 - Automatic creation of Mango Count Sheets physical list for PIP and Mobile Counting.

    October 2018 Report Run

    • Transfer Reports - included Quantity on Order and Future On Order to transfer engine. The report now excludes SKUs with Loc6 = EXTR.
    • Excel: All-Store Exceptions - Started consolidating full and multi-store exceptions into one workbook.
      • added: Cost & QOH Exceptions, Store Supply, Persistent Negative, Location Code Exceptions, Discontinued Flag and Order Indicator Mismatches.
      • added: UPC Coverage (moved from Product Mix)
      • added: OM Variances, Ghost Promos, ROP Protect to Zero, UnSync Retail Prices
    • Excel: Added - All-Store KIM: a multi-store KIM report. Consolidated Data Import COM file and Data Import OP file into the new workbook.
    • Online Report Structure - a new online report directory structure was implemented to make it easier to find Data Import and Multi-Store Files.
    • Multi-Location Engine: enhanced the engine that picks up on SKUs that sell better when sold in multiple locations.
    • Count Sheets - Location Maintenance - added unique pages and help for Multi-location maintenance, COM - Labels, COM - Remove pages. 
    • Added Excel logo to Exceptions PDFs to indicate a full, Multi-Store listing is available online.
    • Eagle Integration - Level 28, automated Mango Count Sheet List (generation and deletion) in PIP and Directed Counts.

    September 2018 Report Run

    • Discovery Express (EXP) format showing in Assortment and Product Mix Excel Reports. 
    • Product Stewardship - Light Recycle environmental handling charges updated for Washington retailers.

    August 2018 Report Run

    • New Savings Showcase and Power Buy files.

    July 2018 Report Run

    • Ace Data Quality Improvements - better source RSC and cost resolution. Makes In-Stock reporting better for central warehouse SKUs and other functionality.
    • Ace Data Quality Improvements - better non-stock status and Discover Code quality.

     

    June 2018 Report Run

    • Excel Data Import - New Catalog Differences Excel file that shows missing class/fineline/vendor hierarchy data and SKU-level catalog differences.
    • Master Exception - Classes without 'NEW' now shows Class Name in case the store does not have the name set up in their system.
    • Excel Vendor Analysis - Fixed bug where some vendors were showing up twice. 
    • Excel Data Import OP - Removed Min/Max from OP tab, made a new Min/Max tab with Min/Max recommendations since this is a different import and evaluation process.
    • Metric - In Stock Fusion - Tweaked to include Ace Min OP suggestions where annual Peer Median units are greater than 1 OR (this is new) the store sells the Min OP quantity annually. 
    • Excel Data Import - New "Chain Boundary" report that shows full store/SKU listing of Boundary issues (Cost QOH Errors, Store Supply, Negative Value).
    • Help Center - moved hosting location of the Mango help center. Links in PDF & Excel, etc. reports updated.

    May 2018 Report Run

    • Mango KIM - Added Mfg Vendor Number to Obsolete tab (column AE).
    • Transfer Report PDF - Stopped printing "From" PO documents including From Master and individual store POs. 
    • Development of communication interface for future integration with the Eagle system (Count Sheet and COM deployment).
    • Data Import - made new Data Import Location Exception report, for importing location exceptions into Data Import/Macros for all stores. This report was previously housed in the Location Exceptions tab of the Location and Class PProductivityExcel report. 

    April 2018 Report Run

    • WA - Light Bulb Special Fee Code list updated to the new list (January 2018) 
    • Excel Show Bulletin - Power Buys tab added
    • Product Restriction root data - State and County SKU-level process transformed and will stay current going forward

    March 2018 Report Run

    • Excel Show Bulletin - Enhanced the single and multi-store report so that it can be copy/pasted into Event Planner, enhanced help pages, enhanced quality assurance process of deal import.
    • PDF Key Metrics - Can be run by chain-specific districts (for large chains separated into districts)
    • Email delivery changes to accommodate Westlake GM packet
    • Refreshed associated SKU data (assortment report)
    • Fixed a bug which delayed (for too long), obsolete lists for lower volume stores


    February 2018 Report Run

    • Incorporated Ace's 2018 Minimum Order Point listing.
    • Excel Elasticity Analysis - Added Ace Retail to Cost Too High/Low columns.
    • Master Exception/Excel Product Mix-UPC Coverage - Acenet Direct - Better UPC Coverage matching.
    • Excel Non-Ace Product Mix - Added Acenet Direct SKU column.


    January 2018 Report Run

    • Master Exception - UPC/Direct Coverage - added Ace/Direct and Store Replacement Cost columns. 
    • Exception Report - New Special Fee Code Audit exception that suggests adding, changing or removing Special Fee Codes for stores in states required to charge fees for certain SKUs, such as PaintCare® fees. 
    • Exception Report - Shooting Outs bug fixed. The report is now showing SKUs that were not shot out! 

  • December 2017 Report Run

    • New test for Prime Vendor Minimum PO Line Amount (Annual Placeholder Exception Report)
    • New Shooting Outs Exception: shows SKUs that were missed (not counted) during the store's weekly shooting outs process.
    • Mango_KIM: Added Transfer Stores to Obsolete tab to indicate where it might make sense to transfer obsolete inventory from one store to another selling store.
    • New Video: Case Study: OL0 & PL0
    • Count Sheets - New Count Type: OT ATX, to audit SKUs showing quantity-on-hand greater than 1 but not experiencing average transaction similar to peers. These SKUs should be audited to ensure inaccuracy (short QOH) is not causing the lower average transaction. 


    November 2017 Report Run

    • New Video: Mango_KIM Assortment Tab
    • Vendor Analysis - Added MVR - P.O. Minimum Order Amount to Excel Vendor Analysis workbook.
    • Quality - made Average Transaction (ATX) better by excluding a larger range of out-of-bounds and special order data.
    • New Exception Report - COM - Pinned Closeouts. 
    • Bug fix - COM promotional prices going to 0.00; new minimum promo price $0.10.
    • Bug Fix - Min OP Reductions was showing very limited results; expect a much larger list this month.


    October 2017 Report Run

    • New Excel Vendor Report.
    • Email - Level Gauges in report emails.
    • Email - Count Sheet Only emails now includes COM Label import file.
    • Excel Data Import OP: added QOH column.
    • Mango KIM Excel Overstock Tab - added columns: Loc2, Annual Sales Units, Dept, Injected 

    September 2017 Report Run

    • Excel Master Transfer: added an Obsolete column to show obsolete SKUs that can be transferred to other stores with a good chance of selling at full price.
    • Excel Data Import OP: added additional columns (last month at zero, days zero, times zero, inventory value change) to help filter data import file.

    August 2017 Report Run

    • Successful company sail.
    • Internal system capacity enhancements.
    • EOM Automation added.

    July 2017 Report Run

    • Min OP Reduction Engine - Power Tools to not go below 2 Min OP suggestion.
    • New Online Directory Excel - Data Import: multi-store rolled up Order Point report, Closeout Management Reports.
    • Count Sheet Only Email - Added the progress viewer CSV file.
    • Excel Mango KIM - Changed Current OP/Last OP to Current Min OP/Last Min OP.
    • Closeout Management - Tightened up stop-loss values so that more expensive SKUs will hold their initial discounts longer and their final discount will not drop to 75% or 90% depending on item average cost.
    • Excel Non-Ace Product Mix - Added Top 10 NIF (Not in File) tab to show your top 10 SKUs you are not carrying for your Non-Ace vendors.

    June 2017 Report Run

    • Excel Elasticity Analysis - Added MSU tab to help audit MSU pricing in your store.
    • Excel Elasticity Analysis - Added Cost Variance tab to highlight obsolete system replacement costs. 
    • Excel KIM - In Stock tab - Added OM column.
    • Accuracy Cadence - IC Checklist - all checklists and pages updated for consistency. 
    • Internal system capacity enhancements. 

    May 2017 Report Run

    • Excel Product Mix - status column to include Slower, Obsolete, etc. Simplified two columns into one.
    • Excel Non-Ace Product Mix - added common manufacturer number.
    • Small bug fixes
    • Internal system capacity enhancements.
    April 2017 Report Run
    • Webinar - Closeout Management video outlines unproductive inventory and the COM process.
    • Webinar - Orientation video was refreshed with updated content and format.
    • Mango_KIM Assortment Tab - new help on how to filter the report into more actionable lists.
    • Video - Data Import: Location Code Exceptions show how to use data import to change incorrect location codes.
    • Master Exceptions - New Order Indicator Mismatch trap where an Order Indicator of S is attached to an active store location and active warehouse SKU.
    • Bug Fixes - Delete report, fixed: Class delete tab showing to delete even if SKUs in your other chain stores are attached to the class.
    • New Excel Report - Non-Ace Product Mix: is an assortment report for your non-Ace vendors.
    • Non-Ace Product Mix - additional help on how to filter and sort the list.
    • Productivity Level 3 - Assortment: threshold adjusted from 2% opportunity to 3% opportunity based on new engine finding more assortment items.

    March 2017 Report Run

    • Excel - New "Show Bulletin" workbook to help stores order Savings Showcase deals (available online, Excel folder).
    • Excel - Chain Assortment has been made a stand-alone workbook (formerly part of the Excel Assortment Report).
    • Excel - Assortment Report renamed to Product Mix to reduce confusion with Excel KIM - Assortment tab.
    • Excel - In Stock - Shooting Outs tab has been made printable.
    • COM - Promotions ending in .04 - .00 are decremented to .94 - .90 for better buying psychology. Eg. $8.03 goes to $7.93, $4.02 goes to 3.92, etc.
    • Assortment Engine - Internal scoring system switch from PDF Assortment report to KIM Assortment.
    • New Video - Data Import: Min OP Reductions shows how to use Data Import and Mango's In Stock report to make min op adjustments.
    • Refreshed Help - 1st Month on Mango (New video and help).

    February 2017 Report Run

    • Mango KIM - Assortment Tab: added columns: Suggested OP, Newly Reported, Times Reported over last 2-years.
    • Mango KIM - Assortment Tab: tightened filters. Scored several more product groups for similar SKUs.
    • Mango KIM - In Stock Tab: added Annual Sales Units column to indicate the number of annual units a SKU has sold.
    • Minimum Order Point Reduction - check to ensure suggested Min OP is not below the SKU's average transaction; check for multiple locations (active location in Location 2). Aligned Excel In Stock Min OP Reduction Tab with Exceptions.PDF totals (other bug fixes).
    • Closeout Management - COM Labels import file included in Excel Reports email for direct import into Label Manager to eliminate redundant printing of COM labels when promotional price does not change from previous month.
    • Closeout Management - Mango KIM - COM Tab reduced from 120 SKUs to 100 SKUs to reduce the number of overall SKUs in closeout in a store at one time.
    • Count Sheets - COM Label Maintenance, added Remove Label section when SKU has been on 90% Closeout for over a month.
    • Excel Assortment Report - Assortment Tab - added True Value retail price column.
    • Internal changes to better handle bulk, fastener, and key SKU attributing.

    January 2017 Report Run

    • Mango KIM - New COM tab and workflow showing eligible COM SKUs for the month.
    • Mango KIM - Refreshed Assortment tab with better assortment SKU selection engine.
    • Mango KIM - Obsolete tab, added Eligible and In Season columns. 
    • Assortment Engine - upgraded assortment SKU selection engine, New RSC SKU engine, Associated SKU Engine. Started removing/scoring similar items, brands-not-carrying exclusion.
    • Help Center: new 1st month on mango video, Count Type video.
    • Excel In Stock - New Can Rep tab for periodic Cancel/Replace SKU management.
    • Excel In Stock - Min OP tab - added In Stock Fusion column showing if the OP recommendation is included in Fusion metric.
    • Assortment Report PDF - this report is depreciated and will be removed in Q1 2017. Functionality has moved to Mango KIM workbook.
    • Exceptions PDF - removed Unproductive page. Functionality is in the COM tab of the Mango KIM workbook.
    • Executive Summary / Key Metrics - added Lead Measures section: Shooting Outs, COM Fusion, In Stock Fusion, Assortment Fusion.
    • Count Sheets - MC Count Type engine completely overhauled to find more MC's with fewer false-positives.
    • Ace Min OP - New 2017 List incorporated.
    • Help Center updates: COM, Executive Summary, Key Metrics, Excel KIM, Excel In Stock.
    • Excel Assortment Report - assortment tab: added online competitive retail columns.

  • December 2016 Report Run

    • Accuracy Cadence - Addition of IC Checklist.
    • Shrink Report - New Totals page.
    • Help Center - Continued touch-up of Operational Level 0.
    • Help Center - Delete Report help redo. 

    November 2016 Report Run

        • Count Sheets - Previous month missed counts will be included in current month sheets (up to 46 SKUs).
        • Operational Level 4 - Efficiency: raised SKUs Counted max threshold from 33% to 40%. 
        • Operational Level 3 - Shrink: module refresh including refreshed Shrink Report, Shrink & Efficiency Trend chart, help content and videos.
        • Shrink Report - New report: Variance Worksheet.
        • Shrink Report - Reordered sections: Variance Worksheet, Adjusted, Excluded, Defective (removed Count Sheet Results page).
        • Operational Level 0 - Updated PIP Overview video.
        • Operational Level 3 - New Shrink help module and workflow. all new sub pages, excluded, variance research, understanding, monitoring, adjusted, research hints.
        • Operational Level 4 - New Efficiency help module.
        • Help Center - new Shrink & Efficiency Trend Help.
        • Video - new Shrink & Efficiency Trend video.
        • Shrink Report - made Research Hints column logic better with narrower"Alert" status on shrink-for-theft signatures to reduce noise.
        • Added Sales, Gross Profit, Sales Rank, Gross Profit Rank, GP Class Rank and GP Product Group rank columns toExcel Assortment Report.
        • Webinars - Refreshed Productivity Level 1 - In Stock.

    October 2016 Report Run

        • Help Center - Productivity Level 1 - In Stock video for Mango KIM In Stock Tab.
        • Master Exceptions - Acenet Direct - UPC Coverage showing UPCs in your store that have a SKU in the Acenet Direct catalog.
        • Excel Assortment Report - Acenet Direct / RSC source in UPC Coverage Tab to show SKUs available in Acenet Direct catalog.
        • Exceptions - Eternal Outs - Added Acenet Direct SKU as a warehouse status.
        • Excel Assortment Report - Prime Vend column will show Mfg Vend when Prime Vend is blank.
        • Excel Location & Class Productivity - Added Peer Margin and Peer GMROI, added better quality to OUTs% metric.

    September 2016 Report Run

        • Count Metrics (Key Metrics.pdf) - fix averaging bug for some stores.
        • Shrink Report - Excluded Shrink section sorted by Reason column and then by shrink extended cost.
        • Internal - Operational Level 3 - Shrink, Help Center refresh underway.

    June 2016 Report Run

        • Internal - developing better assortment report engine using similar scoring and brand/type affinity.
        • Internal - developing better UPC (non-RSC backed items) classification, scoring and attributing.
        • Internal - hardware upgrades for capacity and speed.
        • Internal - automation of post report run sequence.
        • Internal - better data quality routines and identification during initial data load.

    May 2016 Report Run

        • Closeout Management - New tracking metrics in KIM overview tab, new internal tracking engine improvements, metric benchmarking... 
        • Closeout Management - Expanded Help: Identify, MIP & Label,  Remove
        • Internal - development on Acenet Direct UPC Coverage Reporting
        • Internal - made lots of progress developing a "similar score" for the future purposes of excluding similar items from Assortment Reports - this is cool stuff.
        • Internal - hardware and communication infrastructure upgrades (fiber, yay!). 

    April 2016 Report Run

        • Webinar - Operational Level 1 (IRA).
        • Closeout Management - Task videos. 
        • Closeout Management - Enhancements to identification and markdown strategy.
        • Exception Report - bug fix for retails greater than 9,999.99.
        • Assortment Engine - unified three separate (PDF, KIM, Excel) assortment engines into a common engine. 
        • Peer Group Review -  created 3 new peer groups.
        • UPC - retooled cross-link engine for better quality and pinpoint issues to report to vendor.

    March 2016 Report Run

        • Closeout Management - Soft launch.
        • Closeout Management - Opt-In with Store Closeout = Y and MDR in Location 2
        • Closeout Management - "intelligent" markdown strategy: delay if high-dollar, if discount is "too much" or has good peer sales experience--to maximize cash by delaying some markdowns.
        • Obsolete - better "collection" selection based on SKU review and intelligent separation of sets from individual SKUs based distance from median retail.
        • Obsolete - "intelligent" delay and acceleration of SKUs based on peer data. e.g. accelerate an obsolete if nobody is selling, but delay if peers have good experience.
        • Mango_KIM - Obsolete Tab: added columns: Injected, Dept, ICM SKU, ICM Closeout, ICM QOH for better visibility, sorting and filtering.
        • Exceptions PDF - Unproductive Obsolete section - filtered out SKUs on markdown strategy, closed out or in a collection.
        • Master Exception PDF - Added "Vendor" add in Class/Fineline trap.
        • Master Exception PDF - Added missing "NEW" Default Class Location to Class/Fineline trap.
        • Count Sheets Location Exception - Removed missing "NEW" Default Class Location (moved to Master Exception Report since this is a back office fix).
        • Count Sheets Location Exception - Added Multi Location Maintenance section to call out SKUs to balance or check retail on bin labels for SKUs merchandised in multiple locations.
        • Count Sheets Location Exception - Added Closeout Management Bin Tag Remove trap that shows SKUs on markdown last month but not in this month so that promotional red tags are not orphaned.
        • Exceptions PDF - Added Multiple Location SKUs showing SKUs that will likely benefit from being merchandised in multiple locations.
        • Assortment Report PDF: deprecated the old Closeout Management reports.

    February 2016 Report Run

        • Data - worked with Ace to refresh 2016 Minimum Order Point List, incorporated in Mango's reports.
        • Closeout Management - MIP macro file creation.
        • Internal- Network upgrades to accommodate fiber Internet connection. 
        • Shrink Report - Accommodates 14-character SKUs (from 12 characters).

    January 2016 Report Run

      • Excel Mango_KIM Added Date Reported columns so that newly reported SKUs can be identified, added Loc 2 to show SKUs in multiple locations.
      • Exception Reports - Combined Hot Shrink and Procedure Shrink on same page to save space.
      • Help Center - Updated Hot and Procedure Shrink help.
      • Exception Report - Combined Margin Too High/Low into one page  to save space.
      • Help Center - Updated Margin Too High/Low help.
      • Video - Excel Tips & Tricks: hide, sort, filter, print.
      • Internal data structure changes to accommodate Westlake.
      • Development - Closeout Management strategy and process (inclusion/exclusion Location Codes) and CSV files created for testing purposes.
      • Shrink Report PDF - Research Reasons added Back Stock (BS+) and Multi-Location (Multi+) to indicate shrink on SKUs with Back Stock in Multiple Locations.
      • Refined "collection" taxonomy for SKUs in collection ranges (e.g. numbered drill bits).

  • December 2015 Report Run

    • New IRA Validation Workbook and help for stores with IRA validation alerts.
    • Updated Inventory Accuracy Scorecard help.
    • New Charts.pdf Webinar videoized.
    • Updated Excel Location & Class productivity report (Unproductive and Outs columns fixed).
    • New Multi Location Report tab in Excel Location and Class productivity report.
    • Updated help for Exception Report Placeholder and Fastener Dump SKU Margin.
    • Added Fastener Dump SKU set Margin to annual Placeholder Value Exception Report.

    November 2015 Report Run

    • Neg QOH metric on Inventory Accuracy Scorecard replaced with new metric (times negative/times out) for IRA validation.
    • Better QOO issues detection when errant or vendor canceled order QOO is blocking a SKU from reordering -> Exception.pdf In Stock Eternal Outs
    • Fixed Completion metric for stores making up missed counts in October.
    • Added a "+" to Count Sheets when stores utilize Location 3 for Backstock Shelf Qty and QOH > Shelf Qty to indicate more in back stock.
    • Added manufacturer part number to Count Sheets.
    • Added ability to list more than one secondary location code to Count Sheets.
    • New Operational Level 2 help with checklist. 
    • 2015/16 Get Credit For Value Min Order Points are taken into account in Min OP reduction reports.
    • Added Inventory Accuracy Scorecard alert when Count Sheet Completion falls below 75% for twelve trailing months.
    • Updated Location Code reference including Location 2 and Location 3 guidance, and bin label help.
    • Updated Boundary Exception Report help pages (Cost/QOH Errors, Store Supply, Negative Value).
    • Developed data feed for Acenet Direct SKUs (for future reporting).
    • Deployed PCI access patch to all Mango Stores.


    October 2015 Report Run

    • Count Sheets: Removed QOH from Count Sheets to reduce variance/logging confusion and by many retailer requests. 
    • Count Sheets: Added Count Sheet Count Types definition text to separator page between Ace and Non-Ace Skus on Count Sheets.
    • Transfer report: Allow Store Closeout SKUs to be transferred out (to zero on hand) to a store without Store Closeout status.
    • Added ability to use Eagle 3-digit Store numbers for large chains. (e.g. Store j = Store 035).
    • Changed all report file names from unique Mango IDs (e.g. 5O7LRLIx) to numeric Ace Store numbers.
    • Added Orientation Webinar video (Reference -> Webinars).
    • Resolved SBC & ATT email delivery issue.
    • Fixed Charts.pdf printing error (non-Chrome users) on pages 4,5,6.
    • Revised Operational Level 0 and Level 0 help with checklists


    September 2015 Report Run

    • Added Suggested Min OP Column to Excel KIM and In Stock Days zero report. (replaced Units to Add)


     August 2015 Report Run

    • Enhanced RCIN and Shrink detection to better exclude RCIN's in Shrink Report / Metrics.
    • Tweaked Overstock SKU selection criteria which was picking up Obsolete non-Ace SKUs in certain cases.
    • Added an Inventory Value Year-over-year (YOY) column to Key Metrics Report.
    • Added Productivity Level to Key Metrics report.
    • Addition of Obsolete section in Exception Report - Unproductive.
    • Reorganization of help center to include Productivity Levels. 
    • Reorganization of Executive Summary page to include Productivity Levels and a Mango section to show explicit Mango ROI.
    • Introduction to the Inventory Dashboard report showing two Inventory Levels: Operational and Productivity.
    • Rename Accuracy Level to Operation Level to better reflect the operational focus of achieving accuracy and shrink control.
    • Introduction to Inventory Productivity Levels (0 - 3) to "levelize" key productivity metrics.
    • Incorporate overstock inventory into Unproductive Inventory key metric (Unproductive = Obsolete + Overstock).
    • Bug fix in IRA validation code.
    • Increased filtering to exclude low GMROI SKUs from Assortment Opportunity list/metric.

    July 2015 Report Run

    • New and enhanced "internal IRA" calculation based on daily quantity-on-hand data feed to increase IRA validation accuracy.
    • Addition of Overstock tab in Excel KIM report.

    June 2015 Report Run

    • Internal speed and scale enhancements
    • Upgraded Exchange clients 
    • Utilizing daily negative QOH in data feed  

    May 2015 Report Run

    • Internal scale and performance improvements to physical server
    • Coordination with vendors: billing, PCI compliance, key metrics platform
    • Nick graduated from College - congratulations Nick! lots of videos in store now...

    April 2015 Report Run

    • Internal scale and performance improvements to database engine
    • Working on store weighted margin over time analysis to produce future actionable reports

    March 2015 Report Run     

    • Refactored Mango's Average Transaction engine: produces higher quality peer group SKU-level average transaction which is used in many report engines.
    • Added ability to identify and make consistent, SKUs selling in different multiples across stores. e.g. wire nuts, some stores sell by the each some by the box, this affects average units per transaction.
    • Fixed bug in Exception Report: In Stock - CTX (Common Transaction Quantity) report. 
    • Fixed bug in persistent unsynchronized retail prices where the retail price was showing for the incorrect store.

    February 2015 Report Run     

    • Added SKU-level "Fastener & Bulk" tab in Excel IVA report.
    • Weighting of non-Ace SKUs in Count Sheet Completion metric to full weighting.
    • Enhanced the number of non-Ace SKUs reported on Count Sheets to match store size better.
    • Fixed bug in Delete Report for multi-stores--column "Safe to Delete in All Stores" was not accurate for all stores.
    • New Eternal Outs - Replenishment Exception trap, looking for continuously reordered inventory with no replenishment.
    • Incorporated better restriction and stop sales data, including county-level restrictions for California stores.

    January 2015 Report Run     

    • Fixed formatting bug in Master Exception Persistent unsynchronized retail prices report.
    • Started to tally maximum consecutive days out allowing a more accurate "Shooting Outs" metric.
    • Started to tally the number of times a SKU sells to zero on hand during the month.
    • Updated In Stock - Days Zero report (added Sug Min OP column, Times Out, removed GP Opp, Months Out), more refined filtering.
    • Replaced Excel Kim/In-Stock Days zero column Q: "Number of Months at zero" to "Times sold to zero"
    • Added Baseline Inventory Value Worksheet to Excel IVA Report as an awesome way to see a reasonable value your store's inventory.
    • Min OP PDF Reductions are now filtered to actionable SKUs only (Calculated OP SKUs are excluded)
    • Excel In Stock - Min OP Reductions worksheet has a new column indicating if an OP was calculated or fixed/static. 
    • Added "Times Reported" and PO Season column to Eternal Outs PDF Exception Report.
    • Refreshed Count Sheet Progress Viewer Video
    • Refreshed Help Content: Boundary Exceptions
    • Added 2015 Ace Min OP List

  • December 2014 Report Run  

    • Refined and increased sensitivity in Minimum Order Point Reductions
    • Refined Min/Max recommendations to not suggest Min/Max values already within 20% of recommendation
    • Updated color bar thresholds in Excel KIM
    • Internal data loading fixes: 3-digit MSU codes, better Class, Fineline and Manufacturer header data
    • Added order point to Excel Assortment Report


    November 2014 Report Run     

    • Retooled PDF In Stock - Days Zero to filter out slower moving inventory
    • Retooled Min OP Reduction engine to be more sensitive; shows about 30 times more SKU candidate reductions than before.
    • Min OP Reduction value being tracked as a possible Unproductive metric.
    • Worked extensively with Ace refining the 2015 Min OP listing.
    • Internal modifications to accommodate performance groups and stores with 445 fiscal calendar EOM/EOY rolls.


    October 2014 Report Run     

    • Added Discovery column to KIM Unproductive Excel Report.
    • Added full SKU listing of Location Exceptions to the Location and Class Productivity Excel Report.
    • Improved "calculated location" column in Excel Assortment Report, Assortment Report tab.
    • Updated help for Excel Assortment Report.
    • Added Shooting Outs metric to Key Metrics Count Metrics page.
    • Combined Count Results header pages into Shrink Report, Removed Count Results PDF report from Review Email
    • Removed Class Overview from Assortment Report PDF (available in Location & Class Productivity Excel Report)
    • Added functionality to better identify pending ICM (inventory change management) items
    • Fixed bug in Shrink calculation in Inventory Value Change chart (page 4 of Charts Report).

     
    September 2014 Report Run     

    • Changed Master RPA Audit column headings/help for easier report processing.
    • Added Closeout Management (Assortment Report) inventory value and count by discount type.
    • New Mango Report Overview video.

     August 2014 Report Run     

    • Internal database structure improvements to speed up report processing. 

    July 2014 Report Run     

    • New Video: Shrink Report - helps understand the Shrink Report and how to use it to perform variance research.
    • Added MANGO CSV progress viewer file Excel email.
    • Updated Shrink Report Help Center
    • Refreshed Shrink Report: better headings, research bolding, reasons (added Count Type, Zeroed, Correction, DISC)
    • New Video: Eternal Outs
    • New Exception Report - Eternal Outs - helps stores identify outs not being reordered. increases in stock and reduces counting labor demands.
    • Added Shooting Out and Metric Help/Guidance into Help Center
    • New Video: Excel KIM - Unproductive Inventory
    • Added Shooting Out % Metric on Executive Summary page (Charts.PDF) Other Metrics
    • Added the multiple defective policies to Shrink Report - Defective Items (Policy C items are now shown as Policy C instead of just blanks)
    • Fixed bug in Excel Assortment Report column showing inaccurate replacement SKU Active (Y/N) column.

    June 2014 Report Run

    • Online Report Archive (12-month historical pdf reports) added to online reports. Archive directory.
    • Corrected bug in key metrics, reporting too-low unproductive and overstock inventory for some stores (affects stores with large boundary issues).
    • Corrected bug in Margin Potential metric.
    • Corrected bug where closeout markdown management was picking up current non-closeout promos in some cases.
    • Renamed Excel report "Inventory Value Analysis" to "Mango_IVA".
    • Created Excel report Mango_KIM (Key Inventory Metrics) with help content.
    • Launched Mango KIM, 5 Key Inventory Metrics along with help content and videos.
    • New monthly mango email showing Mango's 5 KIMs with Mango_KIM excel report.
    • Added Sales per Sq. Ft. to Executive Summary, In Stock section.
    • California peer group into 3 groups.
    • Florida peer group into 3 groups.


    May 2014 Report Run

    • New Key Metrics: Accuracy Level, Adjusted Shrink, In Stock Opportunity, Assortment Opportunity, Unproductive Inventory
    • Key Metrics column definitions in Help & Support Center
    • Updated Executive Summary report with fewer metrics, new text and new key metrics.
    • Updated Key Metrics PDF with refreshed metrics. Refreshed Count Metrics (Page 2, added help).
    • Accommodate non-similar item with Ace SKU match (for stores who use Ace SKUs for non-Ace, non-similar items)
    • Fixed a case where coupon a SKU could show in Count Sheets

    April 2014 Report Run 

    • Excel Delete Report to exclude new replacement SKUs added via ICM with old Date Added date
    • Updated In Stock percentages to annualize twelve trailing months rather than only current month (refreshed In Stock report and help)
    • Updated ROI% in In Stock, started to suggest additional quantity to cure out-of-stock (in process)
    • Updated In Stock Exception PDF to no longer print SKUs caused by warehouse service level. This info is being sent to Ace now
    • Fixed issue with ICM replacement SKUs showing as Swell in some situations
    • Fixed Common Transaction Quantity (CTX) to not show crazy suggestions. (Newly added stores were skewing this metric due to a bug)
    • Mango Exchange Client updated to accommodate SSH connection to Eagle for pure PCI compliance. New client services, code updater and libraries updated in all stores. whew!
    • Updated Exchange Service control panel (used internally) for better usability (you're welcome Nick).
    • Moved Help & Support Center to hosted environment for better reliability
    • Added Inventory Change Management (ICM) tracking for future possible exception reports.

    March 2014 Report Run 

    • Added column to In Stock PDF report showing the number of months a SKU sold to zero (non warehouse out affected)
    • Updated RPA Audit Master Exception Report to display an "Alert" for out-of-sequence or other RPA filter/grouping issues, removed unnecessary "Store Target" column
    • Added Location and Estimated Location to Quick Assortment Report (Exception Report)
    • Updated IKM and In-Stock Excel reports with better column help and data quality
    • Updated Cost/QOH Exception Report and Static (Fixed/Placeholder) Exception Reports to accommodate large format stores (Costs & Retails > 9,999) 
    • Fixed bug in Negative Value reported in Inventory Value Analysis Excel Report

    February 2014 Report Run 

    • Updated Excel IKM and In-Stock reports Zero Days tabs to include more detail
    • Created better tracking/accounting of outs caused by warehouse out-of-stocks

     January 2014 Report Run

    • New How to Count Video with "Lines of Defense", Tips before you PIP cards.
    • Consolidated Excel reports: Inventory Value Changes into Inventory Changes. Added TTM (twelve trailing months) value change, changed new and deleted SKUs to TTM. 
    • Consolidated Excel reports, Class Overview and Location Productivity into Location and Class Productivity.
    • New Excel Report (Experimental: inventory IKM) showing two key inventory productivity metrics with actionable SKUs, one of Mango's key reports going forward.
    • New Master Exception Report: Kit Record Header Issues for misconfigured Kit Records causing inventory/reorder issues.
    • Established new email service for more reliable report delivery, tracking and follow up.
    • Fixed Gmail delivery text/html issue with inline CSS.
    • New Online Report access system; new users/passwords. New instructional video for Online Reports.
    • Added columns to In Stock Days Zero PDF/Excel report: OP, (Twelve Trailing months) TTM Outs.
    • Corrected warehouse active SKUs and UPC issues with new Ace data feed.
    • Completed new article/warehouse/store data loading processes (Oct/Nov/Dec).
    • Added Key Metrics PDF Report to all stores in chain (instead of primary only) in Online Reports.
    • Added two new Peer Groups: WISC, PENN.
    • Incorporated long-format costs/retails (above 9,999) into data and exception reports.