Greetings, All!
I'm running v2.5 and have completed the obligatory (for me at least) testing, testing, testing phase of data scenarios and would like now to compact the db of deleted data (test products, variants, customers, etc.) so that I can start uploading real data to a clean db. Is there an option anywhere either by nopC option (that I am missing) or a SQL script that would allow deleted db rows to be permanently deleted, thereby com pacting the db? What would realy be cool is if someone knew in addition a way to cross check the database to indicate potential failures of db flow, like ophans and the like.
Thanks in advance for any assistance.
HB