Questions tagged [eav]

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

Filter by
Sorted by
Tagged with
2
votes
0answers
171 views

How enterprise magento2.1 stores product attributes with schedule updates? (row_id)

In Magento2.1 enterprise, schedule updates has been introduced, which changes the table schema of product & other cms page. Take product attributes as example, a column "row_id" has been added to ...
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
338 views

Why so many tables for single entity in EAV model [duplicate]

In magento EAV model, I want to know why we need to create so many tables depending upon data type? And, how we going to use it?
18
votes
2answers
73k views

How to get attribute “option label/attribute text” having “attribute value” (option_id)?

Suppose I have an attribute that is a collection of option (dropdown/multiselect). I can retrieve the attribute value for a given product: $store_id = [something]; $productId = [something]; // this ...
3
votes
2answers
307 views

How to add custom entity from admin in magento

I am working on a project where I need to add a custom user from the magento admin panel. This user cannot purchase the products. He can only login to his section and write reviews on products or ...
2
votes
1answer
304 views

Is the EAVCleaner Extension safe to Use on my Magento installation?

Project GitHub Repository: https://github.com/magento-hackathon/EAVCleaner Has anyone used these cleaners before? I think this application is excactly what we need, but I am unsure how to know for ...
6
votes
2answers
8k views

How can I add customer attribute in Magento 2?

Note: The question was referring to magento2-dev-beta and the code for setup scripts is not the same anymore in Magento 2.x. I'm playing with Magento 2 and I'm stuck in adding attribute for customer ...
2
votes
0answers
67 views

Non default store_view's product attribute value is not visible on frontend (product list) if store_view 0 EAV value is missing

