Sample: Loading updates for catalog entry properties and descriptions

This sample demonstrates how to use the Data Load utility update mode to update catalog entry property and description information. In this sample, the names for existing products and SKUs are changed.

Before you begin

Ensure that you load the data that is in the following sample:

Sample: Loading initial data

When you load the following sample, the Data Load utility updates the name of products and SKUs that were loaded in the initial catalog data sample.

About this sample

The CatalogEntriesUpdate.csv file in this sample updates only the product and SKU names. You can include more information in the CatalogEntriesUpdate.csv file to update other catalog entry property and description information. Any field that is left without a value is unchanged by the Data Load utility when the utility runs in update mode for loading catalog entry data. For more information about the information that you can include in this file, see CatalogEntry.

This sample loads the following catalog entry data:

Part Number	Name that is loaded within initial catalog data sample	Updated name that is loaded within this sample
`Cords`	`Men's corduroy pants`	`Men's designer corduroy pants`
`Cords-Black-29W x 28L`	`Men's corduroy pants - Black 29W x 28L`	`Men's designer corduroy pants - Black 29W x 28L`

You can load data for updating catalog entry data in CSV or XML formatted input files. The following procedure loads only CSV input files. The sample CSV input file, load order configuration file, and business object configuration file for this sample are in the following folder

utilities_root/samples/DataLoad/Catalog/CatalogEntryUpdate
WCDE_installdir\samples\DataLoad\Catalog\CatalogEntryUpdate

The wc-dataload-env.xml file is in the Catalog folder, which contains the CatalogEntryUpdate folder.

The sample folder includes the following files:

CatalogEntriesUpdate.csv

The Data Load utility uses this sample input file to load the catalog entry data.

wc-loader-catalog-entry-update.xml

The business object configuration file for loading the catalog entry data. This file defines the appropriate business object mediator to use to load the data. The Data Load utility uses this configuration file and mediator to load the data in the CatalogEntriesUpdate.csv input file into the CATENTDESC database table.

wc-dataload-catalog-entry-update.xml

The data load order configuration file, which indicates that the Data Load utility is to run in update mode. This file identifies the CSV input file to load, the data load environment configuration file, and the business object configuration file to use to load the input CSV file data.

wc-dataload-env.xml

The data load environment configuration file, which includes the environment variables for your HCL Commerce instance. These variables include the following information:

Business context variables, including the store identifier, catalog identifier, and the default language and currency for your store.
Database environment settings, including the database type, name, and schema.

Procedure

Open the command-line interface to the utilities directory.
- Open a command-line shell in the Utility Docker container. For information on entering and leaving containers, see Running utilities from the Utility server Docker container. Change the directory to
  utilities_root/bin
- Open a command-line interface and change the directory to:
  WCDE_installdir\bin
Enter the following command to run the sample data load order file and load the information that included in this sample:
- ./dataload.sh ../samples/DataLoad/Catalog/CatalogEntryUpdate/wc-dataload-catalog-entry-update.xml
- dataload ..\samples\DataLoad\Catalog\CatalogEntryUpdate\wc-dataload-catalog-entry-update.xml

The Data Load utility uses the wc-loader-catalog-entry-update.xml configuration file to update the product and SKU data that is in the database with the data that is in the CatalogEntriesUpdate.csv source file.

Verifying results

Verify that the catalog entry data is loaded by reviewing the data load summary report. For more information about the location and contents of this summary report, see Verifying the results of the data load.
You can also verify that the sample data is loaded by running the following SQL statements against your HCL Commerce database:
```
select * from catentdesc where catentry_id in (select catentry_id from catentry where partnumber like
 '%Cords%');
```
This SQL statement returns the description information for the product and SKU that is updated in this sample. Ensure that the value for the name column is updated with the data that you loaded in this sample. Ensure that the values for all other columns remain unchanged.
In Management Center or the storefront, verify that you can view the catalog entry. Verify that the name for the catalog entry is the updated name from this sample and that all other information is unchanged.

Cleaning up the data

To remove the data that is loaded from the database in this sample, run the CleanUp.sql file in the /samples/DataLoad/IntegrateScenario directory.