> For the complete documentation index, see [llms.txt](https://howto.sellercraft.co/how-to-sellercraft/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://howto.sellercraft.co/how-to-sellercraft/oms/products/bulk-operations/bulk-update-inventory-stock.md).

# Bulk Update Inventory Stock

## Steps

<figure><img src="https://lh6.googleusercontent.com/niAfCwt9Nh0W6948UaW1pnQdCipR-Vee2MLWYnexYP3yRBAzbvOHQQOEWdOKu0lMSX81-lDVjz4TowsFmRQ4JowhAibCVgnBoKdc_W9boTto-KHx5TVyiZw7_3CJ0foybd-kDjlSq1w8oLa6Y1nwMXsPh0QBHf8uIq_as1VmqqC9pUI-bZ0wDceXpmugIw" alt=""><figcaption><p>Bulk Operation - Update Inventory Stock</p></figcaption></figure>

1. Click on "Products" in the navigation menu.
2. Navigate to "Bulk Operations".
3. Select the type of file to download and click the "Download" button.
4. Download the latest "Stock Levels Template File" from the "Operation History" section and edit the stock levels as necessary.

<figure><img src="https://lh4.googleusercontent.com/ZNwDtG_UcuINWmg28_ZOB9Zjh2ThC78mhf0p2HTgxjGLaHVPK9ixYrabnb2W8jMXfNLlYsxBFnugpKwIkSNZYIIt61YgPVlyFezIErWxQwMB-bUtA1OkOxiUIprzVJ8AkSxGSmkLK-VZ9YvgAGx6we8U0aYMorQsVCkJeJ0-tKOwMZzO2QDytlUwD00zPQ" alt=""><figcaption></figcaption></figure>

5. Upload the edited stock levels file to the "Update Inventory Stock File Upload" section.
6. Wait for the stock levels file to process and verify that there are no issues reported.

{% hint style="danger" %}
If any issues arise with the uploaded file, the 'Operation History' section will display the 'Uploaded File' and 'Issues Report.' Download the Issues Report file and edit the fields that require corrections.
{% endhint %}

{% hint style="warning" %}
Stock levels that have been successfully processed are not displayed in the issues report file.
{% endhint %}

## Specification

<table><thead><tr><th width="171"> Inventory SKU</th><th width="253">Product / Inventory name</th><th width="278">Version label /  Variation  Name</th><th width="134">End of Life</th><th width="152"> Free Gift</th><th width="130"> Cost Price</th><th width="136"> Stock level</th><th width="164"> Stock reserved</th></tr></thead><tbody><tr><td><mark style="color:red;"><strong>Mandatory</strong></mark> </td><td><mark style="color:red;"><strong>Mandatory</strong></mark> </td><td><mark style="color:red;"><strong>Mandatory</strong></mark> </td><td><mark style="color:red;"><strong>Mandatory</strong></mark> </td><td><mark style="color:red;"><strong>Mandatory</strong></mark> </td><td>Optional</td><td><mark style="color:red;"><strong>Mandatory</strong></mark> </td><td><mark style="color:red;"><strong>Mandatory</strong></mark> </td></tr><tr><td>Inventory SKU is a unique identifier for each physical product.<br>Inventory should be already exist in Sellercraft<br></td><td>Name of the product or the inventory name.</td><td>Indicate the variation name. Variations are <strong>different options of the same listing.</strong> Variations allow shoppers to select different product characteristics, such as size and colour.</td><td><strong>TRUE</strong> when the item already stop for production (not active) or have new Inventory SKU for that item.<br><br><strong>FALSE</strong> when Inventory SKU for the item still active</td><td><strong>TRUE</strong> when the item given as free gift <br><br><strong>FALSE</strong> when the item is not free gift</td><td>The total amount of money of the inventory.</td><td><p>The level of stock required for an efficient and effective control of goods, to avoid over-and under-stocking of goods. </p><p>**Must be more than stock reserved.</p></td><td><p>The quantity of a product that set aside. </p><p>**Must be less than stock level.</p></td></tr><tr><td><strong>Uneditable column for Inventory SKU</strong></td><td><strong>Uneditable column for Inventory Name</strong></td><td><strong>Uneditable column for Version Label</strong></td><td><strong>Please input either TRUE or FALSE option for the end of life.</strong></td><td><strong>Please input either TRUE or FALSE option for the free gift.</strong></td><td><strong>Please input Min 0.2 to 1,000,000,000 for cost price</strong><br><strong>*Only positive numbers are accepted.The price must in 2 decimal places</strong></td><td><p><strong>Please input interger value for the stock level</strong></p><p>**<strong>Must be more than stock reserved.</strong></p></td><td><p><strong>Uneditable column for Stock Reserved.</strong></p><p>**<strong>Must be less than stock level.</strong></p></td></tr><tr><td>Running_Shoes_SE</td><td>Running Sport Shoes Special Edition</td><td>Running Sport Shoes Special Edition</td><td>FALSE</td><td>FALSE</td><td>50.00</td><td>300</td><td>0</td></tr></tbody></table>