Pricing Administration Guide > Creating and Assigning Price Lists > Copying and Transforming a Price List >

Using the Deep Copy Option to Transform Price Lists


The Deep Copy option of the Transform Price list form is only relevant to price lists that include customizable products that use attribute-based pricing. For more information, see Setting Up Attribute-Based Pricing.

If you use the Deep Copy option, ePricer makes modified attribute-based pricing data available to the new price list by:

  • Copying the attribute-based pricing tables attached to the original price list items into new attribute tables attached to the new price list
  • Applying the Prorate % and the currency conversion rate to the new attribute table items (as appropriate)

The new, deep-copied attribute-based pricing tables are identical to the old tables except that:

  • Each new row has a new unique row ID appended to it
  • If a row specifies an adjustment type of Markup Amount, Discount Amount, or Price Override, then the Adjustment Amount value in that row is multiplied by the Prorate % and converted to the new currency (as appropriate).

    NOTE:  Deep Copy does not have any effect on attribute-based pricing table item adjustments if the price adjustment type is Markup % or Discount %. These adjustments apply to an amount in the price list that is already adjusted by the prorating, so there is no reason to change them again with Deep Copy.

These new price adjustments are applied in addition to the fundamental price list changes that result from the Prorate % and currency conversion during the transformation process.

The changed attribute tables also affect any customizable product component product that is linked to an attribute pricing table. Component products use the attribute tables identified in their product line items in the price list.

Examples: Transforming List Prices with Deep Copy

In the first example, the attribute-based adjustment is of the Markup Amount type.

A Widget product normally sells for $100. If a runtime user selects the Chrome Plating attribute, the list price of the $100 Widget increases to $110, based on a $10 amount markup (Adjustment Type = Markup Amount, Adjustment Value =$10).

If you enter a Prorate % of 120 and select the Deep Copy option, then the attribute-adjusted price of this chrome-plated Widget in the transformed price list would be $132, the result of two Prorate % adjustments: (120% x $100) + (120% x $10)=$120 + $12=$132.

In the next example, the attribute-based adjustment is of the Discount Amount type.

Again, a Widget product normally sells for $100. If a runtime user selects the Reconditioned attribute, the list price of the $100 Widget to decreases to $70, based on a $30 amount discount (Adjustment Type = Discount Amount, Adjustment Value =$30).

If you enter a Prorate % of 120 and select the Deep Copy option, then the attribute-adjusted price of this reconditioned Widget in the transformed price list would be $84, the result of two Prorate % adjustments: (120% x $100) - (120% x $30)=$120 - $36=$84.

In both cases, the 120% change is applied both to the original price and to the price adjustment.

If you do not use Deep Copy, the Transform function still copies all of the existing attribute table adjustments, and the attribute pricing tables are not changed.

Pricing Administration Guide