Skip to main content
N
nous333
March 24, 2022
Question

How To Track Inventory For Made To Order Products With Multiple Variants (Shopify)

  • March 24, 2022
  • 5 replies
  • 0 views

I 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! 

5 replies

Fiat Lux - ASIA
Fiat Lux - ASIA
March 24, 2022

You need to have an additional app with the matrix inventory feature to integrate with your QBO.

K
Kurt_M
March 24, 2022
Thanks for posting the details of your situation, @nous333 .
 
I agree with @Fiat Lux - ASIA . You'll need a 3rd party app integrated into your QuickBooks Online account. Once you've got yourself set, you can consider contacting their support team. This way, they can set it up, and you can get back on track with your business.
 
I'd also suggest informing our Product Development Team. They'll consider your idea for future product upgrades. You can click the Gear icon in the upper-right corner and select Feedback.
 
Additionally, here are some articles to help you in the future:
 

 

The Community is open 24/7 if you have other QuickBooks-related concerns. You can also notify me if you need further assistance with integrating a 3rd party app to QuickBooks Online. I'll be more than happy to provide additional help. Keep safe and more power to your business! 
N
nous333Author
March 24, 2022

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.  

K
Kingstore
November 7, 2022

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.

 

K
Kingstore
November 8, 2022

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.

S
SergeyBazh
July 18, 2024

Hey there!

 

It sounds like you're having a tough time managing your inventory and COGS for your made-to-order products on Shopify. QuickBooks can handle this, but it's a bit tricky.

 

Using QuickBooks:

 

1. In QuickBooks, mark your variants as "inventory items".

2. When you sync with Shopify, manually adjust the stock levels in QuickBooks to match Shopify.

3. Record COGS by creating a purchase transaction for the raw materials (sauce) and linking it to your variants.

 

However, this can be cumbersome. I recommend using Cleverence Warehouse 15. It integrates seamlessly with Shopify, automates inventory tracking. This saves you time and reduces errors. Check out Cleverence Warehouse 15 here https://www.cleverence.com/solutions/warehouse/

 

Hope this helps!

Terms & ConditionsAccessibility statement