How to export a list of CoPOS Item Codes and Alt Codes to Excel

You are here:

To get a list of CoPOS Item Codes and Alternate Item Codes, export the Standard CoPOS Item file to Excel and look at columns “A” and “BR”.

Go to option [4.1] Item Database (with Query)

  1. Select [Query]  and press Enter.
  2. Press Enter to select [New Query].
  3. Arrow to the Selection Criteria you want CoPOS to use to select the items to be included, or excluded, in the list. Use I to [I]nclude and E to [E]xclude items.
    By default, Inactive items are excluded.
    Note: By pressing CTRL+F, you can toggle between Including all, Excluding all or Ignoring all (Blank).
  4. Press ESC.
  5. You will be prompted for additional qualifiers based on which Selection Criteria were specified, e.g., Last Sold Date, Department, UPC/PLU, Location, Vendor. Press F10 for details about syntax.
  6. Press ESC or Enter.
  7. Press Enter to select [Select Query Source].
  8. Press Enter to select [Item Database]. The database will be searched and the list of qualifying Items created. How many Items that met the Criteria is displayed.
    If no Items were found, you can specify different Criteria or Query Source. To change Selection Criteria, select [Back].
  9. Once the search is completed, press Enter to select [View Items].
  10. Select [More] and press Enter.
  11. Select [Print/Exprt] and press Enter.
  12. Select [Export] and press Enter.
  13. Select [Items/Movement] and press Enter.
  14. Select [Standard Item] and press Enter.
  15. Select the USB flash drive to [Save In]. Press Enter.
  16. Select [Excel] file. Press Enter.
  17. Press Enter to [Proceed]. Before proceeding verify that Save In, Save As, and Type are correct.
  18. Press Enter to confirm that [Yes] it’s Okay to Export these Items (Standard Form). The file will be saved as ITEMSQ.XLS.
    Note: The previously exported list will be overwritten unless it is saved with a different file name, which can be done in Step 17, above, before [Proceeding].
  19. Open the file in Excel and the codes will be in columns “A” (UPC/PLU) and “BR” (Alternate Item Codes) in Excel.