You can export prices from a price list for products and SKUs so you can work with them outside of Merchandising and easily import those changes back into the Oracle Commerce Platform system. You choose a price list whose prices you want to export, but you cannot export price list assets themselves.
Note: You can export prices from only one price list per export procedure.
The guidelines and limitations for exporting prices are the same as those for exporting other asset properties. For example, the export size limitation (a maximum of 65,534 asset rows) is the same if you are exporting asset properties or prices. For more information, see Export Guidelines and Limitations.
Volume Pricing
Volume pricing models are not supported for export. Exported volume prices are marked the keyword IGNORE
in the cell that contains the price
property .and COMPLEX
in the cell that contains the listPrice
property. For more details about volume pricing models in price lists, see Creating and Managing Price Lists.
Inherited Prices
When the price for an exported product or SKU is inherited from a base price list, the keyword IGNORE
marks the cell that contains the ID
property and the cell that contains the Price
property is empty.
You can replace the keyword IGNORE with a NEW keyword and provide a price value in listPrice column. A new price will be applied/created, when you import the spreadsheet
You can replace the keyword IGNORE
with the keyword NEW
and provide a price value that will be applied when you import the spreadsheet in the listPrice
column. See Marking Data to Ignore.
For more information about inherited prices, see Creating and Managing Price Lists.
Exporting Price Properties
When you export prices for products or SKUs, Merchandising automatically exports the following properties:
Price Item ID
PriceList ID
SKU ID
orProduct ID
SKU Name
orProduct Name
Price
Note: You cannot change the list of properties to export, though the list you see might not contain all the properties listed here, depending on how your administrator configured Merchandising.