Sort of a long story, but it involves a hard drive spontaneously combusting...
Is there a "PROPER" way to delete just the past sales data for thousands of previous sales?
Basically, I needed to install OSPOS on a new computer. We have three store locations, and the products, vendors, employee codes, taxes were all the same.
So I exported an SQL file from a store location #1, and then imported that SQL file into the database for Store Location #2.
Except that now Store Location #2 has all the sales data from Store #1
Anyway to remove that sales history easily? Do I just go into the ospos_sales table and delete all the rows? (This seems like it would probably be a bad idea...)
I don't want that old data from Store Location #1 affecting our reports gong forward for Store Location #2.
(P.S. I understand that getting the original sales data from Store Location #2 - where the hard drive burned out - is going to be nigh on impossible. So I just want store number 2 to start with a "clean slate" as it were).
Thanks in advance.