(Enterprise)

Configurable limits for requisition list uploads

If your B2B store offers the requisition list upload feature to customers, we might want more control over the performance impacts of this feature. For the Aurora starter store, we can configure certain limits to suit your business needs. The following table lists the configurable limits and their default values, and identifies where we can change the default values.

Limit Default value Where to configure
Maximum file size for the CSV file

(maxuploadsize property)

524 KB

If the file is larger, the upload does not start and an error message tells the customer to reduce the file size.

WebSphere Commerce configuration file (wc-server.xml).

In the file, change the maxuploadsize value for the CreateRequisitionListUpload command, as shown in the following code snippet:

    <Command maxuploadsize="524288"
      name="CreateRequisitionListUpload"
      supportedFileExtension="csv"
      uploadReturnURL_enabled="true" viruscheck="no"/>

For general instructions on finding and updating the wc-server.xml file, see WebSphere Commerce configuration file (wc-server.xml).

Maximum number of lines in the CSV file

(limitCSVLine property)

3000 lines

If the file contains more lines, the upload fails and an error message is displayed to the customer to reduce the number of lines.

Order component configuration file:

workspace_dir/WC/xml/config/com.ibm.commerce.order-fep/wc-admin-component.xml

In the file, change the relevant configuration property for the RequisitionListUpload configuration grouping, as shown in the following code snippet:

    <_config:configgrouping name="RequisitionListUpload">
      <_config:property name="uploadInterval" value="5" />
      <_config:property name="maxTask" value="5" />
      <_config:property name="limitCSVLine" value="3000" />
    </_config:configgrouping>

For general instructions on updating the wc-admin-component.xml file for the order component, see Changing properties in the order component configuration file (wc-admin-component.xml).

Maximum number of upload tasks in progress at the same time

(maxTask property)

5 uploads

When a customer tries to upload a sixth requisition list, the upload does not start. An error message tells the customer to wait before you upload another list.

Minimum time interval between each consecutive upload

(uploadInterval property)

5 seconds

If a customer uploads a requisition list and then tries to upload another list without waiting five seconds, the upload does not start. An error message tells the customer to wait before you upload another list.


Controlling threads that handle requisition list upload jobs

We can modify the default settings for the upload work manager to control the number of threads that handle requisition list upload jobs. The upload jobs run according to our custom configuration. Requisition uploads use the work manager named upload, which has the following default settings:

Thread pool property Default setting
Number of alarm threads 2
Minimum number of threads 0
Maximum number of threads 11
Thread priority 5

Use the WebSphere Application Server Administration Console to change the default settings. See the section about the work manager for the scheduler in Scheduler configuration parameters.


Related concepts
Add to Requisition List widget


Related tasks
Uploading requisition lists
Developing Aurora starter store pages


Related reference
Requisition List Details page (B2B)
Requisition Lists page (B2B)
Requisition Lists Log Details page (B2B)