Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

Questions tagged [pricebookentry]

Represents a product entry (an association between a Pricebook2 and Product2) in a price book.

Filter by
Sorted by
Tagged with
0 votes
0 answers
18 views

How do you learn about fields on an Object if they are not shown in the Object Manager?

Periodically, I come across an object that has fields I can access in a Flow or perhaps a SOQL query but that are not listed in the Object Manager (either in Lightning or Classic). Is there a standard ...
kennyc's user avatar
  • 349
0 votes
1 answer
41 views

Can't select the product I've just added in Salesforce to the Price Book

I can create a new product, and it's definitely active. When I try to add it to the Standard Price book (also active) it doesn't appear as an option to select. Same for any custom price book - all ...
Salesforza's user avatar
0 votes
1 answer
342 views

Bulk Api 2.0 max 2 retries instead of 10

I recently started huge PricebookEntry bulk update, around 40 mln records in one of sandboxes where locks are unavoidable. I am relying on the documentation that 10 retries are guaranteed per batch: ...
Bithermal's user avatar
0 votes
1 answer
500 views

Troubles Updating a Currency Field on Quote Through Create Triggered Flow

Hi Im going to try to illustrate what I want to achieve through this flow: Using Quotes I have a Currency Field named AgencyFee__c on Quote And I have a Cross Object Currency Formula named BankFee__c ...
Samuel L's user avatar
1 vote
2 answers
309 views

How can you import a standard price book catalog in a scratch org with the data import command?

When a scratch org is created its default price book is already created in the org. The JSON files with the dummy data in the repository, however, do not contain the ID of the price book record, or it ...
Renato Oliveira's user avatar
0 votes
1 answer
249 views

Historical price list for Products?

Historical price list for Products? Hi, I'm trying to find historical price list for Products? It that possible? All I'm able to find are current prices. Thank you
user115072's user avatar
0 votes
1 answer
130 views

ListPrice does not fill automatically on Order Products Selection layout

Whenever I add Order Products to an Order, they appear with empty ListPrices on the layout. Meaning that the field shows up but it is always blank. The Parent PriceBook and its entries are activated ...
ViniVan's user avatar
0 votes
1 answer
83 views

Set two price book prices equal to each other

Our company has two price books. The standard price book, and an intercompany price book. For the time being, we would like the prices on the intercompany price book to equal those on the standard ...
Ryan Miles's user avatar
1 vote
0 answers
773 views

I can't create quote line items with community user

From a community, I need users to be able to create quotes and their quote line items. With the community user, I create the opportunity, then I create the quote. Then when trying to create a ...
Chandlerbeen's user avatar
0 votes
0 answers
956 views

Field Integrity Exception: Unknown when updating a price in sandbox

In sandbox, I am trying to update a price for a product in the standard price book through the UI. When I change the List Price and click save, I get the following error. These are referencing ...
salesforceheather's user avatar
0 votes
0 answers
377 views

OpportunityLineItem shows UnitPrice with 3 places after decimal

I have an opportunity that has 3 products and each product has a list price of $600 and sales price (UnitPrice) of $400. The amount field on the opportunity is showing $1,199.99 instead of $1200 as ...
user1669296's user avatar
0 votes
0 answers
478 views

Clone with related -- PricebookEntryId (pricebook entry is in a different pricebook than the one assigned to the opportunity): [PricebookEntryId]

I am getting this issue PricebookEntryId (pricebook entry is in a different pricebook than the one assigned to the opportunity): [PricebookEntryId] when ever I tried to clone an opportunity with ...
klnavi's user avatar
  • 79
0 votes
0 answers
813 views

Price Book Entry History Report

Is there no report capability to see the Price Book Entry History? I need to be able to report on what date a certain Product changed price in a certain Price Book and what it changed FROM/TO. I also ...
rcg917's user avatar
  • 1
0 votes
0 answers
20 views

Price Book with 2 prices for same Product [duplicate]

The following query returns 2 rows for me SELECT CurrencyIsoCode,Id,IsActive,IsArchived,IsDeleted,Name,Pricebook2Id,Product2Id,ProductCode,UnitPrice,UseStandardPrice FROM PricebookEntry where product2....
SFDC Dev 27's user avatar
1 vote
0 answers
593 views

DataLoader batch job failing with PricebookEntry upsert

I have an issue with our PRICE BOOK ENTRY Upsert using the DataLoader batch bulk job. We have External IDs in our PRICE BOOK and PRODUCT objects that we use when Upserting to our PRICE BOOK ENTRY ...
VinceD's user avatar
  • 11
1 vote
1 answer
365 views

BulkAPI 2.0 Import PricebookEntries via Postman getting this error:STANDARD_PRICE_NOT_DEFINED:Before creating a custom price, create a standard price

I have setup the Postman requests to talk to the salesforce BulkAPI 2.0 because the dataLoader doesn't work (MacBook M1). The import of the pricebookentries fail at a point because when I import the ...
AMMA's user avatar
  • 311
