Samples > Data load utility samples
Sample: Loading merchandising associations
This sample demonstrates how to load merchandising associations for SKUs that have already been loaded to the database.
About this sample
This sample loads the following associations:
- A cross-sell from the SKU 'Cords-Black-29W x 28L' to the SKU 'Casual shirt-White-Small'.
- An up-sell from the SKU 'Cords-Black-29W x 28L' to the SKU 'Classic pleated dress pants-Black-29W x 32L'.
Procedure
Before running this sample, ensure that you have loaded the initial data.
- Open the command-line interface and navigate to the appropriate directory:
- WC_INSTALL/bin
- WCDE_INSTALL\bin
- Enter the following command:
- ./dataload.sh ../samples/DataLoad/Catalog/IntegrateScenario/wc-dataload-merchandising-association.xml
- dataload ..\samples\DataLoad\Catalog\IntegrateScenario\wc-dataload-merchandising-association.xml
Verify results
Verify that the merchandising associations are loaded by running the following SQL statement:
select * from MASSOCCECE where catentry_id_from = (select catentry_id from catentry where partnumber ='Cords-Black-29W x 28L')
You can also verify the load by viewing the new associations 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: Updating SKU inventory
Next topic: Sample: Replacing existing products and SKUs
Related reference