[SalesForce] Get standard price without query? SeeAllData cannot be true

I am getting this error in my test class with pricebook entries and products:

System.DmlException: Insert failed. First exception on row 0; first error: STANDARD_PRICE_NOT_DEFINED, No standard price defined for this product: []

I've seen many solutions using a query for standard pricebook, but I don't want to use that, because SeeAllData needs to be true for it to return anything, and that messes up the rest of the test class. Suggestions?

ID standardPBID = Test.getStandardPricebookId(); 
    List<Pricebook2> standardPB = [select id from Pricebook2 where isStandard=true];
    System.debug('Standard Pricebook found?');
    System.debug(standardPB.size() > 0); // false
    Pricebook2 customPB = new Pricebook2(Name='Custom Pricebook', isActive=true);
    insert customPB;

    Product2 elderProd = new Product2(IsActive = true, Name = 'Elder Gifts');
    insert elderProd;
    PricebookEntry elderPBE = new PricebookEntry(
        Pricebook2Id = customPB.Id, Product2Id = elderProd.Id,
        UnitPrice = 0, IsActive = true, UseStandardPrice = true);
    insert elderPBE;

Best Answer

Try the following code. Here you can see we insert a price book entry for the standard price book.

Product2 elderProd = new Product2(
        IsActive = true,
        Name = 'Elder Gifts'
        );
insert elderProd;

ID standardPBID = Test.getStandardPricebookId(); 

PricebookEntry standardPrice = new PricebookEntry(
        Pricebook2Id = pricebookId,
        Product2Id = prod.Id,
        UnitPrice = 10000,
        IsActive = true
        );
    insert standardPrice;

List<Pricebook2> standardPB = [select id from Pricebook2 where isStandard=true];
System.debug('Standard Pricebook found?');
System.debug(standardPB.size() > 0); // false

Pricebook2 customPB = new Pricebook2(
    Name='Custom Pricebook',
    isActive=true
    );
insert customPB;


PricebookEntry elderPBE = new PricebookEntry(
    Pricebook2Id = customPB.Id,
    Product2Id = elderProd.Id,
    UnitPrice = 0,
    IsActive = true
    );
insert elderPBE;

Error may be coming from following line:

UseStandardPrice = true

Related Solutions

[SalesForce] TestClass without seealldata=true

I believe user data is accessible, although I have no idea what may cause you problem I will try help you with your code.

This :

User thisUser = [SELECT Id FROM User WHERE Id = :UserInfo.getUserId()]; System.runAs(thisUser) {

is pointless. I even think it may cause some distraction, as you change context from current user to current user...

Creating user in test should not be done in future method - its just wasting of resources (Test.startTest()/Test.stopTest()). If there are any problems with this - investigate and fix, because there is some bug.

Testing - judging by your code there is unhandled exception in trigger, handle it and check number of successfully inserted records instead of exception text.

Try something like this(it is not working code) :

@isTest(seeAllData=true)
public class IncidentLimit_Test {

public static testmethod void testcountincident(){ 

    User usr = CreateUser('Some firstName','Some lastName', 'some profile Id collected by other methode ');
    insert usr;

    System.runAs(thisUser) {
        Test.startTest();
            List<Incident__c> inclist = new List<Incident__c>();
            for(integer i=1;i<=5;i++)
            {
              inclist.add(new Incident__c(client__c=u.id,Description__c='incident'+i));
            }
           insert inclist;
        Test.stopTest();
        }

        // assert here    }

public static UserRole CreateUserRole(String name) {
    UserRole ur = new UserRole();
    ur.Name = name;
    return ur;
}

public static User CreateUser(String firstname, String lastname, String profileId) {
    UserRole ur = CreateUserRole('Testing');
    User usr = new User(FirstName = firstname,
                        LastName = lastname,
                        Username = firstname + '.' + lastname + '@testing.com',
                        IsActive = true,
                        UserRoleId = ur.Id,
                        Email = 'testuser@testing.com', 
                        Alias = 'tusr', 
                        TimeZoneSidKey = 'Europe/Berlin' , 
                        LocaleSidKey = 'en_US', 
                        EmailEncodingKey = 'UTF-8', 
                        ProfileId = profileId, 
                        LanguageLocaleKey = 'en_US'
                        );
    return usr;
}

[SalesForce] Test class fails throws different types of error as :STANDARD_PRICE_NOT_DEFINED, No standard price defined for this product

You can use Test.getStandardPricebookId() method to get the standard pricebook Id in test class. In this way, you don't need to perform any soql or write seealldata=true.

Please let me know if this makes sense.

Related Topic