# I need to import a product list to a certain category in dolibarr with the physical stock amounts **URL:** \ **Category:** PM modules\ **Tags:** Products\ **Created:** [November 10, 2022, 2:43pm UTC](https://www.dolibarr.org/forum/t/i-need-to-import-a-product-list-to-a-certain-category-in-dolibarr-with-the-physical-stock-amounts/23028 "2022-11-10T14:43:32Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![ninoevans29](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/e9bcb4/32.png) [@ninoevans29](https://www.dolibarr.org/forum/u/ninoevans29)\ **Post date:** [November 10, 2022, 2:43pm UTC](https://www.dolibarr.org/forum/t/i-need-to-import-a-product-list-to-a-certain-category-in-dolibarr-with-the-physical-stock-amounts/23028/1 "2022-11-10T14:43:32Z")
I am struggling to figure out how to do a mass import of an excel spreadsheet of a product list with the names, discriptions, selling prices, cost prices and physical stock amounts. I am very new to dolibarr and do not understand coding or open source applications very well at all. I am an accountant and just want to import the list in to the specified category. I can do the basic import but the one key item that is missing is the physcial stock amounts which is extremely important and the list of products is too big to manually ad each stock amount. Can anyone help please? ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [November 10, 2022, 3:04pm UTC](https://www.dolibarr.org/forum/t/i-need-to-import-a-product-list-to-a-certain-category-in-dolibarr-with-the-physical-stock-amounts/23028/2 "2022-11-10T15:04:41Z")
Hello, You may need to do the import in steps: 1- import the product 2 - import the stock etc… ---
**Author:** ![ninoevans29](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/e9bcb4/32.png) [@ninoevans29](https://www.dolibarr.org/forum/u/ninoevans29)\ **Post date:** [November 10, 2022, 3:23pm UTC](https://www.dolibarr.org/forum/t/i-need-to-import-a-product-list-to-a-certain-category-in-dolibarr-with-the-physical-stock-amounts/23028/3 "2022-11-10T15:23:39Z")
sorry and so how would that work, how can i import stock values on to existing products ---
**Author:** ![ninoevans29](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/e9bcb4/32.png) [@ninoevans29](https://www.dolibarr.org/forum/u/ninoevans29)\ **Post date:** [November 11, 2022, 5:12am UTC](https://www.dolibarr.org/forum/t/i-need-to-import-a-product-list-to-a-certain-category-in-dolibarr-with-the-physical-stock-amounts/23028/4 "2022-11-11T05:12:18Z")
Nevermind, i figured it out. Thank you