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 | ProductPath | rating | IsSponsored | Specifications | isWarehouse | isCurrentModel | groups |
40834 | TYR Silicone Happy Fish Cap | N40834_S.jpg | N40834_XL.jpg | 12.99 | 5.00 | 1 | 0 | 0 | 0 | 100108 | 36 | 0 | -42 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 5 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSHFISH 420 F16 | 0 | TYR-Silicone-Happy-Fish-Cap-p40834 | .0 | 0 | Blue | 1 | 0 | 52,362,379,633,725,45674,46646,46668,50195,50722,50802,50804,53221 |
48238 | Tyr Competitor Tri Tank | N0_SM.jpg | N48238_XL.jpg | 89.99 | 25.00 | 1 | 0 | 0 | 0 | 146246 | 36 | 0 | -32 | user1 | | user2 | | DeptName | Clothing - Triathlon | SubDeptName | Tri Tops | 35 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | TCOM6A.009 S17 O | 0 | Tyr-Competitor-Tri-Tank-p48238 | .0 | 0 | Men's Black/Lime | 1 | 0 | 113,126,348,633,725,728,44818,44820,45039,45398,45674,46668,50722,50804 |
50278 | TYR Zola Hipkini | N50278_S.jpg | N50278_XL.jpg | 47.99 | 20.00 | 1 | 0 | 0 | 0 | 160452 | 36 | 0 | -30 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 25 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BBSO7A.001 S18 | 0 | TYR-Zola-Hipkini-p50278 | .0 | 0 | Women's Black | 1 | 0 | 52,113,129,633,725,727,44556,45395,45396,45397,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498 |
40842 | TYR UNL Glide Clip Headstrap | N40842_S.jpg | N40842_XL.jpg | 6.99 | 3.00 | 1 | 0 | 0 | 0 | 100122 | 36 | 1 | -18 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 10 | 10.00 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | LGCS S16 | 0 | TYR-UNL-Glide-Clip-Headstrap-p40842 | .0 | 0 | Black | 1 | 0 | 52,362,379,420,633,725,45674,46646,46668,50195,50722,50804 |
50255 | TYR Santa Cruz Jade Top | N50255_S.jpg | N50255_XL.jpg | 76.99 | 25.00 | 1 | 0 | 0 | 0 | 160299 | 36 | 1 | -18 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 39 | 2.56 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | BJASC7A.523 S18 | 0 | TYR-Santa-Cruz-Jade-Top-p50255 | .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 |
38567 | TYR Alliance Splice Jammer | N38567_S.jpg | N38567_XL.jpg | 49.99 | 20.00 | 1 | 0 | 0 | 0 | 67217 | 36 | 0 | -15 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 47 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | SDAL7MA 034 | 7 | TYR-Alliance-Splice-Jammer-p38567 | .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 |
51661 | TYR Monster Cap | N51661_S.jpg | N51661_XL.jpg | 13.99 | 5.00 | 1 | 0 | 0 | 0 | 169705 | 36 | 0 | -12 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 6 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSMNSTR.310 S19 N | 0 | TYR-Monster-Cap-p51661 | .0 | 0 | Kids Green | 1 | 0 | 52,362,379,633,725,729,46668,50195,50722,50802,50804,53221 |
51658 | TYR Happy Whale Swim Cap | N51658_S.jpg | N51658_XL.jpg | 12.49 | 5.00 | 1 | 0 | 0 | 0 | 169569 | 36 | 0 | -12 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSHWHAL.060 S19 N | 0 | TYR-Happy-Whale-Swim-Cap-p51658 | .0 | 0 | Kids Black/White | 1 | 0 | 52,362,379,633,725,46668,50195,50722,50802,50804,53221 |
43323 | TYR Santa Rosa Bikini Bottom | N43323_S.jpg | N43323_XL.jpg | 35.99 | 10.00 | 1 | 0 | 0 | 0 | 115272 | 36 | 2 | -11 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 34 | 5.88 | | | | 2 | | 0 | | | 0 | 0 | 1 | 0 | BCSR7FA 413 F15 | 0 | TYR-Santa-Rosa-Bikini-Bottom-p43323 | .0 | 0 | Women's Navy/Coral | 1 | 0 | 52,113,129,633,725,727,45395,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58912 |
43185 | TYR Santa Rosa Bikini Bottom | N43185_S.jpg | N43185_XL.jpg | 35.99 | 10.00 | 1 | 0 | 0 | 0 | 114621 | 36 | 0 | -11 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 29 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BCSR7FA 004 F15 | 0 | TYR-Santa-Rosa-Bikini-Bottom-p43185 | .0 | 0 | Women's Black/Multi | 1 | 0 | 52,113,129,633,725,727,45396,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498,58912 |
42616 | TYR Lycra Swim Cap | N0_SM.jpg | N42616_XL.jpg | 9.99 | 5.00 | 1 | 0 | 0 | 0 | 110978 | 36 | 1 | -10 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 23 | 4.35 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | LNSI 001 S18 | 0 | TYR-Lycra-Swim-Cap-p42616 | .0 | 0 | Black | 1 | 0 | 362,379,633,725,44556,45037,45674,46668,50722,50802,50804 |
50279 | TYR Lula Classic Bikini Bottom | N50279_S.jpg | N50279_XL.jpg | 43.99 | 15.00 | 1 | 0 | 0 | 0 | 160458 | 36 | 1 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 20 | 5.00 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | BSO7A.001 S18 | 0 | TYR-Lula-Classic-Bikini-Bottom-p50279 | .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 |
50287 | TYR Girls Sunray Diamondfit | N50287_S.jpg | N50287_XL.jpg | 41.99 | 20.00 | 1 | 0 | 0 | 0 | 160517 | 36 | 0 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 18 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | DSURY7Y.461 S18 | 0 | TYR-Girls-Sunray-Diamondfit-p50287 | .0 | 0 | Youth Blue/Multi | 1 | 0 | 52,113,129,633,725,729,45674,45675,46668,47313,47767,50195,50722,50794,50804,56140,56498 |
51651 | TYR Lula Bikini Bottom | N51651_S.jpg | N51651_XL.jpg | 47.99 | 15.00 | 1 | 0 | 0 | 0 | 169522 | 36 | 0 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 18 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BLCA7A.418 S19 | 0 | TYR-Lula-Bikini-Bottom-p51651 | .0 | 0 | Women's Navy/Multi | 1 | 0 | 52,113,129,633,725,727,45396,45674,45675,46668,47313,50195,50722,50793,50804,50841,56140,56498 |
50261 | TYR Arvada Riva Classic Bottom | N50261_S.jpg | N50261_XL.jpg | 47.99 | 15.00 | 1 | 0 | 0 | 0 | 160333 | 36 | 0 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 13 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BRIAR7A.001 S18 | 0 | TYR-Arvada-Riva-Classic-Bottom-p50261 | .0 | 0 | Women's Black/Print | 1 | 0 | 52,113,129,633,725,727,44556,45397,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498 |
40958 | TYR Lycra Youth Swim Cap | N40958_S.jpg | N40958_XL.jpg | 5.99 | 3.00 | 1 | 0 | 0 | 0 | 100711 | 36 | 0 | -8 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 12 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCYY 001 F16 | 0 | TYR-Lycra-Youth-Swim-Cap-p40958 | .0 | 0 | Black | 1 | 0 | 52,362,379,633,725,45674,46646,46668,50195,50722,50802,50804,53221 |
50288 | TYR Girls Duramax 1PC Maxfit | N50288_S.jpg | N50288_XL.jpg | 49.99 | 20.00 | 1 | 0 | 0 | 0 | 160523 | 36 | 0 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 9 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T322.537 S18 | 0 | TYR-Girls-Duramax-1PC-Maxfit-p50288 | .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 |
50256 | TYR Santa Cruz Blake Bottom | N50256_S.jpg | N50256_XL.jpg | 47.99 | 20.00 | 1 | 0 | 0 | 0 | 160304 | 36 | 1 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 11 | 9.09 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | BLSC7A.523 S18 | 0 | TYR-Santa-Cruz-Blake-Bottom-p50256 | .0 | 0 | Women's Navy/Purple | 1 | 0 | 52,113,129,633,725,727,45397,45674,45675,46668,47313,47767,50195,50722,50793,50804,50841,56140,56498 |
29702 | TYR Burner EBP Fin | N29702_S.jpg | N29702_XL.jpg | 51.99 | 24.00 | 1 | 0 | 0 | 0 | 48197 | 36 | 1 | -6 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 34 | 2.94 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | LFBP S18 | 4 | TYR-Burner-EBP-Fin-p29702 | .0 | 0 | Unisex | 1 | 0 | 52,362,379,633,725,726,727,728,45674,45922,46646,46668,50195,50722,50798,50804,52973 |
38454 | TYR Splice Racer | N38454_S.jpg | N38454_XL.jpg | 28.99 | 10.00 | 1 | 0 | 0 | 0 | 45957 | 36 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 16 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | RDAS 034 S11 | 5 | TYR-Splice-Racer-p38454 | .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 |
50289 | TYR Girls Duramax 1PC Maxfit | N50289_S.jpg | N50289_XL.jpg | 49.99 | 20.00 | 1 | 0 | 0 | 0 | 160530 | 36 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 11 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T322.134 S18 | 0 | TYR-Girls-Duramax-1PC-Maxfit-p50289 | .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 |
50290 | TYR Girls Tankini Yoke Front | N50290_S.jpg | N50290_XL.jpg | 47.99 | 20.00 | 1 | 0 | 0 | 0 | 160537 | 36 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 7 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T316.416 S18 | 0 | TYR-Girls-Tankini-Yoke-Front-p50290 | .0 | 0 | Youth Navy/Turquoise | 1 | 0 | 52,113,129,633,725,45674,45675,46668,47313,47767,50195,50722,50795,50804,56140,56498 |
50272 | TYR Cover Sun Suit | N50272_S.jpg | N50272_XL.jpg | 43.99 | 20.00 | 1 | 0 | 0 | 0 | 160417 | 36 | 0 | -5 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 5 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | CSSK7.420 S19 | 0 | TYR-Cover-Sun-Suit-p50272 | .0 | 0 | Kid's Blue | 1 | 0 | 52,113,129,633,725,729,44402,45674,45675,45922,46668,47313,47767,50195,50722,50794,50804,56140,56498 |
50234 | TYR Mantra Skylar Top | N50234_S.jpg | N50234_XL.jpg | 57.99 | 25.00 | 1 | 0 | 0 | 0 | 160156 | 36 | 0 | -4 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 21 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BSKMA7A.019 S19 | 0 | TYR-Mantra-Skylar-Top-p50234 | .0 | 0 | Women's Grey | 1 | 0 | 113,126,633,725,727,44266,45221,45396,45674,45675,46668,47313,47767,50195,50722,50804,55883,56498 |
50292 | TYR Boys Challenger Boardshort | N50292_S.jpg | N50292_XL.jpg | 37.99 | 15.00 | 1 | 0 | 0 | 0 | 160551 | 36 | 0 | -4 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 8 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | TCHA5Y.060 S18 | 0 | TYR-Boys-Challenger-Boardshort-p50292 | .0 | 0 | Youth Black/White | 1 | 0 | 52,113,129,362,379,633,725,729,44372,45674,45675,46369,46668,47313,47767,50195,50722,50804,56140,56498 |
50251 | TYR Carnivale Lula Bottom | N50251_S.jpg | N50251_XL.jpg | 47.99 | 15.00 | 1 | 0 | 0 | 0 | 160275 | 36 | 1 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 13 | 7.69 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | BLCA7A.004 S18 | 0 | TYR-Carnivale-Lula-Bottom-p50251 | .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 |
50291 | TYR Girls Tankini Yoke Front | N50291_S.jpg | N50291_XL.jpg | 47.99 | 20.00 | 1 | 0 | 0 | 0 | 160544 | 36 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T316.137 S18 | 0 | TYR-Girls-Tankini-Yoke-Front-p50291 | .0 | 0 | Youth Black/Funny Pink | 1 | 0 | 52,113,129,633,725,45674,45675,46668,47313,47767,50195,50722,50795,50804,56140,56498 |
50294 | TYR Boys Challenger Boardshort | N50294_S.jpg | N50294_XL.jpg | 37.99 | 15.00 | 1 | 0 | 0 | 0 | 160561 | 36 | 1 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 5 | 20.00 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | TCHA5Y.641 S18 | 0 | TYR-Boys-Challenger-Boardshort-p50294 | .0 | 0 | Youth Red/White | 1 | 0 | 52,113,129,633,725,729,45674,45675,46668,47313,47767,50195,50722,50793,50804,50842,56140,56498 |
51662 | TYR Monster Cap | N51662_S.jpg | N51662_XL.jpg | 13.99 | 5.00 | 1 | 0 | 0 | 0 | 169706 | 36 | 1 | -2 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 6 | 16.67 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | LCSMNSTR.510 S19 N | 0 | TYR-Monster-Cap-p51662 | .0 | 0 | Kids Purple | 1 | 0 | 52,362,379,633,725,729,46668,50195,50722,50802,50804,53221 |
40959 | TYR Lycra Youth Swim Cap | N40959_S.jpg | N40959_XL.jpg | 5.99 | 3.00 | 1 | 0 | 0 | 0 | 100712 | 36 | 0 | -2 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 7 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCYY 428 F16 | 0 | TYR-Lycra-Youth-Swim-Cap-p40959 | .0 | 0 | Royal | 1 | 0 | 52,362,379,633,725,45674,46646,46668,50195,50722,50802,50804,53221 |
52183 | TYR Kids Solid Maxfit | N52183_S.jpg | N52183_XL.jpg | 43.99 | 20.00 | 1 | 0 | 0 | 0 | 172447 | 36 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 6 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T344.046 S19 | 0 | TYR-Kids-Solid-Maxfit-p52183 | .0 | 0 | Girls Black/Wonderland | 1 | 0 | 52,113,129,633,725,45674,45675,46668,47313,50195,50722,50794,50804,56140,56498 |
51688 | TYR Tutti Fruitti Diamondfit | N51688_S.jpg | N51688_XL.jpg | 41.99 | 20.00 | 1 | 0 | 0 | 0 | 169774 | 36 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | DTFK7.440 S19 | 0 | TYR-Tutti-Fruitti-Diamondfit-p51688 | .0 | 0 | Kid's Turquoise | 1 | 0 | 52,113,129,633,725,45674,45675,46668,47313,50195,50722,50794,50804,56140,56498 |
40832 | TYR Silicone Happy Fish Cap | N40832_S.jpg | N40832_XL.jpg | 12.99 | 5.00 | 1 | 0 | 0 | 0 | 100106 | 36 | 0 | -1 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSHFISH 810 F16 | 0 | TYR-Silicone-Happy-Fish-Cap-p40832 | .0 | 0 | Orange | 1 | 0 | 52,362,379,633,725,45674,46646,46668,50195,50722,50802,50804,53221 |
40961 | TYR Junior Silicone Ear Plugs | N40961_S.jpg | N40961_XL.jpg | 5.99 | 3.00 | 1 | 0 | 0 | 0 | 100714 | 36 | 0 | 0 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LEPY 970 S18 | 0 | TYR-Junior-Silicone-Ear-Plugs-p40961 | .0 | 0 | Multi-coloured | 1 | 0 | 52,362,379,633,725,45674,46646,46668,50195,50722,50801,50804,52617 |
50297 | TYR Boys Splice Square Leg | N50297_S.jpg | N50297_XL.jpg | 29.99 | 10.00 | 1 | 0 | 0 | 0 | 160582 | 36 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T901.027 S18 | 0 | TYR-Boys-Splice-Square-Leg-p50297 | .0 | 0 | Youth Black/Robot | 1 | 0 | 52,113,129,633,725,45674,45675,46668,47313,47767,50195,50722,50793,50804,50843,56140,56498 |
51659 | TYR Happy Whale Swim Cap | N51659_S.jpg | N51659_XL.jpg | 12.49 | 5.00 | 1 | 0 | 0 | 0 | 169570 | 36 | 0 | 0 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSHWHAL.510 S19 N | 0 | TYR-Happy-Whale-Swim-Cap-p51659 | .0 | 0 | Kids Purple | 1 | 0 | 52,362,379,633,725,46668,50195,50722,50802,50804,53221 |