Uploading price lists
Use the Price List Upload feature in Management Center to upload offers
in a CSV format file into a price list in the WebSphere Commerce database. If the price list
does not yet exist, you can create a new, empty price list in Management Center and upload the
offers to that price list. Alternatively, you can upload the offers to an existing price
list.
Before you begin
Ensure that you complete the steps in Creating price lists in CSV format.
About this task
If required, you can upload the CSV file as a compressed (.zip) file.
Make sure that you upload the CSV file to the store to which the catalog entries in the CSV file belong.
You cannot use the Mozilla Firefox browser with a self-signed SSL certificate to upload a CSV file to Management Center. See Troubleshooting: Cannot upload files to Management Center with Firefox browser.
Procedure
- Open the Catalog Filter and Pricing tool.
-
If the price list does not exist in Management Center, create an empty price list to load
the offers into:
- From the toolbar, click the arrow on the right side of Create New; then select Price List.
-
In the Name field, type a name for this price list. The name must match
the value in the
PriceListName
column of the CSV file. - Save and close the new price list.
- From the toolbar, click the arrow on the right side of Create New; then select Price List Upload.
-
In the New Price List Upload page:
- Browse for the CSV file you want to upload.
- Select the file encoding that applies to your pricing data:
- UTF-8
- This is the default encoding. English uses this encoding, and some other languages can also use this encoding.
- UTF-16
- This encoding is broad enough to cover all languages.
- GB2312
- This encoding is for simplified Chinese used in People's Republic of China.
- Big5
- This encoding is for traditional Chinese encoding that is used in Taiwan, Hong Kong, and Macau.
- Windows Latin-1
- This encoding supports more characters than the English language, such as the copyright symbol, .
- ISO 8859-1
- This encoding is used for languages in the Americas, Western Europe, Oceania, and much of Africa.
- ISO 8859-15
- This encoding is used for some European languages, and also contains the euro sign €.
- KS C 5601 (KS X 1001)
- This encoding is used for Korean.
- Shift-JIS
- This encoding is used for Japanese.
- Specify the target price list that you want to upload to.
The name of this price list in Management Center must match the value in the
PriceListName
column of the CSV file. If these two names do not match, you are prevented from uploading the file.
-
Click Save and Close.
After you upload the file, the WebSphere Commerce Server uploads the data into the price list database tables (OFFER, OFFERPRICE, and OFFERDESC tables). The total time for the upload to complete depends on the size of the price list.
-
From the explorer view, click Price List Uploads to check your
uploads.
The Price List Uploads – List shows the following information:
Option Description File name The name of the uploaded CSV file. Size The size of the uploaded file in kilobytes. Uploaded By The logon ID of the user who uploaded the file. Start Time The time the upload process begins. End Time The time the upload process ends. Status The status of the upload. - Idle
- The initial status when the upload is waiting to be started.
- Processing
- The CSV file is uploaded to the server and is submitted for publishing.
- Successful
- The file is published without any errors or exception messages.
- Failed
- The file was submitted for publishing, but publishing did not complete. There are errors or exception messages.
Unique ID The internal unique identifier of the upload. This column is not shown by default. Server Path The server file path of the uploaded file. This column is not shown by default. Upload Time The time the uploaded file is uploaded to the server. This column is not shown by default. -
Select your upload from the Price List Uploads - List view.
The properties page for the selected upload is displayed.Note: An extra section Status is shown on the properties page when the upload completes or fails. This section contains a more detailed status of the selected price list upload.
- Optional:
If your upload fails or is successful, you might want to remove the entry from the Price List
Uploads - List view. Right-click the upload entry that you want to remove; then click
Delete.
The upload entry is removed from the list view, but the upload itself is not affected.