Questions tagged [eav]
Questions about Magento's Entity Attribute Value (EAV) implementation
351
questions
0
votes
0answers
15 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
23 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
25 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
24 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....
1
vote
0answers
53 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
34 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
38 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
43 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
52 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 ...
0
votes
1answer
45 views
How to list unused attributes options by sql query
I would like to list all attributes options that our products don't uses. I prefer to use SQL to do that to learn how to work with.
Right now i use this query to get the ID of my attributs
select * ...
1
vote
2answers
32 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
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
51 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
37 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
0answers
11 views
getAdditionalAttributeTable returning empty string
In the
/vendor/magento/module-eav/Model/ResourceModel/Attribute/Collection.php
file, the call below is simply returning an empty string, any ideas as to where this might be, or even where this ...
0
votes
2answers
143 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(...
0
votes
0answers
34 views
How to add extra fields on ccsave payment method?
I need to create two additional fields for the ccsave checkout form. I created in the tables sales_flat_quote_payment and sales_flat_order_payment two fields called cc_parcelas and cc_csc.
In html, ...
1
vote
1answer
357 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
519 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
31 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
37 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('...
0
votes
0answers
24 views
Customer Custom Attribute missing in order
I have create custom customer attribute using EAV,
While registering customer from Admin-panel Checkout the customer attribute not setting default values.
1
vote
1answer
46 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
135 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
0answers
32 views
“Can't retrieve entity config: eav/” - After migration 1.3 to 1.7
After the migration from Magento 1.3 to Magento 1.7 I get this error when I open orders, products and customers in the backend. The same happens when I add a product to the cart.
Below is the complete ...
0
votes
1answer
38 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
0answers
41 views
How can I have a product attribute with a source model as a swatch?
I have a product attribute that I populate from my own custom table, I have a class that extends from \Magento\Eav\Model\Entity\Attribute\Source\AbstractSource to be able to populate my attribute ...
0
votes
1answer
163 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
0answers
160 views
Magento 2 - get EAV value and display it on admin Grid
I added a new attribute to the product table, using EAV method, this attribute named 'user_id' content the ID of user admin ID who's added the product.
Now, I need to get the value of this attribute ...
0
votes
1answer
38 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
0answers
24 views
Add Customer Attributes through Admin Form
I'm trying to build a extension where I can dynamically add new Customer Attributes just like I would do with Product Attributes. The thing is that I'm new to Admin Grid and I'm not finding the a few ...
0
votes
1answer
158 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
55 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
238 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
334 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
42 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 ...
1
vote
1answer
271 views
How this InstallData works each line in Magento 2?
My questions:
I want know how this works by each and every line of code
I want to add new attribute here
Difference between InstallData and InstallSchema
Here is InstallData.php
<?php
...
2
votes
1answer
1k views
Magento 2 : addAttributeToFilter, addAttributeToSelect, addFieldToFilter not working
I created eav entity module. But, when I use this addAttributeToFilter, addAttributeToSelect, addFieldToFilter function in my custom module collection. It's not working.
My collection file :
I ...
asked Mar 2 '19 at 5:11
Emipro Technologies Pvt. Ltd.
3,3501 gold badge14 silver badges35 bronze badges
0
votes
2answers
271 views
How to set value for radio button in EAV attribute of product type?
We can add simple boolean Radio buttons as EAV attribute in install schema by this code:
"type" => "int",
"backend" => "",
"label" => "Test",
"input" => "...
2
votes
1answer
265 views
Magento 2 : Eav module record can't save in custom module table
I create custom EAV module.
app/code/VendorName/ModuleName/Model/ResourceModel/Mainpage/Collection.php
<?php
namespace VendorName\ModuleName\Model\ResourceModel\Mainpage;
class Collection ...
3
votes
1answer
774 views
Magento 2 : How to create an EAV entity module?
I want to create EAV entity module. I refer these below links. I want to do the same in Magento 2.
How to create an EAV entity?
How to do it in Magento 2?
Please help me.
Thanks.
UPDATE:
I can ...
0
votes
3answers
111 views
Set programmatically added attributes to product
I'm writing cron module to import products (Magento 2). In this module I'm adding attribute, attribute value and assign this new attribute value to product. It sounds easy but new added attributes and ...
0
votes
1answer
79 views
Magento 2 - Add a new product attribute with values from DB
I'm looking for creating a custom attribute for products, already have a CRUD module, with name and descriptions fields, so the names from my DB should be options of that attribute.
How do I need to ...
1
vote
1answer
390 views
Error with Magento\Eav\Model\Entity\Attribute how to fix?
I have this error,
1 exception(s):
Exception #0 (Exception): Item (Magento\Eav\Model\Entity\Attribute) with the same ID "87" already exists.
it seems to me that there must be a duplicate row ?
But ...
0
votes
1answer
564 views
How to create a custom tab with custom attributes in Customer admin
I am a beginner in Magento (version 2.3).
I am looking for a solution to create a form with custom attributes, which would be displayed by clicking on a custom tab in Customer admin.
I have ...
0
votes
1answer
329 views
Magento 1.9.2. - Get Admin value of attribute option in frontend
I'm trying to recall in my configurable product the value of the 'color' attribute of the products associated with the foreach method:
foreach($simple_collection as $simple_product){
echo "$...
0
votes
1answer
30 views
Could a hybrid data model, like using JSON in fields, allow us to eliminate the need for EAV within something like magento 2?
I was reading about EAV, and what options are available to avoid the pain caused by it, and stumbled upon using JSON in fields.
This mariadb feature page shows an example like,
SELECT name,
...
3
votes
2answers
4k views
Magento 2 How to add custom attribute to customer address and how to insert value in that attribute?
I want to add a new custom attribute to "customer_address" that I did with an attribute installer script, now I am able to see that field in "eav_attribute" table. I have created a module and I have ...
1
vote
1answer
239 views
Magento 2 How to add new address in 'customer_address_entity' from helper?
I am using helper data function to add the new address in customer_address_entity but it is not working. code as below :
<?php
namespace Name\Module\Helper;
use \Magento\Framework\App\Helper\...
0
votes
1answer
435 views
Magento 2 How to add custom field in customer_address_entity table? which will not use for front end or back end
I want to add one custom field in "customer_address_entity" table, for custom module. I have custom module installed. I am trying with "InstallData" script to add custom field. I do not want to show ...
