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?
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)
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
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.
Most Users Ever Online: 1012
Currently Browsing this Page:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Paul Cartwright: 414
Administrators: Matthew Ogborne: 4565, Dave Furness: 4606