Questions tagged [eav]
Questions about Magento's Entity Attribute Value (EAV) implementation
351
questions
1
vote
0answers
27 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
25 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. ...
3
votes
0answers
28 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
29 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
29 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
27 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
29 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
13 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
31 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
35 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
10 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
89 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
218 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
1
vote
2answers
282 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
27 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
36 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
20 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
44 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
108 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
30 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
39 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
100 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
135 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
21 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
138 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
47 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
180 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
278 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
40 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
222 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
857 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 ...
0
votes
2answers
215 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
213 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
543 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
102 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
73 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 ...
0
votes
0answers
36 views
Proper way to set default available options for custom Customer EAV attribute?
I have this basic class that I use in my UpgradeData script
class Industry extends AbstractSource
{
/**
* Retrieve All options
*
* @return array[]
*/
public function ...
0
votes
0answers
83 views
Magento 1.9.2. - Set Order by position attribute value of associated products
I'm trying to order my foreach for the products associated with the configurable product. I would like the values to be printed in ascending order by position relative to the size attribute.
At the ...
1
vote
1answer
254 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
0answers
48 views
Magento 1.9.2. - foreach remove duplicate from options attribute value
I'm pulling out all the values of the color attribute of the products associated with the product configurable with this foreach.
foreach($simple_collection as $simple_product){
echo $...
0
votes
1answer
491 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
0answers
191 views
how to get all the attributes and values for all product entities from product collection model
i have created a custom attribute user_id of [type => int] for catalog_products_entity in my Install Data script
$productSetup = $this->eavSetupFactory->create(['setup' => $setup]);
$...
0
votes
1answer
284 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
27 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
3k 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
182 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
378 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 ...
