New Quickbooks integration option.

Ubercart is spreading Smiling . Webgility announced Friday their release of Quickbooks integration with Ubercart 2.0.

greggles's picture
Offline
Joined: 12/12/2007
Juice: 97
interesting - license not found

I was unable to find the license for this service. It looks like Ubercart talks to something called eCC - I'm not sure how or where eCC runs - and then eCC and Quickbooks can talk to each other. Are there any more technical details on how eCC works? If it runs as an Ubercart/Drupal module then this needs to be licensed under the GPLv2+.

webgility's picture
Offline
Joined: 11/04/2009
Juice: 36
eCC details

eCC is a desktop software and it also includes a small module that you install with Ubercart. To learn more about eCC, please visit this page: http://www.webgility.com/quickbooks-integration-ubercart.php

Thanks.

Connect your Ubercart store with QuickBooks & Shipping
Free 15-day trial at http://www.webgility.com

mimetic2's picture
Offline
Joined: 08/07/2007
Juice: 478
Re: eCC details

thank god! i hope this works

sacredjewelry's picture
Offline
Joined: 10/21/2009
Juice: 14
Fingers crossed

Downloading the free 15-day trial. The video demos are promising. Anyone have any luck with this yet?

Thx

Sacred Jewelry, Art, & Gifts
http://www.ShopSacred.com

BenK's picture
Offline
Joined: 11/23/2009
Juice: 4
Ubercart Quickbooks Integration module

Hey everyone,

Rather than look to commercial desktop software for Quickbooks integration, it would be terrific if we could all join forces to get the "Ubercart Quickbooks Integration module" to a stable D6 release. Here's a link to the module:

http://drupal.org/project/uc_qb

And here's a link to the D6 port thread:

http://drupal.org/node/328608

Let's make this happen!

Cheers,
Ben

j0rd's picture
Offline
Getting busy with the Ubercode.
Joined: 07/16/2008
Juice: 453
Re: Ubercart Quickbooks Integration module

Quickbooks is a commercial desktop software. This is one of the most highly sought after modules for Ubercart for more than a year now, but no one has stepped up to create/support it. I assume because it's a fairly large undertaking. There are multiple versions of quicken. And it's not worth the effort, when you can purchase a connector for a couple hundred bucks.

I know of three commercial integrations:
http://www.deepthoughtsoftware.com/
http://www.webgility.com/quickbooks-integration-ubercart.php

Ubercart could also be supported with minor effort by integrating it into http://www.atandra.com/Prod_THub.htm

More paid options and the more they cost, is best for Ubercart....it provides us with the options and eventually someone cheap/bored enough will clone them. Until that time, you have to pay to play.

BenK's picture
Offline
Joined: 11/23/2009
Juice: 4
Re: Ubercart Quickbooks Integration module

j0rd,

Thanks for the reply. I'm not opposed to paying for commercial software... I'm just opposed to most desktop software at this point. We don't use the desktop version of Quickbooks, but rather Quickbooks Online (http://oe.quickbooks.com). We're Mac-based with multiple users in multiple geographic regions, so most desktop software doesn't cut it for us.

Also, I don't think the Ubercart Quickbooks Integration module is that far from being ready to use with Drupal 6. From what I understand, the Drupal 5 version worked fine and there's already a patch to make it work with Drupal 6.

Cheers,
Ben

webgility's picture
Offline
Joined: 11/04/2009
Juice: 36
Re: Ubercart Quickbooks Integration module

Adding a few facts to help the discussion:

1) QuickBooks Online has only a small % of users as compared with the desktop editions. It also has limited functionality so taking that as the baseline for development isn't the best approach.
2) As you will find, the best way to integrate with QuickBooks is by using their SDK. The QuickBooks WebConnector has less functionality in comparison to the SDK. Although Intuit has a new Partner Platform that provides QuickBooks data to the cloud (http://developer.intuit.com), it is fairly new and doesn't expose all QuickBooks data yet. Thus, using a desktop software that utilizes the QuickBooks SDK is the only way to have the most robust, diverse and comprehensive integration.
3) Intuit does not provide an SDK for QuickBooks on Mac, which is why you won't find any commercial integrations with QuickBooks Mac in the market.

