Update inventory stock
With the import tool you can smoothly update the inventory balance on products in a batch. You do this through the product import and the columns you need to map are: Id, Name, Size, Stock.
Even if you are working with oversellable or static stock and want to update the inventory balance, then it's the columns OversellableStock and StaticStock you fill in.
Explanation of current fields
| Column | Description |
|---|---|
| Id | The products Id in the system |
| Name | Name of the product. Can be left empty if it has an Id. |
| Size | Name of the size/model (the field name in the product list inside the product view, see picture below). A new size/model is created if the value in the Size field isn't previously available. It's good to think about spelling exactly the name of the size/model. For example if you have One size, then write it the same way. If you write one size in the import file then a new size/model is created where they are separated by a capital and lowercase O. |
| Stock | The amount you want to update the inventory balance to. |
| OversellableStock | The amount you want to update your oversellable inventory. |
| ** StaticStock** | The amount you want to update your static inventory to. |
Example of an import file based on the product import template with correctly filled in fields:
When your file is done
- Click on Import Tool in the menu. Click then on New to make a new import.
- Choose the file you want to import
- Choose file type in the File extension dropdown
- Choose Template type: Product
- Choose Import mode: Insert/update
- Click on Next - Ensure that the columns that are named in the article are mapped against the system columns.
- Click on Start import
When the import is done and every row is imported then the products inventory balance will be updated. You can see it by going into the product and seeing the amount in stock in the In Stock column in the Product list box that corresponds to what you have imported.
Manage Product Relations with the Import Tool
Create, update, or remove product relations in bulk using the RelatedProducts import template.
Update prices using the import tool
If you want to update prices for products in batches, you can conveniently do so using the import tool. In the product import, you can set or update the regular price (Price), sale price (SalePrice), and purchase price (InPrice) of the product. If you're also dealing with multiple currencies or sales channels, you can update the prices differently for each on the product through the import.