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 | IsFeaturedDeal | salePriceClass | salePriceText | isCurrentModel | groups |
49242 | Aquasphere Marly Jammer | | N49242_XL.jpg | 24.99 | 5.00 | 1 | 0 | 0 | 0 | 153407 | 32 | 0 | -208 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 15 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | SJ1040404 CF17 | 0 | Aquasphere-Marly-Jammer-p49242 | .0 | 0 | Youth Navy Blue | 1 | 0 | text_Warehouse | | 0 | 52,113,129,688,725,729,45674,45675,46668,47313,47767,50195,50722,50784,50793,50804,50840,56140,56498,58913,62982,63657,66505 |
50540 | Arena Solid Short Jr | | N50540_XL.jpg | 44.99 | 10.00 | 1 | 0 | 0 | 0 | 161982 | 32 | 0 | -24 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 16 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A259.075 S19 | 0 | Arena-Solid-Short-Jr-p50540 | .0 | 0 | Kids Navy/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50793,50804,50843,56140,56498,58913,62982,66505 |
50170 | Arena Girls Tag JR One Piece | | N50170_XL.jpg | 59.99 | 10.00 | 1 | 0 | 0 | 0 | 159858 | 32 | 0 | -20 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 6 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A704-40 C18 | 0 | Arena-Girls-Tag-JR-One-Piece-p50170 | .0 | 0 | Youth Red/Multi | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50794,50804,56140,56498,58913,62982,63657,66505 |
50194 | Arena Boys Sarring Youth | | N50194_XL.jpg | 39.99 | 10.00 | 1 | 0 | 0 | 0 | 159960 | 32 | 0 | -16 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 6 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 21103-75 C18 | 0 | Arena-Boys-Sarring-Youth-p50194 | .0 | 0 | Youth Navy/Silver/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
50123 | Arena Youth Gauge Short | | N50123_XL.jpg | 45.99 | 10.00 | 1 | 0 | 0 | 0 | 159733 | 32 | 0 | -14 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 10 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 44796-40 C18 | 0 | Arena-Youth-Gauge-Short-p50123 | .0 | 0 | Kid's Red | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,44487,45674,45675,45701,46668,47313,47767,50195,50722,50793,50804,50842,56140,56498,58913,62982,63657,66505 |
50539 | Arena Solid Short Jr | | N50539_XL.jpg | 44.99 | 10.00 | 1 | 0 | 0 | 0 | 161977 | 32 | 0 | -9 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 6 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A259.055 S19 | 0 | Arena-Solid-Short-Jr-p50539 | .0 | 0 | Kids Black/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50793,50804,50843,56140,56498,58913,62982,66505 |
50197 | Arena Boys BIPBIP JR Brief | | N50197_XL.jpg | 34.99 | 5.00 | 1 | 0 | 0 | 0 | 159972 | 32 | 0 | -8 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 5 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A006-86 C18 | 0 | Arena-Boys-BIPBIP-JR-Brief-p50197 | .0 | 0 | Youth Deep Sea/Green | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50804,56140,56498,58913,62982,63657,66505 |
50554 | Arena Water Jr V Back One | | N50554_XL.jpg | 64.99 | 20.00 | 1 | 0 | 0 | 0 | 162063 | 32 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 13 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 001296.770 F18 | 0 | Arena-Water-Jr-V-Back-One-p50554 | .0 | 0 | Kid's Royal/Navy | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50794,50804,56140,56498,58913,62982,66505 |
50545 | Arena Solid Swim Pro Jr | | N50545_XL.jpg | 64.99 | 20.00 | 1 | 0 | 0 | 0 | 162008 | 32 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 8 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A611.075 S19 | 0 | Arena-Solid-Swim-Pro-Jr-p50545 | .0 | 0 | Kid's Navy/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50794,50804,56140,56498,58913,62982,66505 |
50272 | TYR Cover Sun Suit | | N50272_XL.jpg | 43.99 | 10.00 | 1 | 0 | 0 | 0 | 160417 | 32 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 7 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | CSSK7.420 S19 | 0 | TYR-Cover-Sun-Suit-p50272 | .0 | 0 | Kid's Blue | 1 | 0 | text_Warehouse | | 0 | 52,113,129,633,725,729,44402,45674,45675,45922,46668,47313,47767,50195,50722,50794,50804,56140,56498,58913,62982,63657,66505 |
50158 | Arena Boys Dynamo JR Brief | | N50158_XL.jpg | 27.99 | 10.00 | 1 | 0 | 0 | 0 | 159808 | 32 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A470-75 C18 | 0 | Arena-Boys-Dynamo-JR-Brief-p50158 | .0 | 0 | Youth Navy | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
51375 | Arena Clouds JR Top | | N51375_XL.jpg | 44.99 | 8.00 | 1 | 0 | 0 | 0 | 168008 | 32 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 1 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 000458-906 C18 | 0 | Arena-Clouds-JR-Top-p51375 | .0 | 0 | Kids Paparazzi/Leaf | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50795,50804,56140,56498,58913,62982,66505 |
50193 | Arena Boys Sarring Youth | | N50193_XL.jpg | 39.99 | 10.00 | 1 | 0 | 0 | 0 | 159956 | 32 | 0 | -4 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 8 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 21103-55 C18 | 0 | Arena-Boys-Sarring-Youth-p50193 | .0 | 0 | Youth Black/Silver/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
50165 | Arena Girls Polycarbonite II | | N50165_XL.jpg | 69.99 | 8.00 | 1 | 0 | 0 | 0 | 159837 | 32 | 0 | -4 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 7 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A540-55 C18 | 0 | Arena-Girls-Polycarbonite-II-p50165 | .0 | 0 | Youth Black/Grey | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,44574,45674,45675,45701,46668,47313,47767,50195,50722,50784,50794,50804,56140,56498,58913,62982,63657,66505 |
50542 | Arena Solid Short Jr | | N50542_XL.jpg | 44.99 | 10.00 | 1 | 0 | 0 | 0 | 161992 | 32 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A259.072 S19 | 0 | Arena-Solid-Short-Jr-p50542 | .0 | 0 | Kids Royal/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50793,50804,50843,56140,56498,58913,62982,66505 |
50204 | Arena Boys Beck JR Brief | | N50204_XL.jpg | 34.99 | 10.00 | 1 | 0 | 0 | 0 | 160000 | 32 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A396-76 C18 | 0 | Arena-Boys-Beck-JR-Brief-p50204 | .0 | 0 | Youth Navy/Soft Green | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
50157 | Arena Boys Barn JR Brief | | N50157_XL.jpg | 33.99 | 10.00 | 1 | 0 | 0 | 0 | 159804 | 32 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 1 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A451-78 C18 | 0 | Arena-Boys-Barn-JR-Brief-p50157 | .0 | 0 | Youth Navy/Turquoise | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
50159 | Arena Boys Dynamo JR Brief | | N50159_XL.jpg | 27.99 | 10.00 | 1 | 0 | 0 | 0 | 159812 | 32 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 1 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A470-50 C18 | 0 | Arena-Boys-Dynamo-JR-Brief-p50159 | .0 | 0 | Youth Black | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,44555,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
50205 | Arena Boys Beck JR Brief | | N50205_XL.jpg | 34.99 | 10.00 | 1 | 0 | 0 | 0 | 160004 | 32 | 0 | -3 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 1 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A396-85 C18 | 0 | Arena-Boys-Beck-JR-Brief-p50205 | .0 | 0 | Youth Turquoise/Red | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
50553 | Arena Water Jr V Back One | | N50553_XL.jpg | 64.99 | 20.00 | 1 | 0 | 0 | 0 | 162058 | 32 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 5 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 001296.506 F18 | 0 | Arena-Water-Jr-V-Back-One-p50553 | .0 | 0 | Kid's Black/Soft Green | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50794,50804,56140,56498,58913,62982,66505 |
50156 | Arena Boys Barn JR Brief | | N50156_XL.jpg | 33.99 | 10.00 | 1 | 0 | 0 | 0 | 159800 | 32 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A451-53 C18 | 0 | Arena-Boys-Barn-JR-Brief-p50156 | .0 | 0 | Youth Black/Mango | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
52362 | Garneau Jr Comp 2 Sleeveless | | N52362_XL.jpg | 49.99 | 10.00 | 1 | 0 | 0 | 0 | 173431 | 32 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Cycling | SubDeptName | Jerseys | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 1020879.288 S19 | 0 | Garneau-Jr-Comp-2-Sleeveless-p52362 | .0 | 0 | Kid's Purple/Black | 1 | 0 | text_Warehouse | | 0 | 113,126,348,725,729,44818,44820,45674,45675,46033,46668,47313,50195,50657,50722,50784,53169,55883,56060,56498,57435,58913,62982,63657,66505 |
50203 | Arena Boys Beck JR Brief | | N50203_XL.jpg | 34.99 | 10.00 | 1 | 0 | 0 | 0 | 159996 | 32 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A396-65 C18 | 0 | Arena-Boys-Beck-JR-Brief-p50203 | .0 | 0 | Youth Red/Mango | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
50546 | Arena Solid Swim Pro Jr | | N50546_XL.jpg | 64.99 | 20.00 | 1 | 0 | 0 | 0 | 162013 | 32 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 2 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A263.045 S19 | 0 | Arena-Solid-Swim-Pro-Jr-p50546 | .0 | 0 | Kid's Red/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50794,50804,56140,56498,58913,62982,66505 |
51510 | Arena Fantasy Jr Tankini | | N51510_XL.jpg | 49.99 | 15.00 | 1 | 0 | 0 | 0 | 168537 | 32 | 0 | -2 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 1 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 001808.509 S19 | 0 | Arena-Fantasy-Jr-Tankini-p51510 | .0 | 0 | Kid's Black Shiny Pink | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50795,50804,56140,56498,58913,62982,66505 |
50579 | Arena Solid Swim Pro Jr | | N50579_XL.jpg | 59.99 | 20.00 | 1 | 0 | 0 | 0 | 162276 | 32 | 0 | -1 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A611.72 F18 | 0 | Arena-Solid-Swim-Pro-Jr-p50579 | .0 | 0 | Kid's Royal/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50794,50804,56140,56498,58913,62982,66505 |
48029 | Arena Girls Neon Jr One Piece | | N48029_XL.jpg | 69.99 | 15.00 | 1 | 0 | 0 | 0 | 145005 | 32 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 000097.508 C18 | 0 | Arena-Girls-Neon-Jr-One-Piece-p48029 | .0 | 0 | Youth Black/Turquoise | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,44527,45674,45675,45701,46668,47313,47767,50195,50722,50784,50794,50804,56140,56498,58913,62982,63657,66505 |
50166 | Arena Boys Dynamo JR Short | | N50166_XL.jpg | 34.99 | 10.00 | 1 | 0 | 0 | 0 | 159841 | 32 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A471-75 C18 | 0 | Arena-Boys-Dynamo-JR-Short-p50166 | .0 | 0 | Youth Navy | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50843,56140,56498,58913,62982,63657,66505 |
50192 | Arena Boys Barring Youth | | N50192_XL.jpg | 49.99 | 5.00 | 1 | 0 | 0 | 0 | 159952 | 32 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 21102-75 C18 | 0 | Arena-Boys-Barring-Youth-p50192 | .0 | 0 | Youth Navy/Silver/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50804,50840,50843,56140,56498,58913,62982,63657,66505 |
50196 | Arena Boys BIPBIP JR Brief | | N50196_XL.jpg | 34.99 | 10.00 | 1 | 0 | 0 | 0 | 159968 | 32 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A006-78 C18 | 0 | Arena-Boys-BIPBIP-JR-Brief-p50196 | .0 | 0 | Youth Navy/Turquoise | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,47767,50195,50722,50784,50793,50804,50841,56140,56498,58913,62982,63657,66505 |
50541 | Arena Solid Short Jr | | N50541_XL.jpg | 44.99 | 20.00 | 1 | 0 | 0 | 0 | 161987 | 32 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Swimwear | SubDeptName | | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 2A259.042 F18 | 0 | Arena-Solid-Short-Jr-p50541 | .0 | 0 | Kids Red/White | 1 | 0 | text_Warehouse | | 0 | 52,113,129,725,729,45674,45675,45701,46668,47313,50195,50722,50793,50804,50843,56140,56498,58913,62982,66505 |
52363 | Garneau Jr Comp 2 Sleeveless | | N52363_XL.jpg | 49.99 | 10.00 | 1 | 0 | 0 | 0 | 173437 | 32 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Cycling | SubDeptName | Jerseys | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 1020879.115 S19 | 0 | Garneau-Jr-Comp-2-Sleeveless-p52363 | .0 | 0 | Kid's Blue/Black | 1 | 0 | text_Warehouse | | 0 | 113,126,348,725,729,44402,44818,44820,45674,45675,46033,46668,47313,50195,50657,50722,50784,53169,55883,56060,56498,57435,58913,62982,63657,66505 |