Quickbook Sync

[the_ancient]

I have finally Finished my Quickbooks Sync Project enough to release the 1st version.

This will use the Quickbooks Web Connector to Sync

• Customers
• Orders
• Products

It will NOT sync Inventory levels at this time, but it will, I am still working out the best way to do it, i.e use a report to pull all of the inventory at once or query individual items


PLEASE READ THE DOCS FULLY, YOU MUST CONFIGURE THE SCRIPT PROPERLY OR IT WILL FAIL,

Since this project is still in its inital development, there is no "install" script to walk you through it so you will have to modify the actual php files. Also there are some things inside quickbooks that has to be done and standardized in order for the sync to work

BACKUP ALL DATA!

Before you start, make sure you back up everything, including your quickbooks company file.

Feed back Welcome, This was Tested on a Quickbooks 2006 Installation, If reporting Bugs Please Report the Following

The Version of Quickbooks your Using
Any Log messages Reported (found in "qbAdmin.php")
PM me the "qwcLog" File (found in the WebConnector Software)

To Download
Click here

[the_ancient]

Couple of things I Forgot

• No Changes at all to any Zen Core Files, these
• Short of a Massive Database Restructuring it should be upgrade proof.
• adds 3 New Tables to the Database, and adds 1 Column to the Orders, Products and Customers Tables (this is how I track what is and what is not in Quickbooks)

All feedback welcome

[confused_aswell]

HI

I have had a quick look at it and it seems there is a lot to do before installing, so will wait and see how other people get on before I install. It looks very comprehensive though.

Good luck,

Phil

[the_ancient]

HI

I have had a quick look at it and it seems there is a lot to do before installing, so will wait and see how other people get on before I install. It looks very comprehensive though.

Good luck,

Phil

That is true depending on how your Quickbooks is Set up,

As far as Zen Cart goes there is not much to the install.


I am open to suggestions on how to ease the Configuration of the top of my head I cant think if anything to change or remove

[cornhustlah]

sounds cool.
dl'd and hoping to install/play with in the next couple days.

will report back.

[the_ancient]

Added to the Contributions Database

http://www.zen-cart.com/index.php?ma...oducts_id=1153

[FutureSounds]

I am a brand NEWBIE and have never used Zen-Cart before. I am currently using QuickBook Point of Sale 2007 and need a good e-commerce site. I saw Zen-Cart because I'm using GoDaddy and it was highly rated for e-commerce. Problem is I am not sure if this Quickbook Sync is for Point of Sale or not? I am not familiar with terminology. I saw QBI and have no clue what that is. Any help would be appreciated. Will this sync program help me with POS?

Thanks,

FutureSounds

[the_ancient]

I am a brand NEWBIE and have never used Zen-Cart before. I am currently using QuickBook Point of Sale 2007 and need a good e-commerce site. I saw Zen-Cart because I'm using GoDaddy and it was highly rated for e-commerce. Problem is I am not sure if this Quickbook Sync is for Point of Sale or not? I am not familiar with terminology. I saw QBI and have no clue what that is. Any help would be appreciated. Will this sync program help me with POS?

Thanks,

FutureSounds

Unfortunately QBPOS and QB use different SDK as such my contribution will only work on normal Quickbooks not QBPOS

QBI is a differant quickbooks contribution that has been around longer than mine. Where mine uses advanced Web Services QBI allows you to manually Import the transactions via stanard IIF files. I do not know if they support QBPOS or not, I am not affilated with that project

[tj1]

Does this support importing orders as invoices or sales orders?

I'm trying to decide whether to try this one or QBI.

Thanks.

[the_ancient]

Does this support importing orders as invoices or sales orders?

I'm trying to decide whether to try this one or QBI.

Thanks.

The simple answer NO...

I do have a update that has not be release yet that will create a sales order for Check Payments.



You would have a instantaneously create

Sales order -> Invoice -> Payment Record

or

Sale Receipt

Which is a Invoice, and Payment Record rolled in to one.


Why create the additional overhead?