How to select women’s shorts on AliExpress through a pivot table?

On the AliExpress platform, sellers need to clarify product subcategories in order to effectively select products. For example, for the “panties” subcategory, which is women’s shorts, sellers can use a series of data analysis tools to determine which styles are more popular.

Required preparations

Before starting, sellers should ensure that they have registered and certified stores and complete the selection of subdivisions.

Operation skills

1. Analyze hot-selling attributes

Before determining the specific style of women’s shorts, sellers can first use the two tools of “TOP Hot Selling Attributes” and “Hot Selling Attribute Combinations” to conduct an in-depth analysis of which pants are more popular. This step is crucial in the product selection process because it directly affects subsequent decisions.

2. Use pivot table analysis

First, sellers need to download the original data. Next, convert this data into numeric format to insert a pivot table into the table. In the pop-up dialog box, select the entire table area and click the “OK” button.

Then, in the new window, check the “Attribute Name”, “Attribute Value” and “Transaction Index” options. In this way, the system will generate detailed transaction index analysis data, and sellers can use these data for further analysis.

3. Find hot-selling products

Using pivot tables, sellers can classify and summarize data to identify products with hot-selling attributes. Ultimately, by picking out all the attributes with the highest transaction index, sellers will know which products are performing best in the category “panties”. For example, black, red and white shorts with lace are particularly popular.

Through the above methods, sellers can select products more scientifically and systematically, bringing better sales performance to the store.