Skip to main content
T
truleigh
December 12, 2017
Solved

How to sync inventory from Amazon to QuickBooks Desktop?

  • December 12, 2017
  • 3 replies
  • 0 views

Client wants to start selling on Amazon. He wants his inventory on Amazon to sync up with his inventor on Quickbooks DESKTOP (not Online).  Is this possible without individually entering each sale on QB?  I know I can import his sales, but what about keeping his inventory accurate?  

 

I have a lot of experience with Amazon, but not with inventory.  Your thoughts and suggestions? 

 

 

(Title has been edited by moderator for clarity)

    Best answer by Rustler

    Invnetory is only reduced by one of two actions, a sale with that item listed, or an inventory adjustment.

     

    So to sync amazon with QBDT inventory you need to import each sale by item.

    or

    get an excel sheet from amazon listing the items sold, and use something like transaction pro importer to convert the excel sheet to an iif formatted file for inventory sales.  To this you would need a generic customer like "AZ Sales" and import the sale as a sales receipt.

     

    iif formatted file can not do an inventory adjustment, nor build assembly items.

    3 replies

    Rustler
    RustlerAnswer
    December 12, 2017

    Invnetory is only reduced by one of two actions, a sale with that item listed, or an inventory adjustment.

     

    So to sync amazon with QBDT inventory you need to import each sale by item.

    or

    get an excel sheet from amazon listing the items sold, and use something like transaction pro importer to convert the excel sheet to an iif formatted file for inventory sales.  To this you would need a generic customer like "AZ Sales" and import the sale as a sales receipt.

     

    iif formatted file can not do an inventory adjustment, nor build assembly items.

      T
      truleighAuthor
      December 12, 2017

      What is "transaction pro importer?" Is that an app?

      Rustler
      Rustler
      December 12, 2017
      @truleigh wrote:

      What is "transaction pro importer?" Is that an app?

      QBO:    http://www.baystateconsulting.com/products/01TxnWizardOE.htm

       

      QBDT:    http://www.baystateconsulting.com/products/01TxnWizard.htm

      I am not affiliated

        Shahji
        Shahji
        May 14, 2018

        Hi @truleigh

        You can check out Unify Desktop app from Webgility to Sync the Inventory to QuickBooks.

        There are two ways to sync up your inventories 1) Make sure your Inventory at Amazon and Quickbooks are Updated and then you can download the Orders and Post them in QuickBooks as Sales Receipts which will decrease the qty of the item in Quickbooks , that you have sold on Amazon. 2) Use Webgility which does have the Option to synchronize the Item Qty's of Amazon top QuickBooks. So the second option will be the most viable solution for you. Please let me know if you need any further help. :)

        C
        Checkusfirst
        October 9, 2018

        Do not ever use unify or webgility. Their billing department have zero ethical standards. I didnt use them for a year and then renewal came and they charged my card 799.00. I called same day i saw charge and I didnt use the service and they told me no refunds and I should have called day before charge. 

         

        They also took my money and didnt deliver the sub. Locked my account...so yes, this is legally theft.

        O
        ohyes
        July 23, 2019
        I use a program from qbosolutions.com, works only with QB desktop though. Very simple to use
        Terms & ConditionsAccessibility statement