Administer > Transforming, loading, and extracting data > Overview of the data load utility > Data load best practices

Price: data load best practices

The following best practices are recommended when using the data load utility to load price data.

• Price List

• Offer

Price List

• 
  Mark price list for deletion

  The markPriceListForDelete attribute is used to mark the price list for deletion when loading the price data. This attribute is set to true by default.

  To disable markPriceListForDelete, set the attribute to false as shown:

  <_config:BusinessObjectMediator className="com.ibm.commerce.price.dataload.mediator.PriceListMediator">     <_config:property name="markPriceListForDelete" value="false" />
  </_config:BusinessObjectMediator>
  

• 
  Load the price list

  The price list can be loaded by specifying:

  1. Price list unique ID: The price list is loaded according to the price list unique ID.

  2. Price list name and price list unique ID: If both the price list name and price list unique ID are provided in the CSV file, the price list is loaded according to the price list unique ID.

  3. Price list name: The price list is loaded according to the price list name.
  Consider using the first option to load the price list data to achieve the best performance.

Offer

• 
  Mark offer for deletion

  The markOfferForDelete attribute is used to mark offer for deletion when loading the offer data. This attribute is set to true by default.

  To disable markOfferForDelete, set the attribute to false as shown:

  <_config:BusinessObjectMediator className="com.ibm.commerce.price.dataload.mediator.OfferMediator">     <_config:property name="markOfferForDelete" value="false" />
  </_config:BusinessObjectMediator>
  

• 
  Load the offer list

  The offer list can be loaded by specifying one of the following:

  • Price list name and catalog entry part number

  • Price list name, price list unique ID, and catalog entry part number: If both the price list name and price list unique ID are provided in the CSV file, the data load utility loads according to the price list unique ID.

  • Price list name, catalog entry ID, and catalog entry part number: If both the catalog entry part number and catalog entry unique ID are provided in the CSV record, the data load utility loads according to the catalog entry unique ID.

  • Price list name, price list unique ID, catalog entry part number, and catalog entry ID: The offer list is loaded according to price list unique ID and catalog entry unique ID.

  Consider using the fourth option to achieve the best performance.

  If you do not specify the price list name or price list unique ID in the CSV file, the offer is loaded into the default price list of the catalog entry.

• 
  Currency mode

  Use one currency price per row in your CSV file to ease maintenance, and enhance performance when loading large offers in a single CSV file.

Related tasks

Examples: Mapping pricing data

Examples: Mapping inventory data

Related reference

Catalog: data load best practices

Inventory: data load best practices

Examples: Mapping catalog data

+

Search Tips   |   Advanced Search