Taobao Assistant export CSV file special fields detailed _csv

Taobao Assistant export CSV file Some of the fields are strange, it is difficult for programmers to understand, and business operators are not familiar with the data. Now make a detailed explanation:

Sales attribute Combination Skuprops

Shorts Category:
Data sample: 29:1111:bm1:1627207:28341;20518:10122;29.1:2222:bm2:1627207:3232482;20518:10122;
Data interpretation: Price 1: Quantity 1: Code 1: Color: color code 1; Size: size code 1;
Price 2: Code 2: Color: color code 2; Size: Size code 2;
Special note: 1627207 of which fixed the color; 20518 fixed size
Please note: Each color and size need to be combined. is the "combination" in the concept of "permutation and combination" in high school mathematics.

Vest Category:
Data sample: 69:1:bm1:1627207:28341;20509:28383;69.1:2:bm2:1627207:28320;20509:28383;
Data interpretation: Price: Quantity 1: Code 1: Color: color code 1; Size: size 1;
Where 1627207 fixed the color; 20509 fixed size
Special note: Color is still the same, but the size is different
20518 Pants Size (2 feet, 2 feet 1 ...). ）
20509 indicates the size of the dress (xl,l,m,s ...). ）


Windbreaker Category
Data sample: 69:999::1627207:30156;20509:28383;
Data interpretation: Price 1: Quantity 1: Code not write empty: color; Size: size 1

Appearance in the interface:

Sales attribute alias Propalias
Data example: 1,627,207:28,341: Black And so, 1,627,207:28,320: white and so on; 20,509:28,383: Mean code dissipation
Data interpretation: Color: Original color code: new name;
Special Note: 1627207 fixed expression color, 20509 fixed size

Appearance in the interface:



Inputpids user Input ID string

User input name-value pair Inputvalues

Data sample and Interpretation: 200001632501 (brand selection Other)
Data sample and Interpretation: 1632501 (indicates that the brand remains blank, other categories are also the case)



Data Sample and Interpretation: Thank you, 6051164 (fill in the custom content, item number)
Data sample and Interpretation: 6051164 (item No.)

Appearance in the interface:



New picture
Data sample: 3f6df7df7ef2ff1f5b187d53d6c1122a:1:0:|http://img02.taobaocdn.com/bao/uploaded/i2/t1dus5xifixxafeik4_ 051934.jpg;562f67e22b942e275c4ff7e45af359be:1:1:|http://img03.taobaocdn.com/bao/uploaded/i3/373398419/ t2zusaxc0xxxxxxxxx_!! 373398419.jpg;c8f36f0c9c6cc5f7208b5cf436285759:1:2:|http://img01.taobaocdn.com/bao/uploaded/i1/373398419/ t2ck1axanxxxxxxxxx_!! 373398419.jpg;ca50b41ab51163d83224d9491735d6ea:1:3:|http://img03.taobaocdn.com/bao/uploaded/i3/373398419/ t2tjcaxafbxxxxxxxx_!! 373398419.jpg;697e9ac501ce33b8710f2783243615bf:1:4:|http://img04.taobaocdn.com/bao/uploaded/i4/373398419/ t2ctkaxnlaxxxxxxxx_!! 373398419.jpg;

Data interpretation: Image URL (first not use): Picture code: 1: Order: |

==================

Data section

Until today (September 17, 2012 20:33)

The color of Taobao (1627207) is:

107121: transparent; 28324: yellow; 132069: Brown; 28341: black; 90554: orange; 28338: blue; 28326: red; 28329: purple; 28320: white; 28335: green; 130164: color; 28332: Light gray 30156: light green; 3232480: pink; 28327: Wine red; 3232483: yellow; 80882: violet; 3232479: Dark purple; 3232478: Dark gray; 3232484: Azure; 28340: Dark blue; 60092: Light yellow 3232481: Chocolate color 3232482: deep khaki color;

The size of the trousers (1627207) is:

20518:28415:50 cm (1 ft. 5); 20518:28416:52 cm (1 ft. 56); 20518:28417:54 cm (1 feet 6); 20518:28418:56 cm (1 ft 68); 20518:28420:60 cm ( 1 ' 8); 20518:28421:62 cm (1 ft. 85); 20518:28358:68 cm (2 feet 05); 20518:28359:68 cm (2 feet 1); 20518:28360:70 cm (2 feet 15); 20518:28364:80 cm (2 feet 4)

The size of the garment (20509) is:

28381:xxs;28313:xs;28314:s;28315:m;28316:l;28317:xl;28318:xxl;28319:xxxl;28383: Mean code

Reprint please indicate the source: blog.csdn.net/xxpyeippx