Samples > Data load utility samples > Inventory samples


Sample: Loading non-ATP inventory

This scenario loads inventory records for a non-ATP store. You can either load the data into a consumer direct store, or an extended sites store.


About this sample

Each record stands for an inventory for a particular CatalogEntry be shipped from a FulfillmentCenter on behalf of a Store. The CatalogEntry can be identified by the PartNumber In non_ATP_inventory.csv and storeIdentifier in wc-dataload-env.xml For non-ATP store, we only load inventory for item data, it doesn't make sense to load inventory for product data.


Procedure

  1. Navigate to the appropriate directory:

  2. Enter the appropriate command:

    1. Consumer direct or B2B direct store

      • ./dataload.sh ../samples/DataLoad/Inventory/Non-ATP/wc-dataload.xml

      • dataload ../samples/DataLoad/Inventory/Non-ATP/wc-dataload.xml

    2. Extended sites store

      • ./dataload.sh ../samples/DataLoad/Inventory/Non-ATP/wc-dataload-for-esite.xml

      • dataload ../samples/DataLoad/Inventory/Non-ATP/wc-dataload-for-esite.xml


Verify the results

Verify that the data has been loaded by running the following SQL statement:

select * from INVENTORY where CATENTRY_ID in 
           (SELECT CATENTRY_ID
                      FROM CATENTRY 
                      WHERE partnumber like 'Cords%'
                              or partnumber like 'Classic pleated dress pant%'
                              or partnumber like 'Dress shirt%'
                              or partnumber like 'Casual shirt%'
                              or partnumber like 'Bodysuit%');

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


Clean up the data

To clean up the data loaded in the database, run the following SQL statement

delete from INVENTORY where CATENTRY_ID in 
           (SELECT CATENTRY_ID
                      FROM CATENTRY 
                      WHERE partnumber like 'Cords%'
                              or partnumber like 'Classic pleated dress pant%'
                              or partnumber like 'Dress shirt%'
                              or partnumber like 'Casual shirt%'
                              or partnumber like 'Bodysuit%');

:


+

Search Tips   |   Advanced Search