Sample: Loading receipt records of items

This sample demonstrates how to load receipt records of items at fulfillment centers, for example, "AuroraESite Home".

About this sample

If you want to update after initial load, you can update in the CSV file and run the load again.

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/Receipt/wc-dataload.xml
    • WebSphere Commerce DeveloperWindowsdataload ..\samples\DataLoad\Inventory\Receipt\wc-dataload.xml

Verifying the results

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

Cleaning up the data

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