Integrate our Quickbooks with WooCommerce and GunBroker

I need help integrating three software together: QuickBooks, WooCommerce, and GunBroker. It’s a very busy time of the year and would like to look into hiring someone to finish up the integration for us.

I’ve targeted and semi-implemented a few programs already but need help tying everything together.

Goals:
1) WooCommerce sends order data to QuickBooks in the form of Invoices
1a) Stretch Goal: Implement automatic invoice sending for remaining balance for Partially Paid orders on WooCommerce
2) WooCommerce queries QuickBooks inventory count and marks out of stock any SKUs with QTY <= 0
3) GunBroker sends order data to QuickBooks in the form of Invoices with payment applied
3a) Stretch Goal: Reduce inventory in QuickBooks if there is a bid on the item on GunBroker (but no invoice has been created yet)
4) GunBroker queries QuickBooks inventory count and marks out of stock any SKUs with QTY <= 0
5) Optional: Connect ShipStation to GunBroker and WooCommerce to pull in orders as they are paid in full
6) Optional: We receive a large number of backorders. Create filters on WooCommerce and ShipStation to filter out backorders visually until they are ready to ship

So far, we’ve gathered the following software to help with this implementation:
-MyWorks (for WooCommerce <> QuickBooks)
-Netfish.es (for GunBroker <> ShipStation)
-Zapier (Possibly used for some of the Stretch Goals)
-ecomdash (This doesn’t look very promising, implementation seems poor. Supposed to work with GunBroker <> QuickBooks – but not well for our needs).

Note – GunBroker has a REST API integration so it should be OK to work with.

Leave a Comment