Gmum - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	THÔNG TIN LIÊN LẠC & THANH TOÁN													Thông tin KH: gmum Dao thi thanh tam Metropolitan 235 Dong Khoi, quan 1 tp hochiminh. Dt 0933 80 2224
2	Liên lạc:		Lý - 0972.565785					Yahoo/Skype: medat.shop
3	Số TK VCB:		0451001764575 - chủ TK Trần Thị Nhung - VCB chi nhánh Thành Công - Hà Nội.
4												SỐ DƯ:			0		TỈ GIÁ YÊN (Vnd):	255

5
6	STT	Ngày đặt hàng	THÔNG TIN VỀ SẢN PHẨM					Giá web sau off (nếu có)	Số lượng	TIỀN HÀNG			TIỀN SHIP			TỔNG TIỀN HÀNG + SHIP (Vnd)	Cập nhật thanh toán của khách
7	STT	Ngày đặt hàng	Ảnh	Link	Tên hàng	Size	Màu	Giá web sau off (nếu có)	Số lượng	Thành tiền (Yên)	Công (10% - Yên)	Tổng (Yên)	Trọng lượng (kg)	Phụ thu	Thành tiền ship (VND)	TỔNG TIỀN HÀNG + SHIP (Vnd)	Số tiền CK/ thanh toán	Ngày CK/ thanh toán
8																4,539,778	4,539,778
9	1	28/03/2013		http://www.nissen.co.jp/sho_item/sale/7181/7181_03471.asp?book=7181&cat=&bu=99&thum=sale_back_0319_01-01		M		990	1	990	99	1,089	0.30		54,000	331,695	600,000	29/3
10	2			http://www.nissen.co.jp/sho_item/sale/7179/7179_32024.asp?book=7179&cat=&bu=99&thum=sale_back_0319_02-01		L	B	1090	1	1,090	109	1,199			0	305,745	1000000	5/4/2013
11	3	5/4/2013		http://www.nissen.co.jp/sho_item/sale/7186/7186_55117.asp?book=7186&cat=&bu=99&thum=sale002_003_004_000-01		90		590	1	590	59	649	0.30	10000	54,000	229,495	350,000	18/4
12	4			http://global.rakuten.com/en/store/mutow/item/14150-01/		D75	Nude beige	980	1	980	98	1,078			35,000	309,890	187,539	12/9/2013
13	5			http://www.nissen.co.jp/sho_item/sale/9210/9210_87417.asp?book=9210&cat=&bu=1&thum=sale002_003_004_000-01		95+130	C	480	2	960	96	1,056	0.65	20000	117,000	406,280	1,590,000	17/10
14	6	6/4/2013		http://www.uniqlo.com/jp/store/goods/229916?utm_medium=email&utm_source=gu_html&utm_term=gh_130406sat&utm_content=124_m		M	63	890	1	890	89	979			45,000	294,645	750,000	29/10/2013
15	7	10/8/2013		http://www.nissen.co.jp/sho_item/sale/7175/7175_97022.asp		100	B	698	1	698	70	768	0.30	10000	54,000	259,789	62,239	15/11
16	8	17/10	Tảo bổ não						3	0	0	0			0	1,590,000
17	9	28/10		http://www.uniqlo.com/jp/store/goods/23158600001	màu 90 size 120 490y			490	1	490	15	505			40,000	168,699
18	10			http://www.uniqlo.com/jp/store/goods/23158600002	size 120 color 95 95 490y					0	0	0			0	0
19	11			http://www.uniqlo.com/jp/store/goods/231647	mau navy va trang size 130 490y			490	2	980	29	1,009			40,000	297,397
20	12			http://www.uniqlo.com/jp/store/goods/23158100002	mau 95 490y size 110			490	1	490	15	505			40,000	168,699
21	13			http://www.uniqlo.com/jp/store/goods/231581	size 110 490y			490	1	490	49	539			40,000	177,445
22	14									0	0	0			0	0
23	15									0	0	0			0	0
24	16									0	0	0			0	0
25	17									0	0	0			0	0
26	18									0	0	0			0	0
27	19									0	0	0			0	0
28	20									0	0	0			0	0
29	21									0	0	0			0	0
30	22									0	0	0			0	0
31	23									0	0	0			0	0
32	24									0	0	0			0	0
33	25									0	0	0			0	0
34	26									0	0	0			0	0
35	27									0	0	0			0	0
36	28									0	0	0			0	0
37	29									0	0	0			0	0
38	30									0	0	0			0	0
39	31									0	0	0			0	0
40	32									0	0	0			0	0
41	33									0	0	0			0	0
42	34									0	0	0			0	0
43	35									0	0	0			0	0
44	36									0	0	0			0	0
45	37									0	0	0			0	0
46	38									0	0	0			0	0
47	39									0	0	0			0	0
48	40									0	0	0			0	0
49	41									0	0	0			0	0
50	42									0	0	0			0	0
51	43									0	0	0			0	0
52	44									0	0	0			0	0
53	45									0	0	0			0	0
54	46									0	0	0			0	0
55	47									0	0	0			0	0
56	48									0	0	0			0	0
57	49									0	0	0			0	0
58	50									0	0	0			0	0
59	51									0	0	0			0	0
60	52									0	0	0			0	0
61	53									0	0	0			0	0
62	54									0	0	0			0	0
63	55									0	0	0			0	0
64	56									0	0	0			0	0
65	57									0	0	0			0	0
66	58									0	0	0			0	0
67	59									0	0	0			0	0
68	60									0	0	0			0	0
69	61									0	0	0			0	0
70	62									0	0	0			0	0
71	63									0	0	0			0	0
72	64									0	0	0			0	0
73	65									0	0	0			0	0
74	66									0	0	0			0	0
75	67									0	0	0			0	0
76	68									0	0	0			0	0
77	69									0	0	0			0	0
78	70									0	0	0			0	0
79	71									0	0	0			0	0
80	72									0	0	0			0	0
81	73									0	0	0			0	0
82	74									0	0	0			0	0
83	75									0	0	0			0	0
84	76									0	0	0			0	0
85	77									0	0	0			0	0
86	78									0	0	0			0	0
87	79									0	0	0			0	0
88	80									0	0	0			0	0
89	81									0	0	0			0	0
90	82									0	0	0			0	0
91	83									0	0	0			0	0
92	84									0	0	0			0	0
93	85									0	0	0			0	0
94	86									0	0	0			0	0
95	87									0	0	0			0	0
96	88									0	0	0			0	0
97	89									0	0	0			0	0
98	90									0	0	0			0	0
99	91									0	0	0			0	0
100	92									0	0	0			0	0