CREP PROTECT

The days of your fresh shoes and trainers being ruined, and consequently ruining your style, are long gone, with this revolutionary product which is guaranteed to change your feet forever. We’ve all gone out with the intention ‘dress to impress’. However, it will always be inevitable that you return home looking more ‘unimpressive’ after an eventful night of spilling more drinks than you actually drink! Saving the world from the frightful thought of your box fresh shoes being stained, comes ‘Crep Protect’; a product specifically designed with a unique blend of ingredients. Whether your shoes are leather, suede, nubuck or canvas, Crep Protect will repel liquids, preventing any stains spoiling your footwear, with an invisible coat. This is the future of the footwear industry.

Loading...
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` 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')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (NULL)) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402')
We can't find products matching the selection.