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.
Procedure
- 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:
- 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.
- Check for existing merchandising associations between
catalog entries by running the following command:
select * from massoccece where massoctype_id='massoctype_idFoundInStep_a'
- Check for existing merchandising associations between
categories by running the following command:
select * from massocgpgp where massoctype_id='massoctype_idFoundInStep_a'
- For any records found in steps b and c, change
the type of merchandising association to a merchandising association
which you will not delete.
- Stop your
WebSphere Commerce Server.
- Connect to the database.
- Run the following command:
delete from massoctype where massoctype_id=' massoctype_idFoundInStep_a'
- Start your
WebSphere Commerce Server.