Skip to main content

Questions tagged [eav]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
71 views

Magento 2.4.7 Customer Custom Attribute Value no Change

When I created one Customer Custom Attribute and changed its value website-wise from Admin-> Edit Customer Information so did not change it. <?php namespace Vendor\Extension\Setup\Patch\...
Magecomp Product Team's user avatar
0 votes
1 answer
24 views

how to update the SKU values

Magento Verrion: 2.4.3-p1 Problem: I tried to update the products weight value in the admin panel. I changed the weight value 1.2kgs(current) => 2.8kgs(preffereable) and press the save&exit ...
celina alwin's user avatar
0 votes
0 answers
22 views

Undefined array key 3796 in Eav.php on line 604

I am getting this error, when I try to open a product in the admin: Undefined array key 3796 in vendor/magento/module-catalog/Ui/DataProvider/Product/Form/Modifier/Eav.php on line 604 The code in Eav....
user4095519's user avatar
0 votes
1 answer
180 views

Getting an EAV option's value (eav_attribute_option_value) instead of ID when fetching products using GraphQL

I should preface this by saying I know nothing about Magento 2 development, and barely anything about GraphQL, yet I've been added to this project so I have to learn both of them at the same time. I'...
Alex's user avatar
  • 101
0 votes
0 answers
21 views

Return product attribute object after creation

I've made a class to create product attributes on the fly. After creating it I want to return it immediately. However getAttributeByCode() returns NULL. When I start another process the ...
jrswgtr's user avatar
  • 63
2 votes
1 answer
172 views

Is it possible to get a collection containing the attributes of all entities (customers, products, etc)?

I'm trying to get a collection from the table eav/attribute (where product's attributes are present along with customer's, category's, etc). I already tried to retrieve it like a normal model ...
Matheus Delazeri's user avatar
1 vote
1 answer
97 views

How to enable 'Use in Layered Navigation' for EAV attribute?

The options are disabled and I would like to activate them. The module I am using is Mirasvit
Alessandro Scalesse's user avatar
0 votes
1 answer
116 views

EAV attrubute load value from DB - low level code

During some tasks, I was not aware of exactly how Magento loads values for attributes that are available. for example, if we have loaded Product Model and attributes in $product->getData(). Which ...
Sebas's user avatar
  • 27
0 votes
1 answer
293 views

Cannot Update EAV Unique Attribute

I have a custom product attribute custom_attr that I created using InstallData.php and set its unique value to true. Now, I am trying to set it back to false in UpgradeData.php but the changes are not ...
S.Murtadha's user avatar
0 votes
1 answer
702 views

Magento 2 - where to find "confirmation" attribute for customer?

Where is the status of "Confirmed email" saved in the database? How can I change the value directly in the database for this customer? I searched everywhere, but I can't find the table ...
Black's user avatar
  • 3,390
3 votes
1 answer
225 views

Customer Telephone is required, even it is not configured in that store, works after cache clear, for some time

Since several days (we did not make any code changes, besides the recent the CVE-2022-24086 patches), customers in a certain store of multi-website store cannot order, because Magento requires the ...
Alex's user avatar
  • 13.9k
0 votes
1 answer
35 views

below code gives only enable value i want both enable and disable all product in magento 2.3

$objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory'); $collection = $...
Galib's user avatar
  • 37
0 votes
1 answer
623 views

what is the purpose of eav_entity_attribute table

in Magento i have seen entity table, eav_attribute table and attribute table, which has links. But i don't find any link to eav_entity_attribute. I want to know the purpose of the table
Krishnan Daiva's user avatar
0 votes
3 answers
634 views

Customer EAV attribute error: "Mobile Number" is a required value

I have created a custom attribute to store the users mobile number on registration. It's visible on the registration, and admin page, but upon trying to create a customer I get the following error: &...
BugHunterUK's user avatar
0 votes
1 answer
133 views

entity_type_code_entity table is empty in magento2

I am trying to insert data into the EAV tables, but my main entity table isn't saving any data but the value tables data is inserted. My Entity Type code is vinay_employee, my table ...
Vinay Kharayat's user avatar
0 votes
0 answers
119 views

Filter product collection with nested OR/AND statements

