Samples > Data load utility samples

Sample: Updating SKU inventory

This sample demonstrates how to update inventory quantities for the SKUs that have already been loaded to your database.

Restriction: Inventory quantities cannot be viewed in the Management Center. If you are using the Catalogs tool in the Management Center, verify the inventory quantities using the SQL statements provided.

About this sample

This sample updates the inventory quantity of the SKU with the part number 'Cords-Black-29W x 28' to 200.

Procedure

Before running this sample, ensure that you have loaded the initial data.

1. Open the command-line interface, and navigate to the appropriate directory:

   • WC_INSTALL/bin

   • WCDE_INSTALL\bin

2. Enter the following command:

   • ./dataload.sh ../samples/DataLoad/Catalog/IntegrateScenario/wc-dataload-nonATP-inventory.xml

   • dataload ..\samples\DataLoad\Catalog\IntegrateScenario\wc-dataload-nonATP-inventory.xml

   Alternatively for an ATP store, run data load using wc-dataload-ATP-inventory.xml.

   • ./dataload.sh ../samples/DataLoad/Catalog/IntegrateScenario/wc-dataload-ATP-inventory.xml

   • dataload ..\samples\DataLoad\Catalog\IntegrateScenario\wc-dataload-ATP-inventory.xml

Verify results

The wc-dataload-nonATP-inventory.xml configuration file updates the inventory quantities for the SKUs loaded in the initial load sample. Verify that the inventory data is loaded by looking at the INVENTORY table:

• To return the inventory quantity for the SKU with the part number 'Cords-Black-29W x 28', enter:

  select * from inventory where catentry_id = (select catentry_id from catentry where partnumber ='Cords-Black-29W x 28L')
  

  The inventory quantity returned should be 200.

Alternatively for an ATP store, to see how a particular store allocates inventory for the SKU with part number 'Cords-Black-29W x 28' enter:

select TrackInventory, BackOrderable, ReleaseSeparately, Creditable, ForceBackorder, 
ReturnNotDesired, PickingMethod, Discontinued, MinQTYForSplit, QuantityMeasure, 
QuantityMultiple from baseitem b, itemspc i, storeitem s, distarrang d where b.baseitem_id=i.baseitem_id 
and b.baseitem_id=s.baseitem_id and b.baseitem_id=d.baseitem_id and i.partnumber='Cords-Black-29W x 28L'

Clean up the data

To remove the data loaded in this sample from the database, run the CleanUp.sql file in the /samples/DataLoad/Catalog/IntegrateScenario directory.

After running the CleanUp.sql file, you might see that 0 rows are deleted for certain SQL statements. This result is expected, as not all rows are populated with data in this sample.

Previous topic: Sample: Loading initial data

Next topic: Sample: Loading merchandising associations

Related reference

Data load utility samples

+

Search Tips   |   Advanced Search