Questions tagged [catalog]

It should be used for questions regarding the catalog module.

Filter by
Sorted by
Tagged with
34
votes
5answers
19k 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/...
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 ...
27
votes
5answers
67k 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? //...
27
votes
3answers
21k 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 ...
24
votes
3answers
25k 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 ...
18
votes
4answers
24k 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
14
votes
2answers
1k 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 = [ ...
13
votes
5answers
13k 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 ...
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 ...
10
votes
0answers
2k views

Magento2 : 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 ...
9
votes
1answer
1k 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 ...
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
105 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
434 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 ...
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
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
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
2answers
5k 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
193 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
619 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
2answers
2k views

Magento 2.3 use of `db_schema_whitelist.json` file in etc directory of each module

What is the use of db_schema_whitelist.json located in Magento Catalog etc directory? In Magento 2.3 version, I found db_schema_whitelist.json and db_schema.xml files, in the Magento_Catalog module. ...
7
votes
2answers
750 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 ...
7
votes
4answers
1k 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
3answers
140 views

How to keep products synchronized in two shops

How can I transfer all products from one shop to another after clicking a button? We have a shop which is a copy of our real shop. We need to keep the products, prices, etc. synchronized in both ...
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
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
19k 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')-&...
6
votes
3answers
558 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 ...
5
votes
2answers
457 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
6k 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
3k views

Displaying Regular Price without Tax

This relates to Magento 2.1.3. In final_price.phtml, when there is a special price, the regular price (or "old price") is also displayed. Currently, my shop is set to display prices Excluding and ...
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 ...