SKULabs uses different CSV templates for importing and adjusting different parts within SKULabs. This article will help you create a brand new template for when you want to import new stock quantities in bulk using the Items Stock Import function on the Import/Export page.
Tip: Short on time? Download our default Import template here.
Making a new item stock import CSV file from scratch
To run the Items Stock Import function properly, your CSV template uses 4 required and 3 optional field types set as the column headers.
- SKU - The stock keeping unit used to refer to the parent item.
- Warehouse - The name of the warehouse the location resides in.
- On Hand - The number of units in stock for this specific item.
- Optional if only changing Alert.
- Alert - The number at which a Low Stock Alert should be shown.
- Optional if only changing On Hand. Defaults to either 10 or your account's Default Alert Level if left blank.
There are also 3 optional fields if needed:
- Location* - A name for the specific location in the warehouse.
- Reason - Reason for the adjustment in stock that will show in logs. You can leave entirely blank if you want.
- Remove - Enter "REMOVE" to remove an item from a location.
*Tip – The Location Field: On default Warehouse-based inventory management accounts, the Location field is not required, but can instead be used as a way to make bulk changes to item Location Aliases. If you don't wish to make changes to Location Aliases, feel free to leave this field out.
The Location Field is only absolutely required when importing stocks in Multi-Location inventory management accounts.
If your template looks somewhat like this, then you're ready to start inputting data.
Editing the item stock CSV
To correctly import or updating an item's stock, your item stock CSV file will need to contain accurate information under its SKU and Warehouse columns.
SKU and Warehouse values are case-sensitive and must match exactly for imports to work properly.
- That the Warehouse names you want to include in the items stock CSV already exist in SKULabs. Check this on the Warehouses tab of the Inventory page.
- That the SKUs for you want to import stock are accounted for under the SKU column of the Items Table on your inventory page.
- That you have correctly entered the information. Remember, these values are case-sensitive and will not work if they do not match exactly.
Tip – Less is more: When updating items, we recommend including only the optional columns you intend to make changes to. As CSV importing it is a powerful tool, using this conservative method will help you avoid any potential mistakes.
Once you have your template filled out, it's time to move on to importing item stock in bulk.