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 beginning

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. We 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 we can include in this file, see CatalogEntry. This sample loads the following catalog entry data:

Part Number	Name loaded within initial catalog data sample	Updated name 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

We 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

• (Linux) utilities_root/samples/DataLoad/Catalog/CatalogEntryUpdate

• (Developer) 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 the WebSphere Commerce instance. These variables include the following information:

• Business context variables, including the store identifier, catalog identifier, and the default language and currency for the store.

• Database environment settings, including the database type, name, and schema.

Procedure

1. (Developer) On a command line, go to the WCDE_installdir\bin directory.

2. (Linux) Open a command line in the Utility server Docker container. Change the directory to utilities_root/bin directory.
   For information about entering and leaving containers, see Running utilities from the Utility server Docker container.

3. Enter the following command to run the sample data load order file and load the information that included in this sample:

   • (Linux) ./dataload.sh ../samples/DataLoad/Catalog/CatalogEntryUpdate/wc-dataload-catalog-entry-update.xml

   • (Developer) 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.

• We can also verify that the sample data is loaded by running the following SQL statements against the WebSphere 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 we 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.

Removing the sample data from the WebSphere Commerce database

To remove the sample data that you loaded in this sample from the database, run the CleanUp.sql file that is in the following folder:

• (Linux) utilities_root/samples/DataLoad/Catalog/IntegrateScenario

• (Developer) WCDE_installdir\samples\DataLoad\Catalog\IntegrateScenario

From a command prompt, connect to the database with your user ID and password. Run the following command. (DB2)

• (Linux) db2 -tvf ../samples/DataLoad/Catalog/IntegrateScenario/Cleanup.sql

(Oracle)

• (Linux) sqlplus user_name/password@ database_name@ ../samples/DataLoad/Catalog/IntegrateScenario/Cleanup.sql