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
- Go to the appropriate directory:
- WC_installdir/bin
- WCDE_installdir\bin
- Enter the appropriate command:
- 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
- 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
- Consumer direct
or B2B direct store
Loading data for inventory flags
You cannot use the Data Load utility to update the value of inventoryflags. The default value of inventoryflags is 0. Update it directly using the following SQL statement after the data has been loaded: update inventory set inventoryflags=xx 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%');
Verifying 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
you want to update after initial load, you can update in the CSV file
and run the load again.Cleaning 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%');
: