What is Marcopoloni?

Our goal is to bring people like you, who cherish and appreciate fine artistry, closer to the artisans who create them. Everything we offer is handmade by carefully-selected artisans who pour their love and pride into each piece of work.

Much as Marco Polo brought the Western world in contact with the treasures of the Far East in the late 13th century, Marcopoloni strives to put you in touch with beautiful handmade goods from around the world!

Integrating with QuickBooks Online Using Node.js

With the new year here and the holiday rush behind us I have a month (before tax season arrives) to dedicate to the one project that we see as the holy grail for a small business like ours: Quickbooks Integration.

I, being the nerd that I am, always wanted to integrate accounting with our order management system. Emi, who knows that some things are better outsourced always said: “no way.” The process of moving transaction to the desktop version of QuickBooks was “automated” by exporting customer and order data to “.IIF” files and then importing them into QuickBooks. This worked fine for invoices, but sales receipts would not allow us to put our order number in the number field in QuickBooks. This meant that after the import I would have to move the order number from another field where we sent it temporarily to the number field. A real time saver! Oh, and another thing. Our special sales tax codes for our city and county? Yes, they would come through but not actually select the correct code. So we had to go through every single invoice and sales receipt and select the correct tax codes for orders in Campbell, or in Santa Clara County.

I am in charge of importing orders. When I get busy and I can’t do that for a while I have months worth of orders to import. Invariably, checking for the correctness of the imported data would put me to sleep, or close to it. Let’s face it: I really hated it, and really wished that I could develop my own accounting application… “the data is already there!”

In my previous post I talked about how I had been watching the development of QuickBooks Online and always had to pass on it because it didn’t support inventory management. But that is no longer the case and even multi-currency support is in the works.

I am a full stack JavaScript developer. I don’t code in PHP, Java, or .NET, which are the server languages that are well documented on the QuickBooks Developer page. I have to use Node.js to accomplish this. I struggled to figure out how to make calls to the API that were not documented in the example that I had. Luckily QuickBooks support sent me a link that changed that and it was smooth sailing since.

Now I’m testing my cloud application to send (at a click of a button) customers, sales receipts, and invoices to QuickBooks Online. I hope to be able to go live this week in time for processing sales tax reporting. If I don’t I will be very, VERY sorry!

I hope that this story can help some other business owner out there who is considering a solution to problems like ours. I will let you know how it goes next week!

Be Sociable, Share!

You must be logged in to post a comment.

August 2017
M T W T F S S
« May    
 123456
78910111213
14151617181920
21222324252627
28293031