Shopify supports inventory adjustments on Orders that have a 100% discount applied. The Quickbooks Connector also supports inventory adjustments for Orders with a 100% discount applied. For example, we sell wine tastings, but because QBO doesn't support UNIT of MEASUREMENTS we can't just say after 4 tastings of Merlot remove a bottle of Merlot from Inventory. So the only way we can reflect that a bottle is gone is to sell all the empty bottles to the winery at the end of the day with a 100% discount applied so that our inventory correctly reflects that we used X bottles of wine during tastings for the day. To make sure our inventory is correct, using the Shopify POS we create a new Order at the end of the day, we add all empty bottles to that order, we set the customer as our business, then we apply the Shopify discount code WINETASTINGS, which applies a 100% discount to the order. We complete the order and the Quickbooks Connector syncs the order and adjusts the order in QB, which then syncs back to Shopify. So far everything is great and works as expected.
Now let's say one of the employees accidentally grabs a bottle of wine that was sold to a customer that they drank on-site thinking it was a bottle used for tastings. That would be bad because that bottle was already sold and removed from inventory, and let's say they didn't realize that until after they had already submitted the order for the WINETASTING bottles. That's fine because Shopify supports returning the order and restocking the item into inventory, even when there is no refund of $. Here is where there is a bug... Shopify clearly supports this scenario. There is nothing to lead you to believe as an employee that the refund of the order isn't returning the items to inventory because you even get a big button at the end of the return process that says "Restock Inventory Items". Once you are done the order even says that the items were returned to inventory. There are no errors or warnings in Shopify, the Quickbooks Connector, or even in Quickbooks. So from the end-user perspective, they returned the order, Shopify says it restocked the items, so why would you ever think that wouldn't happen. In our case, it took months of inventory being out of sync and us scratching our heads before we finally noticed that the Quickbooks Connector isn't noticing that the Order was returned and that Shopify updated the order to state that the items should be returned to inventory. The bug is that the Quickbooks connector is making a false assumption that inventory is only returned if a payment was returned, which is wrong. Inventory is also returned if Shopify updates the order to say items were restocked. If the connector removes items from inventory on a $0 sale, then it should also return items on a $0 return.
If there is a better way to remove items from inventory using only the POS system (that's what our employees have access to) then I'm all ears and happy to change our processes, but we haven't found another way to do it.
Please sign in to leave a comment.