This report lists canceled warehouse SKUs and their corresponding replacement SKU. To be listed, the canceled/replacement pair must meet the following conditions: 

1. Canceled SKU's quantity-on-hand (QOH) is zero or less 
2. Canceled SKU's location code is "active" (begins with 0-9)
3. Replacement SKU is not in file (NIF) or has a QOH of zero
4. Replacement SKU is available at your warehouse 
5. Replacement SKU has some sales history in your peer group

The TR (Times Reported) column shows how many times (months) the SKU has shown up on this report. A value of zero or blank will indicate a newly reported SKU.

• Steps to process this report:

  1. Determine if you want to replace the canceled SKU:

  If you do -

  a. Add the REP SKU to file if its REP QOH column showing NIF (you can use catalog (F2) from Inventory Maintenance to accomplish this).

  b. If the SKU is already in your file then make sure the Store Closeout flag is set to "N" in the codes tab of Inventory Maintenance and the Order Indicator flag is blank (Stocking Tab).

  c. Set the replacement SKU's location code to the appropriate location in your store.

          d. Make a scan tag and ensure the item can be put away when it comes in on the next delivery.

          e. Remove the canceled SKU's scan tag and hook from the sales floor.

          f.  Set the canceled SKU's location to your store's drop location code (e.g. DR24, CLOSE, ZZZZZ, etc.).

   

  If you do not want to replace the SKU -

       a. Remove the canceled SKU's bin tag and hook from the sales floor.

       b. Set the canceled SKU's location to your store's drop location code (e.g. DR24, CLOSE, ZZZZZ, etc.)

  • B - Canceled SKU: the SKU that has been canceled from your RSC (retail support center) or warehouse.

    D - Location: the canceled SKU's location code.

    E - Loc2: the canceled SKU's secondary (loc 2) code.

    F - Ord Indicator: the canceled SKU's Ord Indicator (Stocking Tab in Inventory Maintenance). An Ord Indicator of "D" indicates a Dropship SKU only and will not show up on RSO's run for the Primary Vendor.

    G - Store Closeout: the canceled SKU's Store Closeout setting (Codes tab of Inventory Maintenance).

    L - Sales Months Left: the estimated time (in months) until the SKU will be sold out (QOH divided by average monthly sales).

    M - ICM: indicates if the replacement SKU was added via the ICM (Ace's Inventory Change Management) process. When this is Y then the replacement SKU will automatically start ordering once the canceled SKU sells out.

    N - Rep. RSC SKU: the canceled SKU's replacement (if available).

    P - Rep Location: the replacement SKU's location code (if in your inventory file).

    R - Rep QOH: the replacement SKU's QOH (if in your inventory file).

    X - In Season: if the canceled SKU is currently in season in your store (for example, a Christmas SKU will show "No" in July).

    Y - Recommended Action: recommended action to take.

  • File Prep (A)

    1. Enable Editing and Enable Content.
    2.  MULTI-STORES: you'll need to select 1 store at a time using the filters (column A). Data Import cannot handle all-store data at once.
    3. Click the button in the header called "Set SC to Y Export"
    4. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
    5. Close out of Excel.

    Import the Data (B)

    1. Open Eagle Browser.
    2. Locate the folder named Data Import and click on it.
    3. Select Inventory Import Designer.
    4. Under Import File Type select Comma Delimited.
    5. In the top ribbon, select Open (F3).
    6. Select the file you saved in Step A.5 above.
    7. Double check the Import File Type is still Comma Delimited.
    8. In the top ribbon, select Map Field (F6). This is where we'll begin to tell the Eagle system what each column is from the saved file.
    9. Find and select Store (immediate update), click OK.
    10. It will ask what Position. Store was column 1 in our file so enter 1, click OK. We'll repeat this for the remaining columns.
    11. In the top ribbon, select Map Field (F6).
    12. Find and select SKU, click OK. Position 2.
    13. In the top ribbon, select Map Field (F6).
    14. Find and select Store Closeout, click OK. Position 3.
    15. Under Import Options, set the Flex Name to SCFIX.
    16. Click on Store for chg and select the store you're working on.
    17. In the top ribbon, click Import.
    18. A new dialog box will appear, click Import.
    19. Once complete the box will pop up, click Cancel and close out of Data Import.

    Finalize Changes (C)

    1. In the Launch bar of Eagle Browser, type RFL and press Enter.
    2. Print Setup -> Print To -> S (spooler).
    3. Options -> Store -> Enter the store you're working on.
    4. Options -> Options -> F (update inventory file).
    5. Options -> Flex Name -> SCFIX.
    6. In the top ribbon, click Run (F4).
    7. You may see a message "No records exist for this flex name." This is okay as things can be automatically finalized for you and doesn't always require the RFL Step.
    8. You may see a message "Do you wish to exit". Click Yes.
    9. Close out of RFL. You're now complete. You can spot check IMU if you would like.

  • MULTI-STORE WARNING: If you are multi-store you can only do one store at a time. Select a single store in Excel as you do these steps.

    File Prep (A)

    1. Enable Editing and Enable Content.
    2.  MULTI-STORES: you'll need to select 1 store at a time using the filters (column A). Data Import cannot handle all-store data at once.
    3. Click the button in the header called "Set Loc2 to DR Export"
    4. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
    5. Close out of Excel.

    Import the Data (B)

    1. Open Eagle Browser.
    2. Locate the folder named Data Import and click on it.
    3. Select Inventory Import Designer.
    4. Under Import File Type select Comma Delimited.
    5. In the top ribbon, select Open (F3).
    6. Select the file you saved in Step A.5 above.
    7. Double check the Import File Type is still Comma Delimited.
    8. In the top ribbon, select Map Field (F6). This is where we'll begin to tell the Eagle system what each column is from the saved file.
    9. Find and select Store (immediate update), click OK.
    10. It will ask what Position. Store was column 1 in our file so enter 1, click OK. We'll repeat this for the remaining columns.
    11. In the top ribbon, select Map Field (F6).
    12. Find and select SKU, click OK. Position 2.
    13. In the top ribbon, select Map Field (F6).
    14. Find and select Location, click OK. Position 3.
    15. Under Import Options, set the Flex Name to DRLOC.
    16. Click on Store for chg and select the store you're working on.
    17. In the top ribbon, click Import.
    18. A new dialog box will appear, click Import.
    19. Once complete the box will pop up, click Cancel and close out of Data Import.

    Finalize Changes (C)

    1. In the Launch bar of Eagle Browser, type RFL and press Enter.
    2. Print Setup -> Print To -> S (spooler).
    3. Options -> Store -> Enter the store you're working on.
    4. Options -> Options -> F (update inventory file).
    5. Options -> Flex Name -> DRLOC.
    6. In the top ribbon, click Run (F4).
    7. You may see a message "No records exist for this flex name." This is okay as things can be automatically finalized for you and doesn't always require the RFL Step.
    8. You may see a message "Do you wish to exit". Click Yes.
    9. Close out of RFL. You're now complete. You can spot check IMU if you would like.

• Steps to process this report:

  1. Determine if you want to replace the canceled SKU:

  If you do -

  a. Add the REP SKU to file if its REP QOH column showing NIF (Catalog--> View Catalog --> Search SKU --> Click Checkbox  ☑ --> Click the "Add to product" button)

  b. If the SKU is already in your file, then make sure the Store Closeout flag is toggled Off in the Stock & Sell tab of Products and the Product Source flag is blank (Buying Tab).

  c. Set the replacement SKU's location code to the appropriate location in your store.

          d. Make a scan tag and ensure the item can be put away when it comes in on the next delivery.

          e. Remove the canceled SKU's scan tag and hook from the sales floor.

          f.  Set the canceled SKU's location to your store's drop location code (e.g. DR24, CLOSE, ZZZZZ, etc.)

   

  If you do not want to replace the SKU -

       a. Remove the canceled SKU's bin tag and hook from the sales floor.

       b. Set the canceled SKU's location to your store's drop location code (e.g. DR24, CLOSE, ZZZZZ, etc.)

  • B - Canceled SKU: the SKU that has been canceled from your RSC (retail support center) or warehouse.

    D - Location: the canceled SKU's location code.

    E - Loc2: the canceled SKU's secondary (loc 2) code.

    F - Ord Indicator: the canceled SKU's Ord Indicator (Buying Tab of Products). A Product Source of "Dropship Only (D)" indicates a Dropship SKU only and will not show up on RSO's run for the Primary Vendor.

    G - Store Closeout: the canceled SKU's Store Closeout setting (Stock & Sell tab of Products).

    L - Sales Months Left: the estimated time (in months) until the SKU will be sold out (QOH divided by average monthly sales).

    M - ICM: indicates if the replacement SKU was added via the ICM (Ace's Inventory Change Management) process. When this is Y then the replacement SKU will automatically start ordering once the canceled SKU sells out.

    N - Rep. RSC SKU: the canceled SKU's replacement (if available).

    P - Rep Location: the replacement SKU's location code (if in your inventory file).

    R - Rep QOH: the replacement SKU's QOH (if in your inventory file).

    X - In Season: if the canceled SKU is currently in season in your store (for example, a Christmas SKU will show "No" in July).

    Y - Recommended Action: recommended action to take.

  • File Prep (A)

    1. Enable Editing and Enable Content.
    2. Click the button in the header called "Set SC to Y Export".
    3. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
    4. Close out of Excel.

    Import the Data (B)

    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 in the upper left.
    5. Find and select the file you saved in Step A.4 above, and click open.
    6. Under Choose Delimiter, select Comma.
    7. Under Parameters, select 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 Is Store Closed Out?.
    14. Under the Map to Field column, set Is Store Closed Out? 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 at the bottom right corner.
    19. A popup will appear; click Finalize again.
    20. Import is underway, click Ok.

  • File Prep (A)

    1. Enable Editing and Enable Content.
    2. Click the button in the header called "Set Loc2 to DR Export".
    3. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
    4. Close out of Excel.

    Import the Data (B)

    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 in the upper left.
    5. Find and select the file you saved in Step A.4 above, and click open.
    6. Under Choose Delimiter, select Comma.
    7. Under Parameters, select 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 Location 1 Name (Primary).
    14. Under the Map to Field column, set Location 1 Name (Primary) 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 at the bottom right corner.
    19. A popup will appear; click Finalize again.
    20. Import is underway, click Ok.