SitePoint Sponsor

User Tag List

Results 1 to 18 of 18
  1. #1
    SitePoint Member
    Join Date
    Jan 2008
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Integration of Webstore & QuickBooks

    Hello,
    I have QuickBooks version 2005. Is their any tool or software which integrate QuickBooks with any webstore like XCart, ZenCart ?

    Ethan

  2. #2
    He's No Good To Me Dead silver trophybronze trophy stymiee's Avatar
    Join Date
    Feb 2003
    Location
    Slave I
    Posts
    23,424
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)
    You'll pretty much need a quickbooks merchant account.

  3. #3
    SitePoint Addict
    Join Date
    Sep 2005
    Posts
    335
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What type of integration are you looking for? Do you manage inventory with QuickBooks and you want to sync inventory? Do you just need sales data downloaded daily/weekly?
    PHP Shopping Cart Software Easy Ecommerce Shopping Cart Script.
    PHP Super Cart is 100% template driven.

  4. #4
    SitePoint Enthusiast
    Join Date
    Jul 2007
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have the same question - I just need to be able to download sales data into quickbooks.

  5. #5
    SitePoint Enthusiast
    Join Date
    Aug 2007
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The format of the files to IMPORT data to QuickBooks is not difficult to find documentation for or to write. One difficulty is that in order to import sales data, you have to also import the new customers and duplicate customer records will be created for repeat cutomers unless you are very careful to maintain the correct customer ID information.

    I've written scripts that produce IIF files for orders, but it was for a very wierd .ASP based order form that is slated to be replaced, and the scripts were never really tested.

    If there is an interest, contact me directly and I'll consider putting them up on the web.

  6. #6
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    You can use PayPal as your payment processor (all major shopping carts support it) and import your PayPal transactions into QuickBooks later (SimplePort).

  7. #7
    SitePoint Enthusiast
    Join Date
    Aug 2007
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Actually, check this out: I just realized that PayPal has a download format for QuickBooks IIF files! After you log into to your PayPal account, go to "History" / "Download History" and change the "File Types for Download" to "Quickbooks (.iif)".

    I wonder how Simple Port manages to make a buck? Do people just not realize that PayPal already supports that directly?

  8. #8
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by James Newton View Post
    Actually, check this out: I just realized that PayPal has a download format for QuickBooks IIF files! After you log into to your PayPal account, go to "History" / "Download History" and change the "File Types for Download" to "Quickbooks (.iif)".

    I wonder how Simple Port manages to make a buck? Do people just not realize that PayPal already supports that directly?
    PayPal's export does not give you:
    - Customer records
    - Sales receipts
    - Returns/refunds
    - Chargebacks
    - Reversals
    - Bank transfers

    It also dumps everything into only a single income and expense account. It's really wholely inadequate for doing any type of bookkeeping. SimplePort gives you all of that.

  9. #9
    SitePoint Enthusiast
    Join Date
    Aug 2007
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the detail Dan. It appears that SimplePort started as a FOSS perl script called pp2iif. I don't guess anyone kept a copy?

  10. #10
    SitePoint Enthusiast
    Join Date
    Aug 2007
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    http://www.bigredconsulting.com/aboutebaylink.htm Is an M$ Excel add-on that translates import PayPal transactions into QuickBooks. For most transaction types, everything needed to keep your PayPal account in balance is created, including transactions to represent your cash sent & received as well as PayPal fees.

    New! Now includes support for the PayPal shopping cart. Now if your downloaded PayPal file contains your shopping cart details, those details are transferred to QuickBooks.

    New! Now includes support for UK, including VAT details in your PayPal data.

    eBay: The tool also enables integration of eBay sales with your QuickBooks company file. This saves you time managing your auctions and payments, enables for easy accounting integration of eBay and PayPal, and it saves error-prone data entry.

    The cost is $50 one time.

  11. #11
    SitePoint Addict Farrukh's Avatar
    Join Date
    Nov 2002
    Location
    United Arab Emirates
    Posts
    300
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  12. #12
    SitePoint Zealot
    Join Date
    Jun 2006
    Posts
    111
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    if you have aspdotnetstorefront you can integrate qucikbooks.

  13. #13
    SitePoint Member
    Join Date
    Apr 2008
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by EthanBors View Post
    Hello,
    I have QuickBooks version 2005. Is their any tool or software which integrate QuickBooks with any webstore like XCart, ZenCart ?

    Ethan
    I have used quickbooks integration with digishop before. It is a direct integration so you don't have to export or import files. Your orders auto sync with quickbooks.

  14. #14
    SitePoint Enthusiast
    Join Date
    Jun 2007
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Here are some ideas:

    Authorize.net allows for QuickBook exports.
    StoneEdge Order Manager is does this very well.

  15. #15
    SitePoint Member
    Join Date
    Mar 2011
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile

    try WebLink from 4ZMagic E-Business Solutions

  16. #16
    SitePoint Member
    Join Date
    Mar 2011
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've used BigRedConsultings products for several years. Basically I download my sales to Excel and then use their IIF creator to import. Pretty simple although I have to do data cleanup before importing. This is a function of the different sales channels formats rather than BRC's stuff.

  17. #17
    SitePoint Member
    Join Date
    May 2005
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have a PHP cart (eCommerce Templates) and also sell on Amazon. I use T-Hub from Atandra to sync both the cart and Amazon to Quickbooks and it does a pretty good job. Their support team does a pretty good job too although not as good as the ECT folks... they're outstanding. It's a little pricey but after the holiday rush last December, we had to do something to automate the process or it would drive us crazy.
    Wes

  18. #18
    SitePoint Addict Avactis's Avatar
    Join Date
    May 2006
    Posts
    391
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Avactis Shopping Cart & CMS - Easy integration into existing
    site design. Ecommerce Hosting with Free support.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •