Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI sell many items on Shopify that are available in multiple quantities. For example. 100g of 'sauce' is kept in inventory, and I offer 1g, 2g, and 3g variants each with their own SKU. All inventory for these items is tediously kept with manual entry right now. I know no other way.
I am trying to use quickbooks to record sales data including COGS. My problem is, when I use the quickbooks connect app, it will not record COGS on items that are "non-inventory". If I make these multiple variant made to order products "inventoried" in QB, I'm told the app will zero out my Shopify stock levels so these items would appear out of stock if I didn't input a value, and if I did, it wouldn't be accurate.
So I have no way of recording the COGS in quickbooks for these items. I'm lost as to what I can do. I thought about using one SKU and a quantity discounts app for these items, but that would double up the cost of the jar that is included in the unit cost. I'm lost, I need a quickbooks professional. I need to figure out a better way to input these items in shopify possibly, I don't know! Please help!
You need to have an additional app with the matrix inventory feature to integrate with your QBO.
Is there a specific app that will work?
I definitely want to find someone who is a pro at QBO to help me, and I'm willing to pay them, but I want to be able to watch them to do what they do and be in contact with them while they are doing it because this isn't a cut and dry issue with a cut and dry solution. I have a lot of different issues and my products and the way I do things are all subject to change, in fact they will definitely change. Right now a lot of my products are probably not set up in the most efficient way so I don't want to apply one solution that will box those products in and prevent them from being developed more...if that makes sense.
What is the name of the app that I need?
If you are running Shopify you can try SKUSavvy that will enable you to handle your purchases, check-in, bin locations across multiple warehouses, inventory, pick-pack-ship, barcoding, and many other things within the warehouse.
You can connect your Shopify store directly with Quickbooks then utilize SKUSavvy to handle all of the inventory control and movement as well as order management.
It's free for less than 50 orders per month then just $0.14-$0.04 per order.
What you could try is something like SKUSavvy that will connect with your Shopify store to pull products, variants, locations, and inventory as well as orders and customers. With this platform, you will have a full visual warehouse management system capable of placing purchases, check-in inventory, and manage unit of measure relationships between variants.
With SKUSavvy you would have your bulk value in 100g, then you would have a variant option with a unit of a measure tied to the bulk unit for your 1g, 2g, etc. When you check this product in you can check in across multiple units and as the product sells, the respective unit will be taken out across all units and the inventory value will be sent back to Shopify.
SKUSavvy works by first allocating your inventory to bin locations, so if this is not a big concern it may be overkill, however for businesses needing bin locations you will have a visual map of the warehouse with shelves and bins. As you pick from these bin locations your unit of measure will update according to whichever unit was picked from.
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.