Sample: Loading general information about inventory expected from vendors

This sample demonstrates how to load general information about inventory expected from vendor, for example, "Deprecated featureMadisons 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:
    • WebSphere Commerce EnterpriseWebSphere Commerce - ExpressWebSphere Commerce ProfessionalWC_installdir/bin
    • WebSphere Commerce DeveloperWCDE_installdir\bin
  2. Enter the following command:
    • SolarisLinuxAIX./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;