WebSphere Commerce Enterprise

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

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 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

  1. Open the Catalog Filter and Pricing tool.
  2. If the price list does not exist in Management Center, create an empty price list to load the offers into:
    1. From the toolbar, click the arrow on the right side of Add newArrow Create New; then select Price List.
    2. 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.
    3. Save and close the new price list.
  3. From the toolbar, click the arrow on the right side of Add newArrow Create New; then select Price List Upload.
  4. In the New Price List Upload page:
    1. Browse for the CSV file you want to upload.
    2. 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, 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.
    3. 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.

  5. 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.
  6. From the explorer view, click Price List Uploads to check your uploads.
    The Price List Uploads – List shows the following information:
    OptionDescription
    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 Processing
    The CSV file is uploaded to the server and is submitted for publishing.
    Successful Successful
    The file is published without any errors or exception messages.
    Failed 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.
  7. 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.
  8. 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.