Questions tagged [eav]
Questions about Magento's Entity Attribute Value (EAV) implementation
365
questions
0
votes
0answers
10 views
Attempt to load value of nonexistent EAV attribute '90' for entity type 'Magento\Catalog\Api\Data\ProductInterface'. Errors occurs in system.log
Attempt to load value of nonexistent EAV attribute '90'
for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
This occurs continues in my system.log when i see attribute 90 its media ...
0
votes
1answer
24 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 = $...
0
votes
1answer
39 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
0
votes
0answers
37 views
Magento 2 | Use input text as a filter in layered navigation
I try to explain what I would like to do:
I created a new attribute called stockqty in Stores> Attributes> Products.
I assigned this attribute to the Default section and re-indexed everything
...
0
votes
3answers
47 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:
&...
0
votes
0answers
32 views
How to get the custom EAV value loaded for the Customer Address table in admin?
I have a data patch which installs the custom customer attribute (of type "text"). It is EAV attribute, I specify 'is_used_in_grid' => 1 and life's good: in the admin I navigate to Admin -...
0
votes
1answer
10 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 ...
0
votes
0answers
9 views
Custom customer attribute search not working in admin
I added an attribute to customer, but when I try to search values of customer code on the backend, nothing comes up. I can't get my customer attributes to be included in search.
What can I do to get ...
0
votes
0answers
72 views
Move Attributes from attribute group to Unassigned Attribute programmatically
Im trying to move attribute from Attribute group to unassigned, (should reflect in all attribute sets) in my controller.
I tried below code by its not removing, instead its deleted.
$eavSetup = $this-&...
0
votes
0answers
25 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() ...
0
votes
0answers
20 views
Missed fields at listing page, custom EAV
I've created custom entity (EAV). I could see all fields on edit page. app/code/Klever/ProductPricing/Controller/Adminhtml/WallMaterial/Edit.php
public function execute()
{
// 1. Get ID and create ...
0
votes
1answer
79 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);
?>
2
votes
1answer
582 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\...
0
votes
0answers
21 views
Declare extension_attribute.xml for EAV?
I created some attribute for the customer entity, so I used a data Patch to declare the new attribute (it's then an EAV attribute) and assign the attribute group and attribute set.
Everything works ...
0
votes
1answer
29 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\...
0
votes
1answer
28 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 ...
0
votes
0answers
10 views
Can I have a required field based on a condition?
I created a new EAV attribute for customer called "existing customer". it's a yes/no question.
I have an option that comes up if the person clicks on 'no' called "what are you ...
0
votes
1answer
163 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 ...
2
votes
0answers
11 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 ...
2
votes
2answers
115 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 ...
0
votes
1answer
11 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):
...
0
votes
1answer
30 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.
0
votes
1answer
156 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 ...
3
votes
1answer
45 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 ...
1
vote
0answers
65 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
92 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:...
1
vote
0answers
84 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
1answer
209 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. ...
4
votes
0answers
86 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 ...
0
votes
1answer
401 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 ...
1
vote
1answer
613 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 ...
0
votes
1answer
250 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 * ...
1
vote
2answers
37 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"
...
0
votes
1answer
209 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 ...
0
votes
1answer
73 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 ...
0
votes
2answers
568 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(...
3
votes
1answer
2k 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
2
votes
2answers
2k 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\...
0
votes
0answers
119 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 ...
1
vote
1answer
51 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('...
1
vote
1answer
52 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 ...
0
votes
3answers
407 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 |
+-----------+---...
0
votes
1answer
61 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 ...
0
votes
1answer
445 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\...
0
votes
1answer
42 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 ...
0
votes
1answer
306 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/...
1
vote
0answers
79 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.
4
votes
2answers
482 views
Magento 2.3 - Add custom customer entity attribute with service contract
I have some problem to save custom customer entity attribute in database.
I've created a Patch to add this attribute to the customer entity. The attribute is shown correctly in the backend, but when I ...
2
votes
1answer
730 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....
3
votes
0answers
57 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 ...
