Sample: Loading general information about inventory expected from vendors

This sample demonstrates how to load general information about inventory expected from vendor.

About this sample

  1. CatalogEntryMediator load catalog entry data under ATP store
  2. To load inventory data expected from a vendor, ensure that the vendor data has already been loaded to VENDOR table.
  3. If you want to modify ATP configuration, load data under
    • Linuxutilities_root/samples/DataLoad/Inventory/ATPConfiguration
    • HCL Commerce DeveloperWCDE_installdir\samples\DataLoad\Inventory\ATPConfiguration


  1. HCL Commerce DeveloperOn a command line, go to the WCDE_installdir\bin directory.
  2. LinuxOpen a command line in the . Change the directory to utilities_root/bin directory. For information about entering and leaving containers, see Running utilities from the Utility server Docker container.
  3. Enter the following command:
    • Linux./ ../samples/DataLoad/Inventory/RA/wc-dataload.xml
    • HCL Commerce Developerdataload ../samples/DataLoad/Inventory/RA/wc-dataload.xml

Verifying the results

Run the following SQL statement:
select * from RA where RA_ID >= $startKey and RA_ID < $endKey;
The $startKey and $endKey are set in samples\DataLoad\Inventory\RA\wc-dataload.xml . For example, select * from RA where RA_ID >= 100000001 and RA_ID < 200000000;

Cleaning up the data

To clean up the data loaded in the database, run the following SQL statement:
delete from RA where RA_ID >= $startKey and RA_ID < $endKey;