How to match SKU with product items while importing sales from excel

Hi there, @suhail-lesbenjam.

The option to match SKU with product items when importing sales from Excel is unavailable in QuickBooks Online. Imported sales transactions don't include an SKU column. This is the reason why mapping them is inapplicable. 

For now, you'll have to open each product and service item, then manually add the SKU from there. Here's how:

1. Go to Sales, then select Product and services.
2. Look for the item and click Edit. 
3. Add a unique code in the SKU section. 
4. Select Save and close when you're done. 

I can see how this feature would helpful for you especially when handling your business. Thus, I'll take note of this suggestion to improve your experience. 

For additional info, you can check out our sample format when importing sales in QuickBooks: Download sample CSV.

You can also refer to this article to know more about importing multiple invoices in QuickBooks Online: Import multiple invoices at once
 

If you need further help when importing your sales to QuickBooks, please let me know. I'll be more than happy to assist you. Have a good one.