février 2022 – Metrodyn

[UPDATE 2025] Prestashop 1.7 Bugs Resolver Guideline

Set the stock to 0 for all product combinations that do not have an image Safety step: preview affected rows with a SELECT

SELECT sa.id_product, sa.id_product_attribute
FROM ps_stock_available sa
JOIN ps_product_attribute pa
      ON pa.id_product_attribute = sa.id_product_attribute
LEFT JOIN ps_product_attribute_image pai
      ON pai.id_product_attribute = pa.id_product_attribute
WHERE pai.id_image IS NULL
  AND sa.id_product_attribute <> 0;

SELECT sa.id_product, sa.id_product_attribute

FROM ps_stock_available sa

JOIN ps_product_attribute pa

ON pa.id_product_attribute = sa.id_product_attribute

LEFT JOIN ps_product_attribute_image pai

ON pai.id_product_attribute = pa.id_product_attribute

WHERE pai.id_image IS NULL

AND sa.id_product_attribute <> 0;

Correct UPDATE query: set stock to 0 for combinations without an image

UPDATE ps_stock_available sa
JOIN ps_product_attribute pa
      ON pa.id_product_attribute = sa.id_product_attribute
LEFT JOIN ps_product_attribute_image pai
      ON pai.id_product_attribute = pa.id_product_attribute
SET sa.quantity = 0,
    sa.out_of_stock = 0
WHERE pai.id_image IS NULL
  AND sa.id_product_attribute <> 0;

UPDATE ps_stock_available sa

JOIN ps_product_attribute pa

ON pa.id_product_attribute = sa.id_product_attribute

LEFT JOIN ps_product_attribute_image pai

ON pai.id_product_attribute = pa.id_product_attribute

SET sa.quantity = 0,

sa.out_of_stock = 0

WHERE pai.id_image IS NULL

AND sa.id_product_attribute <> 0;

How to Find PrestaShop Color Attributes Without Swatches (and See Which Products Use Lire la suite

Par David, il y a 4 ans9 février 2022

Prestashop

Prestashop – Bigger Products Images on Order

I case someone it’s interested to do this on PS1.7.7… you have to look at file: /src/Adapter/Order/QueryHandler/GetOrderProductsForViewingHandler.php Search for ImageManager::thumbnail and replace with the desidered value (the value it’s the size of the thumbnail in pixel). This should be these two lines: $product[‘image_tag’] = ImageManager::thumbnail(_PS_IMG_DIR_ . ‘p/’ . $product[‘image’]->getExistingImgPath() . Lire la suite

Par David, il y a 4 ans7 février 2022