Impact of deleting all products on invoiced orders

[nitin12m]

Hi All,

I have by mistake deleted all the products on my live site. I have just gone live so very orders were placed.All the orders which were placed were invoiced.

Will there still be any impact on the orders?

Secondly, there was no back up when i deleted the products, so i will be adding products in bulk or one by one. what issue can i possibly face as a result of this on new orders as well as the completed orders.

Note: One problem which will come across is, the existing customers will loose the products in the cart and there wish list will also be lost. Will there be any other impact?

Regards,

Nitin Singh

[Ketika M]

Hi @nitin12m ,

If you deleted all products then already placed order will not have any impact. Same with invoice, if it is already generated then there will be no impact.

If you are adding products again then bulk upload product functionality will be a good idea.

Impacts on customer end: 

1) Items lost from wishlist

2) If added into cart then also it will be lost

3) If any reviews have been submitted by customer then also it will not appear.

It can impact on SEO as well, if uploaded products URL will be different from the deleted one. So you can check this area as well.

if issue solved,Click Kudos & Accept as Solution

[nitin12m]

@Ketika M 

Thanks for the inputs.

Can you also provide some insights when the orders are not processed. Like have not been invoiced.

Also any idea or pointers on who quickly can the data be restored from back up?

Also seems the data was deleted due to bug with magento:

https://github.com/magento/magento2/issues/15935

https://github.com/magento/magento2/pull/16702

[Ketika M]

Hi @nitin12m ,

If order is placed and product is deleted after that then also we can proceed with the Invoice and other things. There will be no issue into that.

For this bug, yes it was till Magento 2.2.x but in Magento 2.3, this has been resolved. Check here:

https://devdocs.magento.com/guides/v2.3/release-notes/ReleaseNotes2.3.0OpenSource.html

Check in UI section, you will see the first pointer and it is resolved now.

if issue solved,Click Kudos & Accept as Solution