Catalog Differences

  • Network Access Steps:

    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. Enable Editing and Enable Content. Enable Content
    2. Sort out any data you may want to exclude using the column filters.
    3. Click the button in the header called "Export for NA".
    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.


    Network Access Import (B)

    1. In Eagle Browser, launch Network Access (NA). MDE
    2. In the Function line type MDE and press Enter.
    3. In the upper right, click Options -> Keys -> Programmable Keys.
    4. Pick an open Key, for this help I will use Ctrl + F6.
    5. Under Data File Name: click the ". . .". 
    6. Select the file we saved in Step A.4 above.
    7. One time setup - Under Macro Definition: paste the following WITHOUT the asterisks. **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.
      1. Single Store: **{Column 2}{BREAK}{ENTER}{ENTER}{BS}{DEL}{Column 3}{F4}{BREAK}{ENTER}{ENTER}{BS}{DEL}{Column 3}{F5}{F12}**
      2. Multi Store: **{DEL}{Column 1}{ENTER}{Column 2}{BREAK}{ENTER}{ENTER}{BS}{DEL}{Column 3}{F4}{BREAK}{ENTER}{ENTER}{BS}{DEL}{Column 3}{F5}{F12}**
    8. Uncheck the box that says "Macro playback follows keyboard focus".
    9. Click OK.
    10. Press F12 to ensure the screen is clear.
    11. Press the programmable key you used, in this case, I used Ctrl + F6.
    12. The screen will begin to flash. This process may take several minutes depending on the number of stores/updates.
    13. When the screen has stopped you can close out of Network Access, you're finished!

    •  SINGLE STORE

      1. Place your cursor in the Macro Definitions box.
      2. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 2 -> and click OK.
      3. Press the Pause/Break key on your keyboard.
      4. Press the Enter key on your keyboard.
      5. Press the Enter key on your keyboard.
      6. Press the Backspace key on your keyboard.
      7. Press the Delete (not backspace!) key on your keyboard.
      8. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      9. Press the F4 key on your keyboard.
      10. Press the Pause/Break key on your keyboard.
      11. Press the Enter key on your keyboard.
      12. Press the Enter key on your keyboard.
      13. Press the Backspace key on your keyboard.
      14. Press the Delete (not backspace!) key on your keyboard.
      15. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      16. Press the F5 key on your keyboard.
      17. Press the F12 key on your keyboard.
      18. Your Macro Definition should look like the image below.
      19. You can now resume the instructions at Step 9.

      Cat Diff Single Store Secure Access Macro

       

      MULTI STORE

      1. Place your cursor in the Macro Definitions box.
      2. Press the Delete (not backspace!) key on your keyboard.
      3. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 1 -> and click OK.
      4. Press the Enter key on your keyboard
      5. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 2 -> and click OK.
      6. Press the Pause/Break key on your keyboard.
      7. Press the Enter key on your keyboard.
      8. Press the Enter key on your keyboard.
      9. Press the Backspace key on your keyboard.
      10. Press the Delete (not backspace!) key on your keyboard.
      11. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      12. Press the F4 key on your keyboard.
      13. Press the Pause/Break key on your keyboard.
      14. Press the Enter key on your keyboard.
      15. Press the Enter key on your keyboard.
      16. Press the Backspace key on your keyboard.
      17. Press the Delete (not backspace!) key on your keyboard.
      18. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      19. Press the F5 key on your keyboard.
      20. Press the F12 key on your keyboard.
      21. Your Macro Definition should look like the image below.
      22. You can now resume the instructions at Step 9.

      Cat Diff Multi Store Secure Access Macro

  • Network Access Steps:

    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. Enable Editing and Enable Content. Enable Content
    2. Sort out any data you may want to exclude using the column filters.
    3. Click the button in the header called "Export for NA".
    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.


    Network Access Import (B)

    1. In Eagle Browser, launch Network Access (NA).MCL
    2. In the Function line type MCL and press Enter.
    3. In the upper right, click Options -> Keys -> Programmable Keys.
    4. Pick an open Key, for this help I will use Ctrl + F7.
    5. Under Data File Name: click the ". . .". 
    6. Select the file we saved in Step A.4 above.
    7. One time setup - Under Macro Definition: paste the following WITHOUT the asterisks. **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.
      1. Single Store: **{Column 2}{BREAK}{ENTER}{ENTER}{BS}{DEL}{Column 3}{F4}{BREAK}{ENTER}{ENTER}{BS}{DEL}{Column 3}{F5}{F12}**
      2. Multi Store: **{DEL}{Column 1}{ENTER}{Column 2}{BREAK}{ENTER}{ENTER}{BS}{DEL}{Column 3}{F4}{BREAK}{ENTER}{ENTER}{BS}{DEL}{Column 3}{F5}{F12}**
    8. Uncheck the box that says "Macro playback follows keyboard focus".
    9. Click OK.
    10. Press F12 to ensure the screen is clear.
    11. Press the programmable key you used, in this case, I used Ctrl + F7.
    12. The screen will begin to flash. This process may take several minutes depending on the number of stores/updates.
    13. When the screen has stopped you can close out of Network Access, you're finished!

    •  SINGLE STORE

      1. Place your cursor in the Macro Definitions box.
      2. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 2 -> and click OK.
      3. Press the Pause/Break key on your keyboard.
      4. Press the Enter key on your keyboard.
      5. Press the Enter key on your keyboard.
      6. Press the Backspace key on your keyboard.
      7. Press the Delete (not backspace!) key on your keyboard.
      8. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      9. Press the F4 key on your keyboard.
      10. Press the Pause/Break key on your keyboard.
      11. Press the Enter key on your keyboard.
      12. Press the Enter key on your keyboard.
      13. Press the Backspace key on your keyboard.
      14. Press the Delete (not backspace!) key on your keyboard.
      15. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      16. Press the F5 key on your keyboard.
      17. Press the F12 key on your keyboard.
      18. Your Macro Definition should look like the image below.
      19. You can now resume the instructions at Step 9.

      Cat Diff Single Store Secure Access Macro

       

      MULTI STORE

      1. Place your cursor in the Macro Definitions box.
      2. Press the Delete (not backspace!) key on your keyboard.
      3. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 1 -> and click OK.
      4. Press the Enter key on your keyboard.
      5. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 2 -> and click OK.
      6. Press the Pause/Break key on your keyboard.
      7. Press the Enter key on your keyboard.
      8. Press the Enter key on your keyboard.
      9. Press the Backspace key on your keyboard.
      10. Press the Delete (not backspace!) key on your keyboard.
      11. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      12. Press the F4 key on your keyboard.
      13. Press the Pause/Break key on your keyboard.
      14. Press the Enter key on your keyboard.
      15. Press the Enter key on your keyboard.
      16. Press the Backspace key on your keyboard.
      17. Press the Delete (not backspace!) key on your keyboard.
      18. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      19. Press the F5 key on your keyboard.
      20. Press the F12 key on your keyboard.
      21. Your Macro Definition should look like the image below.
      22. You can now resume the instructions at Step 9.

      Cat Diff Multi Store Secure Access Macro

  • Network Access Steps:

    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. Enable Editing and Enable Content. Enable Content
    2. Sort out any data you may want to exclude using the column filters.
    3. Click the button in the header called "Export for NA".
    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.


    Network Access Import (B)

    1. In Eagle Browser, launch Network Access (NA).MFI
    2. In the Function line type MFI and press Enter.
    3. In the upper right, click Options -> Keys -> Programmable Keys.
    4. Pick an open Key, for this help I will use Ctrl + F8.
    5. Under Data File Name: click the ". . .". 
    6. Select the file we saved in Step A.4 above.
    7. One time setup - Under Macro Definition: paste the following WITHOUT the asterisks. **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.
      1. Single Store: **{Column 2}{BREAK}{END}{BS}{DEL}{Column 3}{F5}{F4}{F12}**
      2. Multi Store: **{DEL}{Column 1}{ENTER}{Column 2}{BREAK}{END}{BS}{DEL}{Column 3}{F5}{F4}{F12}**
    8. Uncheck the box that says "Macro playback follows keyboard focus".
    9. Click OK.
    10. Press F12 to ensure the screen is clear.
    11. Press the programmable key you used, in this case, I used Ctrl + F8.
    12. The screen will begin to flash. This process may take several minutes depending on the number of stores/updates.
    13. When the screen has stopped you can close out of Network Access, you're finished!

    •  SINGLE STORE

      1. Place your cursor in the Macro Definitions box.
      2. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 2 -> and click OK.
      3. Press the Pause/Break key on your keyboard.
      4. Press the End key on your keyboard.
      5. Press the Backspace key on your keyboard.
      6. Press the Delete (not backspace!) key on your keyboard.
      7. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      8. Press the F5 key on your keyboard.
      9. Press the F4 key on your keyboard.
      10. Press the F12 key on your keyboard.
      11. Your Macro Definition should look like the image below.
      12. You can now resume the instructions at Step 9.

      Cat Diff Single Store Secure Access Macro Fineline

       

      MULTI STORE

      1. Place your cursor in the Macro Definitions box.
      2. Press the Delete (not backspace!) key on your keyboard.
      3. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 1 -> and click OK.
      4. Press the Enter key on your keyboard.
      5. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 2 -> and click OK.
      6. Press the Pause/Break key on your keyboard.
      7. Press the End key on your keyboard.
      8. Press the Backspace key on your keyboard.
      9. Press the Delete (not backspace!) key on your keyboard.
      10. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      11. Press the F5 key on your keyboard.
      12. Press the F4 key on your keyboard.
      13. Press the F12 key on your keyboard.
      14. Your Macro Definition should look like the image below.
      15. You can now resume the instructions at Step 9.

      Cat Diff Multi Store Secure Access Macro Fineline

  • Network Access Steps:

    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. Enable Editing and Enable Content. Enable Content
    2. Sort out any data you may want to exclude using the column filters.
    3. Click the button in the header called "Export for NA".
    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.


    Network Access Import (B)

    1. In Eagle Browser, launch Network Access (NA).MVR
    2. In the Function line type MVR and press Enter.
    3. In the upper right, click Options -> Keys -> Programmable Keys.
    4. Pick an open Key, for this help I will use Ctrl + F12.
    5. Under Data File Name: click the ". . .". 
    6. Select the file we saved in Step A.4 above.
    7. One time setup - Under Macro Definition: paste the following WITHOUT the asterisks. **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.
      1. Single Store: **{Column 2}{DOWN}{Column 3}{F4}{BREAK}{DOWN}{DEL}{DEL}{DEL}{DEL}{BS}{END}{BS}{UP}{Column 3}{F5}{ENTER}{F12}**
      2. Multi Store: **{DEL}{Column 1}{END}{Column 2}{DOWN}{Column 3}{F4}{BREAK}{DOWN}{DEL}{DEL}{DEL}{DEL}{BS}{END}{BS}{UP}{Column 3}{F5}{ENTER}{F12}**
    8. Uncheck the box that says "Macro playback follows keyboard focus".
    9. Click OK.
    10. Press F12 to ensure the screen is clear.
    11. Press the programmable key you used, in this case, I used Ctrl + 12.
    12. The screen will begin to flash. This process may take several minutes depending on the number of stores/updates.
    13. When the screen has stopped you can close out of Network Access, you're finished!

    •  SINGLE STORE

      1. Place your cursor in the Macro Definitions box.
      2. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 2 -> and click OK.
      3. Press the Down Arrow key on your keyboard.
      4. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      5. Press the F4 key on your keyboard.
      6. Press the Pause/Break key on your keyboard.
      7. Press the Down Arrow key on your keyboard.
      8. Press the Delete (not backspace!) key on your keyboard.
      9. Press the Delete (not backspace!) key on your keyboard.
      10. Press the Delete (not backspace!) key on your keyboard.
      11. Press the Delete (not backspace!) key on your keyboard.
      12. Press the Backspace key on your keyboard.
      13. Press the End key on your keyboard.
      14. Press the Backspace key on your keyboard.
      15. Press the Up Arrow key on your keyboard
      16. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      17. Press the F5 key on your keyboard.
      18. Press the Enter key on your keyboard.
      19. Press the F12 key on your keyboard.
      20. Your Macro Definition should look like the image below.
      21. You can now resume the instructions at Step 9.

      Cat Diff - Vendor Macro Single Store.png

       

      MULTI STORE

      1. Place your cursor in the Macro Definitions box.
      2. Press the Delete (not backspace!) key on your keyboard.
      3. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 1 -> and click OK.
      4. Press the End key on your keyboard.
      5. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 2 -> and click OK.
      6. Press the Down Arrow key on your keyboard.
      7. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      8. Press the F4 key on your keyboard.
      9. Press the Pause/Break key on your keyboard.
      10. Press the Down Arrow key on your keyboard.
      11. Press the Delete (not backspace!) key on your keyboard.
      12. Press the Delete (not backspace!) key on your keyboard.
      13. Press the Delete (not backspace!) key on your keyboard.
      14. Press the Delete (not backspace!) key on your keyboard.
      15. Press the Backspace key on your keyboard.
      16. Press the End key on your keyboard.
      17. Press the Backspace key on your keyboard.
      18. Press the Up Arrow key on your keyboard.
      19. In the upper left hand corner, click Insert -> Data File Column...​ -> Enter 3 -> and click OK.
      20. Press the F5 key on your keyboard.
      21. Press the Enter key on your keyboard
      22. Press the F12 key on your keyboard.
      23. Your Macro Definition should look like the image below.
      24. You can now resume the instructions at Step 9.

      Cat Diff - Vendor Macro Multi Store.png

  • This tab can be processed quickest using Acenet but Data Import and Network Access instructions are also available.


    Request Hotsheets from Acenet: (Preferred Method)

    1. Acenet can only handle 1,500 SKUs at a time, if you have more you'll repeat these steps for each block of 1,500 SKUs.
    2. Select the following columns by clicking on the header letter:  SKU (Column B).
    3. Copy the data (Ctrl + C).
    4. Open a web browser and log into Acenet.
    5. Under the Manage Product heading, click Request Hotsheets (2nd column to the right).
    6. Click Import in the upper right.
    7. A new window will appear.
    8. Right-click in the grid and select Paste.
    9. Delete the first record that says "SKU".
    10. Click Import at the bottom of the window.
    11. Click Close.
    12. If multi-store, select all your stores.
    13. Click Submit in the bottom right.
    14. You should get a window stating they've been successfully submitted.
    15. You can close out of Excel and Acenet. These SKUs will be updated in the next 48 hours with your system's Hotsheet process.

    • Excel File Prep

      1. Select the following columns by clicking on the header letter: StoreID, SKU, Corrected Dept, Catalog Class, Catalog Fineline, Catalog Description, Catalog Manufacturer, Catalog Mfg Num (A, B, D, G, J, M, P, S).
      2. Holding Ctrl allows you to select multiple columns.
      3. Copy the data (Ctrl + C).
      4. Open a new Excel window (Ctrl + N).
      5. Paste the data (Ctrl + P).
      6. Delete the first 2 rows of data.
      7. Click row 1 and 2, right-click and select Delete.
      8. Save the file as a Comma Delimited type (.csv).
      9. Close out of Excel.


      Import the Data

      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 CSV file you saved in Excel.
      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 Excel file.
      9. Find and select Store, click OK.
      10. It will ask what Position. StoreID was column 1 in our CSV 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. Repeat steps 11 and 12 for the remaining columns.
      14. Department, Position 3.
      15. Class, Position 4.
      16. Fineline, Position 5.
      17. Description, Position 6.
      18. Manufacturer, Position 7.
      19. Mfg Part #, Position 8.
      20. Under Import Options, set the Flex Name to CATDIFF.
      21. Click on Store for chg and select All.
      22. In the top ribbon, click Import
      23. A new dialog box will appear, click Import.
      24. Once complete the box will pop up, click Cancel and close out of Data Import.


      Finalize Changes

      1. In the Launch bar of Eagle Browser, type RFL and press Enter
      2. Print Setup -> Print To -> S (spooler)
      3. Options -> Store -> Delete out the value so it is blank
      4. Options -> Options -> F (update inventory file)
      5. Options -> Flex Name -> CATDIFF
      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.

    • File Prep (A)

      1. Select the following columns by clicking on the header letter: StoreID, SKU, Corrected Dept, Catalog Class, Catalog Fineline, Catalog Description, Catalog Manufacturer, Catalog Mfg Num (A, B, D, G, J, M, P, S).
      2. Holding Ctrl allows you to select multiple columns.
      3. Copy the data (Ctrl + C).
      4. Open a new Excel window (Ctrl + N).
      5. Paste the data (Ctrl + P).
      6. Delete the first row of data.
      7. Click row 1, right-click and select Delete.
      8. Select all the data (Ctrl + A).
      9. Copy the data again (Ctrl + C).
      10. Open Notepad.
      11. Paste the data (Ctrl + P).
      12. In the upper right corner of Notepad, select File -> Save As...
      13. Save this file somewhere on your computer.
      14. Close out of Notepad and Excel.


      Network Access Import (B)

      1. In Eagle Browser, launch Network Access (NA).
      2. In the Function line type IMU and press Enter.
      3. In the upper right, click Options -> Keys -> Programmable Keys.
      4. Pick an open Key, for this help I will use Ctrl + F11.
      5. Under Data File Name: click the ". . ." and select the TXT file we created in Step A.12 above.
      6. One time setup - Under Macro Definition: paste the following WITHOUT the asterisks.
        1. Single Store: **{Column 2}{BREAK}{ENTER}{BS}{DEL}{Column 3}{ENTER}{BS}{DEL}{Column 4}{ENTER}{BS}{DEL}{Column 5}{ENTER}{BS}{DEL}{Column 6}{ENTER}{ENTER}{ENTER}{BS}{DEL}{Column 7}{END}{END}{DOWN}{BS}{UP}{Column 8}{F5}{F12}**
        2. Multi Store: **{Column 2}{END}{END}{END}{Column 1}{BREAK}{ENTER}{BS}{DEL}{Column 3}{ENTER}{BS}{DEL}{Column 4}{ENTER}{BS}{DEL}{Column 5}{ENTER}{BS}{DEL}{Column 6}{ENTER}{ENTER}{ENTER}{BS}{DEL}{Column 7}{ENTER}{END}{BS}{UP}{Column 8}{F5}{F12}**
      7. IMPORTANT: change Field Seperator to TAB.
      8. Uncheck the box that says "Macro playback follows keyboard focus".
      9. Click OK.
      10. Press F12 to ensure the screen is clear.
      11. Press the programmable key you used, in this case, I used Ctrl + F11.
      12. The screen will begin to flash. This process may take several minutes depending on the number of stores/updates.
      13. When the screen has stopped you can close out of Network Access, you're finished!