The programmer analyzed 500,000 pinduoduo commodity data to tell you whether the consumption is upgraded or degraded!

origin

I have a friend in hangzhou, have mentioned family do social electricity very fire, and that spell, I didn’t care about, until one day, I saw it on television advertising, advertising images, lingering, I was shocked, want to know where this is YL, no, who, under the search on the net, with various versions, such as month GMV more than 40 billion, Has threatened jingdong Taobao, etc.

Hot yao, how can ability know to spell many of these information? For example, how many products are sold in Pinduoduo and how much money are they selling? Not only is a lot of investors, perhaps Taobao Jingdong, also want to know.

I have a simple idea, not necessarily right, is to climb down to put together a lot of items, these items at least have classification, price, sold quantity and other information, do a simple addition, can you get GMV?

Of course, the disadvantages are also obvious. Because the data is acquired for the first time, only the sectional information at this point in time can be obtained, while other information, such as daily, weekly and monthly data, can only be obtained continuously.

Sure, let’s get the ball rolling, get the ball rolling. Now, let’s take a look at it from one side.

How many items did we get?

497,800, about half a million. These data are not complete at all, certainly not complete, but basically cover the vast majority of pinduoduo products sold. Take a step back, the magnitude of data should be correct (data acquisition time: apr.15, 2018).

How much were all these items sold for?

For example, there are 4 SKUs for a mango of a store. The unit price of a small one of 5 catties is 20 yuan, the unit price of a large one of 5 catties is 30 yuan, the small one of 8 catties is 40 yuan, and the large one of 8 catties is 50 yuan. 400, 300, 200 and 100 copies are sold respectively. So the total sales of this product is 400*20 + 300*30+ 200*40+ 100*50 = 30000 yuan.

In this way, we can calculate the total sales of 500,000 items.

28.8 billion.

I am a layman of e-commerce, and it says “9527 pieces have been sold” on general goods. I would like to ask the e-commerce industry members, is this the sales quantity of the month? If so, then 28.8 billion is the monthly GMV, considering that only half of this month has passed, hot, it is rumored that “Pinduoduo monthly GMV exceeds 40 billion”, perhaps, the hole does not come to wind.

What is the concept of 28.8 billion? We searched the public news of JINGdong’s financial results:

In 2017, JD’s GMV was close to 1.3 trillion yuan and its net profit was 5 billion yuan.

It can be estimated that the average monthly GMV of JD last year was about 110 billion, and the GMV of e-commerce can reach 50%+ growth year on year. It is estimated that JD’s GMV in 2018 is about 150 billion, and La, Pinduoduo’S GMV is about one third of JD’s.

Well, that’s a bit of a surprise.

What are the top ten categories by sales?

Knowing the top sales categories of an e-commerce platform can help judge its competitive advantages, such as electronic and digital products to JINGdong, clothing and bags to Taobao, books and videos to Dangdang.

What is the main category of Pinduoduo?

E-commerce likes to divide products into three categories, such as food-fruit-kiwi. Below we list the data of the top 10 categories in category 1 and category 3.

Transaction amount of all first-level categories:

The top 10 categories in terms of first-level sales:

The top three are food, mother and baby, and women’s wear. Turnover was $4 billion, $3.1 billion, $2.7 billion. Much.

Take a look at the top three sales accounted for more than a third of all 36 categories.

Top 10 categories by sales of category 3:

The first is the paper, sold more than 500 million!

I’m a little curious to know what brand of paper towels is selling so much? Also to verify the accuracy of the data, the database was used to find the highest-selling paper strip, with sales of 5.08 million.

According to the name, I found this product manually in pinduoduo APP. Maybe you have never heard of it, it is like this:

Well, the data is correct (20,000 more in 2 days, mobile phone sent, how big the picture is).

For comparison, jd.com’s top-selling product, Vida, sold more than 3.2 million units, about the same as Pinduoduo’s second-ranked paper extract, Chucai, which sold 3.43 million units.

What are the top twenty selling items?

The sales volume of a product represents popularity. Of course, some people may buy more than one product. In any case, we can see from pINDUoduo what the most customers buy:

The first or extract paper, the second indescribable, the third umbrella (hope you can click to view the original picture, otherwise the compression can not see clearly ah). The back still have a few also take out paper, hm, I don’t understand, why so much take out paper, spell many main be to sell paper?

