Samples > Data load utility samples > Inventory samples


Sample: Loading general information about inventory expected from vendors

This sample demonstrates how to load general information about inventory expected from vendor, for example, "Madisons 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. To modify ATP configuration, load data under WC_INSTALL\samples\DataLoad\Inventory\ATPConfiguration


Procedure

  1. Navigate to the appropriate directory:

  2. Enter the following command:

    • ./dataload.sh ../samples/DataLoad/Inventory/RA/wc-dataload.xml

    • dataload ../samples/DataLoad/Inventory/RA/wc-dataload.xml


Verify 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;


Clean 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;


+

Search Tips   |   Advanced Search