Excel Transactions can automatically create the inventory products while importing your transactions.
Please follow below steps to create Inventory Products automatically.
1. Navigate to Import Settings >> Products / Services
2. Select "Auto Created Product Type " as Inventory.
3. Provide "Auto Created Product / Service Expense Account" . "Account" should be the type of "Cost of Goods Sold".
4.Provide "Inventory Account Name for auto created products" .
5. Provide "Inventory Start Date" if needed. You can leave it blank if you want to have the current date.
6. Provide "Initial Quantity of Inventory Product ".