Magento Product Attribute Get Value

Question

How to get specific product attribute value if i know product ID without loading whole product

User · Answer

If you have an text textarea attribute named my attr you can get it by  product- gt getMyAttr

User · Answer

You could write a method that would do it directly via sql I suppose   Would look something like this   Variables    store id   1   product id   1234   attribute code    manufacturer     Query   SELECT value FROM eav attribute option value WHERE option id IN       SELECT option id FROM eav attribute option WHERE FIND IN SET          option id            SELECT value FROM catalog product entity varchar WHERE             entity id     product id  AND              attribute id    SELECT attribute id FROM eav attribute WHERE                 attribute code   attribute code                    gt  0  AND     store id   store id     You would have to get the value from the correct table based on the attribute s backend type  field in eav attribute  though so it takes at least 1 additional query

User · Answer

you can use      lt  php echo  product- gt getAttributeText  attr id      gt

User · Answer

Try this     attribute     product- gt getResource  - gt getAttribute  custom attribute code        if   attribute                echo  attribute value    attribute - gt getFrontend  - gt getValue   product

User · Answer

You can get attribute value by following way   model   Mage  getResourceModel  catalog product     attribute value    model- gt getAttributeRawValue  productId   attribute code    storeId

User · Answer

It seems impossible to get value without loading product model  If you take a look at file app code core Mage Eav Model Entity Attribute Frontend Abstract php you ll see the method  public function getValue Varien Object  object         value    object- gt getData  this- gt getAttribute  - gt getAttributeCode         if  in array  this- gt getConfigField  input    array  select   boolean                valueOption    this- gt getOption  value           if    valueOption                 opt   new Mage Eav Model Entity Attribute Source Boolean                if   options    opt- gt getAllOptions                      foreach   options as  option                        if   option  value       value                             valueOption    option  label                                                                             value    valueOption            elseif   this- gt getConfigField  input     multiselect              value    this- gt getOption  value           if  is array  value                  value   implode        value                       return  value      As you can see this method requires loaded object to get data from it  3rd line

User · Answer

x000D   x000D   orderId   1     YOUR ORDER ID x000D   items    block- gt getOrderItems  orderId   x000D    x000D  foreach   items as  item    x000D       options    item- gt getProductOptions            x000D      if  isset  options  options     amp  amp   empty  options  options               x000D          foreach   options  options   as  option    x000D              echo  Title       option  label       lt br   gt    x000D              echo  ID       option  option id       lt br   gt    x000D              echo  Type       option  option type       lt br   gt    x000D              echo  Value       option  option value       lt br   gt       lt br   gt    x000D            x000D        x000D    x000D   x000D   x000D    all things you will use to retrieve value product custom option cart order in Magento 2  https   www mageplaza com how-get-value-product-custom-option-cart-order-magento-2 html

User · Answer

First we must ensure that the desired attribute is loaded  and then output it  Use this    product   Mage  getModel  catalog product  - gt load   lt product id gt    array   lt attribute code gt       attributeValue    product- gt getResource  - gt getAttribute   lt attribute code gt   - gt getFrontend  - gt getValue  product

User · Answer

Mage  getResourceModel  catalog product  - gt getAttributeRawValue  productId   attribute code    storeId

User · Answer

You don t have to load the whole product  Magentos collections are very powerful and smart    collection   Mage  getModel  catalog product  - gt getCollection     collection- gt addAttributeToFilter  entity id    product- gt getId      collection- gt addAttributeToSelect  manufacturer     product    collection- gt getFirstItem     manufacturer    product- gt getAttributeText  manufacturer      At the moment you call getFirstItem   the query will be executed and the result product is very minimal    status    gt  1  entity id    gt  38901  type id    gt  configurable  attribute set id    gt  9  manufacturer    gt  492  manufacturer value    gt  JETTE  is salable    gt  1  stock item  Varien Object     gt  Array                is in stock    gt  1

User · Answer

A way that I know of    product- gt getResource  - gt getAttribute  attribute code          - gt getFrontend  - gt getValue  product

User · Answer

Please see Daniel Kocherga s answer  as it ll work for you in most cases   In addition to that method to get the attribute s value  you may sometimes want to get the label of a select or multiselect  In that case  I have created this method which I store in a helper class           param int  entityId     param int string array  attribute atrribute s ids or codes     param null int Mage Core Model Store  store        return bool null string     throws Mage Core Exception     public function getAttributeRawLabel  entityId   attribute   store null        if    store             store   Mage  app  - gt getStore                value    string Mage  getResourceModel  catalog product  - gt getAttributeRawValue  entityId   attribute   store       if   empty  value             return Mage  getModel  catalog product  - gt getResource  - gt getAttribute  attribute - gt getSource  - gt getOptionText  value              return null

User · Answer

This one works-  echo   product- gt getData  ATTRIBUTE NAME HERE

[magento] Magento Product Attribute Get Value

Examples related to magento

Examples related to attributes

Examples related to product