top of page

Recent Posts

Archive

Tags

Learn QuickBooks Online - Track Sales

Add Product Information

Read step-by-step instructions

Click Invoicing or Sales, then Products/Services. Click Add product or service.

Select the type of product.

Is this an inventory product or a non-inventory product? If you want to track quantities of this product, select Inventory. If not, select Non-inventory.

Enter the product information.

Fill in the information about the product, such as SKU and description. Click Save and close.

You can also import a spreadsheet of product information.

Organize your spreadsheet to match the format shown below. Be sure your column titles and the order of your columns match this example.

Start the import process.

Click New, then Import.

Click Browse and open your spreadsheet.

Map your spreadsheet data to QuickBooks fields.

Now comes the interesting part–for each of the QuickBooks fields on the screen, choose one of your Excel columns. That column’s contents get imported into that QuickBooks field.

Review your data.

Now you see all your data and where it’s going into QuickBooks. Make any changes you needed. Then click Import.

bottom of page