Questions tagged [catalog-rules]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
7
votes
1answer
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
2answers
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>...
6
votes
2answers
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 ) -- ...
6
votes
1answer
336 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
1answer
132 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 ...
5
votes
2answers
9k 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
2answers
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 ...
4
votes
1answer
708 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
1answer
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
1answer
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 ...
3
votes
1answer
621 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
votes
1answer
630 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
0answers
56 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 ...
3
votes
1answer
309 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"&...
3
votes
0answers
484 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). ...
2
votes
1answer
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. ...
2
votes
1answer
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 ...
2
votes
1answer
483 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/...
2
votes
1answer
30 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
0answers
107 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
0answers
786 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 ...
2
votes
0answers
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 ...
1
vote
3answers
1k 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 ...
1
vote
1answer
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.
1
vote
2answers
2k 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
2answers
4k 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 ...
1
vote
2answers
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 ...
1
vote
1answer
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?
1
vote
1answer
278 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 ...
1
vote
1answer
775 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
1answer
947 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
1answer
169 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
3answers
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. ...
1
vote
1answer
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 ...
1
vote
1answer
475 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(), ...
1
vote
0answers
19 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
0answers
33 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 ...
1
vote
0answers
296 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(...
1
vote
2answers
915 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
1answer
983 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
2answers
769 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
0answers
265 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 ...
1
vote
1answer
115 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).
1
vote
0answers
78 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
0answers
26 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
1answer
578 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
vote
1answer
72 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
vote
1answer
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
1answer
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(...
1
vote
0answers
20 views

Magento Catalog Rules not working after sometime [duplicate]

I have discount on products of particular brand(eg. nike) for logged in users. Its works fine when I click on Save and Apply but after some time it not shows discount price for products. I have ...