[Actual] retail O2O How to optimize commodity structure[i world network operators Note] \u0026 ldquo; Product dimension table \u0026 rdquo; the commodity form the basis of structural optimization, especially for diverse category, SKU rich retail formats, can be used online and offline. Offline retail increased use ABC analysis, general analysis category only, not analysis category dimension. There are more mass merchandise format online than offline, more comprehensive data base (Dimension Data), smarter analytical tools, so overall, commodity dimension tables have a greater role to online formats. Wen / Zhang Chenyong this paper, a story of how to optimize commodity structure, the core tool is a commodity dimension table. Ding find out the commodity structure they get an investment, to create a regional integrated B2C. The B2C main supermarket goods, but in the end what you want to operate category, the category under which goods required, the proportion of each category of goods, how to track commodity investment situation, Ding no idea, ask me how to do. \u0026 Ldquo; You need to do a commodity dimension table. \u0026 Rdquo; I said. It is a commodity classification fractal dimension of the table, such as nuts, peanuts belong to this category, peanut taste, shape multiple dimensions, specifications, and prices. It can help us to track commodity investment situation, optimizing product mix, and even increase revenue. So how do you build \u0026 ldquo; \u0026 rdquo ;? commodity dimension table The first step is to list the product categories will operate, as well as an important dimension of each of the categories under (see below table). When preparing this form, you can refer to the classification and major site navigation field. The second step is to fill the investment to the commodity commodity dimension table (see table below). The third step, when we fill enough merchandise, you can use the \u0026 ldquo; PivotTable \u0026 rdquo; function or sql statement to extract statements, understand the products introduced into the situation (see table below). \u0026 Ldquo; I understand. \u0026 Rdquo; Ding said, \u0026 ldquo; through these forms, I can know how many goods under each category, how many of Nike Air Max 2013 KPU each category of goods each dimension. If too many goods under a category and dimension, the introduction of new restrictions; if too small, they should focus on the introduction. \u0026 Rdquo; \u0026 ldquo; yes. \u0026 Rdquo; I answered, \u0026 ldquo; we can also control the total number of this table SKU, based on the total number of SKU stock funds allocated under each category, SKU range of indicators set for each category. Each dimension sketch class represents a demand of individual commodities have more Nike Air Max Excellerate+2 than one dimension, the introduction of a number of multi-dimensional commodity, you can use fewer SKU, meet more diverse needs, so that we can without affecting the user experience By reducing the capital stock. \u0026 Rdquo; Ding said: \u0026 ldquo; this form is very good, but also a great amount of work invested so much labor time is worth? \u0026 Rdquo; I said: \u0026 ldquo; Product dimension table, there are other useful, it is accompanied by the entire project management process, optimizing product mix, improving the earnings have far-reaching effects, that time you will know. \u0026 Rdquo; the dimension table after months of digging efficiency, the normal operation of the line on the site, Ding found that, on the one hand the customer to reflect commodity rich enough, could not find the necessary goods, on the other hand a lot of commodities decline in sales, a lot of money tied up in inventory , so to ask me whether commodity dimension table can solve this problem. \u0026 Ldquo; of course, you need to join SKU accounting and sales accounting fields (see below table) in the report. \u0026 Rdquo; \u0026 ldquo; In Table 4, accounting for 0.13 percent of peanut SKU, sales accounted for 0.21%, the proportion of sales accounted for more than SKU. If similar products (such as seeds) of SKU and sales accounting for the difference is not so great, then consumers peanuts, peanut category too little, should be increased. \u0026 Rdquo; \u0026 ldquo; from the commodity dimension point of view, 0 \u0026 mdash; 100g specifications of peanut SKU accounted for 80%, but sales accounted for only 46 percent, indicating 0 \u0026 mdash; 100g specifications peanuts too much, should be reduced, a corresponding increase in other specifications peanut single product. \u0026 Rdquo; \u0026 ldquo; That's great, over time, will be more optimized product mix, reducing slow-moving inventory, increase turnover. \u0026 Rdquo; \u0026 ldquo; Not only that, commodity dimension tables can help you improve earnings. Your table below. \u0026 Rdquo; Ding said: \u0026 ldquo; this table and on a table almost ah, but the proportion of sales accounted for into a contribution. \u0026 Rdquo; I replied: \u0026 ldquo; yes, it is an object on the table, is to optimize the product mix, in order to meet consumer demand, it is more from sales of goods dimension. The purpose of this table is to enhance revenue, so the contribution from consideration. \u0026 Rdquo; \u0026 ldquo; What contribution is accounted for, how calculated? \u0026 Rdquo; \u0026 ldquo; contribution accounted = (certain time margin - fixed costs) / overall margins. \u0026 Rdquo; I wrote it down on paper, \u0026 ldquo; different merchandise gross margin, turnover is different. B2C fixed costs (the cost of packaging and distribution) than offline stores. Because the main cost of the line store (rent, labor, utilities) with increased sales share decreased, while B2C even increase sales, reduce fixed cost very little space. Contribution considered above. \u0026 Rdquo; Ding said: \u0026 ldquo; see, according to the proportion of the contribution rate and SKU accounted for data analysis, increased commodity high contribution rates, reduce the low contribution rate products, so overall revenue will increase. \u0026 Rdquo; answer: \u0026 ldquo; Yes, but when analyzing the data, but also consider other circumstances, such as certain sensitive products, although low gross margin, the contribution rate is not high, but if you do not run, the user will be lost, and therefore can not be sale of. \u0026 Rdquo; \u0026 ldquo; In general, A-sensitive goods (attracting products) and merchandise dimensional structure is indispensable. Audience dimensional structure of small commodities, but if lacking, some users will think commodity rich enough. After all, regardless of how to optimize the product mix, 2/8 principles always effective, Air Jordan 5 and not all sales of goods can be less streamlined. \u0026 Rdquo; I continued: \u0026 ldquo; need to consider seasonal factors. Sudden decline in the contribution of some commodities, the problem may just be the season, it does not mean that this product is always unpopular. Product dimension table provides the data foundation for us to combine practical experience and industry characteristics analysis. \u0026 Rdquo; \u0026 ldquo; Product dimension table \u0026 rdquo; the commodity form the basis of structural optimization, especially for diverse category, SKU rich retail formats, can be used online and offline. Offline retail increased use ABC analysis, general analysis category only, not 2015 Latest Nike Shoes analysis category dimension. There are more mass merchandise format online than offline, more comprehensive data base (Dimension Data), smarter analytical tools, so overall, commodity dimension tables have a greater role to online formats. (Edit / world network operators Ma Xiaodan, This article first appeared in the i world network operators, please indicate the source and author)[Actual] retail O2O How to optimize commodity structure[i world network operators Note] \u0026 ldquo; Product dimension table \u0026 rdquo; the commodity form the basis of structural optimization, especially for diverse category, SKU rich retail formats, can be used online and offline. Offline retail increased use ABC analysis, general analysis category only, not analysis category dimension. There are more mass merchandise format online than offline, more comprehensive data base (Dimension Data), smarter analytical tools, so overall, commodity dimension tables have a greater role to online formats. Wen / Zhang Chenyong this paper, a story of how to optimize commodity structure, the core tool is a commodity dimension table. Ding find out the commodity structure they get an investment, to create a regional integrated B2C. The B2C main supermarket goods, but in the end what you want to operate category, the category under which goods required, the proportion of each category of goods, how to track commodity investment situation, Ding no idea, ask me how to do. \u0026 Ldquo; You need to do a commodity dimension table. \u0026 Rdquo; I said. It is a commodity classification fractal dimension of the table, such as nuts, peanuts belong to this category, peanut taste, shape multiple dimensions, specifications, and prices. It can help us to track commodity investment situation, optimizing product mix, and even increase revenue. So how do you build \u0026 ldquo; \u0026 rdquo ;? commodity dimension table The first step is to list the product categories will operate, as well as an important dimension of each of the categories under (see below table). When preparing this form, you can refer to the classification and major site navigation field. The second step is to fill the investment to the commodity commodity dimension table (see table below). The third step, when we fill enough merchandise, you can use the \u0026 ldquo; PivotTable \u0026 rdquo; function or sql statement to extract statements, understand the products introduced into the situation (see table below). \u0026 Ldquo; I understand. \u0026 Rdquo; Ding said, \u0026 ldquo; through these forms, I can know how many goods under each category, how many of each category of goods each dimension. If too many goods under a category and dimension, the introduction of new restrictions; if too small, they should focus on the introduction. \u0026 Rdquo; \u0026 ldquo; yes. \u0026 Rdquo; I answered, \u0026 ldquo; we can also control the total number of this table SKU, based on the total number of SKU stock funds allocated under each category, SKU range of indicators set for each category. Each dimension sketch class represents a demand of individual commodities have more than one dimension, the introduction of a number of multi-dimensional commodity, you can use fewer SKU, meet more diverse needs, so that we can without affecting the user experience By reducing Nike Air Max 91 the capital stock. \u0026 Rdquo; Ding said: \u0026 ldquo; this form is very good, but also a great amount of work invested so much labor time is worth? \u0026 Rdquo; I said: \u0026 ldquo; Product dimension Air Jordan 1 table, there are other useful, it is accompanied by the entire project management process, optimizing product mix, improving the earnings have far-reaching effects, that time you will know. \u0026 Rdquo; the dimension table after months of digging efficiency, the normal operation of the line on the site, Ding found that, on the one hand the customer to reflect commodity rich enough, could not find the necessary goods, on the other hand a lot of commodities decline in sales, a lot of money tied up in inventory , so to ask me whether commodity dimension table can solve this problem. \u0026 Ldquo; of course, you need to join SKU accounting and sales accounting fields (see below table) in the report. \u0026 Rdquo; \u0026 ldquo; In Table 4, accounting for 0.13 percent of peanut SKU, sales accounted for 0.21%, the proportion of sales accounted for more than SKU. If similar products (such as seeds) of SKU and sales accounting for the difference is not so great, then consumers peanuts, peanut category too little, should be increased. \u0026 Rdquo; \u0026 ldquo; from the commodity dimension point of view, 0 \u0026 mdash; 100g specifications of peanut SKU accounted for 80%, but sales accounted for only 46 percent, indicating 0 \u0026 mdash; 100g specifications peanuts too much, should be reduced, a corresponding increase in other specifications peanut single product. \u0026 Rdquo; \u0026 ldquo; That's great, over time, will be more optimized product mix, reducing slow-moving inventory, increase turnover. \u0026 Rdquo; \u0026 ldquo; Not only that, commodity dimension tables can help you improve earnings. Your table below. \u0026 Rdquo; Ding said: \u0026 ldquo; this table and on a table almost ah, but the proportion of sales accounted for into a contribution. \u0026 Rdquo; I replied: \u0026 ldquo; yes, it is an object on the table, is to optimize the product mix, in order to meet consumer demand, it is more from sales of goods dimension. The purpose of this table is to enhance revenue, so the contribution from consideration. \u0026 Rdquo; \u0026 ldquo; What contribution is accounted for, how calculated? \u0026 Rdquo; \u0026 ldquo; contribution accounted = (certain time margin - fixed costs) / overall margins. \u0026 Rdquo; I wrote it down on paper, \u0026 ldquo; different merchandise gross margin, turnover is different. B2C fixed costs (the cost of packaging and distribution) than offline stores. Because the main cost of the line store (rent, labor, utilities) with increased sales share decreased, while B2C even increase sales, reduce fixed cost very little space. Contribution considered above. \u0026 Rdquo; Ding said: \u0026 ldquo; see, according to the proportion of the contribution rate and SKU accounted for data analysis, increased commodity high contribution rates, reduce the low contribution rate products, so overall revenue will increase. \u0026 Rdquo; answer: \u0026 ldquo; Yes, but when analyzing the data, but also consider other circumstances, such as certain sensitive products, although low gross margin, the contribution rate is not high, but if you do not run, the user will be lost, and therefore can not be sale of. \u0026 Rdquo; \u0026 ldquo; In general, A-sensitive goods (attracting products) and merchandise dimensional structure 2015 Latest Nike Shoes is indispensable. Audience dimensional structure of small commodities, but if lacking, some users will think commodity rich enough. After all, regardless of how to optimize the product mix, 2/8 principles always effective, and not all sales of goods can be less streamlined. \u0026 Rdquo; I continued: \u0026 ldquo; need to consider seasonal factors. Sudden decline in the contribution of some commodities, the problem may just be the season, it does not mean that this product is always unpopular. Product dimension table provides the data foundation for us to combine practical experience and industry characteristics analysis. \u0026 Rdquo; \u0026 ldquo; Product dimension table \u0026 rdquo; the commodity form the basis of structural optimization, especially for diverse category, SKU rich retail formats, can be used online and offline. Offline retail increased use ABC analysis, general analysis category only, not analysis category dimension. There are more mass merchandise format online than offline, more comprehensive data base (Dimension Data), smarter analytical tools, so overall, commodity dimension tables have a greater role to online formats. (Edit / world network operators Ma Xiaodan, This article first appeared in the i world network operators, please indicate the source and author)[Actual] retail O2O How to optimize commodity structure[i world network operators Note] \u0026 ldquo; Product dimension table \u0026 rdquo; the commodity form the basis of structural optimization, especially for diverse category, SKU rich retail formats, can be used online and offline. Offline retail increased use ABC analysis, general analysis category only, not analysis category dimension. There are more mass merchandise format online than offline, more comprehensive data base (Dimension Data), smarter analytical tools, so overall, commodity dimension tables have a greater role to online formats. Wen / Zhang Chenyong this paper, a story of how to optimize commodity structure, the core tool is a commodity dimension table. Ding find out the commodity structure they get an investment, to create a regional integrated B2C. The B2C main supermarket goods, but in the end what you want to operate category, the category under which goods required, the proportion of each category of goods, how to track commodity investment situation, Ding no idea, ask me how to do. \u0026 Ldquo; You need to do a commodity dimension table. \u0026 Rdquo; I said. It is a commodity classification fractal dimension of the table, such as nuts, peanuts belong to this category, peanut taste, shape multiple dimensions, specifications, and prices. It can help us to track commodity investment situation, optimizing product mix, and even increase revenue. So how do you build \u0026 ldquo; \u0026 rdquo ;? commodity dimension table The first step is to list the product categories will operate, as well as an important dimension of each of the categories under (see below table). When preparing this form, you can refer to the classification and major site navigation field. The second step is to fill the investment to the commodity commodity dimension table (see table below). The third step, when we fill enough merchandise, you can use the \u0026 ldquo; PivotTable \u0026 rdquo; function or sql statement to extract statements, understand the products introduced into the situation (see table below). \u0026 Ldquo; I understand. \u0026 Rdquo; Ding said, \u0026 ldquo; through these forms, I can know how many goods under each category, how many of each category of goods each dimension. If too many goods under a category and dimension, the introduction of new restrictions; if too small, they should focus on the introduction. \u0026 Rdquo; \u0026 ldquo; yes. \u0026 Rdquo; I answered, \u0026 ldquo; we can also control the total number of this table SKU, based on the total number of SKU stock funds allocated under each category, SKU range of indicators set for each category. Each dimension sketch class represents a demand of individual commodities have more than one dimension, the introduction of a number of multi-dimensional commodity, you can use fewer SKU, meet more diverse needs, so that we can without affecting the user experience By reducing the capital stock. \u0026 Rdquo; Ding said: \u0026 ldquo; this form is very good, but also a great amount of work invested so much labor time is worth? \u0026 Rdquo; I said: \u0026 ldquo; Product dimension table, there are other useful, it is accompanied by the entire project management process, optimizing product mix, improving the earnings have far-reaching effects, that time you will know. \u0026 Rdquo; the dimension table after months of digging efficiency, the normal operation of the line on the site, Ding found that, on the one hand the customer to reflect commodity rich enough, could not find the necessary goods, on the other hand a lot of commodities decline in sales, a lot of money tied up in inventory , so to ask me whether commodity dimension table can solve this problem. \u0026 Ldquo; of course, you need to join SKU accounting and sales accounting fields (see below table) in the report. \u0026 Rdquo; \u0026 ldquo; In Table 4, accounting for 0.13 percent of peanut SKU, sales accounted for 0.21%, the proportion of sales accounted for more than SKU. If similar products (such as seeds) of SKU and sales accounting for the difference is not so great, then consumers peanuts, peanut category too little, should be increased. \u0026 Rdquo; \u0026 ldquo; from the commodity dimension point of view, 0 \u0026 mdash; 100g specifications of peanut SKU accounted for 80%, but sales accounted for only 46 percent, indicating 0 \u0026 mdash; 100g specifications peanuts too much, should be reduced, a corresponding increase in other specifications peanut single product. \u0026 Rdquo; \u0026 ldquo; That's great, over time, will be more optimized product mix, reducing slow-moving inventory, increase turnover. \u0026 Rdquo; \u0026 ldquo; Not only that, commodity dimension tables can help you improve earnings. Your table below. \u0026 Rdquo; Ding said: \u0026 ldquo; this table and on a table almost ah, but the proportion of sales accounted for into a contribution. \u0026 Rdquo; I replied: \u0026 ldquo; yes, it is an object on the table, is to optimize the product mix, in order to meet consumer demand, it is more from sales of goods dimension. The purpose of this table is to enhance revenue, so the contribution from consideration. \u0026 Rdquo; \u0026 ldquo; What contribution is accounted for, how calculated? \u0026 Rdquo; \u0026 ldquo; contribution accounted = (certain time margin - fixed costs) / overall margins. \u0026 Rdquo; I wrote it down on paper, \u0026 ldquo; different merchandise gross margin, turnover is different. B2C fixed costs (the cost of packaging and distribution) than offline stores. Because the main cost of the line store (rent, labor, utilities) with increased sales share decreased, while B2C even increase sales, reduce fixed cost very little space. Contribution considered above. \u0026 Rdquo; Ding said: \u0026 ldquo; see, according to the proportion of the contribution rate and SKU accounted for data analysis, increased commodity high contribution rates, reduce the low contribution rate products, so overall revenue will increase. \u0026 Rdquo; answer: \u0026 ldquo; Yes, but when analyzing the data, but also consider other circumstances, such as certain sensitive products, although low gross margin, the contribution rate is not high, but if you do not run, the user will be lost, and therefore can not be sale of. \u0026 Rdquo; \u0026 ldquo; In general, A-sensitive goods (attracting products) and merchandise dimensional structure is Air Jordan 1 indispensable. Audience dimensional structure of small commodities, but if lacking, some users will think commodity rich enough. After all, regardless of how to optimize the product mix, 2/8 principles always effective, and not all sales of goods can be less streamlined. \u0026 Rdquo; I continued: \u0026 ldquo; need to consider seasonal factors. Sudden decline in the contribution of some commodities, the problem may just be the season, it does not mean that this product is always unpopular. Product dimension table provides the data foundation for us to combine practical experience and industry characteristics analysis. \u0026 Rdquo; \u0026 ldquo; Product dimension table \u0026 rdquo; the commodity form the basis of structural optimization, especially for diverse category, SKU rich retail formats, can be used online and offline. Offline retail increased use ABC analysis, general analysis category only, not analysis category dimension. There are more mass merchandise format online than offline, more comprehensive data base (Dimension Data), smarter analytical tools, so overall, commodity dimension tables have a greater role to online formats. (Edit / world network operators Ma Xiaodan, This article first appeared in the i world network operators, please indicate the 2015 Latest Nike Shoes source and author)