Develop > Presentation layer > Customize marketing > Work with Product Advisor

Delete separate search space for a category

This steps in this section explain how to delete separate search space for a category.

Procedure

1. Open a command window, which corresponds to the database that you are using.

2. Run the following SQL statements:

   1. delete from ICEXPLFEAT where CATGROUP_ID=xxxx
      

   2. delete from ICTPRICES where STOREID= storeId AND (CATENTRY_ID in (select CATENTRY_ID from CATGPENREL where CATGROUP_ID=xxxx) or CATENTRY_ID in (select CATENTRY_ID_CHILD from CATENTREL , CATGPENREL where CATENTRY_ID_PARENT=CATENTRY_ID and CATGROUP_ID=xxxx))
      

   3. delete from ICROOTCAT where CATGROUP_ID=xxxx
      

   4. drop table ICTxxxx
      

   5. drop table ICTDESCxxxx
      

   6. drop view ICVxxxx_NULL where, xxxx is the category reference number and storeId is the store reference number associated with the category.
      

Related concepts

Product Advisor cycle

Product Advisor

Shop metaphors

Product Advisor search space

Related tasks

Set the type of search space

Create search space for Product Advisor

Delete base search space for a category

Related reference

PACreateSearchSpaceBatchCmd scheduler command

+

Search Tips   |   Advanced Search