To use custom catalogs, you must convert your existing standard product catalog to the custom catalog configuration. The following steps describe how to perform this conversion.
Keep in mind that before you set up your custom catalogs for the first time, you should run the Catalog Maintenance Service as described in Using the Catalog Maintenance System.
Step 1: Add New Database Tables
Custom catalogs require some new database tables. These tables are defined in custom_catalog_ddl.sql
. This script is located in the <ATG9dir>/DCS/CustomCatalogs/sql/db_components/
<db-vendor> directory.
Running this script adds the following tables to your database:
dcs_catalog
dcs_root_cats
dcs_root_subcats
dcs_sub_catalogs
dcs_category_info
dcs_product_info
dcs_sku_info
dcs_cat_subcats
dcs_cat_subroots
dcs_cat_catinfo
dcs_catinfo_anc
dcs_prd_prdinfo
dcs_prdinfo_rdprd
dcs_prdinfo_anc
dcs_sku_skuinfo
dcs_skuinfo_rplc
dcs_gen_fol_cat
dcs_child_fol_cat
dcs_catfol_chld
dcs_dir_anc_ctlgs
dcs_ind_anc_ctlgs
dcs_ctlg_anc_cats
dcs_cat_prnt_ctlg
dcs_cat_anc_cats
dcs_prd_prnt_cats
dcs_prd_anc_cats
dcs_cat_catalogs
dcs_prd_catalogs
dcs_sku_catalogs
dcs_user_catalog
Step 2: Run the Custom Catalog Migration
The Commerce Admin page includes a tool that automatically migrates your existing catalog to the new custom catalogs.
Specify the following module during application assembly:
DCS.CustomCatalogMigration
For more information on assembling applications, see the ATG Programming Guide.
Access the ATG Dynamo Administration page by pointing your browser to the URL appropriate for your application server. See the ATG Installation and Configuration Guide for the default port. For example, the default URL on JBoss is:
http://
host
name
:8080/dyn/adminNote: your application must include the Dynamo Administration UI module in order for you to view this URL.
Click on the Commerce Administration link to open the ATG Commerce Administration page.
Select Standard to Custom Catalog Migration.
Enter the nucleus path to your catalog repository component in the Catalog Repository To Migrate: field.
Enter a display name for the new custom catalog.
Click on Migrate. Status updates display in the browser as the migration takes place.
Step 3: Assign Users to Custom Catalogs
You can set each user’s catalog manually or automatically. To automatically assign your customers to a custom catalog, use a scenario to set the catalog as soon as the user’s session begins. For information on scenarios, see the ATG Personalization Programming Guide.