Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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.
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.
What is "transaction pro importer?" Is that an app?
@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
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. :)
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.
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!
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here