Import of inventory items

I would like to import inventory items from Excel and would like to add column quantity. So as they can be seen on my inventory tab.

Also I would like to add tax category in the same import process.

Unfortunately opening qty amount and default tax code are not importable.

So you would need to first import inventory items without opening balances and then set opening balance for each inventory item one-by-one.

Default tax codes for inventory items are not yet supported but they will be eventually added.

@lubos According to below screenshot I can’t find out how to import item name from Excel?

@hafiz4saqib, you are responding to an 8-year-old, obsolete topic.

Use the Batch Create function. See the Guide: Use Batch Create and Batch Update functions | Manager.

@lubos Thank you very much.
I done my work like as below and result is :smiling_face_with_three_hearts: :star_struck:

Paste in here after copy from excel

But Average Cost column is still empty …

How would it be able to give average cost in this screen. Just complete the procedure and then all will be well.

@hafiz4saqib, you have not purchased anything, nor did you enter any starting quantities, so you have no average cost—because you have no total cost.

1 Like

You are now off topic, see this bug Batch operations not working