To get all products that do not have custom options, simply run the following SQL query:
|
1 2 3 4 5 6 |
SELECT * FROM catalog_product_entity WHERE entity_id NOT IN (SELECT DISTINCT product_id FROM catalog_product_option); |
To get all products that do have custom options, remove the “NOT” from the above query.
Would you like to know if and where your Magento shop could be optimized? Do you want to make sure that you are tapping the last potential of your shop to get the best possible conversion? Do you want to…
There are several places in Magento where IPv6 addresses are not shown properly. The fix differs for each part of Magento that shows the wrong IPv6 address and so it can not be discussed here in detail. If you need…
Sometimes, when saving an invoice for an order, the following error might come up: Fatal error: Declaration of Zend_Pdf_FileParserDataSource_File::__construct() must be compatible with Zend_Pdf_FileParserDataSource::__construct() in /var/www/vhosts/website/httpdocs/includes/src/Zend_Pdf_FileParserDataSource_File.php on line 41 To solve that problem, open the lib/Zend/Pdf/FileParserDataSource.php class and change the…
To import Magento gallery images using MAGMI (Magento Mass Importer) the following steps are required: Add a new column to your import file. It must be called media_gallery. Now add all your gallery images to that column. The format is:…
There is no way to add a product image description using the addImageToMediaGallery function. The following code does the job though:
|
1 2 3 4 5 6 |
foreach($product->getData('media_gallery') as $each){ foreach($each as $image){ $attributes = $product->getTypeInstance(true)->getSetAttributes($product); $attributes['media_gallery']->getBackend()->updateImage($product, $image['file'], array('label' => 'whatever')); } } |
You want to increase the speed of your Magento store? One way to achieve that is to add Gzip compression. It can be added easily by modifying your servers .htaccess file. Add the following lines:
|
1 2 3 4 5 |
<IfModule mod_deflate.c> <FilesMatch ".(js|css|html|htm|php)$"> SetOutputFilter DEFLATE </FilesMatch> </IfModule> |
When done, check if…
If the user is not able to login after a Magento version update, you have most likely overwritten the login.phtml template in your local theme. To fix that problem, open \customer\form\login.phtml in your local theme and add the following code…
Using the following code, you can save a store config value. The first parameter is the path from the core_config_data table.
|
1 |
Mage::getModel('core/config')->saveConfig('my/path/whatever', $value); |
Run the following query:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
SELECT * FROM eav_attribute WHERE ( `attribute_id` LIKE '%stomlayoutupdate%' OR `entity_type_id` LIKE '%stomlayoutupdate%' OR `attribute_code` LIKE '%stomlayoutupdate%' OR `attribute_model` LIKE '%stomlayoutupdate%' OR `backend_model` LIKE '%stomlayoutupdate%' OR `backend_type` LIKE '%stomlayoutupdate%' OR `backend_table` LIKE '%stomlayoutupdate%' OR `frontend_model` LIKE '%stomlayoutupdate%' OR `frontend_input` LIKE '%stomlayoutupdate%' OR `frontend_label` LIKE '%stomlayoutupdate%' OR `frontend_class` LIKE '%stomlayoutupdate%' OR `source_model` LIKE '%stomlayoutupdate%' OR `is_required` LIKE '%stomlayoutupdate%' OR `is_user_defined` LIKE '%stomlayoutupdate%' OR `default_value` LIKE '%stomlayoutupdate%' OR `is_unique` LIKE '%stomlayoutupdate%' OR `note` LIKE '%stomlayoutupdate%' ); |
Remember the attribute_ids from that query and run the following query:
|
1 2 3 |
DELETE FROM eav_attribute WHERE attribute_id IN (attribute_ids from first query); |
Done!