Questions tagged [eav]

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

Filter by
Sorted by
Tagged with
5
votes
2answers
2k views

“Undefined Index Notice” in EavAttribute.php when adding a swatch option

I am using Magento 2 and I created an attribute called hair_color that is of a visual swatch input type. I have inputted 140 swatch options for this attribute, but on the 141 I keep getting this error:...
2
votes
1answer
1k views

How to properly save EAV attributes for all store views at once?

We have right now three store views with different locales and plan to extend their quantity in a future. We encountered issue when some attributes (price, name, etc) are properly received when we ...
0
votes
1answer
962 views

SQL Query to get actual name of custom attribute value

I am able to get the value of a custom attribute from the following query, however, the number doesn't help much. I would like to get the actual name of the value. SELECT entity.sku, entity....
2
votes
0answers
744 views

Magento 2: How to add a custom attribute to the CMS Page [duplicate]

I am trying to add a custom attribute to a CMS page in Magento 2. As it seems there is no way of using EAV, since the Page model does not have entity types. I tried to add an Extension Attribute, ...
1
vote
1answer
50 views

what is difference in user created product attributes and created by install script?

Faced with strange issue : trying to get all product attributes with: Mage::getModel('catalog/product')->getAttributes(); but can't see some of them which was created in backend by user, although ...
0
votes
1answer
447 views

Magento 1.9.x - Create store dependent attributes for entity customer

Earlier add a new custom attribute biography_desc was added for customer: $installer = $this; $installer->startSetup(); $installer->addAttribute("customer", "biography_desc", array( "type" ...
0
votes
2answers
924 views

How to Create custom increment id like sales order increment_id for custom module

I want custom increment_id field in custom module. Like sales_flat_order increment_id. Is EAV table format is best solution?
2
votes
1answer
139 views

Issue facing while creating attribute for custom extension in Magento 1.9.2 Community edition

I am maintaining custom attributes for my extension. My installer and setup files are working properly and my atrributes are getting inserted in eav_attribute table but the only problem I am facing ...
0
votes
1answer
332 views

Source model “instagramconnect/source_instagram_user” not found for attribute “instagram_category_source_user”

Any solution of following code then let me know it urgent. I have also remove instagram_category_source_user row form env_attribute table after getting this. but don’t fix it any solution. Following ...
1
vote
2answers
1k views

How to Join an EAV to a Flat Table & Import Flat Table and Update EAV

This will be two parts 1.) Join an EAV to a Flat Table the Magento way 2.) Import into Flat Table that will update the EAV Table. Basically be able to Export(Flat Table) and Import(with flat table) ...
2
votes
2answers
5k views

Where is the newsletter 'general subscription' field stored in the database

I'm working on a customer database export, but can't find where the 'general subscription' newsletter subscription field is stored in the database. I imagine it is some EAV value, but in what table ...
10
votes
2answers
16k views

Magento2 Adding Custom Order Attribute

How would I add a custom attribute to an Order in Magento. It seems clear for Product and Customer, but I can't find any info for adding extra attributes to orders.
6
votes
4answers
6k views

Magento 2 - Get attribute options and sort order

I need to get the label and sort order (as defined in backend) of all the options of a custom attribute, programmatically. I'm using this interface: Magento\Eav\Api\AttributeRepositoryInterface This ...
2
votes
1answer
842 views

adding addFieldsToFilter() does INNER JOIN on eav tables, removing all products which don't have that attribute

This is either a simple fix, or something that magento does natively and I'll have to do a workaround (which I still need to know what it is). Here is my code: $products = Mage::getModel('catalog/...
6
votes
2answers
3k views

Set dropdown value using text value

I have a small import script that will import product to Magento 1. It works well but there is something not work.If a product attribute happen to be a select type attribute the value will not save. ...
19
votes
6answers
53k views

Magento 2 - How to get attribute options value of eav entity?

How can I get the attribute options values of eav entity? I found solution only for magento 1.x but M2 I don't know. M1: $attr = Mage::getResourceModel('eav/entity_attribute_collection')->...
0
votes
1answer
426 views

