Samples > Data load utility samples > Inventory samples
Sample: Loading receipt records of items
This sample demonstrates how to load receipt records of items at fulfillment centers, for example, "Madisons Home".
About this sample
To update after initial load, you can update in the CSV file and run the load again.
Procedure
- Navigate to the appropriate directory:
- WC_INSTALL/bin
- WCDE_INSTALL\bin
- Enter the following command:
- ./dataload.sh ../samples/DataLoad/Inventory/Receipt/wc-dataload.xml
- dataload ..\samples\DataLoad\Inventory\Receipt\wc-dataload.xml
Verify 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;
Clean 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;