Sample: Loading catalog entry description override data

This sample demonstrates how to load catalog entry description override data to your extended sites store.

By loading catalog entry description overrides with the Data Load utility or Catalog Upload feature, you can override the catalog entry descriptions that are inherited from your asset store. By overriding these inherited catalog entry descriptions, you can create store specific catalog entry descriptions to display on your storefront.

About this sample

The data load mediator in this sample loads catalog entry override data into the extended site store catalog. The sample that you are loading in this procedure overrides the description for two shared catalog entries in the catalog asset store. The sample is included in a new directory:

WC_installdir/components/foundation/samples/DataLoad/Catalog/ESiteOverride
WC_installdir\components\foundation\samples\DataLoad\Catalog\ESiteOverride

If you need to update the catalog entry description overrides, you can change the content of your input file and run the sample again.

Note: Both the extended sites store and the catalog asset store must be published.

The following is the override for the first catalog entry with part number ‘AuroraWMDRS-11’:


Column name	Extended site store override value
Name	White Flower Sundress
ShortDescription	Celebrate life with this white flower sundress
Thumbnail	images/catalog/apparel/women/womens_dresses_160x160/WD_031_a_red.jpg
FullImage	images/catalog/apparel/women/womens_dresses_1000x1000/WD_031_a_red.jpg

The following is the override for the second catalog entry with part number ‘AuroraWMDRS-6’:


Column name	Extended site store override value
Name	Strapless Cocktail Dress
ShortDescription	Luigi Valenti red cocktail dress with appliqued roses and tassels at the hem
Thumbnail	images/catalog/apparel/women/womens_dresses_70x70/WD_006_a_red.jpg
FullImage	images/catalog/apparel/women/womens_dresses_1000x1000/WD_006_a_red.jpg

Procedure

Before you run this sample, ensure that you publish the AuroraEsite store which uses the WebSphere Commerce Search. For more information about publishing starter stores, see publishing a store archive with the Publish wizard. For more information about publishing the Aurora enhancements store archive to enable WebSphere Commerce Search, see publishing a starter store enhancements store archive.
Open the wc-dataload-env.xml configuration file in the appropriate directory:
- WC_installdir/components/foundation/samples/DataLoad/Catalog/ESiteOverride
- WC_installdir\components\foundation\samples\DataLoad\Catalog\ESiteOverride
Update the file with your database settings, catalog asset store identifier, and catalog identifier
Open the command-line interface, and navigate to the appropriate directory:
- WC_installdir/bin
- WC_installdir\bin
Enter the following command:
- ./dataload.sh ../components/foundation/samples/DataLoad/Catalog/ESiteOverride/wc-dataload.xml -Dinstance=instance_name
- dataload ..\components\foundation\samples\DataLoad\Catalog\ESiteOverride\wc-dataload.xml -Dinstance=instance_name

-Dinstance: (Required) Specifies the instance that you want to use. When you are using this parameter, replace instance_name with the name of the WebSphere Commerce instance for which you are using the sample.

Verifying results

The wc-dataload.xml configuration file calls the wc-catalog-entry-description-override-loader.xml configuration file to load the description override from the CatEntryDescriptionOverride.csv source file. Verify that the data is loaded into your database by running the following SQL statements:

SELECT *  FROM CATENTDESCOVR 
WHERE CATENTRY_ID IN (select CATENTRY_ID from CATENTRY 
WHERE CATENTRY.PARTNUMBER IN ('AuroraWMDRS-6', 'AuroraWMDRS-11') )

These SQL statements return details about the description override of those two catalog entries. You can also verify the load by viewing the catalog entry in the storefront.

Note: If you do not see the changes in the store front, try the following steps

Clear your browser cache.
If you have DynaCache turned on, clear the cache that is created by DynaCache.
Rebuild your search index.

You can also verify that your description override information displays in Management Center and in your storefront. In the Management Center Catalogs tool, open the properties view for the catalog entry to verify the override information. You can further change your override information in this properties view.

You can preview your loaded information and any changes in your storefront by launching store preview in Management Center. For more information about using the Management Center to change and preview your description overrides, see Adding catalog entry description overrides

Cleaning up the data

To remove the data that is loaded in this sample from the database, run the Cleanup.sql file in the components/foundation/samples/DataLoad/Catalog/ESiteOverride directory.