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_catalogdcs_root_catsdcs_root_subcatsdcs_sub_catalogsdcs_category_infodcs_product_infodcs_sku_infodcs_cat_subcatsdcs_cat_subrootsdcs_cat_catinfodcs_catinfo_ancdcs_prd_prdinfodcs_prdinfo_rdprddcs_prdinfo_ancdcs_sku_skuinfodcs_skuinfo_rplcdcs_gen_fol_catdcs_child_fol_catdcs_catfol_chlddcs_dir_anc_ctlgsdcs_ind_anc_ctlgsdcs_ctlg_anc_catsdcs_cat_prnt_ctlgdcs_cat_anc_catsdcs_prd_prnt_catsdcs_prd_anc_catsdcs_cat_catalogsdcs_prd_catalogsdcs_sku_catalogsdcs_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.CustomCatalogMigrationFor 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://hostname: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.
