Delete Report

  •  

    • The Excel Delete report lists all "safe to delete" candidate SKUs in your store. These are SKUs with quantity-on-hand equal to zero and no activity (sales, purchase, or shrink) for two years or more. For multi-store organizations, there is a column indicating if the SKU meets the criteria for all stores, and therefore safe to delete (for those organizations who like to keep a consistent SKU set for all stores). You can use this worksheet along with your Eagle inventory viewer to manage the size and relevance of your inventory file. We recommend using Mango's delete process on an annual basis (February is our recommended month).

      Not comfortable processing the delete report on your own? We offer a service where we'll remote into a PC in your store and do it for you. $200 per store, billed on your Ace Statement. Schedule a time here!

      Deleting inventory SKUs is permanent. Please talk over your delete strategy with your owner, manager or system manager. Keep an eye out for very slow-moving SKUs like fasteners (cap screws, grade 5 fine thread, etc.) where you may occasionally (once every 5 years) sell a box.

      • Option IDs
         

        • 3037 - Allow deleting items in Inventory Maintenance if QOH is not zero = No. (we should never delete SKUs with QOH because this leaves a gap in shrink accounting).
        • 8617 - Allow Delete in Inventory Viewer = Yes.

        Security Bits
         

        • 224, 777 enabled ("Yes" for your user for this process, then set to "No" after all deletion is finished). For security and accountability reasons, deleting should only be done periodically in a controlled way, and then disabled for all users.
      • You can download Mango’s Delete Report by logging into your online report directory. 
        1. Locate your Action Report email from the start of the month.
        2. In the body of the email you'll find a link, username, and password.
        3. Click the link and enter your credential information.
        4. Click on your Store's folder.
        5. Click on the Excel Folder.
        6. Locate the file named " - Delete Report - " e.g. "7205 - Delete Report - 0525.xlsm".
        7. Download and then open the file.
          Delete Report Online Report Directory.png ​

      • Once you have downloaded and opened your Delete Report, you can use the headings to sort (keep from using filters as the filters will not be retained when saved for export). The idea is to keep an eye out for very slow-moving SKUs like your Fasteners (Cap Screws, Grade 5 Fine Thread, etc.) where you may occasionally (once every 5 years) sell a box. If you find a SKU you want to save, delete the row from the file. Keep in mind, once the file has been imported into your viewer, you will have another chance to further manipulate the SKUs selected for deletion. 

        Delete Report Removing SKUs

        Note: for multi-stores looking to keep SKUs synchronized, you can sort by the ‘can_delete_from_all_stores’ and then delete all rows where this value is “No”.

      •  

        1. Important! These next steps are going to build the file necessary for your Eagle system. Depending on how many SKUs need to be deleted this process may build up to 7 individual files.
        2. In the column header, click Export SKUs for .txt file.
        3. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
        4. Click Save.
        5. Another save window may appear; repeat step 4 until the save windows stop appearing. 

        Delete Report Exporting SKUs

      •  

        1. Open Inventory Maintenance (IMU).
        2. In the top ribbon, click on Viewer (F9).
        3. A new window will appear. In the top ribbon, click on Misc. Kpad (-).
        4. Click on Custom SKU list (2).
        5. Click on Import from CSV file (6).
        6. Locate the file you saved in Step C (Ex. Mango_Delete1, Mango_Delete2, etc.), click Open.
        7. A box will appear asking to clear the grid, select Yes.

        You may need to answer Yes to continue loading if there are any SKUs in the Excel list which have already been deleted or RCIN’ed from your system so check back every 15 minutes.  The import process can take some time depending on the number of SKUs being added to the viewer.

        Import into a Viewer

      •  

        1. Wait for the SKU listing to finish loading.
        2. Right-click in the SKU heading and select Check Boxes.
        3. Right-click in the Check Box heading, click Select All.
        4. Scroll through the listing. This is your final opportunity to spare SKU deletion.
        5. If you find a SKU you want to save, click its checkbox to deselect it.

        Eagle Check Boxes

      • Now comes the easy part! 
         
        1. In the top ribbon, click Delete (F10).
        2. A new window will appear, answer Yes if you are ready to delete.
        3. Eagle will prompt you one more time confirming you are ready to delete, click Yes.

        4. MULTI STORE: click No to only delete SKUs from one store at a time.

          Delete Warning Box

      • If you have more than 15,000 SKUs to delete, 2 or more files were generated in Step C. If that's the case, you'll need to repeat steps D, E, and F for each .txt file.

      • Set security bits 224 and 777 to back to No for all users.

        Set Option ID 8617 to No.

    • The Excel Delete report lists all "safe to delete" candidate SKUs in your store. These are SKUs with quantity-on-hand equal to zero and no activity (sales, purchase, or shrink) for two years or more. For multi-store organizations, there is a column indicating if the SKU meets the criteria for all stores, and therefore safe to delete (for those organizations who like to keep a consistent SKU set for all stores). You can use this worksheet along with your Propello inventory viewer to manage the size and relevance of your inventory file. We recommend using Mango's delete process on an annual basis (February is our recommended month).

      Not comfortable processing the delete report on your own? We offer a service where we'll remote into a PC in your store and do it for you. $200 per store, billed on your Ace Statement. Schedule a time here!

      Deleting inventory SKUs is permanent. Please talk over your delete strategy with your owner, manager or system manager. Keep an eye out for very slow-moving SKUs like fasteners (cap screws, grade 5 fine thread, etc.) where you may occasionally (once every 5 years) sell a box.

      •  
        1. Click the Gear Propello Gear Button.png in the upper right.
        2. Select Manage Roles.
        3. Click the Check Box next to the role you want to edit.
        4. Click the Edit Button Edit Button.png.
        5. Set the FILTER BY AUTHORIZATION: to ALL.
        6. Type or Copy and Paste Access to Delete Product Records in Product Grid into the Search Permissions box.
        7. Check the Check Box next to the permission.
        8. Click Save Propello Save Button.png in the upper right.
      • You can download Mango’s Delete Report by logging into your online report directory. 
        1. Locate your Action Report email from the start of the month.
        2. In the body of the email you'll find a link, username, and password.
        3. Click the link and enter your credential information.
        4. Click on your Store's folder.
        5. Click on the Excel Folder.
        6. Locate the file named " - Delete Report - " e.g. "7205 - Delete Report - 0525.xlsm".
        7. Download and then open the file.
          Delete Report Online Report Directory.png ​

      • Once you have downloaded and opened your Delete Report, you can use the headings to sort (keep from using filters as the filters will not be retained when saved for export). The idea is to keep an eye out for very slow-moving SKUs like your Fasteners (Cap Screws, Grade 5 Fine Thread, etc.) where you may occasionally (once every 5 years) sell a box. If you find a SKU you want to save, delete the row from the file. Keep in mind, once the file has been imported into your viewer, you will have another chance to further manipulate the SKUs selected for deletion. 

        Delete Report Removing SKUs

        Note: for multi-stores looking to keep SKUs synchronized, you can sort by the ‘can_delete_from_all_stores’ and then delete all rows where this value is “No”.

      • Delete Report Exporting SKUs
        1. In the column header, click Export SKUs for .txt file.
        2. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
        3. Click Save.
      •  
        1. Select the Utilities menu and click Imports.
        2. Under the Import Type column, select Products.
        3. In the upper left, click Start Import.
        4. Select the Upload File icon Upload File Icon.png in the upper left.
        5. Find and select the file you saved in step C "Desktop\MangoFiles..." and click open.
        6. Under Choose Delimiter, select Comma.
        7. Under Parameters, select Add/Update Records.
        8. Turn the File Contains Headers toggle to off (gray) .
        9. Make sure the Mapping Type is set to New Mapping. 
        10. Click Upload.
        11. Select the Data Mapping button in the upper right.
        12. Under the Map to Field column, set Description Map to - blank.
        13. Using the search field above, find Tags.
        14. Under the Map to Field column, set Tags Map to - Column 3.
        15. Click Map Data & Proceed.
        16. Click Leave.
        17. Under Data Preview, select Mapped Columns and Verify that each column has the appropriate data.
        18. Click Finalize in the bottom right corner.
        19. A popup will appear; click Finalize again.
        20. Import is underway, click Ok.
      •  
        1. Select the Products Menu.
        2. Click the Overview Button Overview Button.png in the upper right.
        3. Click the Advanced Filter Button Advanced Filter Button.
        4. In the Tags search box, search for the Tag (MDEL25, 25 being the current year).
        5. Click Search.
        6. Click the Check Box in the header to select all rows.

      •  

        1. Click the Delete Trash Can Delete Trash Can.
        2. Click Yes.
        3. You will receive a notification when the SKU deletion is complete.

        Delete SKUs Prompt

  • Below are the steps to delete all the Classes not being used. No SKUs are associated with these classes anymore.

    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)

    1. If you haven't already, Enable Editing and Enable Content.Enable Content
    2. Delete any rows you wish to exclude.
    3. Click the button in the header called "Export Class for .txt file."
    4. The file is automatically prepped and needs to be saved. Save location defaults to your Desktop.
    5. Close out of Excel.

    Network Access Import (B)

    1. In Eagle Browser, launch Network Access (NA).
    2. Type MCL into the function line, press Enter.
    3. In the upper left of the screen, click Options -> Keys -> Programmable Keys.
    4. Find a blank Programmable Key, I'll be using Ctrl F8.
    5. Click the ". . ." button and find the .txt file you exported earlier, click on the file then click Open.
    6. Select the following without the asterisks (*) into the Macro Definition box: *{Column 1}{BREAK}{F6}{F6}{F12}*.
    7. Right-click in the Macro Definition box and select Paste​. **If you are unable to Paste the macro, this is because you have Secure Access. Please see the "Building the Macro for Secure Access users" below.
    8. Uncheck the box saying "Macro playback follows keyboard focus".
    9. Click Ok.
    10. Press F12.
    11. Run your programmable key: Ctrl + F8 or the one you chose.
    12. This could take several minutes to run. The screen will stop flashing when complete then close out of Network Access.
    13. Pat on the back, congrats! All Classes are deleted.
    •  
      1. Place your cursor in the Macro Definitions box.
      2. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 1 -> and click OK.
      3. Press the Pause/Break key on your keyboard.
      4. Press the F6 key on your keyboard.
      5. Press the F6 key on your keyboard.
      6. Press the F12 key on your keyboard.
      7. Your Macro Definition should look like the image below.
      8. You can now resume the instructions at Step B.9.

    N/A Programmable Keys

  • Below are the steps to delete all the Finelines not being used. No SKUs are associated with these finelines anymore.

    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)

    1. If you haven't already, Enable Editing and Enable Content.Enable Content
    2. Delete any rows you wish to exclude.
    3. Click the button in the header called "Export Fineline for .txt file".
    4. The file is automatically prepped and needs to be saved. Save location defaults to your Desktop.
    5. Close out of Excel.

    Network Access Import (B)

    1. In Eagle Browser, launch Network Access (NA).
    2. Type MFI into the function line, press Enter.
    3. In the upper left of the screen, click Options -> Keys -> Programmable Keys.
    4. Find a blank Programmable Key, I'll be using Ctrl F8.
    5. Click the ". . ." button and find the .txt file you exported earlier, click on the file then click Open.
    6. Select the following without the asterisks (*) into the Macro Definition box: *{Column 1}{BREAK}{F6}{F6}{F12}*.
    7. Right-click in the Macro Definition box and select Paste​. **If you are unable to Paste the macro, this is because you have Secure Access. Please see the "Building the Macro for Secure Access users" below.
    8. Uncheck the box saying "Macro playback follows keyboard focus".
    9. Click Ok.
    10. Press F12.
    11. Run your programmable key: Ctrl + F8 or the one you chose.
    12. This could take several minutes to run. The screen will stop flashing when complete then close out of Network Access.
    13. Pat on the back, congrats! All Finlines are deleted.
    •  
      1. Place your cursor in the Macro Definitions box.
      2. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 1 -> and click OK.
      3. Press the Pause/Break key on your keyboard.
      4. Press the F6 key on your keyboard.
      5. Press the F6 key on your keyboard.
      6. Press the F12 key on your keyboard.
      7. Your Macro Definition should look like the image below.
      8. You can now resume the instructions at Step B.9.

    N/A Programmable Keys

  • Below are the steps to delete all the MFG Vendors not being used. No SKUs are associated with these MFG Vendors anymore.

    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)

    1. If you haven't already, Enable Editing and Enable Content.Enable Content
    2. Delete any rows you wish to exclude.
    3. Click the button in the header called "Export MFG Vend for .txt file".
    4. The file is automatically prepped and needs to be saved. Save location defaults to your Desktop.
    5. Close out of Excel.

    Network Access Import (B)

    1. In Eagle Browser, launch Network Access (NA).
    2. Type MVR into the function line, press Enter.
    3. In the upper left of the screen, click Options -> Keys -> Programmable Keys.
    4. Find a blank Programmable Key, I'll be using Ctrl F11.
    5. Click the ". . ." button and find the .txt file you exported earlier, click on the file then click Open.
    6. Select the following without the asterisks (*) into the Macro Definition box: *{Column 1}{BREAK}{F6}{F6}{F12}*.
    7. Right-click in the Macro Definition box and select Paste​. **If you are unable to Paste the macro, this is because you have Secure Access. Please see the "Building the Macro for Secure Access users" below.
    8. Uncheck the box saying "Macro playback follows keyboard focus".
    9. Click Ok.
    10. Press F12.
    11. Run your programmable key: Ctrl + F11 or the one you chose.
    12. This could take several minutes to run. The screen will stop flashing when complete then close out of Network Access.
    13. Pat on the back, congrats! All MFG Vendors are deleted.
    •  
      1. Place your cursor in the Macro Definitions box.
      2. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 1 -> and click OK.
      3. Press the Pause/Break key on your keyboard.
      4. Press the F6 key on your keyboard.
      5. Press the F6 key on your keyboard.
      6. Press the F12 key on your keyboard.
      7. Your Macro Definition should look like the image below.
      8. You can now resume the instructions at Step B.9.

    N/A Programmable Keys