---
title: Update inventory stock
description: Update the inventory balance on products in a batch
---

[Skip to content](https://support.geins.io/update-inventory-stock#main-content)

[![Geins-Black (1)](https://support.geins.io/hubfs/Geins-Black%20(1).svg)](https://support.geins.io/?hsLang=en)

Open main navigation

Close main navigation

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Geins Knowledge base](https://support.geins.io/?hsLang=en)
2. [Import tool](https://support.geins.io/import-tool?hsLang=en)
3. [Work with imports](https://support.geins.io/import-tool?hsLang=en#work-with-imports)

# Update inventory stock

## Update the inventory balance on products in a batch

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 colums 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 colums **OversellableStock **and **StaticStock **you fill in. 

 

Explanation of current fields

| Id | The products Id in the system |
| --- | --- |
| Name  | Name of the product. Can be left empty if it has 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 name of the the size/model. For an example if you have **One size**, then write in the same way. If you write **one size** in the import file then a new size/model is created where it's separated by a big and respect small O.* |
| Stock | The amount you want to update the inventory balance to. |
| **OversellableStock** | The amount you want to update your oversallebale inventory.  |
| **StaticStock** | The amount you want to update your static inventory to.  |

 

**![impor_stock](https://support.geins.io/hs-fs/hubfs/Imported%20images/impor_stock.jpg?width=665&height=228&name=impor_stock.jpg)**

 

Example on import file based on the product import template with correctly filed in fields: 

![import_example_stock](https://support.geins.io/hs-fs/hubfs/Imported%20images/import_example_stock.jpg?width=665&height=164&name=import_example_stock.jpg)

 

 

### 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 drop down
- Choose Template type: *Product *
- Choose Import mode: *Insert/update*
- Click on **Next **
- Ensure that the colums that are named in the article are mapped against the systems colums. 
- 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 through going into the product and se the amount in stock the *In Stock *colum in the *Product list *box that corresponds to what you have imported. 

- [Geins 101](https://support.geins.io/geins-101?hsLang=en)
- [Merchant Center 101](https://support.geins.io/merchant-center-101?hsLang=en#main-content)
  
  
  
  
  
    - [Export](https://support.geins.io/merchant-center-101?hsLang=en#export)
- [Products](https://support.geins.io/products?hsLang=en#main-content)
  
  
  
  
  
    - [Product editing](https://support.geins.io/products?hsLang=en#product-editing)
    - [Categories](https://support.geins.io/products?hsLang=en#categories)
    - [Product parameters](https://support.geins.io/products?hsLang=en#product-parameters)
    - [Other product functionality](https://support.geins.io/products?hsLang=en#other-product-functionality)
- [Campaigns](https://support.geins.io/campaigns?hsLang=en#main-content)
  
  
  
  
  
    - [Create campaigns](https://support.geins.io/campaigns?hsLang=en#create-campaigns)
    - [Other](https://support.geins.io/campaigns?hsLang=en#other)
- [Content](https://support.geins.io/content?hsLang=en#main-content)
  
  
  
  
  
    - [General settings for content management](https://support.geins.io/content?hsLang=en#general-settings-for-content-management)
    - [Create content](https://support.geins.io/content?hsLang=en#create-content)
    - [Widgets library](https://support.geins.io/content?hsLang=en#widgets-library)
- [Orders](https://support.geins.io/orders?hsLang=en#main-content)
  
  
  
  
  
    - [General](https://support.geins.io/orders?hsLang=en#general)
    - [Order fullfillment](https://support.geins.io/orders?hsLang=en#order-fullfillment)
    - [Refunds](https://support.geins.io/orders?hsLang=en#refunds)
- [Customers](https://support.geins.io/customers?hsLang=en#main-content)
  
  
  
  
  
    - [Customer management](https://support.geins.io/customers?hsLang=en#customer-management)
    - [Customer groups](https://support.geins.io/customers?hsLang=en#customer-groups)
    - [Consents](https://support.geins.io/customers?hsLang=en#consents)
- [Import tool](https://support.geins.io/import-tool?hsLang=en#main-content)
  
  
  
  
  
    - [Work with imports](https://support.geins.io/import-tool?hsLang=en#work-with-imports)
    - [Import templates](https://support.geins.io/import-tool?hsLang=en#import-templates)
- [Statistics](https://support.geins.io/statistics?hsLang=en)
- [Settings](https://support.geins.io/settings?hsLang=en#main-content)
  
  
  
  
  
    - [Configurations](https://support.geins.io/settings?hsLang=en#configurations)
- [Cross-border](https://support.geins.io/cross-border?hsLang=en#main-content)
  
  
  
  
  
    - [General](https://support.geins.io/cross-border?hsLang=en#general)
    - [Products and pricing](https://support.geins.io/cross-border?hsLang=en#products-and-pricing)
    - [Texts and content](https://support.geins.io/cross-border?hsLang=en#texts-and-content)
- [FAQs](https://support.geins.io/faqs?hsLang=en#main-content)
  
  
  
  
  
    - [Merchant Center](https://support.geins.io/faqs?hsLang=en#merchant-center)
    - [Product & Categories](https://support.geins.io/faqs?hsLang=en#product-categories)
    - [Orders & order management](https://support.geins.io/faqs?hsLang=en#orders-order-management)
    - [Campaigns & discounts](https://support.geins.io/faqs?hsLang=en#campaigns-discounts)
    - [Content CMS](https://support.geins.io/faqs?hsLang=en#content-cms)
    - [Customers](https://support.geins.io/faqs?hsLang=en#customers)
    - [Import Tool](https://support.geins.io/faqs?hsLang=en#import-tool)
    - [Settings](https://support.geins.io/faqs?hsLang=en#settings)
    - [Statistics](https://support.geins.io/faqs?hsLang=en#statistics)
    - [Mails](https://support.geins.io/faqs?hsLang=en#mails)
- [Incoming Stock managment](https://support.geins.io/incoming-stock-managment?hsLang=en)

[![Geins-white](https://support.geins.io/hubfs/Geins-white.svg "Geins-white")](https://support.geins.io/?hsLang=en)

[Visit geins.io](https://www.geins.io/)

<https://www.linkedin.com/company/geins-io/>

[Developer documentation](https://docs.geins.io/)