Setup & Maintenance

  • Location 3 holds the number of units that fit on your sales floor (shelf or peg hook, including secondary locations).

    • You can do this as part of regular department maintenance when you purge back stock, and when putting stock away. 
    • On Truck Day - any SKUs placed in top stock or back stock need to have Location 3 information updated.

    Onboarding SKUs into Back Stock Replenishment 

    A RF gun or Zebra unit is a great tool for getting SKUs onto the back stock program. Under the Location Maintenance menu, location 3 data can easily be entered on SKUs. In the example below I have 2 facings of 5 for Great Stuff crack filler, so I've entered 10 into Location 3. Common examples: Spray Paint - 6 per facing, gallons of paint - 4 per facing, etc. Below are the steps for getting SKUs onto the program.

    • Backroom Task

      1. Login to the Eagle Mobile+ app.
      2. Under the Inventory menu, click Item Lists.
      3. At the bottom of the screen, click New.
      4. Give the list a name "BackStock" and click the + symbol.
      5. Scan a SKU in Back Stock.
      6. Click the +Add button.
      7. Continue scanning all the SKUs in your Back Stock and Top Stock, repeating steps 5 and 6. 
      8. Once complete, click the ". . ." in the lower right.
      9. Select Build Label Manager File, a new window will appear, select Done.
      10. Proceed to a computer and open Eagle Browser.
      11. Select Label Design and Printing Menu -> Print Inventory Labels.
      12. In the header, select Import.
      13. From the Source dropdown, select Eagle Mobile and click OK.
      14. Select the list you created from your Zebra, change the Label Format to Price Label and click To Label Mgr.
      15. Locate and double click the Location column to print in location order.
      16. If some SKUs already have shelf capacity they can be filtered out using Location 3.
        1. Right-click on the Location 3 column header.
        2. Click Filter on Location 3...
        3. Select Is Blank and click Apply Filter.
      17. In the header, click All/None (+) and then Print (Ctrl + P).
      18. Select a bin label, your standard bin label is perfect, and click Open.
      19. Confirm the correct Printer is selected, click OK.
      20. Retrieve the paper from the printer, attach to a clipboard and proceed to Sales Floor Task below.

       

      Sales Floor Task

      1. Login to the Eagle Mobile+ app.
      2. Under the Inventory menu, click Location Maint.
      3. With your clipboard of SKUs, locate the first item out on the floor.
      4. Scan the SKU or the bin label and count how many fit to make a full shelf, enter that value into Location 3. 
        1. If the shelf isn't completely full, estimate how many will fit, enter that value into Loc3, and write the difference on the label to refill your shelf to full capacity. See minute mark 4:00 from the video above.
      5. Click Save.
      6. Continue this process for all the remaining SKUs on your labels list, repeating steps 4 and 5.

    Optional - Location 4

    For stores interested in giving SKUs in back stock a location we recommend using Location 4. This is displayed in the app and allows for quicker picking each day. Common locations included TOP (top stock), BACK (backroom), BSMT (basement), OUT (outside), and many more. This can be expanded to TOP05 for top stock in aisle 5. 

    Additional Info

    Using Location 3 to indicate shelf quantity has multiple benefits in Mango. 

    • Paper Count Sheets will show a Green Plus  for SKUs where the quantity-on-hand (at month end) was greater than the shelf capacity (Location 3). This helps prompt your counters to look in back stock for additional quantities when processing Mango's Count Sheets.
    • Shrink Report shows BS+ in the Research Reason column indicating a possible incorrect count to a SKU in a back stock position (a common occurrence).
    • You can set up PIP to show Loc3, which is a big help with variance research!

    • If you can fit 12 cans of spray paint on your shelf then enter 12 in Location 3 (click on Location in Inventory Maintenance to bring up the Location Code Maintenance window). 

      Eagle Location 3 Example

      • If Qty On Hand is 20 then Mango's Count Sheet will show a Green Plus indicating more to count in back stock.
      • The Shelf quantity printed on the bin tag indicates a SKU with possible back stock which is helpful for department maintenance and customer service.
      1. Open Eagle Browser.
      2. Click on "Label Design and Printing Menu."
      3. Click on "Design Inventory Labels."
      4. Click "Load Lbl" (F6) and open the label that your store uses.
      5. Click "Add Fld" (F4) and a new box pops up.
      6. Add Location 3.
        1. Double-click the new field and select the options in the screenshot below for Location 3 Code (click "Don't print title field if Blank), click OK. 
        2. Move the Loc 3 field into a place where it fits and can be easily read.
      7. Do the same for Location 2 (set it to print underneath Location 1 but with a smaller font as shown in the tag below.)
      8. Save the change by clicking "Save Lbl" (F5).
      9. Save to the label your store uses and overwrite the previous file.

    • Location 3 Bin Label Location 3 Bin Label EagleLocation 2 Bin Label Eagle

    Location Maintenance Eagle Mobile Location 3.png Location Maintenance Eagle Mobile.png

  • Capacity holds the number of units that fit on your sales floor (shelf or peg hook).

    • You can do this as part of regular department maintenance when you purge back stock, and when putting stock away. 
    • On Truck Day - any SKUs placed in top stock or back stock need to have Capacity information updated.

    Onboarding SKUs into Back Stock Replenishment 

    A Zebra unit is a great tool for getting SKUs onto the back stock program. Under the Shelf Maintenance menu, Capacity data can easily be entered on SKUs. In the example below I have 2 facings of 5 for Great Stuff crack filler, so I've entered 10 into Capacity. Common examples: Spray Paint - 6 per facing, gallons of paint - 4 per facing, etc. Below are the steps for getting SKUs onto the program.

    • Backroom Task

      1. Login to the Mobile+ app.
      2. Under the Products menu, click Lists.
      3. At the bottom of the screen, click Add List.
      4. Give the list a name "BackStock" and make sure the List Type is set to "Standard." 
      5. Select your store in the store drop-down.
      6. Click the Save & Exit button.
      7. In the Search box, type the name of your Back Stock list and click on the list.
      8. Scan a SKU in Back Stock.
      9. Continue scanning each unique SKU in your Back Stock and Top Stock. 
      10. Once complete, proceed to a computer and open Propello.
      11. Under the Products menu, select Products.
      12. Click the Table View button in the upper right.
      13. Click the Advanced Filter button next to the search button.
      14. In the Lists search box, find the Backstock list and click the check box.
      15. Press Search.
      16. If some SKUs already have shelf capacity they can be filtered out using Capacity.
        1. Click the Settings gear near the top right of the table.
        2. Search for Cap 1 and click the check box.
        3. On the grid, click the filter icon next to Cap 1.
        4. Set the Operate to "Is Equal To" 
        5. In the Value box, type 0 and click filter.
      17. Double-click the Prim Loc column to sort in location order. 
      18. Click the select all check box in the upper left.
      19. Click the Print Label button.
      20. Under Label Name select your standard bin label format.
      21. Under Label printer select your printer of choice.
      22. Under Quantity to print select One label.
      23. Under print Sequence, select option Store/Bin Location/Item.
      24. Click Print.
      25. Retrieve the paper from the printer, attach it to a clipboard, and proceed to the Sales Floor Task below.

       

      Sales Floor Task

      1. Login to the Mobile+ app.
      2. In the Products menu, select Shelf Maintenance.
      3. Click on settings at the bottom of the screen.
      4. Flip the View & Update Capacity toggle on (green).
      5. Press Save.
      6. With your clipboard of SKUs, locate the first item out on the floor.
      7. Scan the SKU or the bin label and count how many fit to make a full shelf, enter that value into Capacity. 
        1. If the shelf isn't completely full, estimate how many will fit, enter that value into Capacity, and write the difference on the label to refill your shelf to full capacity.
      8. Click Save.
      9. Continue this process for all the remaining SKUs on your labels list.

    Optional - Location 4

    For stores interested in giving SKUs in back stock a location we recommend using Location 4. This is displayed in the app and allows for quicker picking each day. Common locations included TOP (top stock), BACK (backroom), BSMT (basement), OUT (outside), and many more. This can be expanded to TOP05 for top stock in aisle 5. 

    Additional Info

    Using Capacity to indicate shelf quantity has multiple benefits in Mango. 

    • Paper Count Sheets will show a Green Plus  for SKUs where the quantity-on-hand (at month end) was greater than the shelf capacity (Capacity). This helps prompt your counters to look in back stock for additional quantities when processing Mango's Count Sheets.
    • Shrink Report shows BS+ in the Research Reason column indicating a possible incorrect count to a SKU in a back stock position (a common occurrence).

    • If you can fit 12 cans of spray paint on your shelf then enter 12 into Capacity (click on View Location Codes under the Stock & Sell tab of Products to bring up the Location Codes window). 

      Propello Shelf Capacity in Location Codes.png

      • If Qty On Hand is 20 then Mango's Count Sheet will show a Green Plus indicating more to count in back stock.
      • The Shelf quantity printed on the bin tag indicates a SKU with possible back stock which is helpful for department maintenance and customer service.

    Propello Mobile+ View & Update Capacity Toggle.png Propello Mobile+ Shelf Capacity.png