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
- utilities_root/samples/DataLoad/Catalog/ESiteOverride
- WCDE_installdir\samples\DataLoad\Catalog\ESiteOverride
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 |
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 HCL Commerce Search.
- Open the wc-dataload-env.xml configuration file in the appropriate directory:
- utilities_root/samples/DataLoad/Catalog/ESiteOverride
- WCDE_installdir\samples\DataLoad\Catalog\ESiteOverride
- Update the file with your database settings, catalog asset store identifier, and catalog identifier
- On a command line, go to the WCDE_installdir\bin directory.
- Open a command line in the . Change the directory to utilities_root/bin directory. For information about entering and leaving containers, see Running utilities from the Utility server Docker container.
- Enter the following command:
- ./dataload.sh ../samples/DataLoad/Catalog/ESiteOverride/wc-dataload.xml -Dinstance=instance_name
- dataload ..\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 HCL Commerce instance for which you are using the sample.
Verifying results
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.- 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