A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [catalog-price-rules]

Denotes questions related to Catalog Price Rules (management, creation, configuration) on Magento.

Filter by
Sorted by
Tagged with
1
vote
0answers
74 views

Magento catalogrule: how to have prices ready and showing at midnight exactly?

Magento catalogrule: how to have prices ready and showing at midnight exactly? I've two catalogrules in my Magento ver. 1.9.2.1 shop: Already started, has and end_date of today (so: it is effective ...
0
votes
0answers
327 views

Get catalog rule by customer group id Magento 2

I would like to get the catalog rule using a customer group id. I cant seem to find a method for it. How would I go on about doing this in Magento 2?
12
votes
1answer
620 views

Magento2 : Create Custom Condition Field like Catalog Price Rule with my Own values

In Magento 2 Custom form i would like to add condition field like Catalog Price Rule with my custom values. Please find below screen shot. Screen shot: please suggest me how to get.
0
votes
1answer
38 views

1.9 - Shopping Cart Price Rule - Buy any x + y + z Reduce total price to $399

Could anyone please help me to setup up below price rule? Apply if any category1 + category2 + category3 + category4 in cart. Reduce total price to $399. Quick reply will be much appreciated.
0
votes
1answer
79 views

Using cart rules (coupons) in addition to catalog rules

When running a catalog rule we are finding that customers can still use coupons that get added in addition to the catalog discount already applied. We have the discard subsequent rules turned on for ...
1
vote
1answer
151 views

Extra 25% of site wide even to discount prices

How do I(on Magento 1.9) add a global price rule which is adding an additional 25% discount to all products, even the ones which already have a discount
0
votes
1answer
114 views

how to show multiple discounts for same product Magento 1.9.3.3?

There are same products which are new and some of them have discounts depending on their state of usage. So, for 1 week used product get 5% discount, and 2 weeks 10% etc. Obviously it's the same ...
4
votes
0answers
880 views

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

I am working on extension in which i have add sales rules conditions in my ui form. I am storing as serialised condition. it saves perfectly. However, i am getting empty field during edit form. This ...
0
votes
2answers
424 views

Page for all items with a catalog price rule active

