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, please make sure the vendor data has already been loaded to VENDOR table.
  3. If you want to modify ATP configuration, load data under WC_installdir\samples\DataLoad\Inventory\ATPConfiguration

Procedure

  1. Go to the appropriate directory:
    • WC_installdir/bin
    • WebSphere Commerce DeveloperWCDE_installdir\bin
  2. Enter the following command:
    • LinuxAIX./dataload.sh ../samples/DataLoad/Inventory/RA/wc-dataload.xml
    • WebSphere Commerce DeveloperWindowsdataload ../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;