Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [catalog]

It should be used for questions regarding the catalog module.

33
votes
8answers
14k views

Questions to expect in an interview for a Junior Magento Developer Position

Firstly I would like to say that I hope I am not posting in the wrong place with this question and if I am please advice me of where (if anywhere in the stackexchange world is appropriate) I should ...
33
votes
5answers
18k views

How to set a store ID on Mage_Catalog_Model_Resource_Product_Collection?

The task is trivial. I need to get list of products for particular store view with a flat catalog enabled. The most obvious solution is the following: $collection = Mage::getResourceModel('catalog/...
27
votes
4answers
64k views

Why Can't I Load a Product by SKU using loadBySku()?

Synopsis I wanted to load a product by SKU there are many articles, blog posts, stack overflow results etc. All I want to know is - why does it have to be so difficult to load a product by a SKU? //...
25
votes
3answers
19k views

where does is_salable come from?

Note: If you've been editing products by PHP code, then re-index them in the admin after, save your self hours trying to work out why they not showing like me below ... I am going round in circles ...
23
votes
3answers
23k views

Why and when to use “ Flat Catalog”?

While doing bit research for speed issue of magento website i got some links where people says enable "Flat Catalog" to increase performance and speed . Issue is that why it is not enabled by default ...
17
votes
4answers
23k views

How can I fix “Item (Mage_Catalog_Model_Product) with the same id ”xxx“ already exist”?

I have been getting this error when trying to filter a products collection Item (Mage_Catalog_Model_Product) with the same id "6058" already exist and wanted to ask what could ne causing the error ...
16
votes
2answers
18k views

When should I use the category flat table option?

As a follow-up to a previous question I would like to know: When should I use the category flat table option? While googling I found an advice to enable it "when you have very much categories". But ...
15
votes
3answers
10k views

Catalog rules daily update doesn't work

I face with problem that Magento's Catalog rules daily update doesn't work. This means that there are no products price changes when catalog rule's expire date comes, so I have to press rule apply ...
15
votes
7answers
4k views

Fatal Error in Admin Pages

I have magento 1.7 installed and it worked fine till now. I import products on daily basis. If there is any new manufacturer, I add it in drop down based Manufacturer attribute. Today, I have added ...
14
votes
2answers
6k views

Move out of stock products to the end of the catalog product list [closed]

I need to push out of stock products to the end of catalog list Please guide me how to solve this problem, or that file to dig so far I found Toolbar.php, and working around it
13
votes
5answers
12k views

404 on Store Switch with Product Store View Scoped URL Key

By default URL Key on product page is Global scoped. EDIT: As suggested by FlorinelChis the scope can be changes in Manage attributes. However this breaks the store view switcher behavior. This is ...
12
votes
2answers
915 views

Magento 2 - Use \Magento\Catalog\Block\Adminhtml\Product\Widget\Chooser with multiple selections?

Using this code $chooser = $this->_layout->createBlock('\Magento\Catalog\Block\Adminhtml\Product\Widget\Chooser'); var_dump(get_class_methods($chooser)); $configChooser = [ ...
11
votes
3answers
11k views

Find out to which categories a product belongs to

I opened a product in the backend, but when I switch to the categories tab, the category tree is fully collapsed. I would have to expand all categories to see in which ones the product is in. How can ...
10
votes
4answers
14k views

Hide Attributes and Other Fields in Product Edit Backend

To make editing of products (and maybe also categories) for the shop owner easier, we would like to hide some unnecessary tabs and fields from some users in the admin backend. This means: Hiding some ...
10
votes
2answers
1k views

Selling “big stadium” tickets

I want (need) to implement a stadium ticket selling. The idea is to let the customer choose his number of tickets (a capping on that might be needed but this is no big issue. I think I can achieve ...
10
votes
2answers
1k views

How to get product's price in all allowed currencies?

I have a setup with two store views. The first store view has base and the only one currency set to USD. The second one has 2 allowed currencies - USD and EUR. EUR is the default displayed one, USD ...
10
votes
3answers
3k views

Magento2 Product Listing - Show product options

I'm working on a new Magento 2 theme at the moment. For this theme I want to show all product options (custom options and options form configurable product) in the product listing. This way the user ...
9
votes
1answer
13k views

Parent category is showing products in subcategories, even though product was not assigned to parent category

Let's assume I have a category, Clothing and this category have a sub-category, T-shirts. Now I add a product to the T-shirts category (by checking the box in the add product screen), but I don't ...
9
votes
1answer
100 views

The _data of an EAV model

I understand that the _data of a simple model (e.g., cataloginventory/stock_item) is an array of field value pairs, which corresponding to the fields of database tables. I was curious to know the ...
9
votes
1answer
423 views

Full Page Cache Infinite Redirect

Full-page cache is turned on (Magento EE ver 1.14.0.1). However, some products are having redirect loop upon hitting the URL. No error in the logs. If I clear the full_page_cache, then it would now ...
9
votes
0answers
2k views

How to enable inline edit in catalog grid without changing source code?

I try to turn on inline edit in catalog grid as it described in DevDocs: http://devdocs.magento.com/guides/v2.0/ui-components/ui-secondary-inline.html Main problem is how to override this block of ...
8
votes
1answer
652 views

Magento 2 : what is use of _replica table in Magento_Catalog module?

As Magento releases 2.X version, I found _replica tables, particularly in the Magento_Catalog module may be for indexing the catalog data. I also notice that _replica is nothing but the duplicate ...
8
votes
1answer
17k views

Changing the Attribute Set for a Simple Product

Basically the subject. I have a simple product created with a particular attribute set. Is there a way to change the attribute set associated with this product without having to create a new one?
8
votes
1answer
13k views

Link for action column in custom grid

I have a custom grid which resembles the Manage Products grid in Catalog Menu. I need to get the corresponding action link to each entity item. How do i do that? My custom grid is declared in the ...
8
votes
3answers
2k views

Magento Google sitemap Generation

I have generate google sitemap through Magento adminpanel. I have set Product URL Suffix(html) and Category URL Suffix(html) in the configuration. This suffix are not showing in sitemap.xml. It ...
8
votes
1answer
1k views

Product page tabs disappeared in admin after trying to add a new product attribute

I just followed instructions in this link, in order to add a new product attribute. After that most of my product tabs disappeared. Here are my final codes: /app/code/local/MyCompany/MultiSlider/...
8
votes
4answers
3k views

Always show full URL including categories for product

For our Magento webshop (1.7.0.2), we're trying to optimize the URL structure. We've already managed to improve some things, but in one things we didn't succeed. We want to use a full URL (including ...
8
votes
2answers
4k views

Magento 2 : Catalog Product save after Observer Event

I have a custom multiselect field in Products edit section. The values in the multiselect values from my custom table. If I click on the save button in Manage Products section by selecting any one ...
8
votes
1answer
185 views

Mage_Catalog_Model_Product_Image::_checkMemory

Looking at slow requests in newrelic for a product listing page the top function called was Mage_Catalog_Model_Product_Image::_checkMemory() which does a bunch of stuff like checking the ini settings ...
8
votes
1answer
579 views

How to alter catalog_product_flat column types

A website I manage requires prices to have 5 decimals. I went ahead and modified at least a dozen file/tables altogether to be able to achieve this. But ('cause there's always a but) there seems to be ...
7
votes
4answers
2k views

Magento EE 1.13 catalog routing

UPDATE Below is the original question, and while it's related to what the issue ends up being, it's tangential. Please see the edits starting with number 2 for more useful background information On ...
7
votes
4answers
992 views

Get Categories of Products on Special Offer

How can I get the list of categories of all the products on special offers. It's a bit tricky. I'm able to get the list of products using: $collection ->addAttributeToFilter( ...
7
votes
2answers
1k views

How to obtain catalog price rule expire date?

On catalog page I need to show offer "expires in N days". It can be easily achieved if each product has defined Special Price and date individually for example $this->getProduct()->...
7
votes
1answer
403 views

Error in Front End Product Creation?

I have adding product in front end. I get below error message. SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (magento....
6
votes
2answers
650 views

Magento 2: Difficulty in add simple product, product get added as virtual product

HI I am trying to add product in magento 2 from the admin panel. But product is added as the virtual product even if I select the simple product when adding new product. Please help me to solve this ...
6
votes
4answers
10k views

Catalog Price Rules conditions not working

When I create a catalog price rule everything works fine for a specific customer group. As soon as I add a category condition nothing works. Has anybody experienced this before? Conditions: ANY are ...
6
votes
1answer
7k views

Is it possible to delete root category?

Is it possible to delete an empty root category once accidentally created or not required anymore. It looks like there's no "Delete" button.
6
votes
2answers
5k views

Check if product has catalog price rule

I need to check if a product has a catalog price rule and if it has, it needs to display a specific div. So I need something like: <?php if catalog price rule : ?> <div> Text </div>...
6
votes
2answers
480 views

why magento doesn't enable flat model by default?

we can see that the following two options at system > configuration > system > catalog 1.Use Flat Catalog Category 2.Use Flat Catalog Product it is clear that the flat model reduces the ...
6
votes
1answer
3k views

how does magento check if a configure/grouped product is out of stock in the catalog/search

in the setup of magento i have i have set backorders to be on but i only needed them on so that out of stock items could be added to the cart from an order editor i've been making changes to magento ...
6
votes
2answers
18k views

How to get a product value attribute from attribute id?

I need to retrieve product attribute value based on the attribute id, here's how I get the id and label for each attribute $attributes= Mage::getResourceModel('catalog/product_attribute_collection')-&...
5
votes
2answers
423 views

Custom Tab on Adminhtml Catalog Product New Page Appearing In Two Places Instead of One

I'm trying to add a custom tab to the new product page in the admin panel. The first block added my tab successfully to the product edit page. The second block definitely does add the tab to the new ...
5
votes
2answers
14k views

Multiple configurable products as a bundle

We have many products that we sell in different sizes. We have set up 1 configurable product and linked all the simple product sizes. But now we wish to set-up a bundled product that consists of a ...
5
votes
2answers
4k views

Magento 2 table name for product visibility

In which db table magento is saving the product's visibility such as catalog/search , catalog, search, Not visible.
5
votes
2answers
3k views

How to make products-per-page setting reset to default on pageload

I have tried modifying getLimit() in the file Mage_Catalog_Block_Product_List_Toolbar, but that didn't seem to change anything. Is this even possible?
5
votes
2answers
4k views

do catalog price rules carry over when added to the cart?

I have a catalog price rule - which appears to look correct when viewing the products in the catalog. however, when I add to the cart - the price goes back up to the full amount. Is this price rule ...
5
votes
1answer
114 views

Is Magento2 EE a right solution for 100M of products?

We are in the middle of our decision making process to go with Magento2 or develop our own solution. We have around 90M products and want to know if Magento2 EE is a right platform to support this ...
5
votes
2answers
1k views

How to filter loadedProductCollection to show out of stock products within a specific period?

I have a huge catalog and I've enabled "Display out of stock products" to show the out of stock products too in the listing page. Since my catalog is huge and 80% of the products are out of stock, I ...
5
votes
1answer
5k views

Redirect back to previous page only on successful login

I am trying to show catalog prices only to logged in users. Following snippet works however it has two issues: if(!Mage::helper('customer')->isLoggedIn()) { Mage::getSingleton('customer/session')-&...
5
votes
1answer
3k views

field of type link in admin form is not rendering value

My class extends from Mage_Adminhtml_Block_Widget_Form, which has declaration for _prepareForm method with code for myfield as follows $fieldset->addField('myElementId', 'link', array( '...