cancel
Showing results for 
Search instead for 
Did you mean: 
Spaceman
Level 2

QBO Inventory: Import Initial Costs

I have just set up inventory tracking in QBO, but can't see a way of importing my initial costs in bulk. Am I missing something?

2 Comments 2
QueenC
Moderator

QBO Inventory: Import Initial Costs

Hello there, @Spaceman.

 

Allow me to share some information with regard to how inventory works in QuickBooks Online (QBO).

 

In QBO, importing only the costs of inventory items is unavailable. However, we can import products and services together with its respective costs and quantity. 

 

If you aren't done importing your products and services, I'd love to provide you with the process:

 

Be sure to format your spreadsheet first before importing. Also, note that we can only import 1,00 rows at a time and this process is irreversible.

 

  1. Go to the Gear ⚙ icon then select Import Data.


     
  2. Select Products and Services then click on Browse to upload the file from your computer.
  3. You'll want to select the Download a sample file for your reference in formatting your list.
  4. Choose the file then select Open.
  5. If you prefer to upload from Google Sheet, select Connect to sign in to your Google account. Select the file then click on Select then Next.


     
  6. Map your information. Your Field represents the headers on your spreadsheet. From each drop-down ▼ menu, select the one that matches a field in QuickBooks Online.
  7. Select Next. Cells that are marked in red indicate that they are invalid. Examine the spreadsheet cell, then try importing the file once more.
  8.  Select Overwrite all values for each product or service with the same name. Make sure everything looks correct because this can't be undone.
  9. Click on Import.

 

For the detailed step-by-step process, feel free to refer to this article: Import products and services into QuickBooks Online.

 

Additionally, I got you an article that'll guide you in case you'll need to change the item type of your products and services: Change product and service item types in QuickBooks Online.

 

I'll be here if you've got additional queries about managing your inventory items in QBO. It's always my pleasure to be of assistance. Take care.

Spaceman
Level 2

QBO Inventory: Import Initial Costs

Thanks @QueenC I was able to go through that stage, but my question related to the initial costs. There is no field tomap to those and it seems I ahve to go back in manually to change after the import. Is that correct?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us