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 |
40834 | TYR Silicone Happy Fish Cap | N40834_S.jpg | N40834_XL.jpg | 12.99 | 3.00 | 1 | 0 | 0 | 0 | 100108 | 29 | 0 | -56 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 9 | .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,62984 |
32343 | TYR Swimple Goggles | N32343_S.jpg | N32343_XL.jpg | 16.99 | 12.99 | 1 | 0 | 0 | 0 | 61982 | 29 | 0 | -48 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 21 | .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,62984 |
28649 | TYR Crossblade Fins | N28649_S.jpg | N28649_XL.jpg | 51.99 | 20.00 | 1 | 0 | 0 | 0 | 22133 | 29 | 0 | -28 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 48 | .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,62984 |
35882 | TYR Solid Jammer | N35882_S.jpg | N35882_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 56333 | 29 | 0 | -24 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 42 | .00 | | | | 0 | | 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,62982 |
51666 | TYR Hexa Trinityfit W/Cups | N51666_S.jpg | N51666_XL.jpg | 79.99 | 59.99 | 1 | 0 | 0 | 0 | 169600 | 29 | 0 | -23 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 83 | .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,62982 |
41030 | TYR Square Leg W/Zip Pocket | N41030_S.jpg | N41030_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 101083 | 29 | 0 | -20 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 19 | .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,62982 |
38733 | TYR Catalyst 2 Training Paddle | N38733_S.jpg | N38733_XL.jpg | 27.99 | 10.00 | 1 | 0 | 0 | 0 | 87620 | 29 | 2 | -16 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 58 | 3.45 | | | | 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,62984 |
38549 | TYR Solid Jammer | N38549_S.jpg | N38549_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 56341 | 29 | 1 | -15 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 28 | 3.57 | | | | 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,45674,45675,45922,46033,46646,46668,47313,47767,50195,50793,50804,50840,56140,56498,58368,58370,58371,62982 |
32341 | TYR Youth Qualifier | N32341_S.jpg | N32341_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 61980 | 29 | 0 | -14 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 3 | .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,62984 |
51661 | TYR Monster Cap | N51661_S.jpg | N51661_XL.jpg | 13.99 | 5.00 | 1 | 0 | 0 | 0 | 169705 | 29 | 0 | -12 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 16 | .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,62984 |
50282 | TYR Durafast SquareNeck Sheath | N50282_S.jpg | N50282_XL.jpg | 111.99 | 59.99 | 1 | 0 | 0 | 0 | 160474 | 29 | 0 | -9 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 32 | .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,62982 |
38712 | TYR Swimple Goggles | N38712_S.jpg | N38712_XL.jpg | 16.99 | 12.99 | 1 | 0 | 0 | 0 | 87611 | 29 | 1 | -8 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 15 | 6.67 | | | | 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,62984 |
29702 | TYR Burner EBP Fin | N29702_S.jpg | N29702_XL.jpg | 51.99 | 24.00 | 1 | 0 | 0 | 0 | 48197 | 29 | 0 | -8 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 35 | .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,62984 |
40842 | TYR UNL Glide Clip Headstrap | N40842_S.jpg | N40842_XL.jpg | 6.99 | 3.00 | 1 | 0 | 0 | 0 | 100122 | 29 | 0 | -8 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 6 | .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,62984 |
50278 | TYR Zola Hipkini | N50278_S.jpg | N50278_XL.jpg | 47.99 | 20.00 | 1 | 0 | 0 | 0 | 160452 | 29 | 1 | -7 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 40 | 2.50 | | | | 1 | | 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,45397,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58913,62982 |
50255 | TYR Santa Cruz Jade Top | N50255_S.jpg | N50255_XL.jpg | 76.99 | 25.00 | 1 | 0 | 0 | 0 | 160299 | 29 | 0 | -7 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 29 | .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,62982 |
40549 | TYR Swimple Goggles | N40549_S.jpg | N40549_XL.jpg | 15.99 | 12.99 | 1 | 0 | 0 | 0 | 98681 | 29 | 2 | -6 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 24 | 8.33 | | | | 2 | | 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,62984 |
51658 | TYR Happy Whale Swim Cap | N51658_S.jpg | N51658_XL.jpg | 12.49 | 5.00 | 1 | 0 | 0 | 0 | 169569 | 29 | 0 | -6 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 3 | .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,62984 |
28376 | TYR Youth Qualifier | N28376_S.jpg | N28376_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 41156 | 29 | 0 | -6 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 2 | .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,62984 |
50244 | TYR Square Leg W/Zip Pocket | N50244_S.jpg | N50244_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 160231 | 29 | 0 | -5 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 23 | .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,62982 |
28362 | TYR Youth Qualifier | N28362_S.jpg | N28362_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 36558 | 29 | 0 | -5 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 2 | .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,62984 |
50300 | TYR Durafast Solid Racer | N0_SM.jpg | N50300_XL.jpg | 31.99 | 19.99 | 1 | 0 | 0 | 0 | 160603 | 29 | 0 | -4 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 17 | .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,62982,62984 |
50272 | TYR Cover Sun Suit | N50272_S.jpg | N50272_XL.jpg | 43.99 | 20.00 | 1 | 0 | 0 | 0 | 160417 | 29 | 0 | -4 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 14 | .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,62982 |
43323 | TYR Santa Rosa Bikini Bottom | N43323_S.jpg | N43323_XL.jpg | 35.99 | 10.00 | 1 | 0 | 0 | 0 | 115272 | 29 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 12 | .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,45397,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58913,62982 |
50289 | TYR Girls Duramax 1PC Maxfit | N50289_S.jpg | N50289_XL.jpg | 49.99 | 20.00 | 1 | 0 | 0 | 0 | 160530 | 29 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 12 | .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,62982 |
50251 | TYR Carnivale Lula Bottom | N50251_S.jpg | N50251_XL.jpg | 47.99 | 15.00 | 1 | 0 | 0 | 0 | 160275 | 29 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 11 | .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,62982 |
50288 | TYR Girls Duramax 1PC Maxfit | N50288_S.jpg | N50288_XL.jpg | 49.99 | 20.00 | 1 | 0 | 0 | 0 | 160523 | 29 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 14 | .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,62982 |
38454 | TYR Splice Racer | N38454_S.jpg | N38454_XL.jpg | 28.99 | 10.00 | 1 | 0 | 0 | 0 | 45957 | 29 | 0 | -1 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 16 | .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,62982 |
45447 | TYR Youth Qualifier | N45447_S.jpg | N45447_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 128995 | 29 | 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,62984 |