Introduction While creating a configurable product, you need to create an attribute(s) which will be used as a select option(s) for the customer(For Example Color, Size, etc.). These kinda attributes are called super attributes or configurable attributes. In this article, we will be discussing how to get different info about super attributes using raw SQL. …
Introduction: Magento database is based on EAV(Entity Attribute Value) architecture. And it uses this architecture, especially for categories, products, customers & customer addresses. Before Magento version 1.4.x it used EAV structure for orders as well but thereafter order’s EAV structure has been converted to a flat structure. From the definition of EAV: Entity(E): Entity actually …
Introduction Product Qty can be updated via default import profile though but this is very slow and requires lots of CSV fields(besides SKU & qty) for updating. Today I am going to talk about updating product qty just by using CSV with two fields: SKU & qty(new) which is very fast enough even for thousands …
Introduction Product prices can be updated via default import profile though but this is very slow and requires lots of CSV fields(besides sku & price) for updating. Today I am going to talk about updating product prices just by using CSV with two fields: sku & price(new) which is very fast enough even for thousands …
Following SQL Queries are helpful in determining the InnoDB status of MYSQL: 1> SHOW VARIABLES LIKE ‘%have_innodb%’; Result: 2> SHOW ENGINES; Result: You can use these queries in case of Magento too in order to determine the InnoDB status. Cheers!!