{"id":1774,"date":"2022-07-13T02:42:43","date_gmt":"2022-07-13T02:42:43","guid":{"rendered":"https:\/\/morecpq.com\/?p=1774"},"modified":"2022-07-20T17:14:38","modified_gmt":"2022-07-20T17:14:38","slug":"lookup-price-rule-not-working","status":"publish","type":"post","link":"https:\/\/morecpq.com\/index.php\/2022\/07\/13\/lookup-price-rule-not-working\/","title":{"rendered":"Lookup Price Rule Not Working"},"content":{"rendered":"\n<p>Is your Lookup Price Rule not working?  Sweet.  Below are some common reasons why.  \ud83d\ude42 <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>The API names of your lookup table, tested field, lookup field, target field values is wrong or the field doesn\u2019t exist.<\/li><li>You did not set a Lookup Table value in your price rule.<\/li><li>There are no lookup queries.<\/li><li>You have duplicate records in the custom object you&#8217;re using as your lookup table.<\/li><li>\u201c<a href=\"https:\/\/help.salesforce.com\/s\/articleView?id=sf.cpq_lookup_queries.htm&amp;type=5\" target=\"_blank\" rel=\"noreferrer noopener\">Tested Field supports non-null values only.<\/a>\u201d and you are comparing for null values in your lookup queries.<\/li><li>The set of Lookup Queries you have is not finding any values in the lookup table for the lines you have. (you&#8217;re missing a record in your table or your queries are wrong or the values in your tested fields aren&#8217;t being set as you expect them to be.<\/li><li>A rule that executes before your lookup rule is erroring out and causing the calculation sequence to halt.<\/li><li>A Rule that executes before your look up rule sets of value that the look up uses as a look up quarry on the same calculation event, as the look up rule, and the look up rule, can\u2019t see the value.<\/li><li>Your conditions aren\u2019t matching properly to the things in your quote.<\/li><li>There\u2019s a rule or action that fires after your lookup rule that is overwriting the field you are expecting the lookup value in.<\/li><li>The target field in your price action targets a formula field.<\/li><li>Execute Scripts (in cpq package settings).<\/li><li>Your rule is not active.<\/li><\/ul>\n\n\n\n<p>Reader Submissions!<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Known Issue: Commas are being used in the picklist fields participating in the queries: https:\/\/trailblazer.salesforce.com\/issues_view?id=a1p3A00000031gJQAQ<\/li><\/ul>\n\n\n\n<p>Got any others?  Comment them below! <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Is your Lookup Price Rule not working? Sweet. Below are some common reasons why. \ud83d\ude42 The API names of your lookup table, tested field, lookup field, target field values is wrong or the field doesn\u2019t exist. You did not set a Lookup Table value in your price rule. There are no lookup queries. You have &hellip;<br \/><a href=\"https:\/\/morecpq.com\/index.php\/2022\/07\/13\/lookup-price-rule-not-working\/\" class=\"more-link pen_button pen_element_default pen_icon_arrow_double\">Continue reading <span class=\"screen-reader-text\">Lookup Price Rule Not Working<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1774","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/posts\/1774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/comments?post=1774"}],"version-history":[{"count":17,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/posts\/1774\/revisions"}],"predecessor-version":[{"id":1792,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/posts\/1774\/revisions\/1792"}],"wp:attachment":[{"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/media?parent=1774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/categories?post=1774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/morecpq.com\/index.php\/wp-json\/wp\/v2\/tags?post=1774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}