Price Book Object Import/Export

Business Manager Import Location

Use the pricebook.xsd schema file to import price books.

Granularity: selected price book.

Deleting Price Tables

In Salesforce B2C Commerce, a single SKU can have many associated price tables, as long as each price has a different valid-from date. Using the price book import, you can delete all price tables associated with a specific SKU with a single line using the delete-all attribute, as follows:

<price-table product-id="xyz" mode="delete-all" /> 

Import Mode and Storefront Visibility

If you import your price book in UPDATE mode, each row in the price book table is updated in one transaction and the new price is visible in the storefront after the transaction is committed.

If you import in REPLACE mode, the whole price book is loaded in one transaction and the new prices shown after transaction commit. The prices for the cart are not cached but the script calculateCart.ds loads the price for a line item. Price book changes made in this mode are visible in the storefront after the transaction has been committed. If a line item price changes after the price book load, the new price is visible in the cart as well.

If you import an optimized price book, the import speed is reduced by at least 60%. However, the prices can't be manually edited in Business Manager. Optimized price books should be imported in REPLACE mode for the fastest import times and fewest import failures. Optimized price books are only applicable for customers opted into the early release program. To opt in, submit a support ticket.

You can't change the currency of a price book using import in MERGE or UPDATE mode. However, you can change the currency of a price book in REPLACE mode.

If you import your price book in DELETE mode, the complete price book is deleted, instead of just the price assignments of SKUs listed in the XML.

Price book import ignores price books that contain a negative amount or quantity value. The problem is reported in the import log.

Price book import rejects price books with unknown currencies. The system reports a data warning.

Products and Catalogs > Import & Export

Pipelets

ImportPriceBooks

ExportPriceBooks

Granularity: passed price books.