Error “No Standard Price Defined for This Product” When Adding Products to a Custom Price Book with Data Loader

This article explains why the Salesforce error "No standard price defined for this product" appears when you add products to a custom Price Book with Data Loader, and how to fix it. The error occurs when the product is not yet added to the Standard Price Book.

Why This Error Happens

Salesforce enforces a dependency where all products must first exist in the Standard Price Book before they are used in custom Price Books or transactions. If a product has no Standard Price Book entry, Salesforce blocks the insert into the custom Price Book.

How to Create Standard Price Book Entries with Data Loader

1. Export your product data, including:
   • Product ID
   • Unit Price
2. Add a column for the Standard Price Book ID.
3. Insert records into the Price Book Entry object to create standard price entries for all products.
4. Make sure that:
   • The product is active.
   • The price book entry is active.

Once the Standard Price is defined, you can add the product to a custom Price Book.