Exporting a price list

You can export any price lists that exist in Management Center. The price list is exported as a CSV (comma-separated value) format file. After you export the price list, you can use a spreadsheet editor to edit the price list. Then, you can upload the revised price list so that the changes are available to WebSphere Commerce for pricing.

About this task

Exporting a large price list can take a long time, depending on your system. For example, a price list with 500,000 price entries might take almost an hour to export. For large price lists, you might encounter the following problems:

You might see an error message that states that the browser has timed out.
You might see an error message that states that you cannot export the price list because it contains too many entries.
Your server might crash.

If any of these problems occurs, talk to a site administrator. Site administrators can refer to the suggestions in Limiting the size of a price list to be exported.

Note: When you export a price list, you can export prices for only the following currencies: USD, BRL, CAD, CNY, EUR, JPY, KRW, TWD. If you need to export more prices in other currencies, request that an IT developer customize the export process to include the extra currencies. If you are a developer, you can create a custom implementation class for the export process to define the extra currencies. Use the com.ibm.commerce.price.commands.PriceListExportCmdImpl class as a template for your custom class.

Procedure

Open the Catalog Filter and Pricing tool.
In the explorer view, click the Price Lists folder.
Right-click the price list that you want to export, and then click Export.
Wait until you see the browser window that prompts you to save or open the exported price list. This prompt indicates that the export process is complete.
Follow the instructions in the browser to save the exported price list under a new name to a folder on your computer.