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 |
64299 | Buff Sahara Cap | N64299-S.jpg | N64299_XL.jpg | 44.99 | .00 | 0 | 0 | 0 | 0 | 265513 | 15 | 0 | -28 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 7 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 131295.933.30.00 S24 | 0 | Buff-Sahara-Cap-p64299 | .0 | 0 | Unisex Tiho Light Grey | 0 | 0 | red | On Sale | 0 | 113,362,370,398,608,726,44765,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,62115,62117,62827,62982,62984,63088,63669,63677,66503,66504,66506,66507,66508 |
64302 | Buff Speed Cap | N64302-S.jpg | N64302_XL.jpg | 44.99 | .00 | 0 | 0 | 0 | 0 | 265526 | 15 | 0 | -25 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 5 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 133547.000.30.00 S24 | 0 | Buff-Speed-Cap-p64302 | .0 | 0 | Unisex Solid White | 0 | 0 | red | On Sale | 0 | 113,362,370,398,608,726,44765,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,62827,62982,62984,63087,63088,66503,66504,66506,66507,66508 |
62089 | Buff Speed Cap | | N62089_XL.jpg | 44.99 | 25.00 | 1 | 0 | 0 | 0 | 245325 | 15 | 0 | -12 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 9 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 131389.538 S23 | 0 | Buff-Speed-Cap-p62089 | .0 | 0 | Unisex Deri Pink | 1 | 0 | text_Warehouse | | 0 | 113,362,370,398,608,725,726,44765,45674,45675,46668,47935,50195,50722,55489,56498,58368,58369,58370,58371,62115,62117,62982,62984,63657,66503,66504,66506,66507,66508 |
64295 | Buff Go Visor | N64295-S.jpg | N64295_XL.jpg | 38.99 | .00 | 0 | 0 | 0 | 0 | 265536 | 15 | 0 | -12 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 4 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 131391.525.20.00 S24 | 0 | Buff-Go-Visor-p64295 | .0 | 0 | Unisex Shane Lilac | 0 | 0 | red | On Sale | 0 | 113,362,370,398,608,726,44765,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,62115,62117,62827,62982,62984,63082,63084,63670,63677,63685,66396,66465,66466,66503,66504,66506,66507,66508 |
62965 | Buff Tropical Original | | N62965_XL.jpg | 26.99 | .00 | 0 | 0 | 0 | 0 | 254120 | 15 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 3 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 131503555.555 F23 | 0 | Buff-Tropical-Original-p62965 | .0 | 0 | Unisex Go Flamingo | 0 | 0 | red | On Sale | 0 | 113,362,370,608,726,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,62115,62117,62827,62982,62984,63657,66503,66504,66506,66507,66508 |
64291 | Buff Coolnet UV Half | N64291-S.jpg | N64291_XL.jpg | 24.99 | .00 | 0 | 0 | 0 | 0 | 265517 | 15 | 0 | -6 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Cold Weather | 1 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 133808.720.10.00 S24 | 0 | Buff-Coolnet-UV-Half-p64291 | .0 | 0 | Unisex Malc Azure | 0 | 0 | red | On Sale | 0 | 113,362,370,398,608,726,44765,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,62115,62117,62827,62982,62984,63082,63667,63668,66503,66504,66506,66507,66508 |
64296 | Buff Go Visor | N64296-S.jpg | N64296_XL.jpg | 38.99 | .00 | 0 | 0 | 0 | 0 | 265537 | 15 | 1 | -2 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 1 | 100.00 | | | | 1 | | 0 | | | 0 | 0 | 1 | 0 | 133546.909.20.00 S24 | 0 | Buff-Go-Visor-p64296 | .0 | 0 | Unisex Ellbe Steel | 0 | 0 | red | On Sale | 0 | 113,362,370,398,608,726,44765,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,62115,62117,62827,62982,62984,63082,63669,63677,66503,66504,66506,66507,66508 |
57112 | Buff Coolnet Ellipse Headband | | N57112_XL.jpg | 26.99 | .00 | 0 | 0 | 0 | 0 | 205716 | 15 | 0 | -1 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 8 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 122724.999 S25 | 0 | Buff-Coolnet-Ellipse-Headband-p57112 | .0 | 0 | Unisex Solid Black | 0 | 0 | red | On Sale | 0 | 113,362,370,398,608,725,726,44765,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,62115,62117,62827,62982,62984,63657,66503,66504,66506,66507,66508 |
62957 | Buff Merino Lighweight Solid | | N62957_XL.jpg | 39.99 | .00 | 0 | 0 | 0 | 0 | 254112 | 15 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 113010.653 F24 | 0 | Buff-Merino-Lighweight-Solid-p62957 | .0 | 0 | Unisex Garnet | 0 | 0 | red | On Sale | 0 | 113,362,370,399,608,726,44764,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,62827,62898,62982,62984,66503,66504,66506,66507,66508 |
62964 | Buff Thermonet | | N62964_XL.jpg | 34.99 | .00 | 0 | 0 | 0 | 0 | 254119 | 15 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 130274555.555 F24 | 0 | Buff-Thermonet-p62964 | .0 | 0 | Unisex Suga | 0 | 0 | red | On Sale | 0 | 113,362,370,399,608,726,44764,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,60175,62115,62117,62827,62898,62982,62984,63657,66503,66504,66506,66507,66508 |
64292 | Buff Coolnet UV Half | N64292-S.jpg | N64292_XL.jpg | 26.99 | .00 | 0 | 0 | 0 | 0 | 265518 | 15 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 131577.555.10.00 S24 | 0 | Buff-Coolnet-UV-Half-p64292 | .0 | 0 | Unisex Kashu Multi | 0 | 0 | red | On Sale | 0 | 113,362,370,398,608,726,44765,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,62115,62117,62827,62982,62984,63084,63678,63679,66503,66504,66506,66507,66508 |
64301 | Buff Speed Cap | N64301-S.jpg | N64301_XL.jpg | 44.99 | .00 | 0 | 0 | 0 | 0 | 265523 | 15 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 133547.904.30.00 S24 | 0 | Buff-Speed-Cap-p64301 | .0 | 0 | Unisex Solid Mist | 0 | 0 | red | On Sale | 0 | 113,362,370,398,608,726,44765,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,62115,62117,62827,62982,62984,63669,63677,63682,66503,66504,66506,66507,66508 |
64303 | Buff 5 Panel Go Cap | N64303-S.jpg | N64303_XL.jpg | 41.99 | .00 | 0 | 0 | 0 | 0 | 265529 | 15 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 0 | .00 | | | | 0 | | 0 | | | 0 | 0 | 1 | 0 | 133550.787.20.00 S24 | 0 | Buff-5-Panel-Go-Cap-p64303 | .0 | 0 | Unisex Watsea Navy | 0 | 0 | red | On Sale | 0 | 113,362,370,398,608,726,44765,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,58368,58369,58370,58371,62115,62117,62827,62982,62984,63088,63667,63668,63677,66503,66504,66506,66507,66508 |
65365 | Buff Thermonet | N65365-S.jpg | N65365_XL.jpg | 34.99 | .00 | 0 | 0 | 0 | 0 | 274815 | 15 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Warm Weather | 0 | .00 | | | | | | 0 | | | 0 | 0 | 1 | 0 | 134526.555 F24 | 0 | Buff-Thermonet-p65365 | .0 | 0 | Unisex Rycal Multi | 0 | 0 | red | On Sale | 0 | 113,362,370,399,608,726,44764,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,62827,62982,62984,63668,63669,66503,66504,66506,66507,66508 |
65368 | Buff Merino Midweight Melang | N65368-S.jpg | N65368_XL.jpg | 44.99 | .00 | 0 | 0 | 0 | 0 | 274800 | 15 | 0 | 0 | user1 | | user2 | | DeptName | Clothing - Hats/Head | SubDeptName | Cold Weather | 0 | .00 | | | | | | 0 | | | 0 | 0 | 1 | 0 | 113022.759 F24 | 0 | Buff-Merino-Midweight-Melang-p65368 | .0 | 0 | Unisex Tempest | 0 | 0 | red | On Sale | 0 | 113,362,370,399,608,726,44764,45674,45675,46668,47935,50195,55489,56498,58263,58264,58265,58266,58267,62827,62982,62984,63667,66503,66504,66506,66507,66508 |