Right now we have two inventory items (call them SKU1 and SKU2) that are bundled together to make a customer facing product (SKU3). We did this because SKU1 used to be leveraged for multiple products, but that is no longer the case. Now I would like to make SKU1 and SKU2 inactive and turn the bundled item, SKU3, into a single inventory item.
Let's say that my current state is:
Item | Current Inventory | Purchase Price | Sale Price | Product Type |
SKU1 | 10 | $10 | $15 | Inventory Item |
SKU2 | 15 | $20 | $30 | Inventory Item |
SKU3 | $45 | Bundle (SKU1+ SKU2) |
My desire would be to keep the SKU3 number for the new Inventory item so that this is transparent to the customers.
Thanks!
Solved! Go to Solution.
I agree with your SKU's transition thoughts, @fergy.
I'm here to help you consolidate your inventory items in QuickBooks Online (QBO). Let me give you step-by-step instructions to accomplish this.
First, to take care of your SKU1, you can either purchase it or adjusting the inventory. There will be no issue since a bundle is just like grouping the product and services.
If you prefer in adjusting the quantity, you can follow the steps below.
You may refer to these articles below for more details:
Once done, the inactive Sku's will remove from your Bundle list.
After that, please create the Inventory SKU3 with an initial inventory of 15 units. Then mark the Bundle SKU3 inactive.
See the sample screenshots below for your guidance:
To check all your inactive inventory, please click the funnel icon, then choose Inactive, and click Apply.
Yes, you don't need to create a Journal entry since they use the same COGS account.
For your last question about selling all of the current inventory, it will depend on you. You can also sell it so there'll be no issues when it comes to value and cost calculation.
I've encouraged you to visit this article about handling your inventory accounts and report in QBO:
Please let me know if you have further questions about your SKU's. I'm always here, ready to assist you. Take care always.
I agree with your SKU's transition thoughts, @fergy.
I'm here to help you consolidate your inventory items in QuickBooks Online (QBO). Let me give you step-by-step instructions to accomplish this.
First, to take care of your SKU1, you can either purchase it or adjusting the inventory. There will be no issue since a bundle is just like grouping the product and services.
If you prefer in adjusting the quantity, you can follow the steps below.
You may refer to these articles below for more details:
Once done, the inactive Sku's will remove from your Bundle list.
After that, please create the Inventory SKU3 with an initial inventory of 15 units. Then mark the Bundle SKU3 inactive.
See the sample screenshots below for your guidance:
To check all your inactive inventory, please click the funnel icon, then choose Inactive, and click Apply.
Yes, you don't need to create a Journal entry since they use the same COGS account.
For your last question about selling all of the current inventory, it will depend on you. You can also sell it so there'll be no issues when it comes to value and cost calculation.
I've encouraged you to visit this article about handling your inventory accounts and report in QBO:
Please let me know if you have further questions about your SKU's. I'm always here, ready to assist you. Take care always.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here