Thanks,

Connect your Ubercart store with QuickBooks & Shipping
Free 15-day trial at http://www.webgility.com

marthanws's picture
Offline
Joined: 01/04/2010
Juice: 2
Right

That is indeed a very useful suggestion, Ben. It would help save us a lot of money. Smiling

mimetic2's picture
Offline
Joined: 08/07/2007
Juice: 478
Re: New Quickbooks integration option.

Let me just go ahead and say a couple of things:

#1 - Quickbooks online is horrendous for any store that needs an inventory as there is no inventory. I just had a big issue with QB online
#2 - I just started using webgilitys software and it is truly a lifesaver. No more manually entering in orders. Also the integration with endicia is fantastic.

I'm a fan. Well worth the $300 dollars as it wouldve taken me more money to hire a developer. Also seeing how the module works, I'd be hard pressed to find a module that will connect as well as this did.

I dont mind paying for good software and so far so good. I'll update again if I have any problems.

Cheers,

Aaron @ Ecopaper.com

fblauer's picture
Offline
Joined: 03/05/2010
Juice: 7
Link to Ubercart integration with xtuple postbooks

Here is a link to the opensource integration of Ubercart to opensource community version of xtuple postbooks accounting system:
http://www.xtuple.org/ubercart-integration

Fred Blauer CA, CA.IT, CISA
http://fblauer.com

akolahi's picture
Offline
Joined: 02/28/2008
Juice: 68
Ubercart Marketplace

Does anyone know if any of the Quickbooks solutions offer support for Ubercart Marketplace (module that allows for multiple sellers). It would be great if QB could handle the commissions / payment to sellers.

virtuoso902's picture
Offline
Joined: 02/16/2010
Juice: 39
Quick Review: Been using this for a month now

Been using this for a little under a month now. I am currently running 3 profiles (ubercart, amazon, and ebay)

I set the whole thing up myself. As far as getting it integrated with ubercart it was pretty easy (it was probably the easiest out of the 3 stores I set up). The 30 day support really helped since there were a lot of rough edges that needed to be smoothed out. To be honest I am probably going to buy the annual support plan because it seems like Ebay and Amazon update their site so much there will probably be an error somewhere in the future.

Each store gets its own profile that you have to configure and select from a drop down menu. At first I wanted everything to be under one tab but after using it for a month I see the benefits of having each store separate. I still get the occasional error but tech support is pretty quick in replying. They had to take control of my computer a couple times with gotomeeting but resolved all the problems I threw at them.

Since this is an Ubercart based site i'll touch into the pro's and con's I've dealt with regardiing ECC and Ubercart Integration.

Pro's:
-Easy installation (just ftp the module, direct ecc to your site and give it admin permissions. Also had to configure some file permissions on the server)
-Downloads and Updates orders instantaneously with all the order comments/tracking info

Con's
-Only supports default payment methods from Ubercart out of the box. If you have customized payment options you have to go into quickbooks and create new payment methods and map them
-Sale receipts can only be posted to one account in quickbooks. So if you have Paypal sales receipts and Quickbooks Sales Receipts they both have to go into the same account. They have a workaround to this that seems to allow 2 different methods to 2 different accounts but anything more than that you might have trouble. The workaround is to set paypal to download as invoices to your paypal account and credit card transactions to download as invoices which get paid due on receipt and deposited to whatever account you have. Right now personally I keep both payment types deposited into undeposited funds and I run through them and manually deposit them myself. I'll probably switch over to the above method in a couple days after I make sure it doesn't effect my Accounts Receivables in any way.

