Jump to content

 

markuson

Member Since 08 May 2011
Offline Last Active Apr 20 2021 08:20 PM
-----

Topics I've Started

Deleting/archiving Old Orders Without Affecting Stock

23 April 2018 - 08:51 AM

Hi,

what should I do if I want get rid of old orders, which I dont need any more...?

When I simply delete them, all items from that orders get back to stock, which is unwanted. If my goal is to lower the database size on one side and simply delete old orders on other side, Is there any kind of "archiving" or deleting orders without affecting stock?

 

thanks for ideas


Database Order_Data Getting Too Big...

28 November 2017 - 08:59 PM

Hi all,

after almost 2 yrs of using CSC 4.3.7 Im facing growing database. Usualy I do delete logs which helps to save few megs, but database "order_data" is growing continuosly without possibility to trim or lower.

Firstly I tought I can lower this database when deleting older orders, but size of order_data lowers only little and when look into database I can still see even the oldest order numbers from beggining of eshop.

Database optimization from backup/restore menu does not make any difference on this particular database and this keep growing, actualy 150MB.

Do you have any idea how to solve this?

 

Many thanks, Marek