Sample: Loading bundles and kits

This sample demonstrates how to load bundles and kits to the database.

About this sample

This sample loads the following catalog entries:
  • A bundle named 'Gift set - Shirt Pants' (contains the SKUs 'Classic pleated dress pant-Black-29W x 32L' and 'Dress shirt-White-15')
  • A kit named 'Gift set - Pants' (contains the SKUs 'Classic pleated dress pant-Black-29W x 32L' and 'Cords-Brown-29W x 28L')

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_installdir/bin
    • WebSphere Commerce DeveloperWCDE_installdir\bin
  2. Enter the following command:
    • SolarisLinuxAIX./dataload.sh ../samples/DataLoad/Catalog/IntegrateScenario/wc-dataload-kit-bundle.xml
    • WebSphere Commerce DeveloperWindowsdataload ..\samples\DataLoad\Catalog\IntegrateScenario\wc-dataload-kit-bundle.xml

Verifying results

The wc-dataload-kit-bundle.xml configuration file loads one kit and one bundle from the KitBundle.csv source file. Verify that the data is loaded by running the following SQL statements:
select * from catentry where partnumber like '%Gift Set%'
select *  from catentdesc where catentry_id in (select catentry_id from catentry where partnumber 
like '%Gift Set%')
select * from catentrel where catentry_id_parent in (select catentry_id from catentry where partnumber
 like '%Gift Set%')
select *  from listprice where catentry_id in (select catentry_id from catentry where partnumber
 like'%Gift Set%')
These SQL statements return details about the kit and bundle, including the list price and offer price.

You can also verify the load by viewing the kit and bundle in the Management Center or in the storefront.

Cleaning 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.
Note: 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.