At Leto Wholesale, we offer a diverse range of wholesale scarves to suit every style. Whether your customers love the coziness of blanket and chunky scarves, the endless style of infinity scarves, or the classic appeal of plaid designs, we have it all. We also offer solid, knit, and oblong scarves for those looking for something a little different. As a leading USA-based distributor, we provide high-quality, affordable scarves in bulk for resellers. Explore our collection today.
Wholesale Scarves for Every Style
From Blanket to Infinity - Discover Our Range
At Leto Wholesale, we offer a diverse range of wholesale scarves to suit every style. Whether your customers love the coziness of blanket and chunky scarves, the endless style of infinity scarves, or the classic appeal of plaid designs, we have it all. We also offer solid, knit, and oblong scarves for those looking for something a little different. As a leading USA-based distributor, we provide high-quality, affordable scarves in bulk for resellers. Explore our collection 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 (9808, 9568, 9435, 9426, 9421, 9416, 9350, 9311, 8959, 8391, 8208, 3682)) ORDER BY FIELD(e.entity_id,9808,9568,9435,9426,9421,9416,9350,9311,8959,8391,8208,3682)
Order Column: FIELD(e.entity_id,9808,9568,9435,9426,9421,9416,9350,9311,8959,8391,8208,3682)
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\\\/scarves-wholesale-supplier.html?dir=desc&order=position\",\"formKey\":\"x5luIED3PDE55yfU\",\"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"