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 |
29669 | TYR Square Leg W/Zip Pocket | N29669_S.jpg | N29669_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 45948 | 172 | 1 | -154 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 11 | 9.09 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | BZPD 001 F17 | 0 | Men's Black | .0 | 0 | Men's Black |
38733 | TYR Catalyst 2 Training Paddle | N38733_S.jpg | N38733_XL.jpg | 23.99 | .00 | 0 | 0 | 0 | 0 | 87620 | 172 | 0 | -154 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 7 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LVC2 S18 | 6 | Training Hand Paddles | .0 | 0 | Training Hand Paddles |
50300 | TYR Durafast Solid Racer | N0_SM.jpg | N0_XL.jpg | 31.99 | 24.99 | 1 | 0 | 0 | 0 | 160603 | 172 | 1 | -72 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 9 | 11.11 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | RDUR7.001 F18 | 0 | Men's Black | .0 | 0 | Men's Black |
50294 | TYR Boys Challenger Boardshort | N50294_S.jpg | N50294_XL.jpg | 37.99 | 19.00 | 1 | 0 | 0 | 0 | 160561 | 172 | 0 | -66 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 11 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | TCHA5Y.641 S18 | 0 | Youth Red/White | .0 | 0 | Youth Red/White |
40893 | TYR Alliance Splice Square Leg | N40893_S.jpg | N40893_XL.jpg | 41.99 | 29.99 | 1 | 0 | 0 | 0 | 100347 | 172 | 1 | -56 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 7 | 14.29 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | BDAL7 116 F17 | 0 | Men's Black/Robot | .0 | 0 | Men's Black/Robot |
50288 | TYR Girls Duramax 1PC Maxfit | N50288_S.jpg | N50288_XL.jpg | 49.99 | 39.99 | 1 | 0 | 0 | 0 | 160523 | 172 | 0 | -40 | 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 |
40834 | TYR Silicone Happy Fish Cap | N40834_S.jpg | N40834_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 100108 | 172 | 0 | -39 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSHFISH 420 F16 | 0 | Blue | .0 | 0 | Blue |
50292 | TYR Boys Challenger Boardshort | N50292_S.jpg | N50292_XL.jpg | 37.99 | 19.00 | 1 | 0 | 0 | 0 | 160551 | 172 | 0 | -36 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 9 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | TCHA5Y.060 S18 | 0 | Youth Black/White | .0 | 0 | Youth Black/White |
41224 | TYR Alliance Splice Racer | N41224_S.jpg | N41224_XL.jpg | 33.99 | 19.99 | 1 | 0 | 0 | 0 | 101906 | 172 | 1 | -35 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 7 | 14.29 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | RDAL7 116 F17 | 0 | Men's Black/Robot | .0 | 0 | Men's Black/Robot |
50291 | TYR Girls Tankini Yoke Front | N50291_S.jpg | N50291_XL.jpg | 47.99 | 34.99 | 1 | 0 | 0 | 0 | 160544 | 172 | 0 | -30 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 5 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T316.137 S18 | 0 | Youth Black/Funny Pink | .0 | 0 | Youth Black/Funny Pink |
51688 | TYR Tutti Fruitti Diamondfit | N51688_S.jpg | N51688_XL.jpg | 41.99 | .00 | 0 | 0 | 0 | 0 | 169774 | 172 | 0 | -25 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 5 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | DTFK7.440 S19 | 0 | Kid's Turquoise | .0 | 0 | Kid's Turquoise |
50293 | TYR Boys Challenger Boardshort | N50293_S.jpg | N50293_XL.jpg | 37.99 | 19.00 | 1 | 0 | 0 | 0 | 160556 | 172 | 0 | -20 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 10 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | TCHA5Y.408 S18 | 0 | Youth NavyWhite | .0 | 0 | Youth NavyWhite |
50299 | TYR Boys Splice Square Leg | N50299_S.jpg | N50299_XL.jpg | 29.99 | 14.00 | 1 | 0 | 0 | 0 | 160596 | 172 | 0 | -20 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 10 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T901.063 S18 | 0 | Youth Black/Fuoco/Grey | .0 | 0 | Youth Black/Fuoco/Grey |
28362 | TYR Youth Qualifier | N28362_S.jpg | N28362_XL.jpg | 12.99 | .00 | 0 | 0 | 0 | 0 | 36558 | 172 | 1 | -18 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 2 | 50.00 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | LGQUAL 101 F16 | 0 | Kids Goggles Clear | .0 | 0 | Kids Goggles Clear |
50266 | TYR Alliance Splice Maxfit | N50266_S.jpg | N50266_XL.jpg | 81.99 | 49.99 | 1 | 0 | 0 | 0 | 160365 | 172 | 0 | -18 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 6 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | MDAL7.412 S18 | 0 | Women's Navy/Neon Cherry | .0 | 0 | Women's Navy/Neon Cherry |
43021 | TYR Alliance Splice Jammer | N43021_S.jpg | N43021_XL.jpg | 51.99 | 39.99 | 1 | 0 | 0 | 0 | 113675 | 172 | 0 | -18 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | SDAL7.116 S19 | 7 | Men's Black/Robot | .0 | 0 | Men's Black/Robot |
43323 | TYR Santa Rosa Bikini Bottom | N43323_S.jpg | N43323_XL.jpg | 35.99 | 15.00 | 1 | 0 | 0 | 0 | 115272 | 172 | 0 | -18 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BCSR7FA 413 F15 | 0 | Women's Navy/Coral | .0 | 0 | Women's Navy/Coral |
50129 | Tyr Alliance 45L Backpack | N50129_S.jpg | N50129_XL.jpg | 89.99 | 74.99 | 1 | 0 | 0 | 0 | 159767 | 172 | 0 | -16 | user1 | | user2 | | DeptName | Accessories - Packs/Bags | SubDeptName | | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LATBP45.022 S18 | 0 | Unisex Black/Black | .0 | 0 | Unisex Black/Black |
50272 | TYR Cover Sun Suit | N50272_S.jpg | N50272_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 160417 | 172 | 0 | -16 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | CSSK7.420 S19 | 0 | Kid's Blue | .0 | 0 | Kid's Blue |
52184 | TYR Kids Solid Maxfit | N52184_S.jpg | N52184_XL.jpg | 43.99 | .00 | 0 | 0 | 0 | 0 | 172453 | 172 | 0 | -16 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T344.592 S19 | 0 | Girls Indigo/Concordia | .0 | 0 | Girls Indigo/Concordia |
50134 | TYR Swimple Goggles | N50134_S.jpg | N50134_XL.jpg | 16.99 | .00 | 0 | 0 | 0 | 0 | 159779 | 172 | 0 | -16 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LGSW.479 S18 | 0 | Unisex Berry Fizz | .0 | 0 | Unisex Berry Fizz |
40538 | TYR Swim Shades Mirrored | N40538_S.jpg | N40538_XL.jpg | 24.99 | 10.00 | 1 | 0 | 0 | 0 | 98675 | 172 | 0 | -15 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Goggles | 5 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LGSHDM 810 S16 | 0 | Orange | .0 | 0 | Orange |
50257 | TYR Santa Cruz Della Boyshort | N50257_S.jpg | N50257_XL.jpg | 47.99 | 39.99 | 1 | 0 | 0 | 0 | 160310 | 172 | 0 | -15 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BOSC7A.523 S18 | 0 | Women's Navy/Purple | .0 | 0 | Women's Navy/Purple |
45207 | TYR Boca Chica Circuit Mesh | N45207_S.jpg | N45207_XL.jpg | 54.99 | 15.00 | 1 | 0 | 0 | 0 | 127296 | 172 | 0 | -14 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 14 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BMBC7.420 F16 | 0 | Women's Blue | .0 | 0 | Women's Blue |
50286 | TYR Girls Sunray Diamondfit | N50286_S.jpg | N50286_XL.jpg | 41.99 | 33.99 | 1 | 0 | 0 | 0 | 160511 | 172 | 0 | -13 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 13 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | DSURY7Y.231 S18 | 0 | Youth Pink/Multi | .0 | 0 | Youth Pink/Multi |
35882 | TYR Solid Jammer | N35882_S.jpg | N35882_XL.jpg | 43.99 | .00 | 0 | 0 | 0 | 0 | 56333 | 172 | 1 | -12 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 1 | 100.00 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | SDUR7 001 BK S19 | 7 | Men's Black | .0 | 0 | Men's Black |
45218 | TYR Boca Chica Capri | N45218_S.jpg | N45218_XL.jpg | 67.99 | 25.00 | 1 | 0 | 0 | 0 | 127362 | 172 | 0 | -12 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | TCABC7.832 F16 | 0 | Women's Coral | .0 | 0 | Women's Coral |
50255 | TYR Santa Cruz Jade Top | N50255_S.jpg | N50255_XL.jpg | 76.99 | 54.99 | 1 | 0 | 0 | 0 | 160299 | 172 | 0 | -12 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BJASC7A.523 S18 | 0 | Women's Navy/Purple | .0 | 0 | Women's Navy/Purple |
50261 | TYR Arvada Riva Classic Bottom | N50261_S.jpg | N50261_XL.jpg | 47.99 | 18.00 | 1 | 0 | 0 | 0 | 160333 | 172 | 0 | -12 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BRIAR7A.001 S18 | 0 | Women's Black/Print | .0 | 0 | Women's Black/Print |
32354 | TYR Alliance Splice Jammer | N32354_S.jpg | N32354_XL.jpg | 49.99 | 39.99 | 1 | 0 | 0 | 0 | 62004 | 172 | 0 | -12 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | SDAL7.002 S18 | 0 | Men's Black/Red | .0 | 0 | Men's Black/Red |
48215 | Tyr Alliance 30L Backpack | N48215_S.jpg | N48215_XL.jpg | 71.99 | 59.99 | 1 | 0 | 0 | 0 | 146263 | 172 | 0 | -12 | user1 | | user2 | | DeptName | Accessories - Packs/Bags | SubDeptName | | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LATBP30.487 S18 | 0 | Unisex Blue/Green | .0 | 0 | Unisex Blue/Green |
50253 | TYR Carnivale Della Boyshort | N50253_S.jpg | N50253_XL.jpg | 47.99 | 18.00 | 1 | 0 | 0 | 0 | 160287 | 172 | 0 | -12 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BOCA7A.004 S18 | 0 | Women's Black/Multi | .0 | 0 | Women's Black/Multi |
51661 | TYR Monster Cap | N51661_S.jpg | N51661_XL.jpg | 13.99 | .00 | 0 | 0 | 0 | 0 | 169705 | 172 | 0 | -12 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSMNSTR.310 S19 N | 0 | Kids Green | .0 | 0 | Kids Green |
50287 | TYR Girls Sunray Diamondfit | N50287_S.jpg | N50287_XL.jpg | 41.99 | 33.99 | 1 | 0 | 0 | 0 | 160517 | 172 | 0 | -11 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 11 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | DSURY7Y.461 S18 | 0 | Youth Blue/Multi | .0 | 0 | Youth Blue/Multi |
50240 | TYR La Reve Trinity Fit | N50240_S.jpg | N50240_XL.jpg | 83.99 | .00 | 0 | 0 | 0 | 0 | 160195 | 172 | 2 | -10 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 2 | 100.00 | | | | 2 | | 0 | | | 0 | 0 | 1 | 0 | TLARB7.232 S18 | 0 | Women's Pink/Turquoise | .0 | 0 | Women's Pink/Turquoise |
50758 | TYR Solid Maxfit W/Cups | N50758_S.jpg | N50758_XL.jpg | 65.99 | .00 | 0 | 0 | 0 | 0 | 163810 | 172 | 1 | -10 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 2 | 50.00 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | MDURC7.001 S19 | 0 | Women's Black | .0 | 0 | Women's Black |
50298 | TYR Boys Splice Square Leg | N50298_S.jpg | N50298_XL.jpg | 29.99 | 14.00 | 1 | 0 | 0 | 0 | 160589 | 172 | 0 | -10 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 5 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T901.464 S18 | 0 | Youth Navy/Royal | .0 | 0 | Youth Navy/Royal |
37794 | TYR Silicone Swim Caps | N37794_S.jpg | N37794_XL.jpg | 13.49 | .00 | 0 | 0 | 0 | 0 | 67215 | 172 | 0 | -10 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCSN 510 S18 | 0 | Wrinkle Free - Purple | .0 | 0 | Wrinkle Free - Purple |
40958 | TYR Lycra Youth Swim Cap | N40958_S.jpg | N40958_XL.jpg | 5.99 | .00 | 0 | 0 | 0 | 0 | 100711 | 172 | 0 | -10 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LCYY 001 F16 | 0 | Black | .0 | 0 | Black |
28649 | TYR Crossblade Fins | N28649_S.jpg | N28649_XL.jpg | 51.99 | .00 | 0 | 0 | 0 | 0 | 22133 | 172 | 1 | -9 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Accessories | 3 | 33.33 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | LFCROSS S19 | 7 | Unisex | .0 | 0 | Unisex |
50133 | TYR Nest Pro Nano Goggles | N50133_S.jpg | N50133_XL.jpg | 22.99 | .00 | 0 | 0 | 0 | 0 | 159778 | 172 | 1 | -9 | user1 | | user2 | | DeptName | Accessories - Swimming | SubDeptName | Goggles | 3 | 33.33 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | LGNSTN.041 S18 | 0 | Unisex Smoke | .0 | 0 | Unisex Smoke |
50273 | TYR Cover Sun Suit | N50273_S.jpg | N50273_XL.jpg | 43.99 | 29.99 | 1 | 0 | 0 | 0 | 160424 | 172 | 0 | -9 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 9 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | CSSK7.670 S18 | 0 | Kid's Pink | .0 | 0 | Kid's Pink |
43185 | TYR Santa Rosa Bikini Bottom | N43185_S.jpg | N43185_XL.jpg | 35.99 | 15.00 | 1 | 0 | 0 | 0 | 114621 | 172 | 0 | -9 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BCSR7FA 004 F15 | 0 | Women's Black/Multi | .0 | 0 | Women's Black/Multi |
48216 | Tyr Alliance 30L Backpack | N48216_S.jpg | N48216_XL.jpg | 71.99 | 59.99 | 1 | 0 | 0 | 0 | 146264 | 172 | 0 | -9 | user1 | | user2 | | DeptName | Accessories - Packs/Bags | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | LATBP30.404 S18 | 0 | Unisex Navy/Red | .0 | 0 | Unisex Navy/Red |
52183 | TYR Kids Solid Maxfit | N52183_S.jpg | N52183_XL.jpg | 43.99 | .00 | 0 | 0 | 0 | 0 | 172447 | 172 | 0 | -9 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | T344.046 S19 | 0 | Girls Black/Wonderland | .0 | 0 | Girls Black/Wonderland |
50244 | TYR Square Leg W/Zip Pocket | N50244_S.jpg | N50244_XL.jpg | 43.99 | .00 | 0 | 0 | 0 | 0 | 160231 | 172 | 0 | -9 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 1 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | BZPD7.471 S18 | 0 | Men's Navy/Harward | .0 | 0 | Men's Navy/Harward |
41032 | TYR Shark Bite Jammer | N41032_S.jpg | N41032_XL.jpg | 49.49 | 20.00 | 1 | 0 | 0 | 0 | 101098 | 172 | 1 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 8 | 12.50 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | SSB7.420 F14 | 0 | Men's Black/Blue | .0 | 0 | Men's Black/Blue |
50252 | TYR Carnivale 3/4 Kalani Tight | N50252_S.jpg | N50252_XL.jpg | 71.99 | 25.00 | 1 | 0 | 0 | 0 | 160281 | 172 | 0 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | TKTCA7A.004 S18 | 0 | Women's Black/Multi | .0 | 0 | Women's Black/Multi |