API to get Item Price - Applying Price Rules

Sachin_Mane · June 27, 2017, 5:57pm

Hi,

Is there any Remote API available to get Item’s final price after applying all the Pricing Rules. There could be multiple price rules - based on Item or based on Customer.

I am looking for an API, which when called will understand the context in which the call is made (Customer, Item, Customer Group, Item Group etc) and return me a price for the item.

I am planning to put this price in a custom Shopping Cart App. I need to have different prices for different customers and planning to use ‘Pricing Rule’ feature.

I tried using - erpnext.shopping_cart.product.get_product_info API, but it seems it is returning only the standard selling price. The pricing rules are not applied.

Appreciate any help in pointing to right API.

saurabh6790 · June 28, 2017, 5:50am

Try with apply_pricing_rule

github.com

frappe/erpnext/blob/master/erpnext/accounts/doctype/pricing_rule/pricing_rule.py#L79


      
          				throw(_("{0} can not be negative").format(field))
          
          
	def validate_max_discount(self):
          		if self.rate_or_discount == "Discount Percentage" and self.item_code:
          			max_discount = frappe.get_cached_value("Item", self.item_code, "max_discount")
          			if max_discount and flt(self.discount_percentage) > flt(max_discount):
          				throw(_("Max discount allowed for item: {0} is {1}%").format(self.item_code, max_discount))
          
          
	def validate_price_list_with_currency(self):
          		if self.currency and self.for_price_list:
          			price_list_currency = frappe.db.get_value("Price List", self.for_price_list, "currency", True)
          			if not self.currency == price_list_currency:
          				throw(_("Currency should be same as Price List Currency: {0}").format(price_list_currency))
          
          
#--------------------------------------------------------------------------------
          
          
@frappe.whitelist()
          def apply_pricing_rule(args):
          	"""
          		args = {
          			"items": [{"doctype": "", "name": "", "item_code": "", "brand": "", "item_group": ""}, ...],

Bhaskar · December 10, 2017, 9:43pm

@Sachin_Mane Were you able to use this? I have tried but not getting any result.

Sachin_Mane · December 28, 2017, 9:33am

No. We switched from Pricing Rule to Price List and developed a custom API to get items with correct price list applied.

shivnamha · June 9, 2019, 2:29am

Could you share more information. We are also currently facing challenge with eCommerce Cart reflecting regular price for alll pieces of item in Cart total instead of some at pricing rule as per Max qty set while other qty should be at price list rate.

markgates · September 20, 2020, 4:46pm

Hi, Could you share the solution if you solve this issue as I’m facing the same

mohityadav · March 22, 2021, 3:50pm

Hi,can you share on how to achieve this