I want to make a query as below WHERE manageStock = 0 OR (manageStock = 1 AND productStatus != 0) OR (manageStock = 1 AND backorderStatus = 1) but I can't use $collection->getSelect()->where() ...
Bhupendra Bisht's user avatar
0 votes
1 answer
474 views

How to get attribute group name by id

How to get attribute group name by attribute group id <?php $attribute_group_id = 2; /// this is group id echo likeGetnameforthis($attribute_group_id); ?>
Sayed Mohamed's user avatar
2 votes
1 answer
2k views

Magento 2: Keep use default value when Updating product attribute programmatically in store view level

I have a dropdown product attribute in store view level that i need to update programmatically for specific store: I tried to update the product attribute programmatically like this: // \Magento\...
Tiny Dancer's user avatar
0 votes
1 answer
357 views

Magento 2 - Install category attribute not work

I created a custom form for creating some attributes for the category. My code is this but it doesn't work: InstallData.php <?php namespace Create\Attribute\Setup; use Magento\Framework\Module\...
Jackom's user avatar
  • 493
0 votes
1 answer
1k views

Filter a collection with a custom attribute

I'm trying to add a custom attribute to the customer_entity table and then sort the collection with that custom attribute. So far I've tried using etc/db_schema.xml to add a column to the table, and ...
Gautier Bardon's user avatar
0 votes
1 answer
1k views

Difference between catalog_attributes.xml vs eav_attributes.xml vs extension_attributes.xml

In the Magento_Catalog module i have seen there are three different configuration (xml) files related to the catalog attributes, those three files are catalog_attributes.xml vs eav_attributes.xml ...
Zeeshan Khuwaja's user avatar
2 votes
0 answers
43 views

Basic clarity on some magento default function

I had gone through a interview process. They fired some questions below which I don't know answers and couldn't find in google. The questions are below. How to create a object and why we need to ...
Ramesh KR's user avatar
  • 876
2 votes
2 answers
338 views

Magento 2 - Update eav attributes in a other attribute automatically

we have a multi brand shop with 60K+ of products. Every brand has it's own way of dimensions. Which results in an attribute list of 500+ entries. Attribute: POS-size Here is a screenshot of this: But ...
Ronny's user avatar
  • 433
0 votes
1 answer
65 views

Custom eav category not showing in data front

