Questions tagged [eav-attributes]
Questions about Magento's Entity Attribute Value (EAV) implementation
138 questions
0
votes
1
answer
46
views
How to fix duplicate id's in multiselect options
Via the api, multi select options were accidentally inserted as duplicates.
So instead of 11111,22222 being stored in catalog_product_entity_text.value it was submitted as 11111,22222,11111,22222 and ...
- 388
0
votes
2
answers
336
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\...
0
votes
0
answers
9
views
Search conditions returning no results / breaking
I have a couple custom modules, one for adding eav attributes to customers, and I had a module that filtered those customers based on the attribute values, which 'was' working.
When I say "filter&...
- 295
0
votes
1
answer
391
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'...
- 101
0
votes
2
answers
2k
views
custom attribute value not save in the Database
<?php
declare(strict_types=1);
namespace Vendor\Module\Setup\Patch\Data;
use Magento\Eav\Model\Config;
use Magento\Eav\Model\Entity\Attribute\SetFactory as AttributeSetFactory;
use Magento\Eav\...
1
vote
1
answer
197
views
EAV_ATTRIBUTE auto increment issue
I am trying to save product attributes in my Magento2 system and there may be 100 thousands of attributes.
However, I see that the value specified as auto increment in the eav_attribute table is ...
- 13
2
votes
1
answer
249
views
Filter by attribute is slow for customer collection using addAttributeToFilter() function
I have created a custom attribute called username for Customer which is searchable in admin grid. But whenever I search by username for SSO it takes much time (2-3 sec). Below are the code:
$...
1
vote
2
answers
1k
views
how to enable/disable custom attribute showing on product page
I created an attribute switch, but how do I get it to work? Also I created an attribute - which I want enable/disable
<?php
namespace ivan\ProductAtrr\Setup\Patch\Data;
use Magento\...
- 79
2
votes
0
answers
34
views
Why can't I display anything on the product page? product.info.main
app/module/vendor/View/layout
<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:
noNamespaceSchemaLocation=
&...
- 79
2
votes
1
answer
33
views
how can I apply to old record when add new eav
I want add object toggle switch by eav with default ON (value = 1).
In add new screen it will active but in edit screen it not (value = 0)
new record I create will be apply this, but old record can't.
...
- 49
1
vote
3
answers
676
views
My sql query to get product count for Attribute
I need the mysql query for the following magento code. Need to get the count of products with the given brand option id.
count($this->productCollectionFactory->create()
->...
1
vote
2
answers
1k
views
($callback) must be a valid callback
My extension is failing varnish test over and over again and the only visible error i have found in the error reports is
call_user_func(): Argument #1 ($callback) must be a valid callback, class "...
0
votes
0
answers
108
views
Create custom renderer
I need to create a custom attribute renderer using Magento components.
So how can I apply Magento .js component and element .html template inside the renderer?
Please help.
- 213
1
vote
1
answer
168
views
add categories tree to customer eav attribute
I'm trying to create an EAV attribute for the customer, and I need the input to be the product categories tree like the following image:
Is this acheivable? And how? please.
- 213
0
votes
1
answer
339
views
Magento 2.4.4 customer grid not working
I've seen this error before and I believe i've fixed it in the past but i can't seem to resolve it atm. So the Argument 1 passed must be of the type array, null given, called in vendor/magento/...
- 189
1
vote
2
answers
203
views
Showing customer eav attrribute in product page always shows cached data
I've created a customer EAV attribute and trying to show this attribute on the product details page but it always returns chaced data till I run bin/magento cache:flush full_page.
I've tried to use ...
- 213
0
votes
1
answer
804
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 ...
- 3,431
0
votes
1
answer
608
views
Magento 2.4, How to autofill value of Page Builder/textarea instead of Page Builder(form details) initialized as blank
In admin Catalog->Category->content
I would like this Form detail:Page Builder to have Layout->Row and Element->HTML Code="Default Value" at setup.
<?php
namespace Justins\...
- 363
0
votes
1
answer
651
views
Attribute value not showing properly in admin form
I have created a custom 'Forme' product attribute select type based on option value
class FormeOptions extends AbstractSource
{
/**
* Get all options
*
* @return array
*/
...
- 1,231
1
vote
1
answer
2k
views
Magento 2 : Remove Mandatory Validation for Customer Fields eg. firstname, lastname
I want to remove the mandatory validation for customer fields eg. firstname, lastname (both for frontend and admin).
I tried using UpgradeData to change the value of is_required field to 0 in the ...
- 180
2
votes
0
answers
162
views
Magento 2 : Extension attributes & Eav Attributes
Few question based on extension attributes & eav attributes.
Answers to this question will clear the concept of this topic.
What are extension & eav attributes in magento ?
What is the ...
- 277
1
vote
1
answer
279
views
Order custom attribute, extension attribute or EAV attribute | Magento 2
I want to add custom attribute for Order
From what I have learned, there are two ways this attribtue can be associated to Order entity
Having extension_attributes.xml + custom repository (and ...
2
votes
1
answer
514
views
How to add checkbox default value below attributtes in xml
Hello everyone I want to add "Use Default Value" checkbox , for each attribute in that I have added ,
PS : 'If you have ever seen "Use default value" checkbox in Magento admin, it ...
- 39
1
vote
0
answers
298
views
How to get the unused attributes from the table Magento 2 using SQL Query
I need to get the unused attributes from Magento DB that is not assigned to the Attribute set and not assigned to the production. Also i need to get the unused attribute sets. from Magento table
- 358
0
votes
1
answer
670
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
- 536
0
votes
2
answers
374
views
Removing a custom module doesn't remove it from the database
I created a customer EAV attribute to collect the users postcode on registration. I realized Magento already has this feature, so I removed the module. The problem is the module does not seem to be ...
- 82
0
votes
1
answer
182
views
When this attribute is displayed on the product page, its values must be different depending on the selected language
You need to add a new text attribute to all products in the Magento store. When this attribute is displayed on the product page, its values must be different
depending on the selected language.
...
- 2,636
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 ...
-1
votes
1
answer
813
views
Added custom customer attribute with patch script but it gives an error
I added a custom attribute to my customer with a data patch script. The attribute is added in the database tables but when I try to register a new customer I get this error:
main.CRITICAL: Exception ...
- 11
0
votes
1
answer
170
views
Duplicated Eav attribute in Product Edit form
I want to add a new attribute to the product edit form using the UI components, so I created a product_form.xml file in my module, and added the attribute with the code below:
<field name="...
- 218
0
votes
1
answer
557
views
Magento 2 how to add eav attribute for store information?
How can I add an eav attribute for store? I practically need to add a post code but storeview scope. The problem is that the post code for store information has website scope.
I have addedd eav ...
- 573
0
votes
2
answers
1k
views
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4-General' for key
Run the upgrade command, and the issue should be face
sudo bin/magento setup:upgrade
Return during the process:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4-General' for ...
- 2,147
0
votes
1
answer
627
views
Magento 2 customer attribute not working in Magento 2.3.3
I have created a module for adding a customer attribute and show it in create account form on frontend and account edit in backend, the thing is that it worked in Magento 2.2 but not on Magento 2.3.3, ...
- 573
0
votes
1
answer
670
views
Magento 2 customer attribute not saved in database
So I have created an attribute for customer entity, used it in frontend create account form, but it's not showing anything in customer_entity_varchar table, it's empty. However, in eav_attribute table ...
- 573
1
vote
2
answers
598
views
Magento 2 how to add custom attribute to register form?
I have created an attribute ZipCode just for the registration of a new customer.
In eav_attribute table it exists and it's created correctly. However I have not managed to put the attribute in the new ...
- 573
1
vote
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 ...
- 799
0
votes
2
answers
29
views
What is the query readers here i can't understand magento 2.3
I can't find the what query rendes here and i can't it is not readable so any can to find what query renders hear please tell what are the table involved here
public function getCount(\Magento\...
- 358
0
votes
2
answers
80
views
Why the product attribute input type is uneditable via admin panel once it created in magento 2
Why the product attribute input type is uneditable via admin panel once it created in Magento 2.
Can anyone explain?
My understanding is once the attribute values are entered and saved, the type of ...
- 2,636
1
vote
0
answers
194
views
Magento 2 - Data Migration Tool - Triggers
Intro
Regarding the Data Migration Tool (M1 to M2), the migration creates m2_cl_ trigger tables that I can eventually run bin/magento migrate:delta will only update those triggered tables, or do they ...
- 782
4
votes
1
answer
671
views
SQL error in [stage: data migration][step: EAV Step]: started
I have this issue where I get the following error in the [stage: data migration][step: EAV Step]
In Mysql.php line 110:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
...
- 323
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.
- 101
2
votes
1
answer
835
views
How to create product attribute and assign it to specific attribute set and attribute set group? Magento 2.3
I have an attribute set with name Gold and attribute set group with name Ring, i want to add a boolean product attribute with name biodynamic like this:
namespace Vendor\Module\Setup\Patch\Data;
use ...
- 49
0
votes
0
answers
136
views
Magento 1.9 Custom Category Attribute exists in EAV_Attribute but not showing in backend
I have been trying to add a custom category attribute to our Magento 1.9.4.2 site using this tutorial:
https://www.atwix.com/magento/add-category-attribute/
The module installs and successfully adds ...
- 55
0
votes
1
answer
339
views
How to filter bestseller collection with a product attribute
You can addAttributeToFilter for product collection;
$this->_productCollectionFactory->create()->addAttributeToFilter('att_x', ['eq', $att_x_value]);
How can we do this with bestseller ...
- 103
0
votes
2
answers
124
views
Can not open "Admin -> Customers -> All customers" after Magento 1 to 2 data migration
I have a similar issue like this one here, after migrating from Magento 1 to 2.
But the report is a little bit different and the provided solution in the thread did not help me at all.
I already ...
- 3
1
vote
1
answer
825
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
- 679
0
votes
1
answer
67
views
Magento 2 Attempt to load value of nonexistent EAV attribute with CategoryInterface after migration
after 1.x to 2.3
I am getting error as following in my System.log file.
[2020-02-06 13:29:01] main.WARNING: Attempt to load value of nonexistent EAV attribute '903'
for ...
- 1
1
vote
0
answers
239
views
Pragmatically add product attribute label to an existing attribute for a new store view
I have setup a working store in English (default store view), but now i wish to add a new language which will be a new store view; 'Italian'. We have alot of attributes that have been added ...
- 431
3
votes
0
answers
87
views
Magento 2 Edit Product page Error: Every derived table must have its own alias
I'm using magento 2.2.5 and when i opened the edit product page the product name, price,etc doesnt load at all, and when i checked the var/log/exception.log i got the following error:
...
- 49
4
votes
8
answers
4k
views
“Type Error occurred when creating object: Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Config”
I have migrated from ver 1.9 to 2.3
- 479