David , auteur sur Metrodyn

Louer sa Maison ou son Appartement le Plus Efficacement Possible

Airbnb, Booking, Abritel … Toutes ces plateformes ne cherchent qu’une seule chose, satisfaire le client à n’importe quel prix. Et même si cela doit leur coûter la confiance des locataires et des propriétaires, ils n’en ont que faire, le vivier est tellement grand, que la perte de votre maison ou Lire la suite…

Par David, il y a 2 ans17 août 2022

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, il y a 2 ans9 août 2022

Prestashop

Mettre à jour automatiquement les taux de change des monnaies sur Pretashop

Télécharger le module medlivexchangeurl Dans la liste des modules, rechercher le module « Get the url to update the exchange rates » Récupérer l’URL dans le module Sachant que l’éditeur de tâches cron ne fonctionne plus depuis fin 2021, il faut maintenant rajouter les tâches automatiques directement dans le crontab par SSH. Lire la suite…

Par David, il y a 2 ans24 juin 2022

Non classé

Installer un Certificat SSL GoDaddy avec myVesta Panel

Générer un certificat CSR avec VestaCP sur le nom de domaine Sauvegarder ce contenu (le certificat et la clé privée) Copier le certificat SSL CSR dans l’interface de GoDaddy et régénérer un certificat Une fois que le certificat est prêt, télécharger le. Il contient un fichier name.crt et un fichier Lire la suite…

Par David, il y a 3 ans20 juin 2022

Livraison

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, il y a 3 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, il y a 3 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 3 ans7 février 2022

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, il y a 3 ans14 janvier 2022

Linux

Subversion (SVN) sur Ubuntu 20.04

Subversion est un logiciel de gestion de versions, distribué sous licence Apache. Installation de Subversion On crée l’utilisateur svn

sudo useradd -m -d /home/svn -U -r -s /bin/bash svn

1	sudo useradd -m -d /home/svn -U -r -s /bin/bash svn

On installe subversion

sudo apt install subversion

1	sudo apt install subversion

Faire son premier dépôt Tout d’abord, créez un dépôt (nous considérerons le répertoire user1). On se connecte à l’utilisateur svn

sudo su - svn

1	sudo su - svn

Et on crée le dépôt

cd /home/svn &amp;&amp;
svnadmin create /home/svn/user1

1 2	cd /home/svn && svnadmin create /home/svn/user1

Et on Lire la suite…

Par David, il y a 4 ans16 mai 2021

Odoo

Installation d’Odoo 14 sur Ubuntu 20.04

Je décide finalement d’abandonner mon cher Odoo 8 pour enfin tester la version 14. J’espère découvrir une application à la hauteur de ce que fut Odoo 8 ! Après cinq ans d’utilisation, je peux dire que l’outil m’a grandement aidé dans la gestion de mes entreprises et de celles des Lire la suite…

Par David, il y a 4 ans13 mai 2021