Product pricing

Product pricing

This is a batch upload to set pricing for all existing products and/or variants. Products must exist prior to creation.

Field option

Is required?

Description

PriceID

Optional

If blank, we will search for an existing product price that matches the values provided by the ProductCode, SKU, Role, and Quantity columns. Otherwise, the row will be treated as a new price.

ProductCode

Required

This value must be an existing Product Code.

SKU

Optional

This value must be the existing SKU for the associated Product Code.

Role

Optional

This determines if any custom user roles receive different pricing. The value of this field must be an existing custom user role entered exactly as it is named in Liftoff.

Quantity

Required

This is the quantity associated with the price. This value must be numerical.

Price

Required

This is the total price associated with the quantity. This value must be a numerical value between 0 and 999,999.99. Decimal precision is optional.

Cost

Required

This is the total cost associated with the quantity. This value must be a numerical value between 0 and 999,999.99. Decimal precision is optional.