Howto clear Order status list statistic?

12.08.2012 19:54
#1
trex
Joomshopping forum user no avatar
Name: Todor
07.04.2012
Posts: 4
Quote
Howto clear Order status list statistic?

I deleted some test orders in local shop. Is it possible now to undelete them?
If not how can I clear the Orders statistics in Options->Statistic?

 
19.08.2012 22:14
#2
trex
Joomshopping forum user no avatar
Name: Todor
07.04.2012
Posts: 4
Quote
Aw: Howto clear Order status list statistic?

You have to clear following MySQL tables:
#_jshopping_orders
#_jshopping_order_history
#_jshopping_order_item
then do the following SQL statements:
ALTER TABLE #_jshopping_orders AUTO_INCREMENT =1
ALTER TABLE #_jshopping_order_history AUTO_INCREMENT =1
ALTER TABLE #_jshopping_order_item AUTO_INCREMENT =1

Note: # is your database prefix.


Letzte Änderung: 20.08.2012 15:32
 


Copyrights MAXXmarketing GmbH. All Rights Reserved
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.