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 ".