cancel
Showing results for 
Search instead for 
Did you mean: 
truleigh
Level 3

How to sync inventory from Amazon to QuickBooks Desktop?

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)

Solved
Best answer December 12, 2017

Best Answers
Rustler
Level 15

How to sync inventory from Amazon to QuickBooks Desktop?

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.

View solution in original post

8 Comments 8
Rustler
Level 15

How to sync inventory from Amazon to QuickBooks Desktop?

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.

truleigh
Level 3

How to sync inventory from Amazon to QuickBooks Desktop?

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

Rustler
Level 15

How to sync inventory from Amazon to QuickBooks Desktop?


@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
Level 4

How to sync inventory from Amazon to QuickBooks Desktop?

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. :)

Checkusfirst
Level 1

How to sync inventory from Amazon to QuickBooks Desktop?

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.

selder
Level 1

How to sync inventory from Amazon to QuickBooks Desktop?

We currently ship directly to Amazon (Vendor Central) based on Purchase Orders they send to us using their portal.  However, now we want to sell to Walmart and others so we need an EDI system and found one that works with QB Desktop.  I think it's called True Commerce.  Anyway, our problem is and has always been providing inventory to 3rd parties.  Why?  We have assemblies and lots of them.  This means we have to build the assemblies, in advance of purchase orders, in order to feed 3rd parties available inventory.  The problem is that the same pole we sell is used for multiple assemblies.  We also have multiple colors.  Example: pole + bag = 1 assembly item number.  Pole + bag + net = another assembly item number.  Same pole and bag is used. We'd have to split making 25 of one assembly and 25 of another.  What if we sell 30 of the one assembly, it will say we can't, but we can.  We also have various price levels for each assembly we sell.  I can't figure out for the life of me why QB can't do inventory like kits or kitting, which is NOT the same as assemblies.  Any advice or ideas would be appreciated!

KhimG
QuickBooks Team

How to sync inventory from Amazon to QuickBooks Desktop?

Thanks for visiting the Community, @selder.

 

I’m here to provide some insight regarding your concern with building assemblies and creating inventory kits in QuickBooks Desktop.

 

At this time, you only have the option to build assemblies and group items in QBDT. If this is not what you need, I suggest checking a third-party app that could help you make inventory kits. 

 

Just head to the Apps for QuickBooks Desktop website and search for a keyword like Inventory Kits to get started. 

 

All the applications found in the marketplace were created to solve specific business needs for our QBDT customers. 

 

In the meantime, I’d also suggest sending feedback to our Developers for the inclusion of this option in future updates. Rest assured, I’ll do the same on my end to reinforce your request.

 

Let me show you how:
1.    Go to the Help menu and select Send Feedback Online.
2.    Select Product Suggestion.
3.    On the QuickBooks Feedback window, fill out onscreen instructions.
4.    Click Send Feedback

 

That’s it for now. Reach out to me if you need anything else, I’ll be more than happy to help. Thanks for posting in the Community, and take care!
 

ohyes
Level 1

How to sync inventory from Amazon to QuickBooks Desktop?

I use a program from qbosolutions.com, works only with QB desktop though. Very simple to use
Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us