Market: How Do I Use The Price & Status Filter To See When A Product Was New In, Arrived, Sold Out, Or Was Discounted?

Price & Status lets you filter by the status of products. It is split into four sections; Status, Price, Channel and Replenishment. Here we discuss using Status.

Click Price & Status and then through to Status. Here you will be given the option to filter your products by when they were:

In stock
New in
First sold out
had a First majority sell out
First discounted

All status options give you the choice of timescales to analyze the:

All time
Past week
Past month
Past 3 months
Custom date range.

Once you have selected a timescale, click Add at the bottom of the filter to apply your selection, followed by Close at the top right to shut the filter panel.

Status Filters

There are five Status filters:

In Stock: All products that were retailing during the selected period.
New In: All products that were first tracked by EDITED during the selected period.
First Sell Out: All products that sold out for the first time during the selected period.
First Majority Sell Out: All products that reached majority sell out for the first time during the selected period.
First Discounted: All products that had their first discount during the selected period.

In stock: At least one SKU is in stock, and the product itself is not discontinued.

First sell out: The date when the product had no SKUs in stock for the first time.

First majority sell out: At least 51% of SKUs have gone out of stock.

First discounted: A product is classed as discounted if the selling price of any SKU is lower than the full price of that SKU, even if it is not the cheapest SKU e.g. If a size 6 dress changes in price from $70 to $50, the product will be marked as discounted, even if the size 12 option has a full price of $40. First discount takes into account the date the product was first found to be discounted.

Full price: The highest selling price that EDITED has ever seen the product at. If the price of a product increases from its first seen price, this will become the new 'full price'.

It is important when using Status that you have the Calendar filter at the top of the filter panel set correctly.

How Do The Status Filters Work With The Calendar Filter?

The calendar icon, located at the top of your filter panel, shows the market as it was on the selected date. By default, your workbook will contain products that are In Stock today. This means your workbook will automatically display products that are available on the market right now.

When looking at the status of products over a period of time, if they have since gone out of stock, they will not be included in your workbook unless you change your calendar filter.

For example, to analyze all products that were retailing during the past week;

Select Price & Status > Status > In Stock > Past Week > Add

To only see products that were In stock over the period and are still retailing, select In Stock in the calendar filter.
To see all products, regardless of whether they have since gone out of stock, select Out of Stock and In Stock in the calendar filter.

When using the In Stock, New In, First Sell Out, First Majority Sell Out, and First Discounted filters under Status, always consider if you want to see all products attributed to the selected time period (select In Stock and Out of Stock in the calendar filter), or only the ones that are still in stock (select In Stock in the calendar).

Using Multiple Status Filters At The Same Time

When using multiple status filters it’s important to understand how they interact with each other.

For example, if you applied New In in the past three months and First Discounted, you would see products that had both arrived and been discounted over the analyzed period. Both conditions would need to apply to a product for it to show within your workbook.