Scenario: A Magento 1.7 store which has NO default values at all for some product attributes (like short_description). There is no entry in catalog_product_entity_text for store_view==0. (Even NO ...
1
vote
2answers
6k views

Magento2 Upgrade Data script for custom module

I am working on installer and upgrade script of Magento 2 In which my InstallSchema, UpgradeSchema and InstallData scripts are working but UpgradeData.php is not working. Please check the following ...
0
votes
1answer
1k views

How to solve Fatal error: Class 'Mage_Eav_Model_Entity_Setup' not found in /includes/src/Mage_Core_Model_Resource_Setup.php error

Yesterday I changed my index.php file to make it available to the specific IP addresses written in the Developer options of the Admin Panel. I changed if (file_exists($maintenanceFile)) { to ...
2
votes
1answer
412 views

Prevent saving the default value for category attribute

My module adds a custom dropdown attribute to categories. This attribute has many possible values, but in most cases (~90%) users will leave the default value in the attribute's field. I want to make ...
1
vote
1answer
371 views

how magento stores product details in multiple websie store?

how the product details are stored for each store and website? is magento clones product details for every store, websites separately OR it done by field values of the product tables. because we ...
8
votes
2answers
1k views

Why attributes of bundle items of a bundle product are also saved to the bundle product itself? (database-wise)

Recently I was studying how the options of the layered navigation filter on the category page are determined and retrieved. I have dug a bit into the models and database for it, and there I found the ...
0
votes
1answer
200 views

Can virtual types be used as source models for EAV attributes?

I'm creating my own EAV entity and one of the attributes of my entity has the type select so it requires a source model. But I don't want to create my own class just for this attribute since I already ...
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
1k views

Magento direct SQL query for coupon based orders?

I am trying to write a SQL query for Magento that will show orders which were paid (non-zero total) and those which were coupon based (zero total). The Coupon-based orders should be divided by the ...
2
votes
1answer
366 views

Removing an EAV entity

I'm creating a CRUD module for Magento2 with an EAV entity. My first step is to install and uninstall the module. My EAV entity is similar to products, categories and customers. The install script ...
21
votes
2answers
1k views

Magento Each New Invoice Increment Id Increment By 5?

I need to increment each new invoice id by 5, i have tried below code. But changed all invoices, shipments, orders and credit memos. I need each new invoice id increment by 5, shipments increment by ...
0
votes
1answer
436 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" ...
1
vote
1answer
1k views

How Can a product model get its eav Attribute in Magento 2

I added a custom field to product in admin panel named vendor_name So I wanna get value of this field by do something like $_product->getVendorName() Like what I can do with non eav attribute (...
1
vote
0answers
335 views

How to inject EAV attribute to product model before loading it in Magento 2?

I want to always add a specific EAV attribute to the Product model whenever a Product model is loading. As an example, I always want to include vendor_name and brand_name EAV attributes to my ...
2
votes
1answer
408 views

Customer address attributes of type datetime and decimal cannot be cleared from the admin

I have added custom datetime and decimal attributes to the customer address entity using update scripts such that they can be edited via the admin. Although it is possible to add or update the ...
2
votes
6answers
18k views

How to retrieve full customer name with SQL?

Can anyone provide an SQL command that retrieves a customer's first and last name in one row? All my attempts at JOINs have resulted in multiple rows, with first name in one row and last name in the ...
2
votes
0answers
713 views

How to set input renderer on attribute for custom entity?

I'm trying to use an input renderer for a text attribute in my custom entity, however it doesn't seem to be working. I'm creating my ambassador entity in my setup file like this: <?php /* @var $...
7
votes
3answers
6k views

What are entities in Magento 2?

Entities in Magento 2 are like: Product is an entity? Order/Sale is an entity? Customer/Users/Clients is an entity? etc?? Where can I find a list of all entities? Are they declarated in the DB? For ...
0
votes
1answer
47 views

Convert flat module to eav module [closed]

I have a flat module on my site, which doesnt have store view switcher on add/edit page. I want to enable store view switcher on these pages so i tried to add a field using tabs ( admin html ) but it ...
1
vote
1answer
375 views

Eav Model relationship

I am trying to create an eav attribute model. I create one for blog its working good as long as it has individual entity. Now my question is how I can implement relationships using eav model. for ...
1
vote
0answers
106 views

Magento2 and custom entity options

I'm trying to add a custom attribute to order entity. I managed to add a column to sales_order, but I cannot save any value while placing the order. I tracked down the problem in: Magento\Framework\...
0
votes
2answers
1k views

Get attribute option value from option_ID [duplicate]

I'm getting the child products of a configurable product through this code $childProducts = Mage::getModel('catalog/product_type_configurable') ->getUsedProducts(null,$...
1
vote
0answers
627 views

Invalid entity_type specified: opco_planner_theme

I try to create EAV planner module. I am getting this error "Invalid entity_type specified: opco_planner_theme". All i want to understand why. class Opco_Planner_Model_Resource_Theme extends ...
2
votes
1answer
134 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 ...
2
votes
6answers
3k views

Attribute is not loaded on Product_List and Layered Navigation

I have a development system, here is everything working as expected. And I have a staging system, here the attribute is not loaded. It feels like, the sytem don't know, that the attribute doesn't ...
2
votes
0answers
675 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
49 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
309 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
1answer
2k views

Alphanumeric order increment id's

I've been using Alphanumeric order increment id's since ~CE 1.1 - they're all set up using an alpha character in the prefix field of core_entity_store. At the time there was no real documentation ...
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. ...
2
votes
1answer
214 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 ...
2
votes
1answer
733 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/...
0
votes
1answer
415 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
185 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 ...
1
vote
2answers
206 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 ...
2
votes
1answer
618 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 ...
5
votes
1answer
4k views

Magento2 Create eav_attribute for catalog

I'm trying to understand how magento2 is creating attributes in initial installation and using this I'm trying to create my own attribute. For example I'd like to create duplicate of thumbnail ...
0
votes
2answers
138 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
470 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 ...
1
vote
2answers
312 views

Adding parent_id attribute value in model

I have created a module and EAV tables for that. Module's tables are very similar to customer_Address entity and i have defined Attribute AttrA, AttrB and AttrC for this table. So table structure is ...
3
votes
3answers
5k views

Change increment customer ID from 1 to 00001 with zero padding

Is there a way to change the customer ID to start with 00001. Now it's just 1. I need this for importing into a different system. So each customer number starting with 00001, 00002 and so on...
0
votes
1answer
444 views

Proper method of adding column to table? [duplicate]

I am extending promo coupon labels so that I can define a failed label that would display when coupons fail to apply. So far I have been able to add the fields using: class ...

1
4
5
6 7 8