Skip to main content
Dec 19, 2019 12:59 PM UTC
Question

Hi how do i imprted an updated product list with out duplicating stock codes?

Original commenter did not share additional details

1 reply

JaneD
Dec 19, 2019 2:08 PM UTC

Hi gameforafricaleo,

 

You can choose to overwrite all values for each product or service with the same name when importing items in QuickBooks Online (QBO). I'll show you how.

 

  1. From the Gear icon, chose Import Data under Tools.
  2. Select Product and Services.
  3. Click on Browse, locate your excel file, and select Open.
  4. Choose Next and map your item fields to QuickBooks fields.
  5. Click on Next and mark to select the Overwrite all values for each product or service that you import with the identical name. (This can’t be undone.) box.
  6. Choose Import once done.

See the Import products and services from Excel article for further guidance.

 

Once you're done importing, you can pull up some reports to check the updated stock's quantity on hand, value, and cost.

 

Let us know if you need anything else moving forward. Have a great day!