Spreadsheet: 75751d1276281048-match-item-number-to-sales-data-on-another-sheet-sample
Sheet: RAW QOP DATA

ITEM # | DESC | PAGE# | DEPT | PGC | SQ/INCHES | AVG UNIT PRICE | DEMAND UNITS | [NAME] SALES | DEMAND GR PROFIT | SHIP UNITS | SHIP SALES | SHIP GR PROFIT | RETURN UNITS | RETURN SALES | RETURN GR PROFIT | NET UNITS | NET SALES | NET GR PROFIT | $ SALES/SQ INCH | $ GO/SQ INCH
USEF | [NAME] | 0 | 105 | USEF1 | 0 | 1 | 5 | 5 | 5 | 7 | 7 | 7 | 0 | 0 | 0 | 7 | 7 | 7 | 0 | 0
EGIFT | E-GIFT CARD | 0 | 332 | 280 | 0 | 80.6 | 43 | 3466.01 | 3466.01 | 40 | 3241.01 | 3241.01 | 0 | 0 | 0 | 40 | 3241.01 | 3241.01 | 0 | 0
GIFT | ROD'S GIFT CARD | 0 | 332 | 280 | 0 | 111.97 | 10 | 1119.65 | 1114.65 | 10 | 744.65 | 739.65 | 0 | 0 | 0 | 10 | 744.65 | 739.65 | 0 | 0
FEGIFT | FREE E-GIFT CARD | 0 | 333 | 610 | 0 | 23.87 | 707 | 16875 | 16875 | 686 | 16180 | 16180 | 0 | 0 | 0 | 686 | 16180 | 16180 | 0 | 0
1 | NON STOCK ITEM | 0 | 500 | 1 | 0 | 137.62 | 3 | 412.85 | 194.04 | 3 | 412.85 | 194.05 | 0 | 0 | 0 | 3 | 412.85 | 194.05 | 0 | 0
12621 | BLK TRUCKER | 0 | 500 | 1 | 0 | 99.95 | 1 | 99.95 | 44.95 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4172K | RIOS RUST ROPER | 0 | 500 | 1 | 0 | 199.99 | 1 | 199.99 | 10.99 | 1 | 199.99 | 10.99 | 0 | 0 | 0 | 1 | 199.99 | 10.99 | 0 | 0
4577 | WINTER [NAME] | 0 | 500 | 1 | 0 | 89.95 | 1 | 89.95 | 44.95 | 1 | 89.95 | 44.95 | 0 | 0 | 0 | 1 | 89.95 | 44.95 | 0 | 0
5084 | CHOCOLATE COW | 0 | 500 | 1 | 0 | 224.95 | 1 | 224.95 | 113.45 | 1 | 224.95 | 113.45 | 0 | 0 | 0 | 1 | 224.95 | 113.45 | 0 | 0
6250 | BK SUEDED BOOT | 0 | 500 | 1 | 0 | 244.95 | 1 | 244.95 | 123.45 | 1 | 244.95 | 123.45 | 1 | 244.95 | 123.45 | 0 | 0 | 0 | 0 | 0
6691 | MNS BLK DEERTAN | 0 | 500 | 1 | 0 | 89.95 | 2 | 179.9 | 60.9 | 1 | 89.95 | 30.45 | 0 | 0 | 0 | 1 | 89.95 | 30.45 | 0 | 0
6782 | GREY WINGTIP | 0 | 500 | 1 | 0 | 99.95 | 1 | 99.95 | 43.95 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
68372 | MNS DISTRESDEER | 0 | 500 | 1 | 0 | 99.95 | 1 | 99.95 | 40.45 | 1 | 99.95 | 40.45 | 0 | 0 | 0 | 1 | 99.95 | 40.45 | 0 | 0
9107B | [NAME] | 0 | 500 | 1 | 0 | 236.95 | 2 | 473.9 | 231.9 | 2 | 473.9 | 231.9 | 0 | 0 | 0 | 2 | 473.9 | 231.9 | 0 | 0
DH1372 | BROWN WK WESTRN | 0 | 500 | 1 | 0 | 189.95 | 1 | 189.95 | 95.45 | 1 | 189.95 | 92.45 | 0 | 0 | 0 | 1 | 189.95 | 92.45 | 0 | 0
DH3253 | 12" RUST WEST | 0 | 500 | 1 | 0 | 124.95 | 1 | 124.95 | 62 | 1 | 124.95 | 62 | 0 | 0 | 0 | 1 | 124.95 | 62 | 0 | 0
DH3257 | MNS BLK CHERRY | 0 | 500 | 1 | 0 | 99.95 | 1 | 99.95 | 51.95 | 1 | 99.95 | 51.95 | 1 | 99.95 | 51.95 | 0 | 0 | 0 | 0 | 0
DH3683 | 10" ICE ROPER | 0 | 500 | 1 | 0 | 179.95 | 1 | 179.95 | 89.95 | 1 | 179.95 | 89.95 | 0 | 0 | 0 | 1 | 179.95 | 89.95 | 0 | 0
DH3720 | 10" RNCH BOOT | 0 | 500 | 1 | 0 | 149.95 | 1 | 149.95 | 74.45 | 1 | 149.95 | 74.45 | 0 | 0 | 0 | 1 | 149.95 | 74.45 | 0 | 0
DI05980 | BLK WESTERN | 0 | 500 | 1 | 0 | 109.95 | 1 | 109.95 | 50.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DP26657 | MNS WESTERN | 0 | 500 | 1 | 0 | 189.95 | 1 | 189.95 | 94.95 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DP4242 | DISTRESSED WESTERN | 0 | 500 | 1 | 0 | 89.95 | 3 | 269.85 | 125.85 | 3 | 269.85 | 125.85 | 0 | 0 | 0 | 3 | 269.85 | 125.85 | 0 | 0
J2705 | SUNSET RENEGADE | 0 | 500 | 1 | 0 | 199.95 | 1 | 199.95 | 100.45 | 1 | 199.95 | 100.45 | 0 | 0 | 0 | 1 | 199.95 | 100.45 | 0 | 0
VM2993 | BLACK PAMPAS | 0 | 500 | 1 | 0 | 139.95 | 1 | 139.95 | 69.45 | 1 | 139.95 | 69.45 | 0 | 0 | 0 | 1 | 139.95 | 69.45 | 0 | 0
2 | NON STOCK ITEM | 0 | 500 | 2 | 0 | 144.95 | 4 | 579.8 | 255.11 | 4 | 579.8 | 255.12 | 0 | 0 | 0 | 4 | 579.8 | 255.12 | 0 | 0
1512 | JUSTIN BLK RTOE WEST | 0 | 500 | 2 | 0 | 139.95 | 1 | 139.95 | 64.83 | 1 | 139.95 | 64.83 | 0 | 0 | 0 | 1 | 139.95 | 64.83 | 0 | 0
1517 | BAY APACHEWEST | 0 | 500 | 2 | 0 | 139.95 | 2 | 279.9 | 113.34 | 3 | 419.85 | 170.01 | 0 | 0 | 0 | 3 | 419.85 | 170.01 | 0 | 0
34824 | SQ TOE RGHSTCK | 0 | 500 | 2 | 0 | 179.95 | 1 | 179.95 | 97.18 | 1 | 179.95 | 97.18 | 0 | 0 | 0 | 1 | 179.95 | 97.18 | 0 | 0
34902 | MNS STOCKMAN TL | 0 | 500 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 99.99 | 29.99 | -1 | -99.99 | -29.99 | 0 | 0
34960 | MNS BK/[NAME] | 0 | 500 | 2 | 0 | 69.99 | 1 | 69.99 | 19.99 | 1 | 69.99 | 19.99 | 0 | 0 | 0 | 1 | 69.99 | 19.99 | 0 | 0
39723 | SQ TOE DURACRP | 0 | 500 | 2 | 0 | 163.32 | 3 | 489.97 | 210.97 | 3 | 489.97 | 210.97 | 1 | 169.99 | 76.99 | 2 | 319.98 | 133.98 | 0 | 0
53385 | AUBURN BLKWATER | 0 | 500 | 2 | 0 | 69.99 | 1 | 69.99 | -5.01 | 1 | 69.99 | -5.01 | 0 | 0 | 0 | 1 | 69.99 | -5.01 | 0 | 0
53415 | MNS BISON LTIGO | 0 | 500 | 2 | 0 | 149.99 | 2 | 299.98 | 59.98 | 2 | 299.98 | 59.98 | 0 | 0 | 0 | 2 | 299.98 | 59.98 | 0 | 0