Samples > Data load utility samples

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_INSTALL/bin

   • WCDE_INSTALL\bin

2. Enter the following command:

   • ./dataload.sh ../samples/DataLoad/Catalog/IntegrateScenario/wc-dataload-kit-bundle.xml

   • dataload ..\samples\DataLoad\Catalog\IntegrateScenario\wc-dataload-kit-bundle.xml

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

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: Replacing existing products and SKUs

Next topic: Sample: Loading classic attributes, attribute values, and allowed values

Related reference

Data load utility samples

+

Search Tips   |   Advanced Search