This is going to be a challenge and my instincts on this one is to ask for this data to be exported from eSellerPro (remember this is your data not theirs) and then we have the challenge.
Personally I would suggest not importing these into Magento, this is purely for speed. A database with 400K records less is going to be a lot smaller and you could very easily have this data stored in an access database or even a simple mysql database and add a PHP front end to it if y& when you need to access it.
Just to back up that latter suggestion with some costs, use XCrud here that costs $11 (£8) and it would be peanuts for a PHP developer to make you a simple page that has this password protected (htaccess & login) as XCrud does the display & searching for you, which is the complicated part.
Cheers Matt, that sounds great. I wouldn’t need it in Magento so that’s not a problem. It’s purely for record keeping purposes in case the tax man asks for any of it. (Never actually needed it yet)
Any idea how this would be dealt with in Magento? I assume after a year or so the database would be swelling with old order details. When they are 2 years old for instance could we export old orders to somewhere else to archive them and delete them from magento to keep it running fast?
Yea that’s possible, I’m actually wondering if anything older than a year is worth keeping or not in Magento. Not sure on the exact process, but it’s basically a database, so certainly possible.
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