Where is the table that contains the "Special Price" in Magento?

Question

I am trying to update "Special_price" and "price" in bulk with mySQL and php script, I know a table and a row containing "price", but not the one that contains "special_price".

I look, although the database itself is still out of luck. Any ideas? I need a table name and a field name.

Answer 1

My Magento Membership Question Guild Answers require me to suggest that you work on fixing API errors instead of using plain old SQL to update your database. As mentioned elsewhere, updating the database directly can lead Magento to a state not recognized by the system, which can lead to strange errors that are infuriating.

However, the special price value will be saved with other product attribute values ​​in

catalog_product_entity_decimal 

Table. This table has an attribute_id column, which has a foreign key relationship with the eav_attribute table. Look in the eav_attribute table for the attribute with special_price code. For this attribute_id and product entity_id should be enough to find the correct line in catalog_product_entity_decimal .

Keep in mind that no row will exist if the product does not have the special_price set. Also keep in mind that if a product has special_price installed at different visibility levels, there may be more than one line.

Answer 2

Special price is an attribute of the decimal type. First you need to get the attribute identifier by applying this sql query: SELECT attribute_id FROM eav_attribute WHERE attribute_code='special_price';

You can then add a special price for any product by inserting an entry into the catalog_product_entity_decimal table.

Answer 3

Here's how to remove the special price from the list of SKUs imported through the csv file in temp_import_sp_price_delete .

 delete deci from catalog_product_entity_decimal deci, `catalog_product_entity` pr, temp_import_sp_price_delete temp where temp.SKU= pr.SKU and pr.entity_id=deci.entity_id and deci.attribute_id=76