Set up an SFTP transport and scheduled job to import the latest pricing data from Dynamic
Pricing 16.4 to WebSphere Commerce.
About this task
After merchandisers use Dynamic Pricing to adjust product prices according to their business
strategy, the updated pricing data can be imported to WebSphere Commerce.
In a production environment, this scheduled job is configured on the staging or authoring server.
Imported pricing data must then be propagated from the staging server to the production server
before updated pricing can appear on the live storefront.
Procedure
-
Configure the Dynamic Pricing SFTP transport.
- Open the
Administration Console, then select Store on the Administration Console Site/Store Selection
page.
- Click
. The
Transport Configuration page displays.
- Click Add to open the Add Transport
page.
- Select the Dynamic Pricing SFTP Import connection settings
check box.
- Click Add to accept the changes. When you add a transport
method to a site, it is automatically activated.
- From the Add Transport page, click the check box beside
Dynamic Pricing SFTP Import connection settings, and click
Configure.
- Specify the following configuration parameters for the SFTP transport, and click
Ok.
| Parameter |
Value |
| Host name |
Enter the FTP host name. |
| Port number |
Enter the port number. By default port for Dynamic Pricing is 160.
|
| User name |
Enter your FTP user name. |
| Password |
Enter your FTP password. |
| Remote directory |
Enter remote FTP upload directory. |
- Configure the scheduled job to import prices from Dynamic Pricing to WebSphere
Commerce.
- Click
. A
list of jobs that are scheduled to run is displayed.
- On the Scheduler Status Display page, click
New.
- Create the Dynamic Pricing import job with the following values:
| Parameter |
Value |
| Job Command |
Dataload |
| Job parameters |
Enter the following job parameters:
- dataLoadType
- Use DynamicPricingImport for the type of Dataload command.
- deleteRemoteFiles
- Indicates whether to delete the remote Dynamic Pricing files after they are imported to
WebSphere Commerce.
- true
- Deletes the remote files.
- false
- Does not delete the remote files. This parameter is recommended for this integration.
- getFileNameContains
- Optional: Retrieves files based on a specified value. For example,
getFileNameContains=prices, retrieves files that contain "prices" in the file
name.
The following is an example command that uses multiple parameters:
dataLoadType=DynamicPricingImport&deleteRemoteFiles=false&
getFileNameContains=prices |
| Start date |
Enter the current date. |
| Start time |
Enter a time that you want to start the job for the first time. |
| Schedule interval |
Type the number of seconds between successive runs of this job. If this parameter is omitted,
the job runs only 1 time. A typical schedule interval for this job is 300
seconds (5 minutes). |
Note: If the Dataload command does not exist in the Job command drop-down list, run the following
statements against your database:
-
insert into schcmd (schcmd_id, storeent_id, pathinfo) values (-39, 0, 'DataLoad');
-
insert into chkarrang (chkcmd_id, schcmd_id) values (-1, -39);
Then, return to the Administration Console to configure the scheduled job.
- Click OK.
Results
When the scheduled job runs, the processed data from Dynamic Pricing
is imported to WebSphere Commerce.
What to do next
- If you imported the updated pricing data into your staging server, and not your live production
server, you must propagate the updated data from staging to production by using the stagingprop
utility. For more information about the utility, see Stagingprop utility.
- The updated product prices appear on your storefront after the completion of the next
updateSearchIndex scheduled job. From the Administration console, you can verify
or update the frequency at which this job is configured to run. For more information about updating
your search index, see Building the WebSphere Commerce search index.
