Questions tagged [catalog-rules]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
7 votes
1 answer
5k views

Magento 2 Create Catalog Price Rule Programmatically

I have used the below code to create catalog price rule programmatically. It creates the rule,but the conditions are not saved. $catalogPriceRule = $this->_objectManager->create('Magento\...
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>...
  • 1,504
6 votes
2 answers
4k views

Change Magento URL category Rules

I'm trying to modify URL-Category Rules, from Category Hierarchy-Oriented rules to Seo-Oriented rules. So i need to change URLs in this way. From: - Root-Category (URL: /rootcategory.html ) -- ...
  • 203
6 votes
1 answer
396 views

Magento 2: What is loadPost?

Today, I have reviewed the the catalog-rule modules and found the a method named loadPost on controller during save. I don't know how it works but it saved the rule data in serialized form in ...
5 votes
1 answer
141 views

Magento 2.2.5 : How to place a check on prouduct page on product attributes

How can we can place an if condition on proudct attibutes in a frontend .phtml file In front end .phtml which is associated with our handle in custom module layout catalog_product_view , we get ...
  • 1,712
5 votes
2 answers
10k views

Offering a free gift with purchase of a particular product type like (Buy X products Get Y Free)

We need to the ability to provide customers who purchase a particular product type (attribute type) a free type of gift with that product. The products offered as a free gift are associate products ...
4 votes
2 answers
1k views

CatalogRule not appearing in cron_schedule table

I am on Magento CE 1.9.0.1 I sat a Catalog Price Rule, saved and applied it, and it works correctly. Anyway, after a day it disappear. I understood the cron logic, and went to check the cron_schedule ...
  • 673
4 votes
1 answer
762 views

Catalog Price Rules "Apply Rule" button not showing

We have tried to create catalog rules with category condition and it's not working. Also, we are unable to see Apply Rule button. Please help
3 votes
1 answer
2k views

How to get the product collection based on catalog & cart price rules?

I am trying to get all products based on catalog price rules and cart price rules under all categories which is valid for today's date in Magento 2
3 votes
1 answer
10k views

Offering a free gift with purchase of a particular product type

We need to the ability to provide customers who purchase a particular product type (attribute type) a free type of gift with that product. The products offered as a free gift are associate products ...
  • 1,754
3 votes
1 answer
831 views

Magento2 catalogrule promotions, ability to choose price or special_price?

By default catalogrule promotions are applied to price field. Changing this was one classic request in most Magento 1 projects we have managed One approach could be to apply catalogrule promotions to ...
  • 3,353
3 votes
1 answer
694 views

Is there a way to use item weight in a Shopping Cart Price Rule condition?

I have a product that has two weights options, 1lbs and 2lbs. Is it possible to set a Shopping Cart Price Rule condition for only the 2lbs item?
3 votes
0 answers
93 views

Order of indexers

On a Magento 2.2.8 store, we have a Catalog Price Rule for customer-group offers. The indexers involved are set to update on schedule which is running successfully and not producing any errors. Most ...
  • 300
3 votes
1 answer
397 views

Magento 2 Catalog Rule Condtions

I am trying to implement Magento 2 catalog rule condtions in a custom module Ui Component form. Below is the field set: <htmlContent name="block_promo_catalog_edit_tab_conditions" sortOrder="20"&...
  • 1,712
3 votes
0 answers
498 views

Creating custom rules

I am trying to implement the following: The idea is to be able to filter products by the conditions which allow only product attributes. (I do not want the additional columns in the grid instead). ...
  • 145
2 votes
1 answer
1k views

Using Catalog Rules with Fixed Product Tax

A client has variable tax amounts per product therefore require the use of Fixed Product Taxes (FPT). We also require the ability to use Catalog Price Rules to apply discounts on the catalog. ...
  • 532
2 votes
1 answer
3k views

Catalog Price Rules applied to special_price

Currently magento is using the special price if its lower than the applied catalog price rule. => If the catalog price rule makes the product cheaper than the special price, then the catalog price ...
  • 3,985
2 votes
1 answer
539 views

Can you apply a category rule programmatically?

I've been using $product->getSpecialPrice() to build a custom price range on configurable products: Hat $3.50-$10.00 special price $2.00-$8.00 This works fine on the product page (templates/catalog/...
  • 343
2 votes
1 answer
36 views

Magento catalog price rule

How to get product based on conditions on catalog rule in magento2? By product model products are received but how to apply filter to get only those product based on conditions. Any help will be ...
2 votes
0 answers
119 views

Are catalog rules completely broken in Magento 1 with flat tables enabled? Or, how can these SQL queries ever work as intended?

I've discovered that some of the SQL queries Magento is using to generate catalogrule discounts are completely nonsensical, leading to products receiving discounts even though they should not. This ...
2 votes
0 answers
791 views

get final price of configurable super product with catalog rules applied

I'll try to explain it in details as it's quite tricky. Let's say I have configurable product X with price 10, and color variations red and green with fixed price +5 and -5. So the final price for ...
  • 120
2 votes
0 answers
147 views

Managing Prices [closed]

Hi to everyone! I have to create a new Online Store in Magento 1.9.1.1. For the type of Products, almost all the Products will be Configurable Products with a lot of Simple Products associated. The ...
  • 51
1 vote
3 answers
2k views

purpose of "Catalog Product Rule" and "Catalog Rule Product"

What exactly is the purpose of the "Catalog Product Rule" and "Catalog Rule Product" indexes? Which functionalities do they cover? I am just wondering, because there are often a lot of entries in ...
  • 668
1 vote
1 answer
1k views

Updation of product description from admin panel is not showing up in storefront in magento2?

We tried to update product description form admin-panel, but it's not reflecting in the storefront. Tried with reindexing, cache flush commands. It did not work.
  • 329
1 vote
3 answers
3k views

Magento 2 get catalog rule for current product

I would like to get the current catalog rule for the product on the product page. I want to be able to output the name on the page. I know this is possible in magento 1 but cannot find any function ...
1 vote
2 answers
5k views

How to solve Catalog Rule Product Status: REINDEX REQUIRED

How to solve Catalog Rule Product Status: REINDEX REQUIRED Hi, I have a problem in admin, One or more indexers are invalid. Make sure your Magento cron job is running. I am using cpanel in host. How ...
  • 47
1 vote
2 answers
2k views

Catalog Rule Round rule_price of catalogrule_product_price

How i can round rule_price from table catalogrule_product_price ? i try to change calcPriceRule from Mage_CatalogRule_Helper_Data, no results! have you an idea of what function save rule_price in ...
  • 161
1 vote
1 answer
4k views

Magento redis "read error on connection"

I'm getting redis cache issue on apply the catalog rules from backend. The error is "read error on connection". Can anyone suggest the solution?
  • 21
1 vote
2 answers
691 views

Magento 2 - Catalog rules cronjob stuck at working with increased number of backlogs

Catalog Rule Product, it always shows as working and and 735 in backlog Tried these but didn't work for me: Reindexing Changed state to "Update on Save" then revert back to scheduled Wait ...
  • 8,958
1 vote
2 answers
1k views

Magento 2 Edit Catalog Rule conditions in UI Form

I have created a UI form with field catalog rule conditions. The form loads display the conditions section and it is saved in the table. But in edit case the conditions are not displayed. Reference: ...
1 vote
1 answer
1k views

How to calculate product price based on custom action in Catalog Price Rules

I have added new action in catalog price rule. I have added this action through overriding below file. module-catalog-rule/Model/Rule/Action/SimpleActionOptionsProvider.php When this action is ...
1 vote
2 answers
790 views

Magento 2.2.5 : Save Catalog Rule Conditions

I am trying to save catalog rule condtions from my custom module, below is the array I get in my controller save.php [rule] => Array ( [conditions] => Array ( ...
  • 1,712
1 vote
1 answer
1k views

Get discount amount for customer group in magento

I have customer group id. I need to get sales rule for this customer group. And after that I want to get discount amount in % for this sales rule; $customer_from_session = Mage::getSingleton('...
1 vote
1 answer
175 views

Staging of Catalog Price Rules

I've met with a case. A customer placed an order with products that should be on a sale, but they are bought without a discount. As it turned out, he placed the order when catalogrule_apply_all ...
1 vote
3 answers
1k views

Which concrete job does reset catalogrule rules every day?

We have disabled catalogrule_apply_all Magento cronjob, because of multi-environment system (to simplify things: let's say we have 1 staging server & 1 production server) in one of our customer. ...
  • 3,353
1 vote
1 answer
2k views

Catalog Price Rule Not applying for all products

We are creating a catalog price rule mapping to a particular category. There are three different problems. The rule is applied only to certain products in the category and not the other products. The ...
  • 486
1 vote
1 answer
506 views

How to detect if a child product's parent has a catalog rule applied?

I'm trying to determine if a child products configurable parent has a price rule applied. I can get the correct price on the parent product by loading the parent, and then calling getFinalPrice(), ...
  • 343
1 vote
1 answer
87 views

Magento 2 override Catalog Price Rules to be able to increase the price

We are trying to extend the Catalog Price Rules to make it possible to increase the price of a small group of products. We have already tried to adjust the calculation in the file below, but this has ...
  • 31
1 vote
0 answers
44 views

To Show catalog price rule id applied on products in order API response

I have created a custom field named catalog_price_rule_id in sales_order_item. Now i need to get the catalog price rule applied on that orderitem; then i need to store that into the custom field and ...
1 vote
0 answers
44 views

Create a Programmatic attribute that detects product if it is Still On Sale or New

Scenario wanted: Lets say you have multiple products that is on sale till a specific date each product with its own time and you want to create a promotion condition rule for all these products under ...
  • 11
1 vote
0 answers
370 views

Add condition rule to collection product in Magento 2

I want to add condition rule in the collection product. How to do that. Hope someone help me.[![ public function getLoadedProductCollection() { $this->_limit = (int) $this->getWidgetCfg(...
  • 651
1 vote
2 answers
2k views

Get product applied price rule by product id in magento 2

Simply I want to get the rule_id or catalog rule details that is applied to a product in product details page and product listing page. I have checked with this function _getRulesFromProduct() from ...
1 vote
2 answers
1k views

Magento 2 how to check serialized conditions against product in frontend?

I have created an admin form which contains name and catalog price rule conditions. I have saved these values in a custom table. The conditions are saved as serialized. Now I want to check these ...
1 vote
0 answers
334 views

Magento 2.3.0 How to display only product attribute in custom rule condition into the custom admin form using the ui component

I have implement custom condition Rule to my custom module Take refrance from this link and it is working fine. But it is display also other rule like cart attribute, customer attribute, other ...
  • 5,916
1 vote
1 answer
147 views

Magento2 Apply catalogrule on final price instead original price

I have create catalog rule for all products by 50% if product has original price 100 special(final) price 80 then after apply catalog rule it reduce by 50(100%50). I want it 40(80%50).
  • 2,503
1 vote
0 answers
92 views

Catalog Rule Product indexer process unknown error

I am getting the following error : while running : bin/magento indexer:reindex Catalog Rule Product indexer process unknown error: Table status for `catalogrule_rule_cl` is incorrect. Can`t fetch ...
1 vote
0 answers
34 views

Magento 2: Catalog rules in custom ui form is empty on editing

I am working on extension in which I have add catalog rules conditions in my UI form. I am storing as serialized condition. It saves perfectly. However, I am getting empty field during edit form.
1 vote
1 answer
76 views

Memory exhausted error coming while creating catalogrule with category

I have around 50 categories. When I save the catalogrule without selecting the categories it gets saved correctly. But when I save along with selecting the category it display memory exhausted error. ...
  • 1,468
1 vote
1 answer
54 views

How to bring all customer attributes on CatalogRule?

I have requirement to show all customer attributes on Catalog price Rule Form. You can see attached image for more clarity. How i can get customer attribute collection and how i can display in ...
1 vote
1 answer
1k views

How to get the toDate of a catalog rule programatically?

$discounted_price = Mage::getResourceModel('catalogrule/rule')->getRulePrice( Mage::app()->getLocale()->storeTimeStamp($store_id), Mage::app()->getStore($store_id)->getWebsiteId(...