Magento: update customer attribute to be “required”

apparently we have to add "||$attribute->getAttributeCode()=="email" in our checkout template to show the e-mail field, because isREquired returns false. See below. My question is: how can I set the ...
0
votes
2answers
1k views

How to join two entity table in magento

I have created a custom entity table vaibhav_customtabs_product_entity, where I have following columns. entity_id entity_type_id attribute_set_id increment_id store_id created_at updated_at is_active ...
0
votes
2answers
200 views

Why the database table is not showing Magento

I am working on a module for Magento 1.9.X. However, I am not able to create the database table grided_products. I have also checked core_resource, my module is updating the version also. Below are my ...
4
votes
4answers
4k views

Magento attribute change backend_type from varchar to text

My product attribute exceeded the 255 character limit of varchar, so I came across the solution to change its backend_type to text. Should this operation be considered safe (in the terms that it will ...
2
votes
1answer
667 views

Unable to get multi selected eav attribute values in magento

I have a multi select attribute in eav_attribute with attribute_code my_managers, its entity_type_code is customer_address, I want to get selected value,,I am trying to export it to csv,in my ...
1
vote
2answers
210 views

flat tables no meta title

Does anyone know why meta_title attribute is missing both for product and category flat tables? I can see meta_description and meta_keyword fields in the flat tables but no meta_title. So I am forced ...
0
votes
2answers
139 views

Cannot retrieve EAV product data

I'm facing a strange issue (on Magento EE 1.14.2.1) where I cannot retrieve EAV product data after setting up a fixture. My test: /** * @loadFixture */ public function testExample() { $product ...
0
votes
1answer
486 views

Magento - Add field to Admin Address Forms

How would I go about adding a new field to all Backend Magento Customer Address forms? I've looked into Magento's EAV system but none of the tutorials about adding custom address fields seem to work ...
2
votes
1answer
137 views

Exclude category from flat catalog and indexer

Is it possible to exclude a category from being added to the flat catalog index or index in general? The problem: we have a huge set of data in one category (5mio products). It's only accessible via ...
2
votes
4answers
2k views

get the deleted attribute back to the live site

we missly deleted the attribute : "age" from live site. attribute code : "age" attribute label : Age group we assigned this attribute to thousands of products. is there any option to get that ...
3
votes
1answer
2k views

Magento 2 Fail to save the value of a newly added Yes/No customer attribute

The customer attribute shows up but cannot save it because there are no records about this attribute in eav_entity_attribute table, when I manually add a row for the attribute, it can be saved. How to ...
3
votes
1answer
4k views

Magento 2 - Best practice for extending customer entity

I'm looking for the best practice for extending the customer entity. I want to add some custom fields (user_name, company_infos, etc.) and I don't know if it's better to extend the customer entity ...
2
votes
1answer
225 views

Custom EAV module doesn't insert entries to tables?

I have created an EAV module. It has created below tables. easyinnovates_carparks_carpark easyinnovates_carparks_carpark_datetime easyinnovates_carparks_carpark_decimal ...
3
votes
1answer
734 views

Error while executing the EAV install script?

I have created an EAV module and when I run the install script the following error appears. Error in file: "/var/www/html/carparks/app/code/local/Easyinnovates/Carparks/sql/...
1
vote
0answers
136 views

How to replicate value of custom_source_type model to eav_attribute_option

I created a custom source model for two attribute. But my Layered navigation can not find that value of that attribute. So i want to replicate my custom_attribute_value from my data base to ...
1
vote
0answers
62 views

Flat tables enabled only for one store view

We have 2 store view: one "fr" and one "en". We keep getting an undefined method on "addAttributeToSelect" but only for one store view. I've used "var_dump" to display the result of this: $...
1
vote
1answer
74 views

Getting all non EAV models

I'm building a 'global importer' module that allows an admin to upload a csv, choose a model and import. Is there a way to check if the model is not an EAV entity (since flat csv's will not work with ...
1
vote
0answers
386 views

EAV Attributes Install script - VS - eav_attribute_label table (For Select Attributes)

This question is very specific, I'm currently creating Select (Dropdown) product attributes with string keys (not int) in Magento using installation scripts without any issue using both custom source ...
1
vote
2answers
148 views

unusual Logic behind how order numbers are incrementing

I'm curious about the logic behind how magento increments it's order numbers, especially regarding orders from different stores within the same website. We have four stores and have received orders ...
0
votes
1answer
2k views

Set date value to an attribute in a custom model

So I have my EAV called mymodel and one of it's fields/attributes is called "enddate" of date type. Now, when I create a new object, and I want to set the value of this "enddate"... I just can't. The ...
0
votes
2answers
5k views

List all EAV Attributes of an entity_type_id via SQL

How can I obtain the list of all EAV attributes of a specific entity (by its entity_type_id) via SQL?
0
votes
1answer
175 views

Create custom image attribute for category size chart

I want to create an image attribute in category which maps to size chart in PDP. Following is my install script and config.xml file. My attribute is created in eav_attribute table but it is not ...
1
vote
0answers
52 views

Substitute existing Customer EAV Attributes

In a Magento CE 1.7.0.2 shop I have custom EAV attributes for customer and customer addresses (eav_entity_type 1 and 2), such as: name_one name_two name_three telephonetel instead of the standard ...
0
votes
2answers
2k views

Remove last name in billing address?

I am using Magento1.9 I followed below mention step after that i got error message UPDATE eav_attribute SET is_required = 0 WHERE attribute_code = 'lastname' /app/code/local/Mage/customer/Model/...
0
votes
1answer
164 views

EAV collection problem with Customer entity

(Magento CE V1.7.0.2) I have a problem with the customer data collection, I can't have any "telephone" number. I must remove the line ->joinAttribute('billing_telephone', 'customer_address/...
1
vote
1answer
340 views

Category Attributes, Setup Script and Flat Tables

I have created a setup script that creates new category attributes. It works quite well, however after the setup did run, the flat tables are missing the columns and when the Magento API creates the ...
2
votes
1answer
5k views

Custom Attribute and value not Appearing in Flat Product table if Attribute is not in…Product Listing,Product Listing,Layered Navigation

Basically I installed one market place module in my website......that have a validation attribute...but which is not ...Product Listing,Product Listing,Layered Navigation...so when I use Flat Product ....
2
votes
3answers
2k views

Create attribute option if not exists

How would i create a dropdown attribute option if it does not already exist for an attribute? For example, the following will not work correctly if the option values do not exist: $productColors = ...
0
votes
1answer
207 views

Eav Attribute update problem

I followed this article: http://inchoo.net/magento/creating-an-eav-based-models-in-magento/ I created the Inchoo Blog module, after the firt time it ran the controller code the situation on the ...
0
votes
2answers
1k views

Update EAV attribute value in custom admin module

I have a form container with save button . This is the method that the save button call. public function saveAction(){ $userId = Mage::getSingleton('admin/session')->getUser()->getId(); ...
0
votes
1answer
121 views

Get all attributes group of a specific resource model?

How I can get all attributes group name of a specific eav resource model?
1
vote
1answer
52 views

Eav_Model and Widget_Form

What is the quickest way to render the attributes of a Mage_Eav_Model_Entity_Abstract in Mage_Adminhtml_Block_Widget_Form?
2
votes
2answers
679 views

Mage_Eav_Model_Attribute_Data::factory() must be an instance of Mage_Eav_Model_Attribute

I'm facing this message in system.log when I open an oreder from the admin panel: MESSAGE: Recoverable Error: Argument 1 passed to Mage_Eav_Model_Attribute_Data::factory() must be an instance of ...
1
vote
1answer
6k views

how to find the customer custom attribute select box value table

i install the custom_attribute extension, in that i created a field name like "language" with multi select type, also there have a option to add the select box option values. i add this field into ...

1
4
5
6 7 8