Product_Id | Product_Name | Product_Image_sm | Product_Image_Xl | Product_Price | Product_Sale_Price | Product_Sale_Price_Flag | Product_Featured_Flag | Product_Promotion_Flag | Specifications | SortOrder | Product_SKU | matchingRecords | ActivationDate | SalesRank | ViewOrder | AuxBox1Label | AuxBox1Content | AuxBox2Label | AuxBox2Content | AuxBox3Label | AuxBox3Content | AuxBox4Label | AuxBox4Content | ProductViewsL90 | ConversionL90 | SaleEndDate | hasSound | PriceDisplayText | PricingStartsAt | ActivePrice | isApplyMembership | inStock | Product_Discontinued_Flag | LegacyBaseSku | hasOptions | ProductPath | Stripped_Product_Name | rating | PriceLow | PriceHigh | SalePriceLow | SalePriceHigh | isWarehouse | isCurrentModel | groups |
51495 | Arena Awt Soft Armband | N51495_S.jpg | N51495_XL.jpg | 19.99 | 5.00 | 1 | 0 | 0 | Kid's Punk Red | 0 | 168446 | 27 | 04/15/2019 03:55:00 | 1 | -2 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 11 | 9.09 | | 0 | | | 5.00 | 0 | 1 | 0 | 95244.010 F19 | 0 | Arena-Awt-Soft-Armband-p51495 | Arena-Awt-Soft-Armband | .0 | 19.99 | 19.99 | .00 | .00 | 1 | 0 | 52,362,379,725,729,45701,46668,50195,50722,50804,58914,62984 |
51661 | TYR Monster Cap | N51661_S.jpg | N51661_XL.jpg | 13.99 | 5.00 | 1 | 0 | 0 | Kids Green | 0 | 169705 | 27 | 03/13/2019 08:10:00 | 0 | 0 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 0 | .00 | | 0 | | | 5.00 | 0 | 1 | 0 | LCSMNSTR.310 S19 N | 0 | TYR-Monster-Cap-p51661 | TYR-Monster-Cap | .0 | 13.99 | 13.99 | .00 | .00 | 1 | 0 | 52,362,379,633,725,729,46668,50195,50722,50802,50804,53221,58914,62984 |
49328 | Mizuno Sultan II Lo Youth | N0_SM.jpg | N49328_XL.jpg | 59.99 | 10.00 | 1 | 0 | 0 | Youth Black/White | 0 | 153905 | 27 | 12/20/2017 16:50:00 | 0 | -27 | user1 | | user2 | | DeptName | Shoes - Gym | SubDeptName | | 13 | .00 | | 0 | | | 10.00 | 0 | 1 | 0 | Y809B2 C17 | 0 | Mizuno-Sultan-II-Lo-Youth-p49328 | Mizuno-Sultan-II-Lo-Youth | .0 | 59.99 | 59.99 | .00 | .00 | 1 | 0 | 27,701,725,729,44372,45038,45364,45389,45674,45675,45682,46668,50722,50784,56577,58912,62983 |
32343 | TYR Swimple Goggles | N32343_S.jpg | N32343_XL.jpg | 16.99 | 10.00 | 1 | 0 | 0 | Unisex Blue | 0 | 61982 | 27 | 01/12/2012 05:03:01 | 0 | -13 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 39 | .00 | | 0 | | | 10.00 | 0 | 1 | 0 | LGSW 420 S18 | 0 | TYR-Swimple-Goggles-p32343 | TYR-Swimple-Goggles | .0 | 16.99 | 16.99 | .00 | .00 | 1 | 0 | 51,52,362,379,419,508,509,633,725,726,727,728,729,44979,45476,45674,46646,46668,50195,50722,50784,50804,52614,58914,62984 |
49324 | Mizuno Y9 Spike Franchise G3 L | N49324_S.jpg | N49324_XL.jpg | 39.99 | 10.00 | 1 | 0 | 0 | Youth Black/Silver | 0 | 153880 | 27 | 12/20/2017 16:50:00 | 0 | -10 | user1 | | user2 | | DeptName | Shoes - Gym | SubDeptName | | 10 | .00 | | 0 | | | 10.00 | 0 | 1 | 0 | FB67LBK C17 | 0 | Mizuno-Y9-Spike-Franchise-G3-L-p49324 | Mizuno-Y9-Spike-Franchise-G3-L | .0 | 39.99 | 39.99 | .00 | .00 | 1 | 0 | 27,701,725,729,44637,45359,45360,45361,45389,45674,45675,45682,46668,47767,50722,50784,56577,58262,58912,62983 |
28362 | TYR Youth Qualifier | N28362_S.jpg | N28362_XL.jpg | 12.99 | 10.00 | 1 | 0 | 0 | Kids Goggles Clear | 0 | 36558 | 27 | 07/07/2011 17:29:02 | 0 | -8 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 17 | .00 | | 0 | | | 10.00 | 0 | 1 | 0 | LGQUAL 101 F16 | 0 | TYR-Youth-Qualifier-p28362 | TYR-Youth-Qualifier | .0 | 12.99 | 12.99 | .00 | .00 | 1 | 0 | 51,52,362,379,419,509,633,725,729,44979,45476,45922,46646,46668,50195,50722,50804,52614,58914,62984 |
28376 | TYR Youth Qualifier | N28376_S.jpg | N28376_XL.jpg | 12.99 | 10.00 | 1 | 0 | 0 | Kids Goggles Blue | 0 | 41156 | 27 | 07/07/2011 17:29:02 | 0 | -4 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 19 | .00 | | 0 | | | 10.00 | 0 | 1 | 0 | LGQUAL 420 F16 | 0 | TYR-Youth-Qualifier-p28376 | TYR-Youth-Qualifier | .0 | 12.99 | 12.99 | .00 | .00 | 1 | 0 | 51,52,362,379,419,509,633,725,729,44979,45476,45922,46646,46668,50195,50722,50804,52614,58914,62984 |
49272 | Aquasphere Aelys Swimsuit | N49272_S.jpg | N49272_XL.jpg | 34.99 | 10.00 | 1 | 0 | 0 | Youth Black/Lilac | 0 | 153445 | 27 | 12/14/2017 10:50:00 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 32 | .00 | | 0 | | | 10.00 | 0 | 1 | 0 | SJ2000150 CF17 | 0 | Aquasphere-Aelys-Swimsuit-p49272 | Aquasphere-Aelys-Swimsuit | .0 | 34.99 | 34.99 | .00 | .00 | 1 | 0 | 52,113,129,688,725,729,44271,45674,45675,46668,47313,47767,50195,50722,50794,50804,56140,56498,58913,62982 |
50123 | Arena Youth Gauge Short | N50123_S.jpg | N50123_XL.jpg | 45.99 | 10.00 | 1 | 0 | 0 | Kid's Red | 0 | 159733 | 27 | 05/19/2018 17:10:00 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 19 | .00 | | 0 | | | 10.00 | 0 | 1 | 0 | 44796-40 C18 | 0 | Arena-Youth-Gauge-Short-p50123 | Arena-Youth-Gauge-Short | .0 | 45.99 | 45.99 | .00 | .00 | 1 | 0 | 52,113,129,725,729,44487,45674,45675,45701,46668,47313,47767,50195,50722,50793,50804,50842,56140,56498,58913,62982 |
50193 | Arena Boys Sarring Youth | N50193_S.jpg | N50193_XL.jpg | 39.99 | 10.00 | 1 | 0 | 0 | Youth Black/Silver/White | 0 | 159956 | 27 | 05/20/2018 12:05:00 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 18 | .00 | | 0 | | | 10.00 | 0 | 1 | 0 | 21103-55 C18 | 0 | Arena-Boys-Sarring-Youth-p50193 | Arena-Boys-Sarring-Youth | .0 | 39.99 | 39.99 | .00 | .00 | 1 | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58913,62982 |
50194 | Arena Boys Sarring Youth | N50194_S.jpg | N50194_XL.jpg | 39.99 | 10.00 | 1 | 0 | 0 | Youth Navy/Silver/White | 0 | 159960 | 27 | 05/20/2018 12:05:00 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 16 | .00 | | 0 | | | 10.00 | 0 | 1 | 0 | 21103-75 C18 | 0 | Arena-Boys-Sarring-Youth-p50194 | Arena-Boys-Sarring-Youth | .0 | 39.99 | 39.99 | .00 | .00 | 1 | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58913,62982 |
45146 | Speedo Sprint Splice FB (Y) | N45146_S.jpg | N45146_XL.jpg | 99.99 | 15.00 | 1 | 0 | 0 | Female Youth Black/Yellow | 0 | 126838 | 27 | 06/17/2016 12:10:00 | 0 | -374 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 51 | .00 | | 0 | | | 15.00 | 0 | 1 | 0 | P1312360 CS16 | 0 | Speedo-Sprint-Splice-FB-Y-p45146 | Speedo-Sprint-Splice-FB-Y | .0 | 99.99 | 99.99 | .00 | .00 | 1 | 0 | 52,113,129,725,729,44411,45674,45675,46668,46703,47313,50195,50722,50794,50804,56140,56498,58913,62982 |
45142 | Speedo Sprint Splice FB (Y) | N45142_S.jpg | N45142_XL.jpg | 99.99 | 15.00 | 1 | 0 | 0 | Female Youth Black/Green | 0 | 126819 | 27 | 06/17/2016 12:10:00 | 0 | -143 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 37 | .00 | | 0 | | | 15.00 | 0 | 1 | 0 | P1312358 CS16 | 0 | Speedo-Sprint-Splice-FB-Y-p45142 | Speedo-Sprint-Splice-FB-Y | .0 | 99.99 | 99.99 | .00 | .00 | 1 | 0 | 52,113,129,725,729,45674,45675,46668,46703,47313,47767,50195,50722,50794,50804,56140,56498,58913,62982 |
50289 | TYR Girls Duramax 1PC Maxfit | N50289_S.jpg | N50289_XL.jpg | 49.99 | 15.00 | 1 | 0 | 0 | Youth Black/Soho/White | 0 | 160530 | 27 | 06/28/2018 17:10:00 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 25 | .00 | | 0 | | | 15.00 | 0 | 1 | 0 | T322.134 S18 | 0 | TYR-Girls-Duramax-1PC-Maxfit-p50289 | TYR-Girls-Duramax-1PC-Maxfit | .0 | 49.99 | 49.99 | .00 | .00 | 1 | 0 | 52,113,129,633,725,729,45674,45675,46668,47313,47767,50195,50722,50794,50804,56140,56498,58913,62982 |
50288 | TYR Girls Duramax 1PC Maxfit | N50288_S.jpg | N50288_XL.jpg | 49.99 | 15.00 | 1 | 0 | 0 | Youth Indigo/Antibe/Basil | 0 | 160523 | 27 | 06/28/2018 17:25:00 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 23 | .00 | | 0 | | | 15.00 | 0 | 1 | 0 | T322.537 S18 | 0 | TYR-Girls-Duramax-1PC-Maxfit-p50288 | TYR-Girls-Duramax-1PC-Maxfit | .0 | 49.99 | 49.99 | .00 | .00 | 1 | 0 | 52,113,129,633,725,729,45674,45675,46668,47313,47767,50195,50722,50794,50804,56140,56498,58913,62982 |
50540 | Arena Solid Short Jr | N50540_S.jpg | N50540_XL.jpg | 44.99 | 15.00 | 1 | 0 | 0 | Kids Navy/White | 0 | 161982 | 27 | 08/18/2018 14:05:00 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 23 | .00 | | 0 | | | 15.00 | 0 | 1 | 0 | 2A259.075 S19 | 0 | Arena-Solid-Short-Jr-p50540 | Arena-Solid-Short-Jr | .0 | 44.99 | 44.99 | .00 | .00 | 1 | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50793,50804,50843,56140,56498,58913,62982 |
57501 | Craft Fuseknit Comfort Pants J | N0_SM.jpg | N57501_XL.jpg | 39.99 | 18.00 | 1 | 0 | 0 | Unisex Junior Black | 0 | 209581 | 27 | 07/19/2021 18:10:00 | 1 | -552 | user1 | | user2 | | DeptName | Clothing - Pants | SubDeptName | Long Pants | 81 | 1.23 | | 0 | | | 18.00 | 0 | 1 | 0 | 1906634 BLK CF21 | 0 | Craft-Fuseknit-Comfort-Pants-J-p57501 | Craft-Fuseknit-Comfort-Pants-J | .0 | 39.99 | 39.99 | .00 | .00 | 1 | 0 | 113,128,653,725,726,727,728,729,44556,45397,45398,45399,45674,45675,45694,46668,50195,50722,50784,54752,56498,57648,58913,60175,62982 |
57503 | Craft Fuseknit Comfort RN LS J | N0_SM.jpg | N57503_XL.jpg | 39.99 | 18.00 | 1 | 0 | 0 | Unisex Junior Black | 0 | 209593 | 27 | 07/24/2021 14:05:00 | 1 | -198 | user1 | | user2 | | DeptName | Clothing - Tops | SubDeptName | Long Sleeve | 136 | .74 | | 0 | | | 18.00 | 0 | 1 | 0 | 1906633 BLK CF21 | 0 | Craft-Fuseknit-Comfort-RN-LS-J-p57503 | Craft-Fuseknit-Comfort-RN-LS-J | .0 | 39.99 | 39.99 | .00 | .00 | 1 | 0 | 113,126,128,345,653,725,726,727,728,729,44556,45396,45397,45674,45675,45694,46668,47313,50195,50722,50784,54752,55883,56498,57648,58913,60175,62982 |
59467 | Klean Kanteen 12oz Sport | N0_SM.jpg | N59467_XL.jpg | 30.99 | 19.99 | 1 | 0 | 0 | Orchid Hearts | 0 | 225631 | 27 | 05/06/2022 14:05:00 | 0 | -8 | user1 | | user2 | | DeptName | Accessories - Hydration | SubDeptName | Accessories | 3 | .00 | | 0 | | | 19.99 | 0 | 1 | 0 | KK12-1008862 S22 | 0 | Klean-Kanteen-12oz-Sport-p59467 | Klean-Kanteen-12oz-Sport | .0 | 30.99 | 30.99 | .00 | .00 | 0 | 0 | 362,371,401,692,725,729,45003,46668,50195,50784,54574,55714,58369,58371,62984 |
59468 | Klean Kanteen 12oz Sport | N0_SM.jpg | N59468_XL.jpg | 30.99 | 19.99 | 1 | 0 | 0 | Planets | 0 | 225632 | 27 | 05/06/2022 14:05:00 | 0 | -4 | user1 | | user2 | | DeptName | Accessories - Hydration | SubDeptName | Accessories | 2 | .00 | | 0 | | | 19.99 | 0 | 1 | 0 | KK12-1008863 S22 | 0 | Klean-Kanteen-12oz-Sport-p59468 | Klean-Kanteen-12oz-Sport | .0 | 30.99 | 30.99 | .00 | .00 | 0 | 0 | 362,371,401,692,725,729,45003,46668,50195,50784,54574,55714,58369,58371,62984 |
59462 | Klean Kanteen 12oz Sippy | N0_SM.jpg | N59462_XL.jpg | 30.99 | 19.99 | 1 | 0 | 0 | Safari | 0 | 225626 | 27 | 05/06/2022 13:35:00 | 0 | 0 | user1 | | user2 | | DeptName | Accessories - Hydration | SubDeptName | Accessories | 0 | .00 | | 0 | | | 19.99 | 0 | 1 | 0 | KK12-1008775 S22 | 0 | Klean-Kanteen-12oz-Sippy-p59462 | Klean-Kanteen-12oz-Sippy | .0 | 30.99 | 30.99 | .00 | .00 | 0 | 0 | 362,371,401,692,725,729,45003,46668,50195,50784,54574,55714,58369,58371,62984 |
59464 | Klean Kanteen 12oz Sippy | N0_SM.jpg | N59464_XL.jpg | 30.99 | 19.99 | 1 | 0 | 0 | Coral Strawberries | 0 | 225628 | 27 | 05/06/2022 14:05:00 | 0 | 0 | user1 | | user2 | | DeptName | Accessories - Hydration | SubDeptName | Accessories | 0 | .00 | | 0 | | | 19.99 | 0 | 1 | 0 | KK12-1008857 S22 | 0 | Klean-Kanteen-12oz-Sippy-p59464 | Klean-Kanteen-12oz-Sippy | .0 | 30.99 | 30.99 | .00 | .00 | 0 | 0 | 362,371,401,692,725,729,45003,46668,50195,50784,54574,55714,58369,58371,62984 |
59465 | Klean Kanteen 12oz Sippy | N0_SM.jpg | N59465_XL.jpg | 30.99 | 19.99 | 1 | 0 | 0 | Gators | 0 | 225629 | 27 | 05/06/2022 14:05:00 | 0 | 0 | user1 | | user2 | | DeptName | Accessories - Hydration | SubDeptName | Accessories | 0 | .00 | | 0 | | | 19.99 | 0 | 1 | 0 | KK12-1008858 S22 | 0 | Klean-Kanteen-12oz-Sippy-p59465 | Klean-Kanteen-12oz-Sippy | .0 | 30.99 | 30.99 | .00 | .00 | 0 | 0 | 362,371,401,692,725,729,45003,46668,50195,50784,54574,55714,58369,58371,62984 |
59466 | Klean Kanteen 12oz Sport | N0_SM.jpg | N59466_XL.jpg | 30.99 | 19.99 | 1 | 0 | 0 | Hawaiian Ocean | 0 | 225630 | 27 | 05/06/2022 14:05:00 | 0 | 0 | user1 | | user2 | | DeptName | Accessories - Hydration | SubDeptName | Accessories | 0 | .00 | | 0 | | | 19.99 | 0 | 1 | 0 | KK12-1008859 S22 | 0 | Klean-Kanteen-12oz-Sport-p59466 | Klean-Kanteen-12oz-Sport | .0 | 30.99 | 30.99 | .00 | .00 | 0 | 0 | 362,371,401,692,725,729,45003,46668,50195,50784,54574,55714,58369,58371,62984 |
61551 | Buff Original Ecostretch Kids | N0_SM.jpg | N61551_XL.jpg | 24.99 | .00 | 0 | 0 | 0 | Unisex Fynch/Multi | 0 | 242176 | 27 | 02/16/2023 17:05:01 | 0 | -4 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Cold Weather | 13 | .00 | | 0 | | | 24.99 | 0 | 1 | 0 | 126925.555 S23 | 0 | Buff-Original-Ecostretch-Kids-p61551 | Buff-Original-Ecostretch-Kids | .0 | 24.99 | 24.99 | .00 | .00 | 0 | 0 | 113,362,370,398,399,608,726,727,728,729,44764,44765,45674,45675,46668,47935,50195,50784,55489,56498,58368,58369,58370,58371,62115,62117,62827,62898,62982,62984 |
61544 | Buff Original Ecostretch Kids | N0_SM.jpg | N61544_XL.jpg | 24.99 | .00 | 0 | 0 | 0 | Unisex Nacreous Multi | 0 | 242172 | 27 | 02/16/2023 17:05:01 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Cold Weather | 9 | .00 | | 0 | | | 24.99 | 0 | 1 | 0 | 126929.555 S23 | 0 | Buff-Original-Ecostretch-Kids-p61544 | Buff-Original-Ecostretch-Kids | .0 | 24.99 | 24.99 | .00 | .00 | 0 | 0 | 113,362,370,398,399,608,726,727,728,729,44764,44765,45674,45675,46668,47935,50195,50784,55489,56498,58368,58369,58370,58371,62115,62117,62827,62898,62982,62984 |
61552 | Buff Original Ecostretch Baby | N0_SM.jpg | N61552_XL.jpg | 24.99 | .00 | 0 | 0 | 0 | Unisex Breezie Pink | 0 | 242177 | 27 | 02/16/2023 17:05:01 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Cold Weather | 8 | .00 | | 0 | | | 24.99 | 0 | 1 | 0 | 126910.538 S23 | 0 | Buff-Original-Ecostretch-Baby-p61552 | Buff-Original-Ecostretch-Baby | .0 | 24.99 | 24.99 | .00 | .00 | 0 | 0 | 113,362,370,398,399,608,726,727,728,729,44764,44765,45674,45675,46668,47935,50195,50784,55489,56498,58368,58369,58370,58371,62115,62117,62827,62898,62982,62984 |