Lightning Pricebook Editor

Hi David & Ainsile, I’m happy to let you know that I have identified the cause—a conflict within the dynamic SOQL queries—and have released a new version on the AppExchange that resolves this issue. To get the fix, please uninstall the current version from your sandbox and reinstall the updated package. Please let me know once you’ve had a chance to test it out. I’d love to hear if this gets everything working smoothly for you! Thanks.

Hi there - I'm having the same issue as David, and I hope this can be resolved quickly - we would LOVE this app to work! (System Admin profile, all Products have Standard and Custom Price Books with entries etc)

Hi David, Thank you for bringing this to the attention. I understand how frustrating it must be to encounter the error, especially for all the products even though you have a full access, I’d like to investigate it thoroughly and resolve it as soon as possible. Could you please send an email to sshanmugaraj@salesforce.com with the following details? - The exact steps you followed before the error occurred - Any relevant screenshots and screen recordings of the error This will help us better understand the context and identify the root cause quickly. I truly appreciate your patience and cooperation, and I assure you that I’ll work on resolving this issue at the earliest. Warm regards, Subitha

First of all, thank you for your quick response. But ... Both messages appear for all products. The products are maintained in the standard price book as well as in some (not necessarily all) other price books. This also applies to different currencies. As an org administrator, I have full access to everything. This includes Product2, Pricebook2, and PricebookEntry. In general, I have full access and can maintain the data manually as well as with my own flows and automations without any problems. Access rights cannot be the problem here. Thanks.

Hi David, Thank you for reaching out about the messages you're seeing when using the Edit Pricebook functionality. I want to provide clarity on what these messages mean and how to resolve them. Message 1: "No Standard Pricebook available!" / "No Pricebook Entries available!" What These Mean: These are informational messages, not errors. They're designed to help you understand the current pricing configuration state of your product. "No Standard Pricebook available!" - The product hasn't been added to the Standard Pricebook yet "No Pricebook Entries available!" - The product hasn't been added to any Custom Pricebooks yet When You'll See These: - Working with newly created products - Products that are only partially configured with pricing - Products that exist in some pricebooks but not others How to Resolve: - Navigate to the Product record - Go to the "Price Books" related list - Click "Add to Price Book" - First, add the product to the Standard Pricebook with a list price - Then, add to any Custom Pricebooks as needed - Once added, the modal will display pricing data in tables for editing Message 2: "ERROR! unexpected token 'WITH'" What This Means: This is an actual error indicating a permissions or data access issue. This occurs when the user doesn't have sufficient access to view or edit Pricebook data. Root Cause: The system is trying to query Pricebook records, but the user's profile or permission sets lack the necessary permissions to access: - PricebookEntry records - Pricebook2 records - Product2 records - Or specific fields on these objects How to Resolve: Please verify the affected user has the following permissions: 1. Object-Level Permissions (Setup → Users → Profile/Permission Sets): - Read access on PricebookEntry - Read access on Pricebook2 - Read access on Product2 - Edit access on PricebookEntry (required to update prices) 2. Field-Level Security (Setup → Object Manager → [Object] → Fields): Ensure these fields are Visible for the user's profile: PricebookEntry fields: - UnitPrice - UseStandardPrice - IsActive - Product2Id - Pricebook2Id - CurrencyIsoCode (if multi-currency is enabled) - Pricebook2 fields: - Name - IsStandard Product2 fields: - Name - ProductCode 3. Standard Pricebook Access: - Ensure the user can access the Standard Pricebook - May require "View All" permission on Pricebook2 object 4. Quick Diagnostic Test: - Navigate to any Product record - Check if you can see the "Price Books" related list - Try clicking on a Pricebook Entry record - If they cannot see or access these, it confirms a permissions issue. Next Steps: - For the informational messages: Follow the steps to add products to pricebooks - For the permission error: Review and grant the necessary permissions listed above Once the permissions are properly configured and products are added to pricebooks, the modal will work smoothly and display the pricing data for editing. Please let me know if you need further assistance. Thanks.