Skip to main content
December 19, 2019
Question

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

  • December 19, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

JaneD
December 19, 2019

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!