Stock Management

You can update the stock in your warehouse only if at least one delivery method is chosen in the warehouse settings.

Learn more about adding a delivery method

Update stocks #

You can update stocks manually in your personal account via an Excel template or API.

it takes about 20 minutes to update the stocks on the storefront. If you upload more than 500 products, the update process may take longer.

Manually in your personal account #

  1. In your account, go to Logistics → Warehouses and methods or FBS → Logistics section. On the warehouse card, click:

    • on the number of products or on the No products field if you have no stock:

    • Manage stocks.

  2. On the Products in stock page, you can:

    • filter products that are in or out of stock;
    • see all products on sale: click All products;
    • search for products by name or article code.
  3. In the In stock, pcs column, specify the number of items in stock and click Save.

  4. To update the stock amount in other warehouses, in the upper left corner select a warehouse from the drop-down list and specify the number of items.

How to handle errors

Using the Excel template #

  1. On the Products in stock page, click Update via XLS.

  2. On the Uploading stocks page, download the template and fill it out.

On the Stock balances sheet fill in all the required columns:

  • Warehouse name: A column.
  • SKU: B column.
  • Name (optional): C column.
  • Quantity: D column.
  • Filling in required cells: E column.

Make sure to fill in each row when uploading stocks to avoid errors.

  • In the Warehouse name column select the warehouse for which you want to update the stocks from the drop-down list. To avoid errors, select the values only from the drop-down list.

  • In the Article column, add SKU of the product you want to update the stocks for. You can find SKUs in your personal account in the Products and pricesProduct list section in the SKU visibility column.

The Name (optional) column is optional. Here you can add the product name associated to this SKU.

  • In the Quantity column specify product quantity in your warehouse. Use only digits.

  • The Filling in required cells column is used for verifying that data provided is complete. If one of the required values in the columns A, B, or D is missing, you’ll see the “Not filled” value in the Filling in required cells column.

  1. Upload the filled in template on Uploading stocks page.

Several products in all warehouses #

Go to the Logistics → Update stocks or FBS → Update stocks page, download a template, fill it in, and upload.

Using API #

Use this method if you have a lot of warehouses, more than 50 types of products, and want to update stocks faster. Learn more in Seller API documentation

View stock reports #

Stock reports contain data about the amount of available and reserved products in the selected warehouse.

To view your stock report:

  • For one warehouse:

    1. Go to Logistics → Warehouses and methods or FBS → Warehouses and methods page and click on the number of products on the warehouse card.

    2. On the Products in stockIn stock page, click Download XLS:

  • For all warehouses:

    1. Go to the Products and pricesProduct list section.
    2. Click Download → Download stocks in my warehouses.

    The report contains the data on the total number of products reserved and available in all your warehouses and the data on the total number of products reserved and available in each of your warehouses.

Check for errors when uploading stocks #

To check if any errors occurred when uploading stocks and view its update history, go to Products and pricesUpdates history, to the Stock tab.

To see exactly what errors occurred, in the Actions column, click Learn more. The Product import errors page will open.

Resolving errors #

When you fill in the amount of products in your warehouse, the following errors may occur:

  • «You can’t sell bulky products»: you didn’t specify that you sell bulky products when setting up your warehouse. Create a new warehouse for bulky products.
  • «Weight or size of your products exceeds the limit. Stock can’t be updated»: you are trying to update the amount of product that has too much weight or size. Edit the product description page and then try to update the stock again.
  • «Ordinary products can’t be stored in the warehouse for bulky products»: you specified that you sell bulky products when setting up your warehouse, and now you are trying to update the amount of ordinary products. Create a new warehouse for ordinary products.
  • «The number of products exceeds 1,000,000»: you’ve entered too many products. Change the value and update the stock again.
  • «The number of products didn’t change»: you haven’t changed the number of products. Check the value update the stock again.
  • «PDP is being created. Please try again later»: you’ve uploaded the product, however, it hasn’t appeared in our system yet. Wait until the product description page status changes and then try to update the stock again.

Examples of changing stocks #

Customer receives the order

You specify a stock balance of 10 units. When the customer places an order, 1 unit is reserved and 9 units are available. After packing, there are 0 products in reserve again, and 9 available for sale.

Action Number of items available for purchase on Ozon Number of items that are reserved for purchase
Seller indicates the quantity of products in their warehouse as “10” 10 0
Customer places an order for 1 piece of product on Ozon 9 1
Seller collects the order 9 0
Customer receives the order 9 0
Сustomer cancels order before it's packed
Action The number of products available for purchase on Ozon The number of products reserved for purchase
Seller indicates the quantity of products in their warehouse as “10”. 10 0
Customer places an order for 1 piece of products on Ozon. 9 1
Customer cancels the order. 10 0
Customer cancels the order after it's packed

You specify a stock balance of 10 units. When the customer places an order, 1 unit is reserved and 9 units are available. After packing, there are 0 products in reserve again, and 9 are available for sale.

If the customer cancels the order, you can:

  • immediately update the stocks if you haven’t handed over the shipment for delivery;
  • wait for a return if you sent the products to the carrier.

There are 9 products in the stocks until the product is returned to the warehouse.

Action The number of products available for purchase on Ozon The number of products reserved for purchase
Seller indicates the quantity of products in their warehouse as “10”. 10 0
Customer places an order for 1 piece of products on Ozon. 9 1
Seller is packing the order. 9 0
Customer cancels the order. 9 0
Customer cancels the order due to defective or missing products in stock

You specify a stock balance of 10 units. When the customer places an order, 1 unit is reserved and 9 units are available. If the order is canceled due to “Defective product” or “Out of stock”, we`ll reset the number of reserved products.

Action The number of products available for purchase on Ozon The number of products reserved for purchase
Seller indicates the quantity of products in their warehouse as “10”. 10 0
Customer places an order for 1 piece of products on Ozon. 9 1
Seller cancels the order and indicated “Defective” in the reasons for the cancellation. 0 0
Customer received the product, but then issued a return

You specify a stock balance of 10 units. When the customer places an order, 1 unit is and 9 units are available. After packing, there will be 0 units in reserve again, and 9 available for sale.

Action The number of products available for purchase on Ozon The number of products reserved for purchase
Seller indicates the quantity of products in their warehouse as “10”. 10 0
Customer places an order for 1 piece of products on Ozon. 9 1
Seller collects the order. 9 0
Customer receives the order. 9 0
Customer issues a return. 9 0
Seller receives the refund and updates the stocks. 10 0

Learn more #