Delete a merchandising association type

You can delete any custom merchandising association type you created. Do not delete the following default merchandising association types: cross-sell, up-sell, replacement and accessory.

To delete a merchandising association type:

1. Ensure there are no existing merchandising associations of the type you want to delete.
   If you delete a merchandising association type, any existing merchandising associations using that type will also be deleted. If this situation is acceptable to you, skip this step. Otherwise:

   1. From a database command window, find the massoctype_id by running the following command: select massoctype_id from massoctype. Find the massoctype_id in the resulting list.

   2. Check for existing merchandising associations between catalog entries by running the following command:

          select * from massoccece where massoctype_id='massoctype_idFoundInStep_a'
      

   3. Check for existing merchandising associations between categories by running the following command:

          select * from massocgpgp where massoctype_id='massoctype_idFoundInStep_a'
      

   4. For any records found in steps b and c, change the type of merchandising association to a merchandising association which you will not delete.

2. Stop your WebSphere Commerce Server.

3. Connect to the database.

4. Run the following command:
   delete from massoctype where massoctype_id='massoctype_idFoundInStep_a'

5. Start your WebSphere Commerce Server.

Related concepts

• Merchandising associations

Related tasks

• Create a merchandising association semantic

• Change the type or semantic of merchandising association

• Deleting a merchandising association semantic