0 votes
2 answers
785 views

Using Custom Price Book Entry Object

I am developing the custom aura component for adding products to the opportunity for achieving client requirements. For this, I have created a custom price book entry object but while creating the ...
jsmith's user avatar
  • 175
0 votes
0 answers
188 views

Creating opportunity line from SalesforceSharp

I am using SalesforceSharp to create an Opportunity. The header is working OK, I have ensured that the CurrencyIsoCode and PriceBook2Id fields are set. When trying to create the Opportunity Line Item,...
Dominic Cotton's user avatar
0 votes
1 answer
223 views

STANDARD_PRICE_NOT_DEFINED, No standard price defined for this product

I checked the other answers about this topic but I have no clear result. I think Id pricebookId = Test.getStandardPricebookId(); is use to get a standardPrice before insertion of PricebookEntry in a ...
CPS's user avatar
  • 345
0 votes
2 answers
336 views

Update both Pricebook2 and PricebookEntry objects using just one for loop

Having the next code: for (WrapperTest pb : pbs_lst) { Pricebook2 newPB2 = new Pricebook2(); PricebookEntry newPBE = ...
CPS's user avatar
  • 345
0 votes
1 answer
426 views

Are Pricebook and Pricebookentries available in Service cloud? [closed]

Please let me know if these objects are available in service cloud.
user91530's user avatar
0 votes
1 answer
2k views

Insert PriceBookEntry using Product2 External Id field

I am developing an external application which will insert & update products and their pricebook entries into Salesforce system. In order to avoid maintaining the Salesforce ProductId in my ...
ronnie's user avatar
  • 1
5 votes
1 answer
8k views

Get custom Picklist value in LWC without Record Type

I have created a custom Picklist in PricebookEntry and trying to get the Picklist values in LWC. All the solutions I found needs to pass the RecordTypeId to get the list. @wire(...
Tapas Mukherjee's user avatar
0 votes
1 answer
1k views

How to display Product fields and it's pricebookentries in a single datatable?

I need to dynamically put products and the products' pricebookentries in a single row in a datatable. If I add a pricebook, a new column and it's prices should also be displayed. I could do this for ...
Santosh's user avatar
  • 73
-1 votes
1 answer
68 views

string.isempty doesn't appear to work when trying to retrieve price list Name

it appears my if statement with String.isEmpty doesn't seem to be working. What i want it to do is check if a price list entry doesn't exist it creates a new one, and if it does it updates that one. ...
Shaan Khokhar's user avatar
0 votes
1 answer
64 views

Not Able To Update Price Entries

I am trying to insert products, then those products then create price entries if they don't already exist but if they do exist they update the previous price entry based on the name of the product ...
Shaan Khokhar's user avatar
0 votes
0 answers
390 views

Use Database.upsert with external id field is not working on PricebookEntry object

I need help to do a DML operation with external id field. I am using the below syntax, but it is throwing an error Schema.SObjectField f = PricebookEntry.Fields.Product_Code__c; Database.UpsertResult[...
jsmith's user avatar
  • 175
3 votes
2 answers
785 views

Change the label of a standard field of PriceBookEntry object

Is it possible to change the label of a field (in my case I'd like to change the label of the UnitPrice field) of the PriceBookEntry standard object ? In the setup -> tabs and labels, I don't see ...
dou's user avatar
  • 1,959
0 votes
1 answer
151 views

Load PricebookEntry in empty Scratchorg with Cumulusci

When generating a .yml file with generate_dataset_mapping with cumulusci it resolves in following code(sample): Insert Product2: sf_object: Product2 table: Product2 fields: Id: sf_id ...
Ammar's user avatar
  • 1
0 votes
1 answer
426 views

How to restore or undelete PricebookEntry records

Is it possible to undelete/restore a deleted PricebookEntry record? I am not referring to restoring a Price Book or Product record but hitting the delete button on an entry record itself, then ...
Erick Molina's user avatar
0 votes
1 answer
337 views

Order Pricebook2Id to manage with multiple Order Product Pricebooks

Scenario: There are multiple Order Products with different Pricebook(Year wise Pricebook) to be added on Order Object. But, on Order Object we can only set a single Pricebook Id. Can anyone please ...
Jahnvi Jasani's user avatar
1 vote
1 answer
305 views

Error when I try to create OrderItem records Insert failed. INVALID_CROSS_REFERENCE_KEY

I'm trying to create a visualforce page where a user can create multiple OrderItem records at the same time. The error that I get is OrderItem records Insert failed. First exception on row 0; ...
Chandlerbeen's user avatar
-1 votes
1 answer
934 views

Add a picklist value to Global Value Set in test class

I am working on test class that inserts an Opportunity with the opportunity products using the correct price book/price book entry. The OpportunityLineItem has a ProductSelected__c picklist field. We ...
Balaji Pooruli's user avatar
0 votes
1 answer
3k views

Different currencies in PricebookEntry throwing exception FIELD_INTEGRITY_EXCEPTION, PricebookEntryId (must have the same currency as the order)

I wrote a trigger which converts a Quote to Order on changing Status to a particular value. This Quote has QuoteLineItems, hence, they should converted to corresponding OrderItems. Now when the ...
Nilang Pandey's user avatar
2 votes
2 answers
8k views

Pricebook and PricebookEntries with different currencies

Can Pricebook and its PricebookEntries have different currencies? So, if I create a Pricebook with currency USD and its PricebookEntries with multiple currency like USD, GBP, AUD, etc., is this ...
Nilang Pandey's user avatar
0 votes
0 answers
962 views

Pricebook2Id not populating in opportunity when default price book is already present

I have applied a default pricebook to a set of users. When I try to add products to that opportunity the pricebook already shows that it is selected at the product selection screen but still ...
user74804's user avatar
0 votes
1 answer
213 views

I am unable to query pricebook entry. (Internal Salesforce Error)

I am making a lightning component for a user to create a quote + line items quick and easy. However the apex function that is meant to query the pricebook entry and its Id for each line item is ...
Alexander Atkinsoon's user avatar
1 vote
0 answers
1k views

Selecting the Opportunity Price Book

I'm still fairly new to Salesforce Apex and trying to figure out how to select a price book from the opportunity. The reason being I have a trigger which adds in a product when the opportunity is ...
Will May's user avatar
1 vote
1 answer
2k views

Is it possible to update Order Product on Draft Order?

We are trying to utilize the Order object, but we're finding that if we create an Order Product, we are unable to change the product (i.e. essentially the Pricebook entry), even if we're in a Draft ...
Maya Tran's user avatar
  • 229
0 votes
1 answer
333 views

PricebookEntry Conflict Error not matching existing products

I am getting an error message on a trigger that was working until recently. The issue arises on a trigger that inserts an OpportunityLineItem on an Opportunity. Here is the error: Insert failed. ...
jaw999's user avatar
  • 1,315
1 vote
2 answers
3k views

FIELD_INTEGRITY_EXCEPTION when creating Price Book Entry from flow

I have created a flow that creates a pricebook entry for new products (based on a custom field on the Product object), however when I debug the flow it comes up with the following quite generic error: ...
Kees's user avatar
  • 31
1 vote
1 answer
173 views

Failure when inserting records via dataloader, however anonymous apex inserts fine

I'm getting the following error when running dataloader (inserting new quotelineitems), however an identifcal anonymous apex works fine - any thoughts? Error: The price book entry is in a different ...
rmarq423's user avatar
  • 967
0 votes
1 answer
883 views

Trying to do an SOQL Query for all product names and their Price books

I Have a Salesforce Org where there are almost 1000 products and 51 Price books, I want to know a query where I can get each product and the price books they belong to. Any help is much appreciated!
Adam Lawrence's user avatar
0 votes
1 answer
1k views

How to prefill UnitPrice on Order Products

I want my Order Product price to prefill based on the price defined on the Pricebook Entry. I swear I've seen this work in the past, but I can't figure out why this time I keep getting an empty field ...
Valyrion's user avatar
  • 1,144
5 votes
1 answer
3k views

In which sequence should I be creating/inserting order/orderItem/pricebookEntry/product2?

I'm on the advanced apex super badge step 7, and before this I thought I had a good understanding of order/orderItem/pricebookEntry/product2/pricebook2 objects. However, upon creating my own ...
rna7's user avatar
  • 347
3 votes
1 answer
3k views

Find all Product2 records that do NOT have a PricebookEntry in the Standard Price Book

We have come to find that we have a small amount of products that have Product2 records, but no PricebookEntry for them. I'm trying to query for just those products, but I am having trouble with the ...
AstroLovesCodey's user avatar
0 votes
1 answer
705 views

Deep Cloning a Product - Clone Standard Price and Custom Prices

I have created a Record Detail button to clone a Product's detail, a related list called Bill of Materials, and both the Standard PB Entry, and any Custom PB Entries. If I remove the Custom PB Entry ...
TheMikeyBoosh's user avatar
1 vote
1 answer
4k views

Automatically add a Standard Price Book Entry after creating product

I am successfully importing a CSV of products and creating Product objects in Salesforce. I'd like to be able to automatically (or even via CSV update) create Standard prices for those objects, but ...
Scott C Wilson's user avatar
1 vote
1 answer
1k views

Make Price Book Entry object's Product Code field Read/Write

I'd like to automatically create Standard Price Book entries for new products using dataloader.io. I am successfully creating the new products, using the Product Code as the ID. But when I go to ...
Scott C Wilson's user avatar
1 vote
1 answer
1k views

Can I show the standard price on the product layout page?

I know I can click the Related Tab and drill into the Standard Price Book to see it, but it would sure be nice to just show it on the product page. Is this possible?
Scott C Wilson's user avatar