Questions tagged [eav]

Questions about Magento's Entity Attribute Value (EAV) implementation

83 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
25
votes
0answers
973 views

Magento Profiling - Why so many EAV: Magento\Eav\Model\Config::getAttribute?

I'm just reviewing the speed of a store and just wondering if anyone knows more about why I have over 100 EAV: Magento\Eav\Model\Config::getAttribute 0.006978 rows within my profiler. It's just I do ...
7
votes
1answer
598 views

Magento Too many tables error bulk updating products

This morning while selecting and enabling some one hundred products in magento i got this mysql too many table error Below is the snippet from the log file a:5:{i:0;s:92:"SQLSTATE[HY000]: General ...
4
votes
0answers
39 views

magento 2: create custom frontend input type

I need a custom frontend input type which I would call "table": The issue at hand is that I have a customer that has a lot of different attribute sets with even more attributes. And he is in a ...
4
votes
0answers
159 views

How to use modifier in product_action_attribute Form?

I have created an eav attribute and modified the field inside edit product form, that was easy. But in products mass action (Update attributes) page, the field I have created, by eav Attribute and ...
4
votes
1answer
2k views

How to get custom attributes from customer via SOAP API?

I have a few custom attributes to extend the customer with bank account information. The attributes are stored in mage_eav_attribute table. How can I get them via the SOAP API?
3
votes
0answers
43 views

EAV Model Product - Loading too heavy

Our website's using Magento 2 platform. Number of product and number of product's attributes keep growing faster.It leads to heavy loading when getting product's information(using EAV Model).In ...
3
votes
0answers
343 views

What is the distinction between defining a customer attribute as “system” versus not “user defined”?

General Context When adding custom attributes to EAV-storage data types such as customers and customer_addresses, two seemingly redundant configuration values are allowed to be passed in: // File: ...
3
votes
0answers
262 views

How to create Entity in magento 2?

We have customers,orders,products etc has Entity in magento. similarly i want to create custom Entity Called XYZ. Any Help will be appreciable!!
3
votes
1answer
528 views

Magento 2.1 Dynamic Drop-downs 2 models with UI component

Having 2 Drop-downs where the second one should load options according to the first one selections, but both come from the EAV models, I want to make them work in the admin but I can understand how to,...
2
votes
1answer
370 views

Magento 2 : Invalid method Magento\Eav\Model\Entity\Attribute::isScopeStore

I am getting an issue on Magento 2.2.6 when trying to save my module record. This error occurs sometimes and the error disappears if run Magento upgrade command. But it comes again sometime. system....
2
votes
1answer
560 views

How do you manually create an EAV attribute on Magento 2.2?

I have been fighting with a module with an InstallData.php that will not execute on Magento 2.2.1, but I need to get this task done today. For the meantime, how can I create the needed category ...
2
votes
0answers
458 views

Argument 1 passed to Mage_Eav_Model_Attribute_Data::factory() must be an instance of Mage_Eav_Model_Attribute

I'm having problems with the VAT field after a customer placed an order and entered a VAT number. Everything appears to be working except when opening an order with a VAT number filled in. The ...
2
votes
1answer
367 views

Old attributes persist after attribute set is changed in Magento 2

There's an issue we're struggling with the products EAV. Here's an explanation: There's a shop with attributes and attribute sets created from them. A product is assigned an attribute set, and a ...
2
votes
0answers
169 views

How enterprise magento2.1 stores product attributes with schedule updates? (row_id)

In Magento2.1 enterprise, schedule updates has been introduced, which changes the table schema of product & other cms page. Take product attributes as example, a column "row_id" has been added to ...
2
votes
0answers
67 views

Non default store_view's product attribute value is not visible on frontend (product list) if store_view 0 EAV value is missing

Scenario: A Magento 1.7 store which has NO default values at all for some product attributes (like short_description). There is no entry in catalog_product_entity_text for store_view==0. (Even NO ...
2
votes
0answers
702 views

How to set input renderer on attribute for custom entity?

I'm trying to use an input renderer for a text attribute in my custom entity, however it doesn't seem to be working. I'm creating my ambassador entity in my setup file like this: <?php /* @var $...
2
votes
1answer
133 views

Issue facing while creating attribute for custom extension in Magento 1.9.2 Community edition

I am maintaining custom attributes for my extension. My installer and setup files are working properly and my atrributes are getting inserted in eav_attribute table but the only problem I am facing ...
2
votes
1answer
212 views

Custom EAV module doesn't insert entries to tables?

I have created an EAV module. It has created below tables. easyinnovates_carparks_carpark easyinnovates_carparks_carpark_datetime easyinnovates_carparks_carpark_decimal ...
2
votes
2answers
643 views

Mage_Eav_Model_Attribute_Data::factory() must be an instance of Mage_Eav_Model_Attribute

I'm facing this message in system.log when I open an oreder from the admin panel: MESSAGE: Recoverable Error: Argument 1 passed to Mage_Eav_Model_Attribute_Data::factory() must be an instance of ...
1
vote
0answers
67 views

Magento2.3.3 Facing Error during Data migration

I am trying to migartion from Magneto1.9.3.10 to Magento2.3.3 but I am facing error during [Eav Step] data migration like: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does ...
1
vote
0answers
58 views

Magento2 Create extra column in eav_attribute and eav_attribute_option table

I have created one extra column in the eav_attribute and eav_attribute_option table. Now I want to store values in those tables when I will create new attributes. Please suggest options.
1
vote
0answers
110 views

Magento 2: Good way to modify a custom attribute field dynamically from admin

I have added a custom customer attribute. I need to enable backend validation for this field in registration form, edit customer form, etc. It needs to be required and unique field. Or not, depending ...
1
vote
0answers
37 views

Use a Data Grid Table to assign values to an EAV attribute in admin

I have a custom attribute for Catalog Categories that represents the IDs of products associated with the category in question (this is a separate requirement from the usual association of products and ...
1
vote
0answers
34 views

Eav Attributes options

Script below add new eav attribute to product model. But who can explain me what mean everyone option in third paramater from function addAttribute() and where it using or give some links where i can ...
1
vote
0answers
304 views

Magento 2 - How to create custom EAV entity with backend crud operations

I want to create custom EAV entity module with back-end crud operations like in Magento default Product Attributes functionalities. So i can create new attribute multiselect, dropdown, text and etc.. ...
1
vote
0answers
110 views

Magento2 Custom EAV attribute text in layered navigation

Im having multiple custom EAV Attributes which only contain numbers and I want them to be used for filtering in the layered navigation. I got an extra plugin for the layered navigation but I have to ...
1
vote
0answers
177 views

Magento2 custom EAV in ui component listing

I created a custom EAV for my module. Now I want to show all the columns in my **ui_component** listing. But only the field from my **main** table can be displayed. How do I get all the other field ...
1
vote
0answers
305 views

Magento 2: Query For Product Attributes, SKU, SetID, AttributeID

I need a full table query of all my SKUs in the following structure. I feel I am pretty close but can't seem to figure out the relationships: valueID = eav_attribute_option_value.value ...
1
vote
2answers
3k views

Set default value for attribute in Setup Script in Magento 2

I have created install script to add an attribute to category. Default value has to be set, thus 'default' => '1', is used. InstallData.php file: public function install(...
1
vote
0answers
78 views

Magento 2 : Best practice to load category EAV value

I want to know what is best practice to load a complex EAV attribute in a block. I have added a custom EAV attribute to category and I can see it in Catelog_Category_Entity_Text table, although I am ...
1
vote
0answers
652 views

magento 2 custom product attribute won't save

I am writing a Magento 2 module - am trying to get it to add a custom attribute to every product. My Setup>InstallData.php file is successfully adding the attribute to the eav_attribute table when ...
1
vote
1answer
5k views

Where the actual data of custom attribute is stored in magento 2?

I have added a custom attribute in existing table catalog_category. The following code i have write in InstallData.php. namespace BelVG\AdditionalImageTemplate\Setup; use Magento\Framework\Setup\...
1
vote
2answers
2k views

Magento 2: addAttributeToFilter not returning any results

When I use addAttributeToFilter on Magento\Catalog\Model\ResourceModel\Product\CollectionFactory, with a custom attribute, I always get 0 results. use Magento\Catalog\Model\ResourceModel\Product\...
1
vote
0answers
32 views

Magento 2: Should we use API in setup as best practice?

Some time ago I opened an issue on magento2 about a possible problem I've spotted in Magento EavSetup class. In the discussion that follows some Magento devs are saying that for module setup (...
1
vote
0answers
330 views

How to inject EAV attribute to product model before loading it in Magento 2?

I want to always add a specific EAV attribute to the Product model whenever a Product model is loading. As an example, I always want to include vendor_name and brand_name EAV attributes to my ...
1
vote
2answers
895 views

What is the difference between eav/attribute and eav/entity_attribute?

Looking at eav_setup file and trying to understand the difference between the eav/attribute and eav/entity_attribute table. If I have to guess, eav/attribute is the entity that represents the ...
1
vote
0answers
106 views

Magento2 and custom entity options

I'm trying to add a custom attribute to order entity. I managed to add a column to sales_order, but I cannot save any value while placing the order. I tracked down the problem in: Magento\Framework\...
1
vote
0answers
603 views

Invalid entity_type specified: opco_planner_theme

I try to create EAV planner module. I am getting this error "Invalid entity_type specified: opco_planner_theme". All i want to understand why. class Opco_Planner_Model_Resource_Theme extends ...
1
vote
0answers
128 views

How to replicate value of custom_source_type model to eav_attribute_option

I created a custom source model for two attribute. But my Layered navigation can not find that value of that attribute. So i want to replicate my custom_attribute_value from my data base to ...
1
vote
0answers
62 views

Flat tables enabled only for one store view

We have 2 store view: one "fr" and one "en". We keep getting an undefined method on "addAttributeToSelect" but only for one store view. I've used "var_dump" to display the result of this: $...
1
vote
1answer
74 views

Getting all non EAV models

I'm building a 'global importer' module that allows an admin to upload a csv, choose a model and import. Is there a way to check if the model is not an EAV entity (since flat csv's will not work with ...
1
vote
0answers
376 views

EAV Attributes Install script - VS - eav_attribute_label table (For Select Attributes)

This question is very specific, I'm currently creating Select (Dropdown) product attributes with string keys (not int) in Magento using installation scripts without any issue using both custom source ...
1
vote
0answers
50 views

Substitute existing Customer EAV Attributes

In a Magento CE 1.7.0.2 shop I have custom EAV attributes for customer and customer addresses (eav_entity_type 1 and 2), such as: name_one name_two name_three telephonetel instead of the standard ...
0
votes
0answers
19 views

EAV - Static and Varchar Entity - What is the common between both?

I need a help on one of the following question : Q - EAV - Static and varchar entity type what is the similar in between this ? Both values can be identical for single sites Both values can be ...
0
votes
0answers
29 views

Magento 2 - How to hide/remove custom attribute from backend Account Information tab in customer page?

I have a custom attribute showing in the account information tab page. how can I remove them? Right now I can see the following
0
votes
0answers
28 views

Using EAV attribute as foreign key?

What would be the best way to link products and customers. I want that all products are assigned to customers. So customers can create their own products. As I am new to Magento I can think of 2 ways:...
0
votes
0answers
29 views

EavSetupFactory doesn't exist?

Trying to add a attribute to categories. Setting up install script following this guide: https://devdocs.magento.com/guides/v2.3/ui_comp_guide/howto/add_category_attribute.html and https://www....
0
votes
1answer
47 views

EAV indexer optimization: cannot find option

There is a section in the Magento 2.3 documentation that is titled EAV indexer optimization. It says that you should basically disable the EAV indexer, if you are not using a MySQL based search ...
0
votes
0answers
17 views

Unable to define customer flat columns using source entity

I'm trying to create a customer EAV which is always either 0 or 1, never null. The main issue I'm having is forcing the column in the customer_grid_flat table to be not nullable. $customerSetup->...
0
votes
1answer
62 views

Magento 2: EAV Attribute is not showing on catalog page

I've made an EAV attribute using an external script but the attribute is not showing on catalogue page. The database has created. I tried to put value in EAV Database but nothing works. Ext_Script in ...