Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
Sales invoices in ESP
Dave1
Member
November 8, 2013 - 6:41 pm
Member Since: October 24, 2013
Forum Posts: 153
sp_UserOfflineSmall Offline

Something just dawned on me, we keep all of our old sales invoices in ESP. If we ever needed to produce one for tax purposes we would just look the order up and be able to view the invoice.

Is there any way to export them if we moved, I estimate there are 400k of them!

Avatar
Matthew Ogborne

Founder
November 8, 2013 - 7:02 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Dave,

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.

Matt

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

Ultimo Magento Theme

Avatar
Matthew Ogborne

Founder
November 8, 2013 - 7:06 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Dave,

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.

Matt

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

Ultimo Magento Theme

Dave1
Member
November 8, 2013 - 7:37 pm
Member Since: October 24, 2013
Forum Posts: 153
sp_UserOfflineSmall Offline

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?

Avatar
Matthew Ogborne

Founder
November 8, 2013 - 7:57 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Dave,

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.

Matt

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

Ultimo Magento Theme

Dave1
Member
November 8, 2013 - 8:43 pm
Member Since: October 24, 2013
Forum Posts: 153
sp_UserOfflineSmall Offline

Cheers Matt, just installing Magento and M2E Pro now to have a mess around and get a feel for things. Should be in the pub….

 

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:
30 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