Home > MEGA Report > Location Exceptions
MEGA Report - Location Exceptions This tab shows a full SKU listing of your PDF version Location Code Exceptions report. Below is instructions for both Network Access and Data Import. Network Access is slower but allows multi-store organization to make these changes with 1 file. Data Import is much faster but for multi-store, it forces you to generate a file for each store.
This trap looks for an O (letter "O") in place of a 0 (zero) in the location code. This is a common mistake that keeps SKUs with these errant locations form sorting and filtering as expected. For stores with first-digit numeric RSO filters, a leading “oh” will prevent SKUs from showing up on your order! The trap will also look for the “)” (right parenthesis), which is the shift-zero key which is another common error. Note: for obvious reasons, it is a bad practice to incorporate location code schemes with the letter O.
2) Lowercase trap
Case matters in your location code schemes. For example, a location of 01R10 will not filter or sort the same as 01r10. Here Mango will look for lowercase location codes and suggest the uppercase replacement.
3) Single Location
Mango will display SKUs having unique locations in your store. That is, there is no other SKU with a location code matching the listed SKU. A lot of times this will pick up SKUs with errant locations and sometimes this will pick up on SKUs where the unique location code is desired. We continue to put additional intelligence into this section to reduce false-positive reporting (where there is a desired unique location). Some stores will location code individual bins (a store’s plumbing brass rack for example) to make locating product easy in SKU-dense sections.
4) Blank Location
Most stores are very location code sensitive and a SKU with a blank location code is against policy.
5) NEW Persistent
If a SKU has a NEW location code for over 3 months, it will be listed here. These SKUs are newly added but have not yet been assigned a proper location code.
6) All Numeric
For stores utilizing non-numeric location codes, a common mistake when locating entire sections is to accidentally scan a SKU for in the sticky location code and errantly locate the entire section with a numeric partial SKU. This trap will pull these SKUs out and list them here.
7) Closed Out
This trap seeks out SKUs which have been closed out (Store Closeout flag set to "Y") and have a quantity-on-hand (QOH) of zero. Although these SKUs have been successfully closed out, they still maintain an active location and may exhibit a persistent empty hook/bin condition. Note: active codes start with a numeral (0 - 9) where inactive codes generally start with an alpha character (DR, ZZ, etc.).
Most stores change a closed-out SKU's Location Code to DRXX where XX is the year of the SKU's closeout. For example, if SKU 1404540 is closed out in 2019, it's Location Code would be DR19. Before the location is changed, it should be physically checked to make sure the bin tag is removed from the shelf.
Multi-Store: all stores can be done in 1 file which can make this the more appealing option vs Data Import but it is slower.
Stores with Secure Access will not be able to paste in the macro, you'll need to build the macro manually which is different than typing in the macro.
File Prep (A)
Network Access Import (B)
MULTI-STORE WARNING: If you are multi-store you can only do one store at a time. Excel will build multiple files per store in your organization.
Import the Data (B)
Finalize Changes (C)