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

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

 
1 Comment 1
JaneD
Moderator

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

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!