Welcome to Leto Wholesale, your go-to source for wholesale beanies, hats, bandanas, and headbands. As a large volume distributor, we're all about passing on factory direct costs to you, the retailer. This means you can offer our high-quality products to your customers at prices that let you maintain attractive profit margins. So why wait? Dive into our range and give your retail business the boost it deserves today.
Wholesale Beanies, Hats, Bandanas & Headbands
Factory Direct Prices for Retailers
Welcome to Leto Wholesale, your go-to source for wholesale beanies, hats, bandanas, and headbands. As a large volume distributor, we're all about passing on factory direct costs to you, the retailer. This means you can offer our high-quality products to your customers at prices that let you maintain attractive profit margins. So why wait? Dive into our range and give your retail business the boost it deserves today.
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents`, `product_attributes`.`sku_policy` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (9801, 9694, 9691, 8344, 9679, 9620, 9606, 9602, 9597, 9592, 8112, 9527)) ORDER BY FIELD(e.entity_id,9801,9694,9691,8344,9679,9620,9606,9602,9597,9592,8112,9527)
Order Column: FIELD(e.entity_id,9801,9694,9691,8344,9679,9620,9606,9602,9597,9592,8112,9527)
Order Direction:
order by: "position" D: "asc"options: "{\"productListToolbarForm\":{\"mode\":\"product_list_mode\",\"direction\":\"product_list_dir\",\"order\":\"product_list_order\",\"limit\":\"product_list_limit\",\"modeDefault\":\"grid\",\"directionDefault\":\"asc\",\"orderDefault\":\"position\",\"limitDefault\":12,\"url\":\"https:\\\/\\\/letowholesale.com\\\/wholesale-beanies-hats-bandanas-headbands.html?mode=grid\",\"formKey\":\"qtM5BjaQZkz55yWQ\",\"post\":false}}" D: "asc"options: {"type":"Magento\\Catalog\\Block\\Product\\ProductList\\Toolbar\\Interceptor","_current_grid_order":"position","_current_grid_mode":"grid","_current_limit":12,"_current_grid_direction":"asc"} D: "asc"