Managing stock of products with options

Inventory tracking helps to know if it’s time to replenish a product stock and what product variations are the most popular in your online store. If you sell products that slightly differ from each other, for example, by color or size, you can add them to your catalog as one base product with Color and Size options. To track stock levels of these product options automatically, you have to create variations out of them (Red Small, Red Medium, Red Large; White M, White L, White XXL, etc). Every variation can have its own SKU and stock quantity for inventory purposes.

Plan availability: Business, Unlimited. Upgrade.

Enabling inventory tracking for variations

After you add products with options like size and color, you can track the stock level of every product variant if you create variations out of options. A product variation is a combination of product options, for example, Red Small or Yellow Large.

You can quickly generate all possible product variations using Ecwid mobile app for iOS:
Generate variations

Every newly created variation inherits SKU and quantity properties (as well as price, weight, and image) from the product it belongs to. To track the stock level of a certain variation, you should set a unique SKU and quantity in stock for it.

To enable inventory tracking for a variation:

  1. Go to Ecwid control panel → Catalog → Products.
  2. Сhoose a product or add a new product.
  3. Click the Options tab in the product details page, and then Variations:

Variations tab

  1. Click on the default SKU next to a variation to set a unique SKU for it:

Variation SKU

  1. Click on Manage in the Stock column next to that variation:

Variation stock

  1. Set the stock quantity for this variation (and, if needed, at what quantity a low-stock notification should be sent):

Quantity in stock

  1. Click OK and save the changes.

Add unique SKU and stock quantity for other variations of the product in a similar way.

That’s it, now your store tracks stock levels of product variations. When buyers place orders (with Awaiting Payment or Paid payment status) for a product variation, its stock gets reduced for the number of items ordered. When the variation stock reaches zero, it becomes unavailable for purchase - it gets Sold Out label and can’t be ordered until its stock is replenished.

Out of Stock message

If you cancel or refund the order, the quantity of the variations in that order will be automatically returned to the stock of those variations in your online store.

Low-stock notifications for variations

You can set low-stock email notifications to be informed when this or that variation is about to run out of stock:

Low stock notification

When you replenish the stock of a variation (produce more of such a product variation or order and receive it from supplier), you can click Re-stock product button in such email to visit the product editing page and update the quantity in stock number for that variation in your store.

To receive low-stock notifications to your inbox, you should specify at what variation’s quantity you should be alerted:

  1. Go to Ecwid control panel → Catalog → Products page;
  2. Choose a product for which you’ve added variations;
  3. Go to Options, then to the Variations tab;
  4. Click Manage under the Stock column next to the variation;
  5. Enter the low stock quantity in the Send me a note when quantity in stock reaches field:

Low stock quantity

  1. Click OK and save the changes.

Now when the stock of the variation reaches that low-stock quantity, you will be alerted of this by email that is specified in Ecwid control panel → Settings → Mail page. Make sure that the Low Stock notification type is enabled there, too:

Enable notification

If you do not set any low stock quantity for a variation whose inventory you track, a low-stock notification will be sent as soon as the variation reaches zero.

FAQ

How do I know that it’s time to restock?

To get the list of out-of-stock products, you can use the Out of Stock filter in the Ecwid control panel → Catalog → Products page. If all variations of a product are out of stock, the product appears under the Out of Stock filter:

Filter out of stock products

Also, for every variation that you’ve enabled the inventory tracking for a low-stock notification will be sent to you as soon as the variation’s stock reaches 0 or a greater number if you specify the low-stock quantity for that variation.

How can I specify a different email address for Low Stock Notification?

You can specify an email address to which administrator notifications (both New Order and Low Stock) should be sent in Ecwid control panel → Settings → Mail page. You can add there several email addresses separated by a comma, for example, yours and email address of a person that manages your inventory:

email address for notifications

Can I update the stock of several variations at once?

You can use the built-in import tool to update the stock quantity of product variations if they have their own SKU in your store (in this case they are treated as individual products). For this, you can create a simple CSV file with any text editor and add two data types in it - SKU and quantity - and import this file to your store.

For example, you want to update the stock quantity of the variation Black Shoes Size 6 to 55 items and the stock of the variation Red Shoes Size 5 to 79 items. In this case, create a file with the SKU and Quantity columns:

import stock for variations

Save it as .csv and import to your store via Ecwid control panel → Catalog → Product, Import Products button.

As a result, the stock of these variations will be updated in your store:

Updated stock of variations in the store

Related articles

Creating variations
Adding images to product options in your store
Product inventory tracking

Was this article helpful?

Awesome! Thanks for your feedback!

Sorry about that! We are here to assist you by email or chat.

Contact support