Prestashop

[UPDATE 2023] Use the default combination image, with a non-zero quantity, as the cover image in Prestashop

Update 2023 I was really hanging over a problem with a website. In fact, the products have a lot of combination (colors). Because it is related with fashion accessories. The thing is, some colors were simply not remade because of the complexity of certain material. So, a lot of products Lire la suite…

Par David Sprang, il y a 3 mois21 septembre 2023

Prestashop

Adapter la Taille des Images Transporteurs sur Prestashop Thème Warehouse

Dans themes/warehouse/assets/css/custom.css Rajouter :

.carrier-hasLogo img {
     max-width: 100%;
     max-height: 100%;
}

.carrier-hasLogo img {

max-width: 100%;

max-height: 100%;

}

Par David Sprang, il y a 1 an9 août 2022

Prestashop

Augmenter les Ventes E-commerce (Prestashop)

Désactiver la vérification du code postal J’ai pu remarquer que beaucoup de ventes était littéralement anéanties à cause de la vérification du code postal. En effet, en Corée du Sud et aux États-Unis, de nombreuses personnes avaient des problèmes à rentrer un code postal correct. Sans pouvoir rentrer correctement leur Lire la suite…

Par David Sprang, il y a 2 ans31 mars 2022

Prestashop

Prestashop – Argument 4 passed to PrestaShop\PrestaShop\Core\Domain\Order\QueryResult\OrderCustomerForViewing::__construct()

Argument 4 passed to PrestaShop\PrestaShop\Core\Domain\Order\QueryResult\OrderCustomerForViewing::__construct() must be of the type string, null given, called in /home/……/……/src/Adapter/Order/QueryHandler/GetOrderForViewingHandler.php on line 236

UPDATE ps_address SET phone = '' WHERE phone IS NULL;
UPDATE ps_address SET phone_mobile = '' WHERE phone_mobile IS NULL;

UPDATE ps_order_detail SET id_order_invoice = '0' WHERE id_order_invoice IS NULL;
UPDATE ps_order_detail SET product_reference = '' WHERE product_reference IS NULL;
UPDATE ps_order_detail SET product_supplier_reference = '' WHERE product_supplier_reference IS NULL;
UPDATE ps_order_detail SET product_isbn = '' WHERE product_isbn IS NULL;
UPDATE ps_order_detail SET product_upc = '' WHERE product_upc IS NULL;
UPDATE ps_order_detail SET product_mpn = '' WHERE product_mpn IS NULL;
UPDATE ps_order_detail SET download_hash = '' WHERE download_hash IS NULL;
UPDATE ps_orders SET gift_message = '' WHERE gift_message IS NULL;

UPDATE ps_order_payment SET transaction_id = '' WHERE transaction_id IS NULL;
UPDATE ps_order_payment SET card_number = '' WHERE card_number IS NULL;
UPDATE ps_order_payment SET card_brand = '' WHERE card_brand IS NULL;
UPDATE ps_order_payment SET card_expiration = '' WHERE card_expiration IS NULL;
UPDATE ps_order_payment SET card_holder = '' WHERE card_holder IS NULL;

UPDATE ps_order_carrier SET tracking_number = '' WHERE tracking_number IS NULL;
UPDATE ps_order_carrier SET id_order_invoice = '0' WHERE id_order_invoice IS NULL;
UPDATE ps_order_carrier SET weight = '0' WHERE weight IS NULL;

UPDATE ps_product SET isbn = '' WHERE isbn IS NULL;
UPDATE ps_product SET upc = '' WHERE upc IS NULL;
UPDATE ps_product SET mpn = '' WHERE mpn IS NULL;
UPDATE ps_product SET unity = '' WHERE unity IS NULL;
UPDATE ps_product SET supplier_reference = '' WHERE supplier_reference IS NULL;
UPDATE ps_product SET location = '' WHERE location IS NULL;
UPDATE ps_product SET redirect_type = '301-category' WHERE redirect_type = '';
UPDATE ps_product SET available_date = '2020-12-01' WHERE available_date IS NULL;
UPDATE ps_product SET cache_default_attribute = '0' WHERE cache_default_attribute IS NULL;
UPDATE ps_product_shop SET unity = '' WHERE unity IS NULL;
UPDATE ps_product_shop SET redirect_type = '301-product' WHERE redirect_type = '';
UPDATE ps_product_shop SET available_date = '2020-12-01' WHERE available_date IS NULL;
UPDATE ps_product_shop SET cache_default_attribute = '0' WHERE cache_default_attribute IS NULL;

update ps_address set dni = '' where dni is null;
update ps_address set other = '' where other is null;
update ps_address set address2 = '' where address2 is null;
update ps_address set company = '' where company is null;
update ps_address set vat_number = '' where vat_number is null;

UPDATE ps_address SET phone = '' WHERE phone IS NULL;

UPDATE ps_address SET phone_mobile = '' WHERE phone_mobile IS NULL;

UPDATE ps_order_detail SET id_order_invoice = '0' WHERE id_order_invoice IS NULL;

UPDATE ps_order_detail SET product_reference = '' WHERE product_reference IS NULL;

UPDATE ps_order_detail SET product_supplier_reference = '' WHERE product_supplier_reference IS NULL;

UPDATE ps_order_detail SET product_isbn = '' WHERE product_isbn IS NULL;

UPDATE ps_order_detail SET product_upc = '' WHERE product_upc IS NULL;

UPDATE ps_order_detail SET product_mpn = '' WHERE product_mpn IS NULL;

UPDATE ps_order_detail SET download_hash = '' WHERE download_hash IS NULL;

