1. Take the spreadsheet and save it as Fotmatted Text (Space Delimited) file.
2. Open it in notepad and make sure 1 st line is item # and count.
3. Count from 1 st column how many spaces till end of item number, then how many spaces for counts. ie 1-8 = item #, and 9 – 28 = counts
4. Then make that map in Retail Pro PI map and make sure Item # is checked.
5. Then start a PI and use zones. Go to import that zone and it must give total scans and good scans.
6. Then mark and merge the zone and then update if your satisfied it looks good.