Cycledelic Posted February 28, 2006 Share 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. Link to comment Share on other sites More sharing options...
Guest Posted March 3, 2006 Share Posted March 3, 2006 I have some details of my experiences with this very problem on my blog. Of course, your experience may be different, but at least you can see what our business went through. I know that some folks here have had success with Turbocash as well. -jared Link to comment Share on other sites More sharing options...
Cycledelic Posted March 4, 2006 Author Share Posted March 4, 2006 Thanks Jared - I did find your blog the other day and the information is very helpful. I'm looking into the same solutions, but am curious if you looking into the Atandra T-Hub software at all? The software apparently can sync the inventory between osC and either Quickbooks or Quickbooks POS, depending on which software you purchase. Its pricey software but would be a solution for a growing business. Any experience for you researching this software? Link to comment Share on other sites More sharing options...
Guest Posted March 8, 2006 Share Posted March 8, 2006 I had not seen this software previously. If I had, I'd have considered it, but probably not have purchased it (again, not everyone's needs are the same) because: - they charge $200/year for realtime synch - for our purposes, it really just takes care of the online <--> in-store synchronization function and still requires Quickbooks POS, which we wanted to get rid of anyway. Good luck! -jared Link to comment Share on other sites More sharing options...
mjhaatandra Posted March 16, 2006 Share Posted March 16, 2006 I had not seen this software previously. If I had, I'd have considered it, but probably not have purchased it (again, not everyone's needs are the same) because: - they charge $200/year for realtime synch - for our purposes, it really just takes care of the online <--> in-store synchronization function and still requires Quickbooks POS, which we wanted to get rid of anyway. Good luck! -jared Hi Jared, Just wanted to clarify that the $200/year pricing DOES NOT apply for osCommerce to QuickBooks link with T-HUB. Also the T-HUB product integrates with QuickBooks while the "T-HUB for POS" integrates with QuickBooks Point of Sale Manish Atandra Link to comment Share on other sites More sharing options...
joedunn Posted March 25, 2006 Share Posted March 25, 2006 I am also looking for a way to integrate Quickbooks Point of Sale with OSC. Have you found a really easy, fast and cheap solution? :rolleyes: Link to comment Share on other sites More sharing options...
Guest Posted March 25, 2006 Share Posted March 25, 2006 The only option I'm aware of is T-HUB, mentioned above. You can see my blog for more information about the process I went through, things I tried, etc. -jared Link to comment Share on other sites More sharing options...
CDavis78 Posted March 28, 2006 Share Posted March 28, 2006 The only option I'm aware of is T-HUB, mentioned above. You can see my blog for more information about the process I went through, things I tried, etc. -jared Okay - I am WAY new at all this stuff so I don't have a clue as to what T-Hub or anything else for that matter is... but I'm searching these forums looking for a "shopping cart" system that will keep real time track of my inventory. I have an eBay store & want to create my own site - the size, color, etc of each item varies and quantities are usually limited to 2 per size... does this POS thing you have keep updated inventory and is it fairly simple to figure out? Thanks! :blush: Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2006 Share Posted March 28, 2006 T-Hub is some software that, among other things, has a synchronization tool that synchs up Quickbooks Point of Sale with osCommerce. For more information, simply search your favorite search engine for Atandra T-Hub. Some other alternatives for synching with osCommerce (or using the osCommerce database) are PHP Point of Sale (sourceforge.net project), TurboCash (turbocash-usa.com) and WebCart Point of Sale. I personally prefer WebCart Point of Sale, but as everyone's needs are different, I recommend that you do some research on each one of them and decide which one is right for you. Edit: Re-reading your post, Cathy, it seems that you're perhaps not looking for a Point of Sale (think of it as an intelligent PC cash register) but a replacement for your eBay store. osCommerce will be an effective replacement for your eBay Store, but you may find that you want to either learn a little PHP, or hire someone else who is familiar with osCommerce, to add some of the many "contributions" that are freely available to enhance your osCommerce site. Just remember not to try to hire folks by posting here on the forums - - it's considered a commercial post and is prohibited. -jared Link to comment Share on other sites More sharing options...
joedunn Posted March 29, 2006 Share Posted March 29, 2006 Jared, I looked through your blog but only found 3 pages. I could not find anything about integrating Quickbooks Point of Sale and OSCommerce in those 3 pages. Could you point me to it? I would greatly appreciate it. Thanks, Joe Link to comment Share on other sites More sharing options...
Guest Posted April 6, 2006 Share Posted April 6, 2006 There is a lot of info in the comments, but the ONLY tool that I've found that synchronizes Quickbooks POS data with osCommerce is the T-HUB product mentioned above. The other info on my blog that is relevant to this discussion can largely be summed up like this: - I found a few other Point of Sale systems, some of which say they synch with osCommerce - I didn't like either of the two the currently synch - Another POS, with a synch tool "in the works" apparently never got finished - I found a POS that suited my personal needs, bought rights to it, and now develop it. It doesn't suit everyone's needs, but it does mine. HTH -jared Link to comment Share on other sites More sharing options...
stillwater Posted April 7, 2006 Share Posted April 7, 2006 POS solutions I have found so far: 1. TurboCash: PC based open source accounting software with a built-in simple POS. Written in Delphi. You need to install a script on your oscommerce website. 2. QuickBooks POS and T-HUB by Atandra: PC based commercial product. If you use quickbooks pos, T-HUB is the sync solution. 3. PHP Point of Sale for osCommerce: Web based. Open source. 4. WebCart: Web based. Commercial product. 5. SynPOS: Free. Closed source. Written in Java. You need to install a script on your oscommerce website. The first two solutions are for PC based POS. PC based POS software usually has its own product database. So it's always a problem to maintain two databases (online oscommerce and ofline pos) even though you can sync them. Web based solutions use native osCommerce database to eliminate the need for sync. I see two problems with a web based solution: 1. Availability: you can't access your POS when you lose your internet connection. 2. Hardware: it will be very difficult to connnect to most POS hardware like cash drawer, pole display, credit card terminal, pinpad... if it's possible SynPOS is something in between the above two categories. It's PC based but use native osCommerce database. Interesting idea. Unfortunately it's still under development. Link to comment Share on other sites More sharing options...
Guest Posted April 7, 2006 Share Posted April 7, 2006 If you're considering a web-based solution: There are often very easy ways to access the POS hardware. Most cash drawers can be opened by sending a control sequence to the connection they're plugged in to. Mine, for example, is opened by sending a CTRL-G to the LPT port. A Google search will yield several proposed solutions for programmatically opening cash drawers. I suspect it's the same with the pole display. The pinpad and credit card terminal go together, and don't have to be hooked up the POS. Sure, it's more convenient to have them integrated, but not always a necessity. You'll need internet connectivity to access the POS. If you're considering a PC-based solution: You'll need internet connectivity to access the database. You may be able to access the POS, depending on the POS architecture, but you'll not be able to synch inventory or customer data until the internet connection is available again. As always, YMMV, and the best solution for one situation can be the worst solution for another situation. :) -jared Link to comment Share on other sites More sharing options...
mthierfelder Posted January 2, 2007 Share Posted January 2, 2007 I am in the same boat, I have a brick & mortar store that needs an online store. They use QuickBooks POS, and OsCommerce and I have just installed T-HUB to integrate the two. I am not yet able to get T-HUB to download orders though, it gives me an error: "Error in writing to file [C:/Program Files/ATANDRA/T-HUB/THubOrdersTemp.xml]" Then it gives me another error after I close that box that essentially says the same thing. I've tried changing the entire ATANDRA folder and subfiles to non-read only in the windows explorer but that didn't help. I do have some admin modules installed but T-Hub says it is connecting successfully so I'm not sure what the problem is at this point and the T-HUB support line goes to a message machine. Any help appreciated. Mike Installed Modules: Dynamenu, InfoBox Admin, Master Products v.1.2, Header Tags Controller, Multiple Products Manager, Quick Edit in Admin, Secure Admin, Ultimate SEO URL's, EZ Secure Order, Easy Populate v.2.76d MS2, AuthorizeNet_AIM, ChangeFinal Breadcrumb Title, FedEx Labels, Fedex Direct 2.06, How Did you Hear 1.5, Login a la Amazon, UPS XML 1.2.4, USPS Labels, USPS Methods API MS2 Link to comment Share on other sites More sharing options...
superdairyboy Posted January 12, 2007 Share Posted January 12, 2007 I've come across this Web based POS Looks like it might be good I'm waiting for a return Phone call and a Complete list of features http://www.florentinedesign.com/oscommerce-pos.htm Also found this for automating Shipping http://www.interapptive.com And this for intergrating E-bay with OS commerce http://www.auctionblox.com/index.htm All three look very prommising I'm looking forward to trying them all and seeing how they work. Any one here use any of them? Brian Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.