UPDATE ps_orders SET gift_message = '' WHERE gift_message IS NULL;

UPDATE ps_order_payment SET transaction_id = '' WHERE transaction_id IS NULL;

UPDATE ps_order_payment SET card_number = '' WHERE card_number IS NULL;

UPDATE ps_order_payment SET card_brand = '' WHERE card_brand IS NULL;

UPDATE ps_order_payment SET card_expiration = '' WHERE card_expiration IS NULL;

UPDATE ps_order_payment SET card_holder = '' WHERE card_holder IS NULL;

UPDATE ps_order_carrier SET tracking_number = '' WHERE tracking_number IS NULL;

UPDATE ps_order_carrier SET id_order_invoice = '0' WHERE id_order_invoice IS NULL;

UPDATE ps_order_carrier SET weight = '0' WHERE weight IS NULL;

UPDATE ps_product SET isbn = '' WHERE isbn IS NULL;

UPDATE ps_product SET upc = '' WHERE upc IS NULL;

UPDATE ps_product SET mpn = '' WHERE mpn IS NULL;

UPDATE ps_product SET unity = '' WHERE unity IS NULL;

UPDATE ps_product SET supplier_reference = '' WHERE supplier_reference IS NULL;

UPDATE ps_product SET location = '' WHERE location IS NULL;

UPDATE ps_product SET redirect_type = '301-category' WHERE redirect_type = '';

UPDATE ps_product SET available_date = '2020-12-01' WHERE available_date IS NULL;

UPDATE ps_product SET cache_default_attribute = '0' WHERE cache_default_attribute IS NULL;

UPDATE ps_product_shop SET unity = '' WHERE unity IS NULL;

UPDATE ps_product_shop SET redirect_type = '301-product' WHERE redirect_type = '';

UPDATE ps_product_shop SET available_date = '2020-12-01' WHERE available_date IS NULL;

UPDATE ps_product_shop SET cache_default_attribute = '0' WHERE cache_default_attribute IS NULL;

update ps_address set dni = '' where dni is null;

update ps_address set other = '' where other is null;

update ps_address set address2 = '' where address2 is null;

update ps_address set company = '' where company is null;

update ps_address set vat_number = '' where vat_number is null;

Source : https://github.com/PrestaShop/PrestaShop/issues/22215

Par David Sprang, il y a 2 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: /httpdocs/src/Adapter/Order/QueryHandler/GetOrderProductsForViewingHandler.php Search for 45 and replace with the desidered value (the value it’s the size of the thumbnail in pixel). After this modify probably you should delete all the images that start with « product_mini_ » Lire la suite…

Par David Sprang, il y a 2 ans

Prestashop

Display selected attribute color name on Prestashop for Warehouse theme

Source: https://mypresta.eu/prestashop-17/show-selected-color-attribute-name.html Modification of custom.css File is located in this directory: themes/warehouse/assets/css/custom.css (if you use different theme than « classic » theme – open your theme directory instead). At the end of this file paste code attached below:

.ColorLabel:after {
	display:inline-block;
	content: ': ' attr(data-after);
	margin-left:5px;
	font-weight:bold;
}

.ColorLabel:after {

display:inline-block;

content: ': ' attr(data-after);

margin-left:5px;

font-weight:bold;

}

Modification of custom.js File is located in this directory: themes/warehouse/assets/js/custom.js (the same as Lire la suite…

Par David Sprang, il y a 2 ans14 janvier 2022

Linux

[UPDATE 2023] How to Install and Compile ngx_pagespeed with Nginx with VestaCP/myVesta on Linux

First, I would like to thank Mysterydata for their article on this subject. The thing is they did provide a downloadable library ngx_pagespeed.so but this file is compiled for the Nginx 1.18.0 version. And now VestaCP provide another Nginx version and their library is not compatible anymore. Some of my Lire la suite…

Par David Sprang, il y a 3 ans13 juillet 2020

Livraison

Envoyer sa marchandise en 2021 avec MyFlyingBox et Delivengo

Bien ! Nous sommes le 04 Mars 2021. Des mises à jour pourront être effectuées au cours dans le futur. Mon dernier article sur ma méthode pour envoyer des colis à eu un certain succès donc j’ai décidé de remettre tout à plat. En effet, beaucoup de choses ont changés Lire la suite…

Par David Sprang, il y a 3 ans4 mars 2021

Prestashop

[Update 2021] Guide Ultime d’Installation d’une Boutique Prestashop 1.7 – Partie 4

Configuration du back-office *J’utilise le thème Warehouse Store disponible sur themeforest.net. Réglages de la bannière et de la favicon Apparence > Thème et logo > Logo de l’en-tête Apparence > Thème et logo > Logo des mails Apparence > Thème et logo > Favicon Supprimer les données inutiles

Toutes les boutiques sélectionnées

1	Toutes les boutiques sélectionnées

Catalogue Lire la suite…

Par David Sprang, il y a 3 ans1 juillet 2020

Prestashop

[Update 2021] Guide Ultime d’Installation d’une Boutique Prestashop 1.7 – Importation, Store Commander, Akeneo PIM, Importation entre deux PrestaShop – Partie 3

Import de vos données pour Prestashop avec Store Commander et Akeneo PIM Pour ma part, j’utilise Akeneo PIM pour m’aider à importer mes données dans mes sites internet. Je vais supposer que vous avez vos catégories, vos produits, vos déclinaisons, vos clients et vos adresses déjà prêts à importer dans Lire la suite…

Par David Sprang, il y a 3 ans25 juin 2020