The Item With Init Inventory import allows users to batch import products and beginning inventory quantities into C2W Inventory.
This is useful when setting up the system for the first time or moving item data from another system.
If users already know the starting stock quantity for each item, they can include the inventory location and quantity in the same import file. C2W Inventory also supports multiple inventory locations.
Open the Import Data Screen
Fill in the Excel Template
The Customer import template may include the following fields:
- The yellow highlighted column is mandatory.
- For the Customer template, Name is mandatory.
For this template, the Name field is mandatory and must be unique.
Users can also enter beginning inventory information by filling in:
- Location
- Quantity
If the company has more than one inventory location, enter the correct location for the beginning stock quantity.
Save and Upload the Template
Verify Imported Customers
After importing, users can verify the imported records in two places:
- Go to Inventory > Manage Item to confirm the items were imported.
- Go to Inventory > Current Stock to confirm the initial inventory quantities were imported.
Best Practice
Before importing, check that:
- The item name is filled in
- The item name is unique
- Location names are correct
- Quantity values are correct
- The Excel file is saved and closed before uploading
This helps prevent import errors and keeps beginning inventory accurate.