Questions tagged [catalog-rules]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
25 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
18 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
10 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
12 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
10 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
38 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
35 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
78 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
24 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
0answers
69 views

Magento 2 how to get matching product id's from condition serialize of catalog rule

I would like to get matching product id's from condition serialize value of catalog rule. Let's take an example to explain in brief. For Eg. i have a condition serialize value like below. {"type":"...
0
votes
0answers
9 views

Add “Update Attributes” Field

I wanted to add a value to in the bulk product catalog "update attribute" tool. I have a editable product attribute called "Categories". But when I go the "Update Attributes" option in the product ...
0
votes
1answer
137 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
213 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
215 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
2answers
415 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 ...
0
votes
0answers
20 views

Catalog Rule - Discount price application

What is the exact location where discount is applied ? How can we markup the discount price ? Are negative values acceptable in discount price ? If we want to set negative values and increase ...
0
votes
0answers
20 views

Apply coupon to only non discounted or non sale products

I need to apply coupon to only those product in a cart on which catalog price rule is not applicable, when there are more than 1 products in cart. As currently when I apply a coupon code it applies ...
1
vote
0answers
224 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
248 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 ...
2
votes
0answers
26 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 ...
0
votes
0answers
23 views

magecatalogrule database tables automatic copies

I have a Magento/2.2 (Community) which is creating every about 30 minutes a copy of magecatalogrule_* database tables. In the last hour: 09:36 magecatalogrule_group_websitebda17fbb 09:36 ...
0
votes
0answers
35 views

Magento 2 catalog rule markup price

I'm trying to achieve a positive "discount" so I could have a base price, and percentage markup prices based on client groups. For ex. base price: 100$, default client group: +20%, another client ...
1
vote
1answer
558 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
362 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
139 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
178 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
76 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
69 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
472 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
23 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
346 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
156 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
38 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
297 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
631 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
119 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 ...
0
votes
1answer
393 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
222 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
63 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
135 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
153 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
240 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
174 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 ...
3
votes
1answer
633 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
979 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
89 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
238 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 ...
1
vote
1answer
47 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
786 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('...