This error message is displayed when trying to delete a product that is in use. To resolve this issue, click the
Double Arrow button and use the
Last SQL Statement to identify which of the following three scenarios is causing the error.
- SELECT count(*) FROM SOItem - The product is in use on a sales order and must be removed from any sales orders before it can be deleted. If the product is on a fulfilled sales order, the product can be inactivated by unchecking the Active box on the General tab of the
Product module.
- SELECT * FROM KitItem - The product is in use on a kit and must be removed from any kits before it can be deleted.
- SELECT * FROM Product - The product may be set as the default shipping product on the Shipping tab of the
Sales Order module options and must be removed as the default shipping product before it can be deleted.
Double Arrow button and use the Last SQL Statement to identify which of the following three scenarios is causing the error.