Inventory Export to Quickbooks

Inventory Export to Quickbooks

Aug 05, 2016
Larissa Bunker wrote
When we export our inventory from Magento to Quickbooks, the export function creates thousands of individual inventory adjustment records, many with zero qty change (no impact to inventory or accounting). I would like to request that the inventory export create ONE transaction updating the inventory quantity on hand on all items (list all items in one inventory adjustment record, rather than individual records for each item, group, or kit). Our Quickbooks file size will increase significantly if we run automatic inventory exports to Quickbooks daily.

Please advise.
New
4 votes
Vote
Reply
19 Answers
Aug 05, 2016
Brandon wrote
Same here see attached.


I have attached a short screen shot of the inventory adjustments. As you can see, many have no impact on our accounts. However, the large number of transactions will greatly increase the file size of our Quickbooks if we update our inventory daily.


Instead of individual transactions, we would like to have Inventory Adjustment. I have attached a screen capture of an example of a long inventory adjustment transaction.
Avatar image
Aug 08, 2016
Alex Pryshlivskiy agent wrote
Thanks for q comment, Larissa!
Are you talking about products with q-ty = 0 ?
In this case, you should you column filter to show products with q-ty > 0
After that - Select All products - Ctrl+A
- To send selected products to QuickBooks Addon.

Please see 2 attached screenshots.
Aug 08, 2016
Larissa Bunker wrote
Thank you for your reply and instruction. However, the issue is not with product that has zero quantity. The issue is with the export Inventory Adjustment being zero.

For example, if we had 3 parts in stock already in Quickbooks, and we have not sold any or added any to inventory, the export function creates an Inventory Adjustment with a net zero change to Quickbooks (Quickbooks had 3 in stock, export creates an Inventory Adjustment record changing the stock to 3 - no change). When we export inventory, this function is creating thousands of Inventory Adjustment records that are not needed, they produce no change in Quickbooks, and they significantly increase the Quickbooks file size.
Avatar image
Aug 09, 2016
Alex Pryshlivskiy agent wrote
Sorry, Larissa,
it's not clear for me :-(
Could you provide video or screenshots of this problem ?
Aug 09, 2016
Larissa Bunker wrote
The screen shots above posted by Brandon is a great example of the problem I am having as well. In the first screen shot, there is a huge list of Inventory Adjustments, many with zero dollar change to the books (no credit, no debit). All of these Inventory Adjustments are making my Quickbooks file really large. I need instead to have one Inventory Adjustment with all of the items listed in one record, like the second screen shot.

I hope that helps?
Avatar image
Aug 09, 2016
Alex Pryshlivskiy agent wrote
Could you share your screen and demonstrate this problem?
Is it ok to connect via TeamViewer ? if yes, please let me know - I'll contact you by email. Please don't publish your email here.
Aug 17, 2016
Larissa Bunker wrote
Yes, that would be great. Please contact me by e-mail and I can show you what we need.
Avatar image
Aug 18, 2016
Alex Pryshlivskiy agent wrote
Hello Larissa,
Sent.
Please check email.
Aug 24, 2016
System wrote
Hello,

We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team
Sep 02, 2016
Brandon wrote
This is still a problem for us! Also another problem is that product syncing syncs grouped & configurable products, which quickbooks doesn't need to have since they are virtual products. We tried to fix that particular issue with a filter for only simple products to sync, but it doesn't save the filter for the automatic sync.
Avatar image
Sep 05, 2016
Alex Pryshlivskiy agent wrote
if you need a manual filter - please use this option - manual-filter.png
if you need a filter for sync. you should change SQL file ExportProductsSQL.sql with product type - see screenshot - Qbooks-path.png
see the path on the screenshot for your Addon.

Modified SQL file is attached - see zip archive. (section : WHERE e.`type_id` = 'simple' /*FILTER*/ )

Sep 05, 2016
Brandon wrote
OK ill test that thanks, What can I replace in the export order to filter only completed?
Avatar image
Sep 06, 2016
Alex Pryshlivskiy agent wrote
this implementation will be available for you as an additional service. Our tech. engineers will do some modifications for a Quickbooks Integration Addon.
Please let us know if you are interested in this payment service.
Sep 06, 2016
Brandon wrote
Could you just modify and send us a filter built into the ExportOrdersSQL.sql file like you did ExportProductsSQL? We just want filter to work on automatic syncs, it should just be part of the module we purchased to sync automatically.
Avatar image
Sep 07, 2016
Alex Pryshlivskiy agent wrote
Hello, Brandon.
Have you met our tech. engineer online (TeamViewet) ? Support dep. told me, you've got a online meeting according to this situation.
They demonstrated how it works.
Do you need extra time for this option ?
Please let me know.

Sep 12, 2016
Brandon wrote
The tech. team showed us how filters work, but they only work for manual syncing. Your ExportProductSQL helped with product shipping, but we would like a solution to set filters on our automatic syncs of orders as well. We would like to only sync processing and completed orders.
Avatar image
Sep 13, 2016
Alex Pryshlivskiy agent wrote
Here it is decision for you:

You should find file ExportOrderDetailsSQL.sql and replace the following line from
WHERE 1=1 /*FILTER*/
to
WHERE e.status = 'complete' AND 1=1 /*FILTER*/

don't forget to save modification and restart Store Manager and Addon. :-)
Sep 13, 2016
Brandon wrote
Thanks can I make it both completed and possessing?
Avatar image
Sep 13, 2016
Alex Pryshlivskiy agent wrote
in this case, you should use OR condition for your SQL. WHERE (e.status = 'complete') OR (e.status = 'processing') AND 1=1 /*FILTER*/