Questions tagged [catalog]

It should be used for questions regarding the catalog module.

Filter by
Sorted by
Tagged with
34 votes
5 answers
21k 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/...
Tim Bezhashvyly's user avatar
33 votes
7 answers
15k 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 ...
develophper's user avatar
  • 2,214
32 votes
3 answers
28k 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 ...
Hayden Thring's user avatar
31 votes
5 answers
76k 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? // ...
Ash's user avatar
  • 1,746
27 votes
4 answers
33k 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 ...
mdeveloper's user avatar
20 votes
3 answers
20k 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. ...
Softec's user avatar
  • 2,065
20 votes
4 answers
27k 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 ...
user1704524's user avatar
  • 2,483
16 votes
3 answers
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 ...
vovsky's user avatar
  • 163
16 votes
2 answers
19k 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 ...
Celldweller's user avatar
15 votes
7 answers
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 ...
sunlight's user avatar
  • 151
14 votes
2 answers
9k 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
Alexandr Sopkov's user avatar
14 votes
2 answers
2k 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 = [ ...
Gianni Di Falco's user avatar
13 votes
1 answer
4k 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 ...
sandip's user avatar
  • 4,004
13 votes
5 answers
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 ...
Fra's user avatar
  • 6,965
13 votes
3 answers
6k 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 ...
Silvan's user avatar
  • 1,347
13 votes
1 answer
5k 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 described in DevDocs: http://devdocs.magento.com/guides/v2.0/ui-components/ui-secondary-inline.html The main problem is how to override this block of ...
user50138's user avatar
  • 296
11 votes
3 answers
12k 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 ...
Alex's user avatar
  • 13.8k
11 votes
1 answer
16k 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 ...
ProcessEight's user avatar
  • 1,000
10 votes
4 answers
17k 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 ...
Alex's user avatar
  • 13.8k
10 votes
2 answers
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 ...
Marius's user avatar
  • 198k
10 votes
2 answers
3k 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 ...
Jan Petr's user avatar
  • 339
9 votes
1 answer
14k 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 ...
basha's user avatar
  • 167
9 votes
1 answer
133 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 ...
MengT's user avatar
  • 193
9 votes
1 answer
515 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 ...
user1240207's user avatar
  • 1,339
8 votes
2 answers
14k 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.
user43415's user avatar
  • 375
8 votes
1 answer
18k 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?
Karlson's user avatar
  • 747
8 votes
4 answers
6k views

Magento 2 reindex gives error Duplicate entry

I am experiencing an issue which not sure why when I try to reindex it gives the error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4458-142-1-1293-4458' for key 'PRIMARY',...
Juliano Vargas's user avatar
8 votes
3 answers
3k 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 ...
VijayS91's user avatar
  • 1,788
8 votes
4 answers
4k 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 ...
Niels's user avatar
  • 1,406
8 votes
1 answer
2k 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/...
chamich's user avatar
  • 443
8 votes
2 answers
12k 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 ...
Vindhuja's user avatar
  • 1,395
8 votes
1 answer
214 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 ...
FlorinelChis's user avatar
  • 2,900
8 votes
1 answer
1k 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 ...
Julien Lachal's user avatar
7 votes
4 answers
37k views

Get category collection from specific store

With flat tables turned off, how can I get a category collection from a specific store view ? I have tried the following: Mage::getModel('catalog/category')->getCollection()->setStoreId(3); ...
Marty Wallace's user avatar
7 votes
4 answers
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 ...
mpw's user avatar
  • 1,050
7 votes
1 answer
6k views

how to add an image programmatically from any url in Magento 2?

I try this code but if the image doesn't exist in this path pub/media/catalog/product; it doesn't work. I want to add an image from any url; any ideas for that ? for ($i = 0; $i < count($...
Jack's user avatar
  • 71
7 votes
2 answers
1k 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 ...
Nitin Pawar's user avatar
  • 1,546
7 votes
4 answers
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( ...
Yehia A.Salam's user avatar
7 votes
2 answers
2k 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()->...
Nazariy's user avatar
  • 201
7 votes
1 answer
409 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....
V-jay's user avatar
  • 153
6 votes
3 answers
453 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 ...
Black's user avatar
  • 3,330
6 votes
1 answer
9k 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.
user1866453's user avatar
6 votes
2 answers
7k 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>...
JGeer's user avatar
  • 1,418
6 votes
3 answers
18k views

Magento 2 : How to Add quantity increment & decrements button on product details page

How to add increment(plus +) and decrements(minus -) qty button on product detail page?
Chirag Patel's user avatar
  • 6,126
6 votes
4 answers
11k 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 ...
Paul Rose's user avatar
6 votes
2 answers
21k 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')-&...
Idham Choudry's user avatar
6 votes
3 answers
677 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 ...
mano's user avatar
  • 366
6 votes
1 answer
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 ...
Memor-X's user avatar
  • 686
6 votes
3 answers
5k 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 ...
Will's user avatar
  • 71
6 votes
4 answers
2k views

Best practice to connect Magento 2 to price/product service

I have my own price/product service that I need to connect to Magento. The service has a variable amount of products with very variable prices. The price can change with every request a customer makes....
steros's user avatar
  • 1,622

1
2 3 4 5
22