Spreadsheet: 679351d1590343678-pull-in-top-products-but-not-duplicates-top-25-porducts-sample
Sheet: Transaction Report

Order ID + SKU | Date | Order ID | SKU | ASIN | Product Name | Quantity | Sale Price | Buy Price | ALL FEES | Amazon fees: Commission | Amazon fees: FBA fulfilment fee per unit | Amazon fees: Refund commission | Net Profit | ROI
 | 2020-04-30 00:00:00 | [PHONE]-2497162 | 2F-AF0N-0VRN | X002XFX3XQ | Product 1 | 1 | 14.39 | 4.79 | -4.68 | -2.08 | -2.6 | 0 | 4.920000000000002 | 1.02713987473904
 | 2020-04-30 00:00:00 | [PHONE]-1423567 | 2F-AF0N-0VRN | X002XFX3XQ | Product 1 | 1 | 14.4 | 4.79 | -4.68 | -2.08 | -2.6 | 0 | 4.93 | 1.029227557411273
 | 2020-04-30 00:00:00 | [PHONE]-7204334 | LE-4749-YL7A | X07H2LPFNV | Product 2 | 1 | 20 | 9.95 | -8.4 | -3.6 | -4.8 | 0 | 1.65 | 0.1658291457286433
 | 2020-04-29 00:00:00 | [PHONE]-4300355 | 4Q-JL12-E2QV | X07M6NS9QX | Product 3 | 1 | 12.07 | 4.833333333333333 | -5.1 | -2.17 | -2.93 | 0 | 2.136666666666668 | 0.4420689655172416
 | 2020-04-28 00:00:00 | [PHONE]-8013103 | KD-QA4S-NDYK | X06XP8FLY9 | Product 4 | 1 | 11.4 | 4.99 | -4.619999999999999 | -2.05 | -2.57 | 0 | 1.790000000000001 | 0.3587174348697397
 | 2020-04-28 00:00:00 | [PHONE]-2375546 | 4Q-JL12-E2QV | X07M6NS9QX | Product 3 | 1 | 12.07 | 4.833333333333333 | -5.1 | -2.17 | -2.93 | 0 | 2.136666666666668 | 0.4420689655172416
 | 2020-04-27 00:00:00 | [PHONE]-3433952 | EE-5DLH-NTAZ | X00U1ZJUXM | Product 5 | 1 | 27.79 | 15.4925 | -7.93 | -5 | -2.93 | 0 | 4.3675 | 0.2819106019041471
 | 2020-04-27 00:00:00 | [PHONE]-9725905 | NA-ZCKA-UFJJ | [NAME] | Product 6 | 1 | 10 |  | -4.37 | -1.8 | -2.57 | 0 | No Buy Price | No Buy Price
 | 2020-04-27 00:00:00 | [PHONE]-4758769 | 1D-79K6-CI7L | X078M3FY2T | Product 7 | 1 | 22.71 | 13.74 | -6.69 | -3.28 | -3.41 | 0 | 2.280000000000001 | 0.165938864628821
 | 2020-04-27 00:00:00 | [PHONE]-1789155 | 2F-AF0N-0VRN | X002XFX3XQ | Product 1 | 1 | 14.64 | 4.79 | -4.71 | -2.11 | -2.6 | 0 | 5.140000000000001 | 1.073068893528184
 | 2020-04-27 00:00:00 | [PHONE]-2328314 | 6Y-72ZN-RPF2 | X008XL2ZQW | Product 8 | 1 | 22.75 | 11.33333333333333 | -6.69 | -4.09 | -2.6 | 0 | 4.726666666666667 | 0.4170588235294118
 | 2020-04-27 00:00:00 | [PHONE]-5677922 | DF-R9C9-E35I | X008VMXV26 | Product 9 | 1 | 13.17 | 6.23 | -5.31 | -2.38 | -2.93 | 0 | 1.629999999999999 | 0.2616372391653289
 | 2020-04-26 00:00:00 | [PHONE]-9141115 | R1-O5RA-UKSS | X07MNZV828 | 0 | 1 | 17.38 | 8 | -5.09 | -3.13 | -1.96 | 0 | 4.289999999999999 | 0.5362499999999999
 | 2020-04-25 00:00:00 | [PHONE]-4209117 | R1-O5RA-UKSS | X07MNZV828 | Product 10 | 1 | 17.38 | 8 | -5.09 | -3.13 | -1.96 | 0 | 4.289999999999999 | 0.5362499999999999
 | 2020-04-25 00:00:00 | [PHONE]-7641928 | R1-O5RA-UKSS | X07MNZV828 | Product 10 | 1 | 17.38 | 8 | -5.09 | -3.13 | -1.96 | 0 | 4.289999999999999 | 0.5362499999999999
 | 2020-04-25 00:00:00 | [PHONE]-6670737 | K2-ZPHE-3KVC | X07G9P2VVF | Product 11 | 1 | 54.68 | 15 | -12.56 | -9.84 | -2.72 | 0 | 27.12 | 1.808
 | 2020-04-24 00:00:00 | [PHONE]-2370744 | KD-QA4S-NDYK | X06XP8FLY9 | Product 4 | 1 | 11.4 | 4.99 | -4.619999999999999 | -2.05 | -2.57 | 0 | 1.790000000000001 | 0.3587174348697397
 | 2020-04-24 00:00:00 | [PHONE]-5089946 | 6Y-72ZN-RPF2 | X008XL2ZQW | Product 8 | 1 | 22.51 | 11.33333333333333 | -6.66 | -4.06 | -2.6 | 0 | 4.516666666666667 | 0.3985294117647059
 | 2020-04-23 00:00:00 | [PHONE]-2161950 | U2-YAN7-4KN2 | X07YX9XMHC | Product 12 | 1 | 34.46 | 19 | -7.98 | -6.2 | -1.78 | 0 | 7.48 | 0.3936842105263158
 | 2020-04-23 00:00:00 | [PHONE]-1261137 |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | No Buy Price | No Buy Price
 | 2020-04-23 00:00:00 | [PHONE]-7978735 | EE-L3SY-SHA0 | [NAME] | Product 13 | 1 | 17.22 | 6.666666666666667 | -5.67 | -3.1 | -2.57 | 0 | 4.883333333333331 | 0.7324999999999996
 | 2020-04-23 00:00:00 |  | 60-O5SR-TUO3 | X0776GM3PC | Product 14 |  | 0 | 8.87 | 9.15 | 0 | 0 | 0 | 0.2800000000000011 | 0.03156708004509596
 | 2020-04-22 00:00:00 | [PHONE]-1170723 | EE-L3SY-SHA0 | [NAME] | Product 13 | 1 | 17.62 | 6.666666666666667 | -5.74 | -3.17 | -2.57 | 0 | 5.213333333333333 | 0.7819999999999999
 | 2020-04-21 00:00:00 | [PHONE]-7480355 | 2F-AF0N-0VRN | X002XFX3XQ | Product 1 | 1 | 14.64 | 4.79 | -4.71 | -2.11 | -2.6 | 0 | 5.140000000000001 | 1.073068893528184
 | 2020-04-21 00:00:00 | [PHONE]-4297136 | 6Y-72ZN-RPF2 | X008XL2ZQW | Product 8 | 1 | 22.58 | 11.33333333333333 | -6.67 | -4.07 | -2.6 | 0 | 4.576666666666664 | 0.4038235294117645
 | 2020-04-21 00:00:00 | [PHONE]-1619555 | EE-L3SY-SHA0 | [NAME] | Product 13 | 1 | 17.42 | 6.666666666666667 | -5.699999999999999 | -3.13 | -2.57 | 0 | 5.053333333333335 | 0.7580000000000001
 | 2020-04-21 00:00:00 | [PHONE]-3454769 | R1-O5RA-UKSS | X07MNZV828 | Product 10 | 1 | 14.99 | 8 | -4.66 | -2.7 | -1.96 | 0 | 2.33 | 0.29125
 | 2020-04-20 00:00:00 | [PHONE]-1448329 | AP-Z6AK-YPZF | X01C6O62LI | Product 15 | 1 | 13.9 | 5 | -5.08 | -2.51 | -2.57 | 0 | 3.82 | 0.764
 | 2020-04-20 00:00:00 | 20040719GP |  |  |  |  | 0 |  | -0.3 | 0 | 0 | 0 | No Buy Price | No Buy Price
 | 2020-04-20 00:00:00 | [PHONE]-5063543 | 2F-AF0N-0VRN | X002XFX3XQ | Product 1 | 1 | 14.64 | 4.79 | -4.71 | -2.11 | -2.6 | 0 | 5.140000000000001 | 1.073068893528184
 | 2020-04-20 00:00:00 | [PHONE]-1557952 | 9E-2INK-HE0J | X0162AOLGA | Product 16 | 1 | 19.45 | 7.77 | -6.43 | -3.5 | -2.93 | 0 | 5.25 | 0.6756756756756757
 | 2020-04-19 00:00:00 | [PHONE]-7009917 | 4F-61L5-N20T | X01IM299FG | Product 17 | 1 | 21.99 | 14 | -6.68 | -3.96 | -2.72 | 0 | 1.309999999999999 | 0.09357142857142849
 | 2020-04-19 00:00:00 | [PHONE]-0493143 | 2F-AF0N-0VRN | X002XFX3XQ | Product 1 | 1 | 14.64 | 4.79 | -4.71 | -2.11 | -2.6 | 0 | 5.140000000000001 | 1.073068893528184
 | 2020-04-19 00:00:00 | [PHONE]-9342744 | U2-YAN7-4KN2 | X07YX9XMHC | Product 12 | 1 | 34.46 | 19 | -7.98 | -6.2 | -1.78 | 0 | 7.48 | 0.3936842105263158
 | 2020-04-18 00:00:00 | [PHONE]-8099525 | PN-NLE3-2P6R | X071J11CXT | Product 18 | 1 | 30.15 | 15.99 | -8.14 | -5.42 | -2.72 | 0 | 6.019999999999998 | 0.3764853033145715
 | 2020-04-18 00:00:00 | [PHONE]-1673133 | R1-O5RA-UKSS | X07MNZV828 | Product 10 | 1 | 14.99 | 8 | -4.66 | -2.7 | -1.96 | 0 | 2.33 | 0.29125
 | 2020-04-18 00:00:00 | [PHONE]-8087541 | 93-V9LC-7J0Z | X002302CYE | Product 19 | 1 | 45.78 | 28 | -10.96 | -8.24 | -2.72 | 0 | 6.82 | 0.2435714285714286
 | 2020-04-18 00:00:00 |  | 77-ZSA5-ZUQY | X008O0P1SS | Product 20 |  | 0 | 12 | 11.76 | 0 | 0 | 0 | -0.2400000000000002 | -0.02000000000000002
 | 2020-04-17 00:00:00 | [PHONE]-6805164 | Q9-7NED-2NSE | X072KHC72S | Product 21 | 1 | 19.75 | 10 | -6.15 | -3.55 | -2.6 | 0 | 3.6 | 0.36
 | 2020-04-17 00:00:00 | [PHONE]-4481911 | VA-KLDN-ZCRK | X01F1ZEJ1Y | Product 22 | 1 | 14.79 | 12.32 | -4.84 | -2.12 | -2.72 | 0 | -2.370000000000001 | -0.1923701298701299
 | 2020-04-17 00:00:00 | [PHONE]-1261137 | IR-LLLN-TTDP | X00GMM2ZAU | Product 23 | 1 | 21.76 | 9.5 | -6.840000000000001 | -3.91 | -2.93 | 0 | 5.420000000000001 | 0.5705263157894738
 | 2020-04-17 00:00:00 | [PHONE]-7401138 | LK-0EC7-2SE2 | X07PM8V3VY | Product 24 | 2 | 26.96 | 6 | -10.05 | -4.85 | -5.2 | 0 | 10.91 | 1.818333333333333
 | 2020-04-16 00:00:00 | [PHONE]-7526764 | 7E-UIJ1-9JO3 | X01I8N133S | Product 25 | 1 | 17.04 | 8.95 | -5.050000000000001 | -2.45 | -2.6 | 0 | 3.039999999999999 | 0.3396648044692737
 | 2020-04-16 00:00:00 | [PHONE]-9764342 | UP-07HA-OKOR | X07SGQZG6M | Product 26 | 1 | 0 | 8.72 | -3.92 | 0 | -3.12 | -0.8 | -12.64 | -1.44954128440367
 | 2020-04-16 00:00:00 | [PHONE]-6877913 | FK-AH2V-IF7O | X01872KIGE | Product 27 | 1 | 18.94 | 9.33 | -5.19 | -3.41 | -1.78 | 0 | 4.420000000000001 | 0.4737406216505896
 | 2020-04-16 00:00:00 | [PHONE]-0511514 | 4A-JNO3-LERK | X07PJCF8JP | Product 28 | 1 | 14.57 | 6.67 | -5.35 | -2.63 | -2.72 | 0 | 2.550000000000001 | 0.3823088455772115
 | 2020-04-15 00:00:00 | [PHONE]-7687515 | 1S-ADAF-AELI | X01608LX8Y | Product 29 | 1 | 39 | 25.5 | -10.14 | -7.02 | -3.12 | 0 | 3.359999999999999 | 0.1317647058823529
 | 2020-04-15 00:00:00 | [PHONE]-1605107 | 6Y-72ZN-RPF2 | X008XL2ZQW | Product 8 | 1 | 22.37 | 11.33333333333333 | -6.630000000000001 | -4.03 | -2.6 | 0 | 4.406666666666666 | 0.3888235294117647
 | 2020-04-15 00:00:00 | [PHONE]-5101926 | 7E-UIJ1-9JO3 | X01I8N133S | Product 25 | 1 | 17.04 | 8.95 | -5.050000000000001 | -2.45 | -2.6 | 0 | 3.039999999999999 | 0.3396648044692737
 |  |  |  |  | Count 2 Quantities
 |  |  |  |  | Count 3 Quantities