I don't expect Chris or the team to develop an entire automatic migration from QB POS - but I am posting here to see if anyone has done this and has any tips, pointers, or pitfalls to be aware of. I have about 6.5 years worth of sales data in QB POS but we are sick of paying the exorbitant licensing fees they charge for the privilege of upgrading every three years(despite minimal improvements to the software with upgrades) and are ready to migrate to a more modern POS system with more robust features and better support(thank you Chris!)
QBPOS will export Items, Customers, Vendors, Departments, and Employees to Excel, which would allow us to fairly easily set up a similar framework in PHPpos; but the most important feature, sales receipts/history, cannot be exported directly. There are other programs out there (an ODBC driver, and another custom one) which will dump this data into Excel or CSV format.
My gut is telling me that the best way to get this data into PHPPOS will be to either import it directly into the MySQL database, or use the API to do so. Any suggestions from anyone out there on where to start?
This is kind of a daunting task, but frankly the benefits of figuring this out far outweigh the headaches. If we can't pull the historical data over, then we face the reality of having to use BOTH pos systems - PHPPOS for current activity, and QBPOS for pulling historical sales data - at least until the remaining data in QBPOS is so old that it's obsolete - but frankly, that could be years.
This is made somewhat easier only because we have not ever in history accepted CC payments from within QBPOS - we have always used standalone terminals which do not communicate with QBPOS, so we do not have to worry about the complexities of handling and migrating sensitive payment card information at all.
Hopefully someone has some advice. :) Thanks in advance!
Please sign in to leave a comment.