Questions tagged [catalog-rules]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
15 views

Will category discounts double if items are in multiple categories?

If I set up a catalogue discount for 40% off the women's category and 40% off the sale category, will items that live in both the women's and the sale category end up at 80% off? What is the best way ...
0
votes
0answers
16 views

Magento 2 Catalog rule can not applied after reindex automatic

I wrote the code for creating a Catalog rule in Magento 2.3.5 and after saving I have the code to re-index it automatically. /** @var \Magento\CatalogRule\Model\Rule $model */ $...
1
vote
1answer
109 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 ...
0
votes
0answers
9 views

How to show tier price in a configurable produtct in Magento 2 product list?

I added the product tier_price below the product price on the catalog page, like this: But I noticed that when it is a configurable product, composed of other simple products, tier_price does not ...
0
votes
0answers
15 views

Magento 2 How to create product rule condition on Category Edit Page

How to create and save rule condition product on category edit page admin.
0
votes
0answers
22 views

How to add extra price in product base price?

I want to add extra price on product base price and all Magento default calculation working on this. Like the product, price is $100 and add extra price $20 then tax, catalog rule calculation will ...
0
votes
0answers
12 views

magento 1.9 Catalog Price rules are not carried over to the shopping cart and checkout?

i'm having troubles with catalog price rules.i have a rule for a catalog product- which appears to look correct on product. Product have many option and difference price. When i add product to cart, ...
1
vote
0answers
17 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 ...
0
votes
0answers
34 views

Magento 2 Commerce Cloud catalog price rule

Can anybody explain to me how Catalog rules working for an item in Magento 2 commerce cloud edition? I cannot see the start/end date while creating a rule. also when I create this rule ...
0
votes
0answers
197 views

Programmatically Apply Catalog Rule Not update product price in tables - Magento 1.9

I have a catalog price rule whose one condition is short_description contains Discount word. For the rules having contains condition with flat catalog enabled system we need to disable flat catalog ...
0
votes
0answers
12 views

Magento 2 Catalog rule Reindex Fail `Unknown column 'at_sku.store_id'` in 'on clause'

I am having this error when running php bin/magento indexer:reindex SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_sku.store_id' in 'on clause', query was: SELECT e.*, at_sku.sku FROM ...
0
votes
0answers
21 views

Optimizing the catalogrule_product_price indexing

We have a situation where catalogrule_product_price table has around 13 000 000 rows. Indexing it takes a lot of time and the main goal is to speed it up and leave more resources for the server. Major ...
0
votes
0answers
13 views

How i can create custom magento marketing rule's module in magento 2.3

any resource is available for creating custom marketing rule module in Magento 2.3 Thanks in advance
0
votes
1answer
98 views

Add customer attribute to catalog price rules in Magento 2

I need to extend the functionality of Magento Catalog price rules. I want to be possible to have a rule or a field to have the possibility to select the country where the rule should apply. So ...
0
votes
3answers
40 views

Magento2 - Email Marketing Question

We are launching a new e-commerce store soon. When a customer placed an order for first time then we want to give a unique coupon code to customer. In Magento we have option for cart rules and ...
0
votes
1answer
227 views

Magento 2: Catalog Rule Collection -> filter by store

I have the following block of code that gets all active catalog rules: $catalog_rule_collection = $objectManager ->create('\Magento\CatalogRule\Model\RuleFactory') ...
1
vote
0answers
30 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 ...
0
votes
1answer
301 views

Magento 2.3.X: GraphQL does not reflect catalog rule discounts

I'm using Magento 2.3.2. I've successfully completed all cart-related tasks (create cart, add a product, select shipping& payment methods, and place the order) using GraphQL. GraphQL seems not ...
0
votes
0answers
498 views

Magento 2 custom catalog condition rule not saving in custom module

I have added custom catalog conditions to my custom module admin form. a condition drop-down is displayed fine and in post data, condition value is also getting. but I am unable to save condition ...
0
votes
1answer
378 views

Magento 2: Catalog rule not apply on product special price

I have tried to apply Catalog Rule on product but this discount rule is not applied which product have already special price and tier price. so is this default magento behaviour of its bug or any ...
1
vote
3answers
932 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
0answers
274 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
602 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 ...
3
votes
0answers
42 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 ...
2
votes
1answer
29 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 ...
1
vote
1answer
763 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
614 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: ...
0
votes
0answers
165 views

How to implement “Uses Per Customer” in Catalog Rules?

How can I implement "Uses Per Customer" functionality (Same Like Cart Price Rules) in Catalog Rules? Say for example. If I enter 3 in Uses Per Customers. Catalog Price rule has to apply only 3 times ...
1
vote
0answers
219 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
103 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
73 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
1answer
667 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
0answers
24 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.
0
votes
1answer
495 views

Magento 2.3 - event when catalog price rules are applied

I am working in a module which extends catalogrule feature In this module, we apply some changes to price calculation process. Right now, it is working when a product is saved in admin. We have ...
0
votes
1answer
169 views

Not able to apply free shipping method when selecting custom customer group

I have created a new custom customer group, then i created a new cart rule to apply free shipping & assign that rule to new custom customer group. When i go to checkout page i am not getting Free ...
0
votes
1answer
40 views

Catalog Price Rule in Percentage in group Product

i want to add percentage in magneto2 catalog rule on list page show price i want to show percentage.
3
votes
1answer
467 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 ...
1
vote
1answer
850 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.
5
votes
1answer
126 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
vote
1answer
511 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 ( ...
3
votes
1answer
264 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
vote
1answer
66 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. ...
0
votes
1answer
146 views

It is possible to run the reindex of a single catalog price rule in a module controller for example?

The idea behind it, is some how keep a track of what's catalog rules are indexed. If i can run the index of a single rule in a module i can then save some logs and also do them in blocks of 10 for ...
0
votes
1answer
162 views

Magento 2 page gets hanged during adding New Catalog Price Rule Condition

Magento 2 page gets hanged during adding New Catalog Price Rule Condition What I am trying to do is: Open Marketing->Catalog Price Rule->New Catalog Price Rule. When I add a condition like : "...
0
votes
2answers
307 views

Catalog Price Rules: "Stop Further Rules Processing' (not cart rules) - how does this work? M1

Catalog Price Rules: "Stop Further Rules Processing" (not cart rules) - how does this work? So, How does "Stop Further Rules Processing" work? does this work in product level? set a flag: stop ...
0
votes
3answers
212 views

Magento 1.9 : Error getting collection Model of Catalogrule

I try to get a collection of Mage::getModel('catalogrule/rule') but when I do Mage::getModel('catalogrule/rule')->getCollection() I have an error because can't call a function of boolean. I do a ...
4
votes
1answer
682 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
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 ...
2
votes
0answers
102 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 ...
6
votes
1answer
293 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 ...