As a leading US-based wholesale distributor, Leto Wholesale offers a wide range of high-quality ruanas, ponchos, shawls, and wraps. Perfect for resellers and online retailers looking to expand their offerings. Shop our collection today.
Wholesale Ruanas, Ponchos, Shawls, and Wraps
Quality Wholesale Distributor of Shawls and More
As a leading US-based wholesale distributor, Leto Wholesale offers a wide range of high-quality ruanas, ponchos, shawls, and wraps. Perfect for resellers and online retailers looking to expand their offerings. Shop 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 (9318, 9281, 9300, 3493, 8871, 8852, 9790, 9789, 9788, 9687, 9656, 9648)) ORDER BY FIELD(e.entity_id,9318,9281,9300,3493,8871,8852,9790,9789,9788,9687,9656,9648)
Order Column: FIELD(e.entity_id,9318,9281,9300,3493,8871,8852,9790,9789,9788,9687,9656,9648)
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\\\/ruanas-ponchos-shawls-wraps-wholesale.html\",\"formKey\":\"v5tg3WVpAXmkhno9\",\"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"