PS 1.5 how to reset delete orders and invoices?

[wagac2012]

Hi there,

 

I am ready to go public with the shop

 

however not sure how to erase former TEST users and orders

 

found som'n in this thread: http://www.prestasho...__fromsearch__1

 

though there is no instruction how reset the invoice number

 

can anybody help reviewing the whole process?

Edited November 19, 2012 by wagac2012 (see edit history)

[prestaslo]

Same problem...

 

I'm using 1.5.6.2

[vekia]

hello

have you tried to use PS Cleaner addon? it's a default prestashop module

[prestaslo]

Yes, but I made some test invoices myself...

[inweb]

You have to delete records in ps_orders table and all associated records in ps_order_carrier, ps_order_cart_rule, ps_order_detail, ps_order_detail_tax, ps_order_history, ps_order_invoice, ps_order_invoice_payment, ps_order_invoice_tax, ps_order_return, ps_order_return_detail, ps_order_slip and ps_order_slip_detail tables (make a database backup before taking any action).

[PrestaHeroes USA]

for me, and I recommend...simply cancel test orders....this way you do not take chance of corrupting your db with a cleaner solution.

[prestaslo]

for me, and I recommend...simply cancel test orders....this way you do not take chance of corrupting your db with a cleaner solution.

 

Yes I know, but I create some test orders and I would like to reset invoice number...

[inweb]

To reset invoice numbering change PS_INVOICE_NUMBER in ps_configuration table.

[prestaslo]

You have to delete records in ps_orders table and all associated records in ps_order_carrier, ps_order_cart_rule, ps_order_detail, ps_order_detail_tax, ps_order_history, ps_order_invoice, ps_order_invoice_payment, ps_order_invoice_tax, ps_order_return, ps_order_return_detail, ps_order_slip and ps_order_slip_detail tables (make a database backup before taking any action).

 

Thanks, I solve problem

[klemen130]

That doesn't solve same problem in my case. At next order is new invice number, but then at further orders it goes back to old invice numbers. Any idea to resolve?