Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Archiving Data
Steven Howe

April 8, 2014 - 1:27 pm
Member Since: March 19, 2014
Forum Posts: 25
sp_UserOfflineSmall Offline

We are relatively high sales volume. Say 200-250k sales orders per year. Now that sales data is useful for reporting and being able to see what items perform when and to what extent, to where, on what markets, etc.

So, hanging onto that data seems useful, but I’m more interested in how this will begin to impact performance. There are also the requirements for tax inspection or other legal requirements around keeping your data.

Do you have any recommendations on being able to keep performance solid AND keep reporting accurate AND cover inspection criteria?

How necessary is archiving data?

Matthew Ogborne

April 8, 2014 - 2:05 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Steven,

This will start to become a challenge with a very large number of transactions in the site, a couple of options that immediately come to mind.

1. Better web hosting.
If you’re turning over that amount then you can afford better hosting. One of the companies that I work with have done over £1M on Magento, the biggest win they made was to get out of a Hybrid server and move to sonassi and trust me that site is now very, very quick (but costs a fair amount too)

2. Cloning.
Taking a clone of the site at a specific point in time means that you can shed older orders and still keep a backup & working version of the site if needed

3. An arching extension
There are a couple of these, basically they create a new order status called archive and put orders after X number of days into this state. Then tweak the orders page so that they’re not found, thus keeping the orders page manageable.

Those are the 3 that immediately sprang to mind, I’m sure there are plenty of other options too


"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme


Why Should You Join UnderstandingE?

  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks


Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.


Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
19 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5221

Posts: 27486

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606