SELECT e.sku, cpev.value as productName, COUNT(m.value) as cnt FROM catalog_product_entity e inner join catalog_product_entity_varchar cpev on e.entity_id = cpev.entity_id and cpev.attribute_id=73 LEFT JOIN catalog_product_entity_media_gallery_value_to_entity r ON e.entity_id = r.entity_id LEFT JOIN catalog_product_entity_media_gallery m ON r.value_id = m.value_id GROUP BY e.entity_id HAVING cnt = 0 cpev.attribute_id=73 is name attribute id.
Run composer with specific php version in Plesk
/opt/plesk/php/7.1/bin/php /usr/lib/plesk-9.0/composer.phar install –dry-run –profile –verbose
Install Magento Module and Recompile
rm -rf var/di/ var/generation/ var/cache/ var/log/ var/page_cache/ var/session/ var/view_preprocessed/ pub/static/ php bin/magento setup:upgrade php bin/magento setup:di:compile php bin/magento setup:static-content:deploy -f php bin/magento cache:clean php bin/magento cache:flush php bin/magento indexer:reindex chmod -R 777 generated chmod -R 777 var chmod -R 777 var/log chmod -R 777 var/cache chmod -R 777 pub If you get memory limit […]
Install Magento 2 Exteion using SSH Termal
Hi guys, In this tutorial I’ll show you how to install a Magento 2 extension using the SSH terminal. Before installation (Prerequisite) Before we begin the installation, you must first download the Magento 2 extension you want to install and then move those folders from the archive to your Magento 2 root directory. Once you’ve […]
Error in Magneto Information Changes have been made to this section that have not been saved. This tab contains invalid data. Please resolve this before saving.
This error occur , when you create magento order using api and you don’t provide your shipping method and shipping address. So provide your shipping method and shipping address or disable the following module Temando_Shipping Following command use to disable module from ssh. bin/magento module:disable Amazon_Core Amazon_Login Amazon_Payment Dotdigitalgroup_Email Klarna_Core Klarna_Ordermanagement Klarna_Kp Shopial_Facebook Temando_Shipping Vertex_Tax
Get list of Category & Category Product from Magento using Mysql Query
If you want to get magento category list using mysql. Use following query to get Categories List SELECT DISTINCT cc.entity_id as category_id, cc.value as name, cc1.value as url_path ,cce.parent_id as parent_id ,0 as top,level as `column`,position as sort_order,1 as status,created_at as date_added,updated_at as date_modified FROM catalog_category_entity_varchar cc JOIN catalog_category_entity_varchar cc1 ON cc.entity_id=cc1.entity_id JOIN catalog_category_entity_int cc_int […]
Change Order No in Magento 2.0
Open your PHP Admin database (I tested on php 7) Find & click on the table called: sequence_order_1 (it is located in database itself not in the information_schema ) Run this SQL Query ALTER TABLE sequence_order_1 AUTO_INCREMENT = (your new value);