Skip to main content
October 25, 2021
Question

I am transporting my opening inventory over from Shopify. How do i specify the $$ per product associated to each item so QBO knows records COGS when the items are sold?

  • October 25, 2021
  • 1 reply
  • 0 views
I realize that migrating a products and service list will allow me to specify the quantity but I am unsure how to connect the opening $$ value per product so that QBO knows how to record COGS.

1 reply

October 26, 2021

Hello aaron55,

 

It's great to have you connect with us here. QuickBooks offers the flexibility that makes it simple for you to manage your inventory. I'll be glad to point you in the right direction so you can continue to do what you love the most. 

 

Based on what you've described, I recommend importing the inventory into your account using these steps: 

  1. Click on the Gear icon.
  2. Under Tools, choose Import Data.
  3. From the list, select Products and Services.
  4. In the Import Products and Services page, select Browser button. (You can also download the sample file to see how the columns look like.)
  5. Find and select the Excel file then select Open.
  6. Select Next to continue.
  7. From here you can map your data. 
  8. Click on Next.
  9. If you'd like, you can check the Overwrite all values for each product or service that you import with the identical name. (This can't be undone.)
  10. Click on Import.

For more info on this, check out this article: 

Let me know if this info helps. I'll be one message away in case you have other questions.