Conclusion:
My order processing time/ quickbooks entries have basically been brought down to 10 minutes a day. I find myself sitting around bored because I ran out of things to do. It was well worth the 600 dollars (I got 3 licenses and inventory module which I haven't used too much yet) for the time it saves me alone. Keep in mind the initial configuration will not run 100% straight out of the box (unless you are lucky) but the support staff is awesome and are really on top of their stuff.

fblauer's picture
Offline
Joined: 03/05/2010
Juice: 7
You might want to look at the Ubercart integration to xtuple

You might want to consider another alternative:

http://www.xtuple.org/ubercart-integration

xtuple does everything that quickbooks does and more. It also has the added benefit of being free and open source (like Ubercart)

Fred Blauer CA, CA.IT, CISA
http://fblauer.com

billy_comic's picture
Offline
Joined: 08/12/2010
Juice: 70
Nice Suggestion

I appreciate the suggestion, unfortunately my client already has quickbooks set up and running and they are quite married to it. I was hoping that I could find a way to post all information (including attribute price) in an itemized format into their quickbooks. I have noticed that the ubercart checkout does not break purchases down by attribute cost. Do you know if there is a way that I can have ubercarts checkout be broken down by attribute cost, rather than just the total amount and then description?

Thanks,
B

nightbird's picture
Offline
Joined: 11/02/2011
Juice: 22
Another FREE ubercart module QuickBooks Integration

Why paid? and why desktop software?

Ubercart QuickBooks Integration Solution, it works with ubercart and QuickBooks API module to synchronize Ubercart orders to QuickBooks

http://toptons.com/content/drupal-ubercart-module-uc-qb-order

give it a try, please leave some feedback

NIGHTBIRD @ TOPTONS
eBay Integration
QuickBooks Integration
www.toptons.com

stockli's picture
Offline
Joined: 12/03/2008
Juice: 58
Re: New Quickbooks integration option.

I'd like to add my comments to this thread, having used eCC/Webgility a couple of times with Ubercart.

1. Their support is absolutely atrocious. Their support techs are very low-skill, and they make very little attempt to understand your issue before responding. Every time I've asked for help it takes several exchanges to get something that's even remotely close to a real answer. And sometimes I've just given up. They frequently misunderstand your question, or give you a knowledgebase answer that's not even closely related to what your issue is.
2. Their Drupal module integration is scary bad. I found a major security hole in it, which I told them about (and even included a patch!) and got no thanks in return, though they did update the module with the patch. In addition, they've got issues in their PHP module that have required me to make code changes to fix, including some broken SQL statements, or uninitialized arrays that were generating errors in watchdog. Also, their Drupal module is advertised as being compatible with D6 and D7, but the actual module they provide is D7 only. You don't technically have to enable the module as eCC boots Drupal on it's own in the connector code, but it still doesn't look right when you get started. I created a ticket over this issue and never got a response.

The idea is a great one. It greatly streamlines shipping for my customers (shipping integration, etc), and it's really helped to revamp their order processes. But the excruciatingly bad support experience makes me shudder when I recommend it, because I feel like there's a great chance we're going to be left out in the cold if something isn't working right. And my customers are doing way too much volume to wait a couple of days to beat the issue into the heads of their support techs enough to get a clear answer.

Faustine_Von_Argyl's picture
Offline
Joined: 02/22/2011
Juice: 16
ecc v3.4

Hi,

Our Quickbooks Ubercart integration program eCC V3.4 has just been released! Try it out for free for 15-days

at http://www.webgility.com. Please feel free to contact us if you have any questions at (877) 753-5373 ext. 1.

Thanks,

Webgility =)

guyd's picture
Offline
Joined: 04/11/2012
Juice: 19
Ubercart + marketplace + quickbooks

Has anyone found a way to do book keeping with marketplace yet? Would be so grateful for any guidance...

I've posted an issue related to this here: http://drupal.org/node/1682762