The top 20 selling products, sales are more than 2 million. To my feeling, a bit similar to the supermarket, to be more precise, a bit like a grocery store, or, similar to the village head of the childhood of the grocery store, with practical articles for daily use, real, convenient, affordable.

What is the general price of goods? What price range sells best?

So the next thing you might ask is, what’s the price range for most of the half a million items, and what’s the relationship between price and volume?

Let’s look at the following quantity-price range:

In terms of the number of commodities, more than half (about 57%) of the commodities are between 0 and 50, and most (about 75%) of the commodities are between 0 and 100 yuan.

From the statistics, it can be found that 96.5% of the commodities are between 1 yuan and 1000 yuan. We removed these commodities (to make the picture less sharp and ugly) and made the following price-sales dot plot:

The horizontal axis represents the price (unit: yuan), and the vertical axis represents the sales (unit: thousands). The higher the point, the greater the sales. Still sharp, it seems that the price above 200 is very flat ah, let’s look at a dot plot between 1 and 200:

Please click to see the original image so that it is clearer. As you can see from this graph, the price of a product that has sold more than a million units is less than 50. Except for two scattered spots, the price is around 100, and the sales volume is around 1 million.

It needs to be noted that sales plummeted with the price, which is very normal, JD Taobao do a dot map estimate is about the same.

Can you be more specific?

You can. Food is the first category of sales, clothing, food, housing and transportation, not surprisingly, there are a wide variety of food, spicy, we may ask, from the total volume of transactions, the top ten three food categories are what? What are the proportions?

The first nut stir-fried goods (turnover 500 million), the second white wine (280 million), the third instant food (250 million), the top ten three categories of turnover more than 100 million yuan.

Top 10 sales of roasted nuts:

Bean bear… Much. The second place is Kang Meng. I remember eating a snack when I was young. I wonder if kang Hui still has it.

Baijiu? I’m curious.

Wuliangye Maotai? But a closer look is not Maotai, maotai town wine, so. It’s a bit surprising that pinduoduo sells so much baijiu.

What fruit is the most popular in Pinduoduo?

I noticed that fresh fruit exists as a separate category, fresh fruit is the second category, is it spicy, which fruit is the most popular among the three categories?

Mango first! Look at the picture (Mango. Let’s give it yellow), apple in second place, kiwi fruit in third.

In terms of sales, mango is indeed no. 1, with the key words “Imported from Vietnam” prominently displayed. In this sense, Pinduoduo has also contributed a lot to cross-border trade.

Superfluous words

In this era of mass innovation and consumption upgrading, the emergence of social e-commerce providers like Pinduoduo has achieved great success in satisfying ordinary people’s demand for quality and inexpensive goods. I have an illusion. Does this mean that our society has fallen into the trap of consumption degradation?

As I pieced together these data, I was reminded of a book I read a few years ago by a writer named Mitsuaki Miura: “Low Society”. The term “low society” here is not derogatory, but just discusses the social consumption and class clumps in Japanese society.

As soon as the term “nasty society” was coined in Japan, it immediately sparked discussion. This is because the trend of “downward mobility” is taking shape in the world, and the middle class that Japan, the United States and Europe used to be proud of is disappearing, and the polarization between “upper class” and “lower class” is emerging.

The biggest characteristic of the “low-class society” that the younger generation is constantly joining is not only low income, but also the overall decline in communication ability, living ability, willingness to work, willingness to learn, and willingness to consume. It can also be said that the “low enthusiasm for the whole life.” The pull of social sinking is increasing, when the global society has downward mobility, China, can prevent?

However, the rise of Pinduoduo may be a different situation, because China is so big, maybe it is really the consumption upgrade, just not the consumption upgrade of the residents of the first and second tier cities?

What is the best-selling item of Pinduoduo? Paper extraction.

It reminds me that when I was a child in the countryside, I used to go to the toilet, sorry, to the toilet in the thatch, where there was no such thing as refreshing breeze and fresh harvest, just used books and exercise books. Now that everyone’s living standard has improved, they begin to use paper drawn and reeled. Look, is this consumption upgrade?

Reward

Long press the QR code to transfer money to me

Due to apple’s new regulations, the appreciation function of the iOS version of wechat has been disabled, and qr code transfer can be used to support public accounts.