I have 5 catalog price rules that affects 3-4 categories each, they are applied one each day of the week (say: on monday we have cat 3 and 6 on sale, on tuesday it's cat 5, on wednesday it's 7, 10, 11....
2
votes
1answer
292 views

magento 1.9 catalog price rules disappear in view page overnight

I am running Magento 1.9.3. I made a price rule to give all customer group 25% off on all products, and date is 7/25/2017 to 8/31/2017. I click the button "Save and Apply", the prices of all products ...
1
vote
1answer
1k views

Magento 2 API - Get list of products with Catalog Price Rule

We are using Magento 2.1.7 and building some API endpoints to serve our need. Following is how we get Products list and send them as json from API call. <?php namespace Vendor\Customer\Model; ...
0
votes
1answer
74 views

Simple product of configurabile discount issue

I have the following situation: i have configurable product X which has the price let's say 50$. Now for this product X there are 3 simple products associated on the Size attribute, let's say A,B,...
1
vote
2answers
2k views

magento set “catalog price rules” *only* if special price was not set

I am looking at magento "catalog price rules" and although I have added the special_price to filter conditions: I dont think I can do the following question: How can I only apply the "catalog price ...
5
votes
0answers
601 views

Magento 2 : How can I add discount to a custom option

I have a product with custom options and a catalog price rule (that applies to a certain customer group). When your in this customer group (group X), you get a discount of 15%. This works for the ...
0
votes
1answer
778 views

Magento 1.9 Get price from catalog price rule to a SKU programmatically

In Magento, we can use $product->getSpecialPrice() to get the discount price which is set under product view. Is there a way to get the discount price for a SKU from Catalog Price Rule ...
0
votes
1answer
85 views

Cart Price Rules Help

I am trying to setup a cart price rule but I can't seem to get it working. I am on Magento CE 2.1.5 I offer 4 price categories of products (elite, premium,standard etc...). If you buy two of the same ...
1
vote
1answer
642 views

How to Apply the Coupon Code only to the products that are “Not on Sale” - [Without Special Price]?

My conditions are working fine when i check out with single product which is not having the special price, The same condition is working fine with the products has special price. So the problem is ...
1
vote
1answer
708 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('...
2
votes
1answer
988 views

How to add catalog price rule condition in magento2

I have added to custom module to add catalog price rule condition. how to Add Rule Condition in My custom module, I have also added Rule file and Condition. $renderer = $this->_rendererFieldset-&...
1
vote
1answer
161 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
1answer
675 views

catalogrule_product_price and catalogrule_product are empty

I am trying to apply catalog rule for 27% from 2 customer group but it's not applied after indexing and cleaning cache. So i debug the issue and found that catalogrule_product_price and ...
1
vote
0answers
38 views

Discount on products if selected from “Category A” but not from “Category B”

We have 8 products in "Category A" and same 8 products in "Category B". We want a functionality where when customer selects same product from CatB, they should get discount and not when they select ...
0
votes
1answer
462 views

Magento 2: Add cart price rule for unique customer

I'd need to create price rules for an unique customer, like: For certain products: General: 0% discount Retailer: 5% discount Wholesale: 10% discount Customer1: 20% discount Customer2: 22% discount ...
0
votes
1answer
39 views

Additional Pricing Fee for Split Carts

Hello to all the geniuses out there! After days of research and trials I find I am still looking for a resolution to my pricing problems on a large wholesale site. We sell 1000s of products that come ...
0
votes
0answers
381 views

Magento issue with dates for catalog price rule

I have set up a catalog price rule for my webshop, with a start date and a end date. Today is 21/04/2017. can someone explain to me why this setup (screenshot) is still working? I still have discount ...
2
votes
1answer
460 views

Magento : Catalog Price Rule Date Not Working Properly

I want to give some discounts for some products. Discount should start from a certain date, let's say 20/04/2017. This date is working fine if I use special price field in product management. But ...
2
votes
1answer
1k views

Magento 2 : What is The _flag Table in Database

I have a problem with Catalog Price Rules not being applied in my store. Some work and some don't. I have searched for solution, and I finally found one that I have never heard of before. Magento ...
0
votes
1answer
35 views

Current customer cart prices does not update after catalog price rules are inactive

Here's the problem: Logged in customer adds a product the cart that is on sale based on catalog price rules. The price rule goes inactive. Customer comes back the next day and the price in their cart ...
0
votes
1answer
542 views

i want to write custom sql query to select low and high price in magento2?

I want to write a custom sql query to find final price,min-price,max_price,special_price but i dont know in which file i suppose to write this code and execute? can anyone tell me where we can write ...
0
votes
2answers
64 views

Shopping cart rule

I'm using CE Magento 1.9.0.1, and i'm intending to do a promotion for a specific category. For instance, 2 products for $68.00 instead of u.p. S$90.00 I've tried to play around with the rules in ...
1
vote
0answers
42 views

Show special Price when swatch color for customer group

System: Magento 1.9.3.1 What we need: We want to show in the product view if the customer (who is grouped in 10% discount customer group) chooses white or black the special price. In our shopping ...
0
votes
1answer
93 views

Magento 2 : Buy X and get Y Free in custom module..How it set in admin and fronted?

Magento2 default in set Cart Rule get X qty get the Y free same logic in my custom module in the set but I was confused about which file in set code?
1
vote
0answers
75 views

Miss-match discount price with 2 catalog price rule magento 1.9

I have facing issues with catalog price rule. You can see below senario which you getting to help you. I have a product which have price $77.00, sku - product1 I create two Catalog Price Rule for ...
0
votes
1answer
248 views

multiple catalog rules with same price, calculate wrong final price

I have multiple catalog price rules on same product with same price but different priority, so i suppose that system will apply the lowest (0 is lowest) priority rule to calculate final price. Rule A:...
2
votes
1answer
2k views

How to make magento price reindexing and catalog rule apply process faster?

I am using Magento Community Edition **1.9.2.**4. Its a multi-store-webiste with 9 websites and 25 store views. At present the price re-indexing is taking 40 minutes. This causing issue when I ...
7
votes
1answer
3k 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\...
1
vote
0answers
456 views

Custom Product Attribute not applying in Promo Rules

I have a custom attribute set for my products named "item_category". I have set Use for Promo Rule Conditions to yes for the attribute, and it is displayed in the catalog rule as well. But the ...
0
votes
2answers
246 views

Discount on categories but how to exclude already discounted products

I need to discount some categories in a magento shop which is not a problem. But I would like to exclude already discounted items in shop that has been setup manually on the products. So I need a ...
1
vote
1answer
814 views

Catalog Price Rule - discount issue (possible rounding problem?)

SOLVED - see edit below I have a Product where the Price is £14.99. I have applied a Catalog Price Rule 50% off and the new price is showing as £7.00. I would expect it to be £7.49/£7.50. If I knock ...
0
votes
0answers
491 views

Catalog price rules are not working if I had the dates in the rules.

I am building an e-commerce website named bookslab.in. I had added the catalog price rule of 10% OFF, but it is not getting visible on frontend. I had tried a lot, change dates, tried different types ...
0
votes
1answer
200 views

Catalog price rule for all products with qty > 0

Is there a way to apply a catalog price rule to all products with qty > 0?
4
votes
5answers
4k views

Catalog Price Rule not applied / working in Magento 2 EE (v2.1.2)

After applying Catalog Price Rule, price did not change even though the schedule changes already started. But I can see the price change in preview mode only. checked in Magento 2.1.4 too Why ?
3
votes
0answers
173 views

Catalog Price Rules 'switching off'

Im using Magento ver. 1.9.2.4 CE I have few different Catalog Price Rules that are applied across customer groups which give 20%, 30%, etc off of products. The problem I'm having is that the rules, ...
2
votes
2answers
2k views

Show Grouped product price in catalog view as sum of associated products in grouped product

In my magento store majority of products are "grouped products". Right now when you go in category you can see the label under the product image says "Price starting at" and the lower price of two ...
3
votes
2answers
2k views

Catalog price rules work only on the catalog page, not in single product page, cart and checkout

I have Magento 1.9 I created a rule for discount 3 of my categories. Immediately the rules works perfect, I see that everywhere sould be. But after a few time (I tried, but I didn't understand how ...
1
vote
0answers
396 views

bundle product with fixed price and special price percent does not work with catalogue price rules

I have a bundle product with the following set: fixed price of $300 special price 90% When I create a catalogue price rule of 10% off all products I would expect the product price to be less than $...
2
votes
0answers
788 views

dot change automatically for comma into item description

Help to solve this bug or problem, into description item, the price change automatically Ex: my price is: $1,999.99 But after few seconds, the price convert comma for dot and dot for a comma: Ex: ...
2
votes
1answer
906 views

Magento 2 - product final price issue

If I try to print price and final_price from $_product in category page template (product/list.phtml), they have the same value despite the product is affected by a catalog rule. Why? How can I get ...
2
votes
0answers
380 views

Shopping card price rule NOT overriding catalog price rule

I'm having issues with the catalog price rules not applying the discount correctly and i have figured out that the shopping card rule does what i need to. Unfortunately even though i have the ...
1
vote
2answers
1k views

Catalog price rule doesn't apply if the date is set to today

I'm trying to set scheduled catalog price rules in my store. When applying a catalog price rule to my store it does not work when the starting date is set to the current day. It does work when I ...