cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
hausvonliquor
Level 1

How do i import a stock sheet with zero stocks because later i will buy the items?

 
1 Comment 1
ChristieAnn
QuickBooks Team

How do i import a stock sheet with zero stocks because later i will buy the items?

Hi there, hausvonliquor.

 

I suggest going to the Gear icon. From there, you'll have an option to see Import Data to import a stock sheet with zero stocks.

 

Here's how:

 

  1. Go to the Gear icon.
  2. Under Tools, choose Import Data.
  3. Select the Products and Services from the lists.
  4. In the Import Products and Services page, select the Browser button. (You may want to 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. 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.
  8. Click on Next.
  9. Select Overwrite all values for each product or service with the same name. Make sure everything looks correct because this can't be undone.
  10. Hit on Import.

 

For additional information, you can refer to this article: Import products and services from Excel.

 

Please check this article to see what are the lists or information you can import in QuickBooks Online: Common questions about importing data to QuickBooks Online.

 

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.