Commerce, delete a product then what happens to related records

[Richard Arch]

What happens to transactions and invoices if a product that has been used is deleted?

Will the members who have purchased that product still see it in their Manage Purchases list or will it disappear from there.  Will it also disappear from the members customer view in ACP?

[Jim M]

You will either need to change or cancel the existing purchases. The alternative, if you no longer want to sell the product to new users but keep it available to current users is to remove the product from being visible in the store.

[Richard Arch]

Oh, not sure I'd want to cancel the purchases as that is transactional history I would like to keep as is although the product has expired/completed/finished.

At the moment I make such products Non Purchasable (Show in store? off and set Stock level to zero) which removes them from the Store but the list is growing making the Product list in ACP long and messy looking.

Any suggestions to a method of keeping it tidier?

Edited September 27, 2023 by Richard Arch

[teraßyte]

Are you leaving the disabled products in their original categories? One option could be moving them to a separate category to keep your others "clean" when looking at them in the ACP.

[Richard Arch]

Ah thats a nice idea but it will look strange in the Store having this category group full of products that can't be bought.

There doesn't seem to be any permissions that could be set to hide such groups.

[teraßyte]

As long as Show in store? is disabled the products won't show on the front end. I think (?) categories with no products available products are also automatically hidden, but I'm not completely sure. If they aren't, a quick plugin can take care of it, I guess. 🙄

[Richard Arch]

Nice and yes, I can confirm the category/group is not displayed in the Store when the products are not shown.

Thanks for help guys.