Cannot delete product

[Ckay]

Hi

 

I have a product in my Prestashop site which I cannot delete because it does not even show up in my back office list of products. It does however show in the front office.

 

Any ideas anyone?

 

Thanks in advance.

[Ckay]

From other threads I've found, with a similar problem, people have suggested deleting 'John Doe' orders associated with the product. As it happens, the product in question is not associated with any orders but I thought I'd give it a try.

 

This is now throwing up a rather nasty error when I try and change the status of the order (See error message below). What concerns me is that there is a fundamental flaw somewhere in the system

 

[PrestaShopException]

Property StockAvailable->id_product is empty
at line 909 in file classes/ObjectModel.php

904.             }905. 906.             $message = $this->validateField($field, $this->$field);907.             if ($message !== true) {908.                 if ($die) {909.                     throw new PrestaShopException($message);910.                 }911.                 return $error_return ? $message : false;912.             }913.         }914. 

• ObjectModelCore->validateFields - [line 246 - classes/ObjectModel.php]
• ObjectModelCore->getFields - [line 652 - classes/ObjectModel.php]
• ObjectModelCore->update - [line 406 - classes/stock/StockAvailable.php] - [1 Arguments]
• StockAvailableCore->update - [line 127 - Core/Business/Stock/Core_Business_Stock_StockManager.php]
• Core_Business_Stock_StockManager->updateQuantity - [line 472 - classes/stock/StockAvailable.php] - [4 Arguments]
• StockAvailableCore::updateQuantity - [line 214 - classes/order/OrderHistory.php] - [4 Arguments]
• OrderHistoryCore->changeIdOrderState - [line 531 - controllers/admin/AdminOrdersController.php] - [3 Arguments]
• AdminOrdersControllerCore->postProcess - [line 178 - classes/controller/Controller.php]
• ControllerCore->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 58 - admin/index.php]