Table/Field for product price in Magento

Asked

Viewed 702 times

3

In which table/field are stored the prices of products registered in Magento 1.9?

I saw on some sites the table catalog_product_entity_decimal, but I didn’t see the field price or any other value in R$.

UPDATING: This is really the price chart. The problem is that I need to use a conversion for the value to appear correctly, but on this subject, I’m zero! Someone can give a light?

php mysql magento

  • When I have problems of this kind, I put an absurd value (like R$ 939393,93) and do a search on Phpmyadmin.

  • Man! Simple and objective solution. Hahaha. I will do here and return!

  • Okay, I found the table. The problem is I can’t find a reference field at all to compile my report. Has anyone ever done anything like that? I need the images, SKU, Quantity and Value. Of all the fields, only the value is not hitting.

  • Update your question with new data, this way it will end up on the main page and receive new views

  • Thanks @brasofilo. I’m still kind of new around here...

1 answer

2

Magento uses a data structure called EAV, Entity attribute value or entity attribute value.

That is, you have an entity, which has an attribute that has a value.

To find the price attribute, you will have to look at the attributes in the table eav_attribute, the attribute special_price has a id that will connect you with catalog_product_entity_decimal through the attribute_id where the value is stored.

The EAV allows shaping any type of data dynamically is useful for ecommerces.

Browser other questions tagged php mysql magento

You are not signed in. Login or sign up in order to post.