Delete Test Transactions?

[vzex]

How do I remove all the test transactions?

They are still there even after uninstalling and deleting stripe module?

Test data was deleted at stripe but they all still show up.

[MockoB]

I'm not sure but if you are in demo mode there is module for what you need and if you are not there is no way to delete them. There was a way to remove them just from the list in the back office but all their entries in the database will be left.

[30knees]

Is it safe to just go into the database and delete the orders in tb_orders?

[MockoB]

There are too many entries concerning orders, there will be always something left. I'm not sure how safe it could be, but if it is test environment why not try.

[30knees]

I think this would be a good feature. I posted about it here: https://forum.thirtybees.com/topic/793/suggestion-delete-orders-directly-in-the-backend

I went in to the database and deleted all idorder and idorder_* rows. So far it looks OK, but I haven't tested fully yet.

[vzex]

I'm not too happy about the test data being there. :(

I'm going live soon so I really don't want to break something deleting things.

Seriously, test data needs a delete key!

[MockoB]

What about invoices, carts associated with those orders etc. If that link is the feature request, I voted for it long time ago. But i don't think somebody will develop such module because it is illegal to delete orders I believe.

[MockoB]

@vzex i wouldn't risk if i was you. Soon they will be on the next page and won't bother you.

[vzex]

Not sure about deleting orders being illegal but I deleted all my test orders, customers etc getting ready to go live.

Came to a halt when I couldn't delete test stripe transactions :(

My pet peeve is modules leaving trash behind when you delete them.

I don't think basic functionality keeping things tidy should require a module but should be built in.

Then again I don't write code

[MockoB]

Sure it would be great to be build in feature and many need it but sure it is illegal at least in EU.

[vzex]

I'm on the other side of the pond, never heard that before!

[MockoB]

:) it maybe will not concern you then.

[30knees]

@mockob It most definitely is NOT illegal to delete orders in your shop. You might be mixing something up with deleting accounting entries.

[MockoB]

@30knees at least in my country and I believe whole eu, the financial data is protected by the law and can't be deleted. I will look later for particular directive and if I find such I will paste it here.

[MockoB]

Sorry for posting that link here but @30knees please check the third paragraph: http://doc.prestashop.com/m/mobile.action#page/20578341

[30knees]

@mockob Thank you for the link, but it's incorrect in that broadness. You are required to keep data relating to a transaction. That makes sense. If you sell something, you need to keep documentation that you sold something. How long you need to keep the data depends on your country.

But if you didn't sell something, eg if someone placed a fake order or placed an order but never paid, if you made a test order and want to delete it, there's nothing that would prevent you from doing so.

[MockoB]

That's the statuses are for. And don't get me wrong, I need that feature too but not for the legal part you talk about ...

[vzex]

UPDATE

Used PHPMyAdmin found and deleted all 17 test transactions by deleting them under: stripetransaction

They no longer show up in stripe BO module so I'm happy they are hopefully all gone.

If remnants remain elsewhere at least I don't have to see them :)

[vzex]

Aw thanks, now I have to send another :coffee:

Don't forget the capture/charge delay, think it's 7 days, until product shipped :) :) :)

You work so fast I'd hate for you to run out of things to fix ;)