Cycledelic Posted February 28, 2006 Posted February 28, 2006 I am looking to expand a small retail store and online retailer, already setup with osCommerce, and currently using Quickbooks for all inventory, sales, etc. I want to upgrade to a POS system and am looking at the options for integrating our current Quickbooks information with the POS software. Does anyone have experience with integrating an osCommerce site and retail location with inventory of roughly 500-700 products? Is any software available to update in store sales with our in online inventory, either batched or in real time? Just looking at options currently, and would love to seamlessly integrate the POS software with Quickbooks and our osCommerce inventory setup. I am very interested in any suggestions, or from experience what software or packages anyone has decided to use in this way.
stillwater Posted March 2, 2006 Posted March 2, 2006 I am looking to expand a small retail store and online retailer, already setup with osCommerce, and currently using Quickbooks for all inventory, sales, etc. I want to upgrade to a POS system and am looking at the options for integrating our current Quickbooks information with the POS software. Does anyone have experience with integrating an osCommerce site and retail location with inventory of roughly 500-700 products? Is any software available to update in store sales with our in online inventory, either batched or in real time? Just looking at options currently, and would love to seamlessly integrate the POS software with Quickbooks and our osCommerce inventory setup. I am very interested in any suggestions, or from experience what software or packages anyone has decided to use in this way. read jcall's blog?
coldfission Posted July 10, 2007 Posted July 10, 2007 read jcall's blog? page not found. i need this information. where can i find it?
Guest Posted July 24, 2007 Posted July 24, 2007 Alex, My blog disappeared along with many others when the sponsorship program changed. My experience with osCommerce and Point of Sale could be summarized like this: 1) look for POS software that works with osCommerce 2) find expensive-ish software that really didn't do what I wanted 3) get frustrated with inventory issues stemming from running separate database for POS and for osCommerce 4) work with 3rd party development company to write a good synch tool for osCommerce and their software 5) get sick of waiting and purchase different POS software outright 6) start to develop that software. PM me if you would like additional information. -jared
motorcity Posted July 30, 2007 Posted July 30, 2007 This is a direction I've hoped to take for some time now. Real time POS & osCommerce sharing the same inventory, same database, on our own server. Our inventory is in the 100's of thousands of SKU's, and our website about 4,000 ~ I hate the idea of duplicate data entry and I still believe we'll get this somehow. With the way prices fluctuate in the real world how do you manage 2 separate databases without going crazy? I thought TurboCash was going to be the answer, but more recently I discovered it has been forked to Osfinancial, and part of the reason why was lack of interest. Reading up on osFinancials I discover it is using Firebird for its database. Again, it sounds like you get POS and you have to update in a batch form as many times a day or whatever you want, but it IS NOT the same database. I've seen several threads on this subject, and I remember Jcall's blog. I've also heard of several folks around here who have big store inventory running on (I'm pretty sure) MySQL - osCommerce. I've heard those who say MySQL is a poor database, I've also heard people say osCommerce is a poor shopping cart. You can't believe everything you hear because a lot of it is wrong. Now why can't the POS & the financial software just use a slightly expanded MySQL, and share the core of it from osCommerce?
Guest Posted August 18, 2007 Posted August 18, 2007 I'm glad there are apparently better solutions than when I was originally looking. The market sure seemed sparse at the time. FWIW, I'd like to think I was more frustrated and exasperated than cynical at that point. My post above was intended to convey simply what I discovered, not to disparage or put down. -jared
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.