Best way to remove test transactions from DB ?

Hi. Before going live, I want to "sanitize" the production DB of all the test transactions that we've been doing. What's the recommended/quickest way to do this?

Thanks in advance

Rich

Reply to
hitman
Loading thread data ...

Rich,

Store Ops Admin --> Connect --> DB menu --> Delete transactions

Rob

Reply to
Robert

Yes, I just want to remove all POS transactions that we used for testing (sales info and any associated report data that's created)...haven't gone live yet, so don't have any PO activity. I'm reloading all inventory items and quantities via the import utility (see my related post), so should the command per earlier suggestion be okay?

Regards,

Rich

"Alex" wrote:

Reply to
hitman

But doesn't this also remove any and all P.O. activity / transactions? And how about inventory?

Reply to
Alex

Reply to
beadstringer55

Thanks, good info to know! BTW: Are you in the retail / bead business? If so, I'd like to compare notes / share any tips with you on using RMS in this context, if you're interested...let me know and I'll give you my offline contact info or I can contact you at your convenience...

Best regards,

Rich Muller

"beadstr> hi,

Reply to
hitman

Reply to
beadstringer55

Greetings, my name is Rich Muller --

Below is my contact info, let me know how you'd like to correspond...we just opened up a new store in Fresno, CA this month running RMS on 2 registers...before that no real experience wth POS applications, but I've been doing global networking /IT for the last 20 years (currently on a "sabatical" helping my wife get things going w/ the business), so I'm sure you've got a wealth of knowledge in terms of best practices for the business & IT side of things as it pertains to running a retail bead shop using RMS...look forward to chatting with you.

Kind regards,

Rich Muller Bella Bead Boutique Fresno, CA

559-447-0400 snipped-for-privacy@pacbell.net

"beadstr> Yes, I am in the bead biz. In addition to being a Certified tech for several

recommended/quickest way

Reply to
hitman

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.