I sell many items 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.
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 for items that have even more quantity options (up to 28 grams) the added packaging would affect the cost per unit and thus the COGS value wouldn’t be accurate.
Hoping someone has been through this and can offer up a solution! Also, if any accounting/quickbooks professionals are here that have time to help me between now and April 15, I need some serious help once I figure this out to get my quickbooks organized.
Thanks!