I have products on my site that have never been sold and have become obsolete
Will there be any problems if i replace all the product information with a newer product instead of deleting the old product and creating a new product?
I understand there may be issues if there was a sale against a product so i would not follow this process then, i would just unpublish the product.
I just feel it would keep my database small and not grow it unnecessarily over time.
I need to say that i am purely a business owner with limited experience in databases and how they function
Any advice will be greatly appreciated