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 | SortOrder | Product_SKU | matchingRecords | SalesRank | ViewOrder | AuxBox1Label | AuxBox1Content | AuxBox2Label | AuxBox2Content | AuxBox3Label | AuxBox3Content | AuxBox4Label | AuxBox4Content | ProductViewsL90 | ConversionL90 | ProductSalesL7 | ProductSalesL30 | ProductSalesL60 | ProductSalesL90 | SaleEndDate | hasSound | PriceDisplayText | PricingStartsAt | isApplyMembership | applySpecialMemberDiscount | inStock | Product_Discontinued_Flag | LegacyBaseSku | HasOptions | Specifications | rating | IsSponsored | Specifications | isWarehouse | isCurrentModel | groups |
38733 | TYR Catalyst 2 Training Paddle | N38733_S.jpg | N38733_XL.jpg | 27.99 | 10.00 | 1 | 0 | 0 | 0 | 87620 | 37 | 2 | -75 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 52 | 3.85 | | | | 2 | | 0 | | | 0 | 0 | 1 | 0 | LVC2 S18 | 6 | Training Hand Paddles | .0 | 0 | Training Hand Paddles | 1 | 0 | 52,362,379,633,725,45398,45674,46646,46668,50195,50722,50800,50804,53087,58914 |
35882 | TYR Solid Jammer | N35882_S.jpg | N35882_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 56333 | 37 | 2 | -56 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 63 | 3.17 | | | | 2 | | 0 | | | 0 | 0 | 1 | 0 | SDUR7 001 BK S19 | 7 | Men's Black | .0 | 0 | Men's Black | 0 | 0 | 51,52,113,129,633,725,728,44556,45415,45674,45675,45922,46033,46646,46668,47313,47767,50195,50793,50804,50840,56140,56498,58368,58370,58371 |
41030 | TYR Square Leg W/Zip Pocket | N41030_S.jpg | N41030_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 101083 | 37 | 0 | -55 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 44 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BZPD7.116 S18 | 0 | Men's Black/Robot | .0 | 0 | Men's Black/Robot | 0 | 0 | 52,113,129,633,725,728,45413,45414,45674,45675,46033,46646,46668,47313,47767,50195,50793,50804,50843,56140,56498,58368,58370,58371 |
38549 | TYR Solid Jammer | N38549_S.jpg | N38549_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 56341 | 37 | 1 | -52 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 63 | 1.59 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | SDUR7 401 S19 | 7 | Men's Navy | .0 | 0 | Men's Navy | 0 | 0 | 51,52,113,129,633,725,728,45414,45415,45674,45675,45922,46033,46646,46668,47313,47767,50195,50793,50804,50840,56140,56498,58368,58370,58371 |
51666 | TYR Hexa Trinityfit W/Cups | N51666_S.jpg | N51666_XL.jpg | 79.99 | 59.99 | 1 | 0 | 0 | 0 | 169600 | 37 | 0 | -35 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 86 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | DHEXC8.079 S19 | 0 | Women's Black/Comedy | .0 | 0 | Women's Black/Comedy | 0 | 0 | 52,113,129,633,725,727,45674,45675,46668,47313,50195,50794,50804,56140,56498,58368,58370,58371,62118 |
32343 | TYR Swimple Goggles | N32343_S.jpg | N32343_XL.jpg | 16.99 | 12.99 | 1 | 0 | 0 | 0 | 61982 | 37 | 0 | -28 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 15 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LGSW 420 S18 | 0 | Unisex Blue | .0 | 0 | Unisex Blue | 0 | 0 | 51,52,362,379,419,508,509,633,725,726,727,728,729,44979,45476,45674,46646,46668,50195,50784,50804,52614,58369,58371 |
28649 | TYR Crossblade Fins | N28649_S.jpg | N28649_XL.jpg | 51.99 | 20.00 | 1 | 0 | 0 | 0 | 22133 | 37 | 0 | -26 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 75 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LFCROSS S19 | 7 | Unisex | .0 | 0 | Unisex | 1 | 0 | 52,362,379,633,725,726,727,728,45674,45922,46646,46668,50195,50722,50798,50804,52973,58914 |
50278 | TYR Zola Hipkini | N50278_S.jpg | N50278_XL.jpg | 47.99 | 20.00 | 1 | 0 | 0 | 0 | 160452 | 37 | 0 | -24 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 30 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BBSO7A.001 S18 | 0 | Women's Black | .0 | 0 | Women's Black | 1 | 0 | 52,113,129,633,725,727,44556,45396,45397,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58913 |
51661 | TYR Monster Cap | N51661_S.jpg | N51661_XL.jpg | 13.99 | 5.00 | 1 | 0 | 0 | 0 | 169705 | 37 | 0 | -24 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 13 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSMNSTR.310 S19 N | 0 | Kids Green | .0 | 0 | Kids Green | 1 | 0 | 52,362,379,633,725,729,46668,50195,50722,50802,50804,53221,58914 |
38712 | TYR Swimple Goggles | N38712_S.jpg | N38712_XL.jpg | 16.99 | 12.99 | 1 | 0 | 0 | 0 | 87611 | 37 | 1 | -20 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 24 | 4.17 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | LGSW 105 S18 | 0 | Unisex Clear/Trans Blue | .0 | 0 | Unisex Clear/Trans Blue | 0 | 0 | 51,52,362,379,419,509,633,725,726,727,728,729,44979,45476,45674,46646,46668,50195,50784,50804,52614,58369,58371 |
28376 | TYR Youth Qualifier | N28376_S.jpg | N28376_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 41156 | 37 | 0 | -18 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 14 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LGQUAL 420 F16 | 0 | Kids Goggles Blue | .0 | 0 | Kids Goggles Blue | 0 | 0 | 51,52,362,379,419,509,633,729,44979,45476,45922,46646,46668,50195,50804,52614,58369,58371,62117,62827 |
40834 | TYR Silicone Happy Fish Cap | N40834_S.jpg | N40834_XL.jpg | 12.99 | 3.00 | 1 | 0 | 0 | 0 | 100108 | 37 | 0 | -15 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 15 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSHFISH 420 F16 | 0 | Blue | .0 | 0 | Blue | 1 | 0 | 52,362,379,633,725,45674,46646,46668,50195,50722,50802,50804,53221,58914 |
38567 | TYR Alliance Splice Jammer | N38567_S.jpg | N38567_XL.jpg | 49.99 | 20.00 | 1 | 0 | 0 | 0 | 67217 | 37 | 0 | -12 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 67 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | SDAL7MA 034 | 7 | Men's Black/Charcoal | .0 | 0 | Men's Black/Charcoal | 1 | 0 | 51,52,113,129,633,725,728,45415,45674,45675,45922,46033,46646,46668,47313,47767,50195,50722,50793,50804,50840,56140,56498,58913 |
50244 | TYR Square Leg W/Zip Pocket | N50244_S.jpg | N50244_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 160231 | 37 | 0 | -12 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 33 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BZPD7.471 S18 | 0 | Men's Navy/Harward | .0 | 0 | Men's Navy/Harward | 0 | 0 | 52,113,129,633,725,728,45674,45675,46668,47313,47767,50195,50793,50804,50843,56140,56498,58368,58370,58371 |
28362 | TYR Youth Qualifier | N28362_S.jpg | N28362_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 36558 | 37 | 0 | -12 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 13 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LGQUAL 101 F16 | 0 | Kids Goggles Clear | .0 | 0 | Kids Goggles Clear | 0 | 0 | 51,52,362,379,419,509,633,729,44979,45476,45922,46646,46668,50195,50804,52614,58369,58371,62117,62827 |
50282 | TYR Durafast SquareNeck Sheath | N50282_S.jpg | N50282_XL.jpg | 111.99 | 59.99 | 1 | 0 | 0 | 0 | 160474 | 37 | 0 | -11 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 28 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | TSSQJ7.001 S19 | 0 | Women's Black | .0 | 0 | Women's Black | 0 | 0 | 52,113,129,633,725,727,45674,45675,46668,46941,47313,47767,50195,50794,50804,56140,56498,58368,58370,58371,62118 |
29702 | TYR Burner EBP Fin | N29702_S.jpg | N29702_XL.jpg | 51.99 | 24.00 | 1 | 0 | 0 | 0 | 48197 | 37 | 0 | -10 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 37 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LFBP S18 | 4 | Unisex | .0 | 0 | Unisex | 1 | 0 | 52,362,379,633,725,726,727,728,45674,45922,46646,46668,50195,50722,50798,50804,52973,58914 |
50255 | TYR Santa Cruz Jade Top | N50255_S.jpg | N50255_XL.jpg | 76.99 | 25.00 | 1 | 0 | 0 | 0 | 160299 | 37 | 0 | -10 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 28 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BJASC7A.523 S18 | 0 | Women's Navy/Purple | .0 | 0 | Women's Navy/Purple | 1 | 0 | 52,113,129,633,725,727,45399,45674,45675,46668,47313,47767,50195,50722,50788,50804,56140,56498,58913 |
40549 | TYR Swimple Goggles | N40549_S.jpg | N40549_XL.jpg | 15.99 | 12.99 | 1 | 0 | 0 | 0 | 98681 | 37 | 1 | -9 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 14 | 7.14 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | LGSW 085 F16 | 0 | Unisex Smoke/Green | .0 | 0 | Unisex Smoke/Green | 0 | 0 | 52,362,379,419,509,633,725,726,727,728,729,45674,46646,46668,50195,50784,50804,52614,58369,58371 |
50301 | TYR Durafast Solid Racer | N50301_S.jpg | N50301_XL.jpg | 31.99 | 19.99 | 1 | 0 | 0 | 0 | 160611 | 37 | 0 | -9 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 18 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | RDUR7.401 F18 | 0 | Men's Navy | .0 | 0 | Men's Navy | 0 | 0 | 52,113,129,633,725,728,44466,45674,45675,46668,47313,50195,50793,50804,50841,56140,56498,58368,58370,58371 |
43323 | TYR Santa Rosa Bikini Bottom | N43323_S.jpg | N43323_XL.jpg | 35.99 | 10.00 | 1 | 0 | 0 | 0 | 115272 | 37 | 0 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 29 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BCSR7FA 413 F15 | 0 | Women's Navy/Coral | .0 | 0 | Women's Navy/Coral | 1 | 0 | 52,113,129,633,725,727,45395,45397,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58913 |
38454 | TYR Splice Racer | N38454_S.jpg | N38454_XL.jpg | 28.99 | 10.00 | 1 | 0 | 0 | 0 | 45957 | 37 | 0 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 21 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | RDAS 034 S11 | 5 | Men's Black/Charcaol | .0 | 0 | Men's Black/Charcaol | 1 | 0 | 52,113,129,633,725,728,45413,45674,45675,45922,46646,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58913 |
32341 | TYR Youth Qualifier | N32341_S.jpg | N32341_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 61980 | 37 | 0 | -7 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LGQUAL 041 F16 | 0 | Kids Goggles Smoke | .0 | 0 | Kids Goggles Smoke | 0 | 0 | 51,52,362,379,419,509,633,44979,45476,46646,46668,50195,50804,52614,58369,58371,62117,62827 |
41224 | TYR Alliance Splice Racer | N41224_S.jpg | N41224_XL.jpg | 33.99 | 14.99 | 1 | 0 | 0 | 0 | 101906 | 37 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 32 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | RDAL7 116 F17 | 0 | Men's Black/Robot | .0 | 0 | Men's Black/Robot | 0 | 0 | 51,52,113,129,633,725,728,45412,45674,45675,46033,46646,46668,47313,47767,50195,50793,50804,50841,56140,56498,58368,58370,58371 |
50300 | TYR Durafast Solid Racer | N0_SM.jpg | N50300_XL.jpg | 31.99 | 19.99 | 1 | 0 | 0 | 0 | 160603 | 37 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 23 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | RDUR7.001 F18 | 0 | Men's Black | .0 | 0 | Men's Black | 0 | 0 | 52,113,129,362,379,633,725,728,44556,45674,45675,46369,46668,47313,47767,50195,50804,56140,56498,58368,58369,58370,58371,61272 |
50272 | TYR Cover Sun Suit | N50272_S.jpg | N50272_XL.jpg | 43.99 | 20.00 | 1 | 0 | 0 | 0 | 160417 | 37 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 10 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | CSSK7.420 S19 | 0 | Kid's Blue | .0 | 0 | Kid's Blue | 1 | 0 | 52,113,129,633,725,44402,45674,45675,45922,46668,47313,47767,50195,50722,50794,50804,56140,56498,58913 |
50134 | TYR Swimple Goggles | N50134_S.jpg | N50134_XL.jpg | 16.99 | 12.99 | 1 | 0 | 0 | 0 | 159779 | 37 | 0 | -5 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 16 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LGSW.479 S18 | 0 | Unisex Berry Fizz | .0 | 0 | Unisex Berry Fizz | 0 | 0 | 52,362,379,419,509,633,725,726,727,728,729,45674,46668,50195,50784,50804,52614,58369,58371 |
50251 | TYR Carnivale Lula Bottom | N50251_S.jpg | N50251_XL.jpg | 47.99 | 15.00 | 1 | 0 | 0 | 0 | 160275 | 37 | 0 | -4 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 15 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BLCA7A.004 S18 | 0 | Women's Black/Multi | .0 | 0 | Women's Black/Multi | 1 | 0 | 52,113,129,633,725,727,45395,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58913 |
40842 | TYR UNL Glide Clip Headstrap | N40842_S.jpg | N40842_XL.jpg | 6.99 | 3.00 | 1 | 0 | 0 | 0 | 100122 | 37 | 0 | -4 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 7 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LGCS S16 | 0 | Black | .0 | 0 | Black | 1 | 0 | 52,362,379,420,633,725,45674,46646,46668,50195,50722,50804,58914 |
50302 | TYR Durafast Square Leg | N50302_S.jpg | N50302_XL.jpg | 35.99 | 26.99 | 1 | 0 | 0 | 0 | 160620 | 37 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 16 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BPS7.001 F18 | 0 | Men's Black | .0 | 0 | Men's Black | 0 | 0 | 52,113,129,633,725,728,44556,45409,45674,45675,46668,47313,47767,50195,50793,50804,50843,56140,56498,58368,58370,58371 |
50288 | TYR Girls Duramax 1PC Maxfit | N50288_S.jpg | N50288_XL.jpg | 49.99 | 20.00 | 1 | 0 | 0 | 0 | 160523 | 37 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 10 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T322.537 S18 | 0 | Youth Indigo/Antibe/Basil | .0 | 0 | Youth Indigo/Antibe/Basil | 1 | 0 | 52,113,129,633,725,729,45674,45675,46668,47313,47767,50195,50722,50794,50804,56140,56498,58913 |
50289 | TYR Girls Duramax 1PC Maxfit | N50289_S.jpg | N50289_XL.jpg | 49.99 | 20.00 | 1 | 0 | 0 | 0 | 160530 | 37 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 10 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T322.134 S18 | 0 | Youth Black/Soho/White | .0 | 0 | Youth Black/Soho/White | 1 | 0 | 52,113,129,633,725,729,45674,45675,46668,47313,47767,50195,50722,50794,50804,56140,56498,58913 |
50290 | TYR Girls Tankini Yoke Front | N50290_S.jpg | N50290_XL.jpg | 47.99 | 20.00 | 1 | 0 | 0 | 0 | 160537 | 37 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T316.416 S18 | 0 | Youth Navy/Turquoise | .0 | 0 | Youth Navy/Turquoise | 1 | 0 | 52,113,129,633,725,45674,45675,46668,47313,47767,50195,50722,50795,50804,56140,56498,58913 |
50291 | TYR Girls Tankini Yoke Front | N50291_S.jpg | N50291_XL.jpg | 47.99 | 20.00 | 1 | 0 | 0 | 0 | 160544 | 37 | 0 | -1 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 7 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T316.137 S18 | 0 | Youth Black/Funny Pink | .0 | 0 | Youth Black/Funny Pink | 1 | 0 | 52,113,129,633,725,45674,45675,46668,47313,47767,50195,50722,50795,50804,56140,56498,58913 |
50297 | TYR Boys Splice Square Leg | N50297_S.jpg | N50297_XL.jpg | 29.99 | 10.00 | 1 | 0 | 0 | 0 | 160582 | 37 | 0 | -1 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 1 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T901.027 S18 | 0 | Youth Black/Robot | .0 | 0 | Youth Black/Robot | 1 | 0 | 52,113,129,633,725,45674,45675,46668,47313,47767,50195,50722,50793,50804,50843,56140,56498,58913 |
45447 | TYR Youth Qualifier | N45447_S.jpg | N45447_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 128995 | 37 | 0 | 0 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LGQUAL.700 F16 | 0 | Kids Goggles Amber | .0 | 0 | Kids Goggles Amber | 0 | 0 | 52,362,379,419,509,633,45674,46668,50195,50804,52614,58369,58371,62117,62827 |
51658 | TYR Happy Whale Swim Cap | N51658_S.jpg | N51658_XL.jpg | 12.49 | 5.00 | 1 | 0 | 0 | 0 | 169569 | 37 | 0 | 0 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSHWHAL.060 S19 N | 0 | Kids Black/White | .0 | 0 | Kids Black/White | 1 | 0 | 52,362,379,633,725,46668,50195,50722,50802,50804,53221,58914 |