I have added an attribute to my category. The attribute is working well on backend (it's showing and saving correctly), but I can't get it on the front. Here's how i've added this (install): ...
Morgan Tartreau's user avatar
0 votes
1 answer
44 views

productAttributeOptionManagementInterface api not loading attributes

I use \Magento\Catalog\Api\ProductAttributeOptionManagementInterface in my constructor and since Magento 2.3.5 it doesn't load any attributes.
Walter Woshid's user avatar
0 votes
1 answer
622 views

InstallScripts vs db_schema for new EAV attribute

I'm in the process of adding new fields to my registration page. I know that we're now supposed to use db_schema instead of InstallScripts, but how can I make sure that they're seen as customer ...
web master's user avatar
4 votes
2 answers
198 views

What is the difference between the customer attribute properties user_defined and system and what are they used for?

How to create a customer attribute is explained in various answers such as this or this. What they all have in common, is that when creating the attribute its properties user_defined and system are ...
Daniel's user avatar
  • 2,239
1 vote
1 answer
791 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
jibin george's user avatar
0 votes
0 answers
236 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:...
Pisikoll's user avatar
1 vote
0 answers
114 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 ...
Rv Singh's user avatar
  • 1,637
1 vote
1 answer
835 views

How to make product specific multiselect attributes on Magento 2.3?

We have a table that has data linked to products. MyCustomDataTable { id, product_id, text_value } We want to be able to search for products using the MyCustomDataTable.text_value value. ...
MikeGrove's user avatar
4 votes
0 answers
453 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 ...
omsta's user avatar
  • 698
1 vote
1 answer
1k 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 ...
fritzmg's user avatar
  • 747
2 votes
1 answer
1k views

How to add 'switcherConfig' to a Modifier pool on Magento2

I have custom eav table whose attributes I'm getting dynamically on my modifier pool. But I want to add switcherConfig, as one of my fieldset display is dependent on a selected field value. Can anyone ...
Afreen Sheikh's user avatar
1 vote
1 answer
479 views

How to list unused attributes options by sql query

I would like to list all attributes options that our products don't use. I prefer to use SQL to do that to learn how to work with it. Right now I use this query to get the ID of my attributes select * ...
Stéphane Baribeau's user avatar
1 vote
2 answers
49 views

Magento 2 - read and write new customer attribute

I added a new customer attribute n2gEmails: app/code/Fekete/Newsletter2Go/etc/extension_attributes.xml: <?xml version="1.0" ?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ...
Black's user avatar
  • 3,390
0 votes
1 answer
653 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 ...
Izhar Mehdi's user avatar
0 votes
1 answer
531 views

Magento 2: Call to a member function getEntityType() on null

I'm trying to create a new Eav Entity after this instruction post. Then i got this issue: Call to a member function getEntityType() on null I'm still new with Eav Entity, so can some one help me ...
fudu's user avatar
  • 1,298
0 votes
2 answers
2k views

Magento 2 : Need to perform clean cache programmatically after records save

In admin side, I want to clean "eav" cache type on records save. I added code in afterSave() function and function also call after save records. But, I think it's not working because, parent afterSave(...
Rohan Hapani's user avatar
  • 17.5k
5 votes
1 answer
3k views

row_id vs entity_id in magento 2.3 EE

In Magento 2.3 EE, entity_id is missing in EAV tables, instead row_id is available Please explain the difference between row_id and entity_id and the removal of entity_id in EAV tables
manokarthick karthick's user avatar
2 votes
2 answers
7k views

Custom Customer attribute not saving Magento 2.3.1

I have the following code to create a custom customer attribute. <?php namespace Vendor\MyModule\Setup\Patch\Data; use Magento\Customer\Model\Customer; use Magento\Customer\Setup\...
Goose84's user avatar
  • 2,621
0 votes
1 answer
267 views

Magento 2 - join using EAV attribute

I created an EAV attribute on product entity, this attribute named user_id and has the ID of the user who's added the product. After works, I crashed on this point, I need to join tables to get ...
sayou's user avatar
  • 363
1 vote
1 answer
59 views

How is a product name retrieved if the query does not return it in the result set?

I'm trying to get data from catalog_product EAV tables with the following code: $productCollection = Mage::getModel('catalog/product')->getCollection() ->addAttributeToFilter('...
YD8877's user avatar
  • 113
1 vote
1 answer
58 views

Needed short explanation

I have read many blogs to understand some of the topics in Magento 2 but still not clear about them. They are as follows EAV Dependency Injection Could anyone please explain them shortly? Thanks ...
Siva's user avatar
  • 1,120
0 votes
3 answers
761 views

custom table left join with catalog/product

I have a custom table called flagged_products which lists flagged products like this: +-----------+------------+---------------------+ | entity_id | product_id | flagged_on | +-----------+---...
YD8877's user avatar
  • 113
0 votes
1 answer
123 views

Can't create custom attribute for order_address

I need to create a custom attribute on the order address to stock my ERP id of the address for a syncing purpose. I've tried to create a Eav in Maru3l/SyncOrchestra/Setup/InstallData.php. I don't see ...
maru3l's user avatar
  • 145
0 votes
1 answer
1k views

Magento 2 - Hide/Show custom EAV attribute after if condition

I created a new EAV attribute using this code : 'information', [ 'group' => 'Content', 'type' => 'int', 'default' => null, 'global' => \Magento\Eav\...
sayou's user avatar
  • 363
0 votes
1 answer
53 views

Magento 2 : How to know who admin_user added a product?

I created a new admin_user role, this role has access to the products page and can add a new product. So, I want to save the ID of the current admin_user to know who's added the product. The first ...
sayou's user avatar
  • 363
0 votes
1 answer
786 views

Should Magento\Eav\Model\AttributeRepository save 'used_in_forms' attribute value?

I add EAV attribute to a customer address. I can use \Magento\Customer\Model\ResourceModel\Attribute $attributeResource to save the attribute. According to Magento DevDocs https://devdocs.magento.com/...
Boris Ruvinsky's user avatar
2 votes
0 answers
189 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.
Deepak Shinde's user avatar

1
2 3 4 5
8