deleting a product removes it from the orders?

[Ray UK]

Hi,

When deleting an old product from the inventory, why does it remove it from the order details?

Looking at the shopping cart list, some orders that have been placed now show as £0 total because the items the ordered are now not in the catalogue.

In the Orders list, the totals are correct for the invoice, but trying to open any of those orders where a product is no longer in the catalogue causes an error with this wording

"Oops... looks like an unexpected error occurred.

Type error: Argument 4 passed to PrestaShop\PrestaShop\Core\Domain\Order\QueryResult\OrderShippingAddressForViewing::__construct() must be of the type string, null given, called in /home/**********/public_html/src/Adapter/Order/QueryHandler/GetOrderForViewingHandler.php on line 270

[Symfony\Component\Debug\Exception\FatalThrowableError 0]"

Opening the actual invoice pdf, the items are still listed.

PS 1.7.7.1

Edited February 1, 2021 by MerseyRay (see edit history)

[jetway]

Removing an item from your store does not remove it from previous orders. The order details are saved in the database table order_details, which remains untouched. I believe your issue is related to customer accounts. How old are the oldest user accounts in your shop? 

Edited February 3, 2021 by jetway (see edit history)