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.
About this task
The Price List Upload feature uses the Data Load utility to upload price lists. By default,
the Data Load utility operates in replace mode, which means that the file you upload replaces the
content of the target price list you specify. If required, a site administrator can configure the
Data Load utility to operate in delete or insert mode instead. For more information, see Configuring the data load order.If required, you can
upload the CSV file as a compressed (.zip) file.
Make sure that you upload the CSV file to the
correct store, that is, the store to which the catalog entries in the CSV file belong.
You
cannot upload a CSV file to Management Center using
the Mozilla Firefox browser with a self-signed SSL certificate. See Troubleshooting: Cannot upload files to Management Center when using 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 value 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.
The Status 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.
Results
After you complete these steps, you can view and modify the
price list in the Catalog Filter and Pricing tool. For example, you
can change the price of a catalog entry in the price list.