In which table / field are the prices of products registered in Magento 1.9 stored?
I have seen in some sites the catalog_product_entity_decimal table, but I have not seen the price or any other field that looks like a value in R $.
UPDATING: This is actually the table with prices. The problem is that I need to use a cast for the value to appear correctly, but on this subject, I'm zero! Can someone give a light?
Magento uses a data structure called an EAV, entity attribute value, or entity attribute value.
That is, you have an entity, which has an attribute that has a value.
For you to find the price attribute, you have to look at the attributes in the eav_attribute table, the special_price attribute has a id that will connect it with catalog_product_entity_decimal through attribute_id where the value is stored. / p>
EAV allows you to shape any type of data dynamically useful for ecommerces.
