一切从Trade开始(转)

taobao.trades.sold.get 取得交易列表

从店铺取得时间

taobao.shop.get (nick,field)
shop.created

循环读取从开店时间到当前时间的所有交易

taobao.trades.sold.get(start_created,end_created,field)
每次获取时间不能超过三个月，最大分页记录数100条。

获取单笔交易的详细信息
```
taobao.trade.fullinfo.get (tid,field) 可以更新到用户信息表
```
1. 只有在交易成功的状态下才能取到交易佣金，其它状态下取到的都是零或空值
2. 只有单笔订单的情况下Trade数据结构中才包含商品相关的信息
3. 获取到的Order中的payment字段在单笔子订单时包含物流费用，多笔子订单时不包含物流费用
通过交易列表取得buyer_nick 别名构建用户数据库
```
SELECT DISTINCT buyer_nick FROM [USER]
```

数据结构

CREATE TABLE [Trade] (

	[AdjustFee] VARCHAR(50) NULL,

	[AlipayNo] VARCHAR(50) NULL,

	[AvailableConfirmFee] VARCHAR(50) NULL,

	[BuyerAlipayNo] VARCHAR(50) NULL,

	[BuyerEmail] VARCHAR(50) NULL,

	[BuyerFlag] NUMERIC NULL,

	[BuyerMemo] VARCHAR(50) NULL,

	[BuyerMessage] VARCHAR(50) NULL,

	[BuyerNick] VARCHAR(50) NULL,

	[BuyerObtainPointFee] NUMERIC NULL,

	[BuyerRate] BOOLEAN NULL,

	[CodFee] VARCHAR(50) NULL,

	[CodStatus] VARCHAR(50) NULL,

	[CommissionFee] VARCHAR(50) NULL,

	[ConsignTime] VARCHAR(50) NULL,

	[Created] VARCHAR(50) NULL,

	[DiscountFee] VARCHAR(50) NULL,

	[EndTime] VARCHAR(50) NULL,

	[HasPostFee] BOOLEAN NULL,

	[Iid] VARCHAR(50) NULL,

	[InvoiceName] VARCHAR(50) NULL,

	[Is3D] BOOLEAN NULL,

	[Modified] VARCHAR(50) NULL,

	[Num] NUMERIC NULL,

	[NumIid] NUMERIC NULL,

	[PayTime] VARCHAR(50) NULL,

	[Payment] VARCHAR(50) NULL,

	[PicPath] VARCHAR(50) NULL,

	[PointFee] NUMERIC NULL,

	[PostFee] VARCHAR(50) NULL,

	[Price] VARCHAR(50) NULL,

	[Promotion] VARCHAR(50) NULL,

	[RealPointFee] NUMERIC NULL,

	[ReceivedPayment] VARCHAR(50) NULL,

	[ReceiverAddress] VARCHAR(50) NULL,

	[ReceiverCity] VARCHAR(50) NULL,

	[ReceiverDistrict] VARCHAR(50) NULL,

	[ReceiverMobile] VARCHAR(50) NULL,

	[ReceiverName] VARCHAR(50) NULL,

	[ReceiverPhone] VARCHAR(50) NULL,

	[ReceiverState] VARCHAR(50) NULL,

	[ReceiverZip] VARCHAR(50) NULL,

	[SellerAlipayNo] VARCHAR(50) NULL,

	[SellerEmail] VARCHAR(50) NULL,

	[SellerFlag] NUMERIC NULL,

	[SellerMemo] VARCHAR(50) NULL,

	[SellerMobile] VARCHAR(50) NULL,

	[SellerName] VARCHAR(50) NULL,

	[SellerNick] VARCHAR(50) NULL,

	[SellerPhone] VARCHAR(50) NULL,

	[SellerRate] BOOLEAN NULL,

	[ShippingType] VARCHAR(50) NULL,

	[Sid] VARCHAR(50) NULL,

	[Snapshot] VARCHAR(50) NULL,

	[SnapshotUrl] VARCHAR(50) NULL,

	[Status] VARCHAR(50) NULL,

	[Tid] NUMERIC NULL,

	[TimeoutActionTime] VARCHAR(50) NULL,

	[Title] VARCHAR(50) NULL,

	[TotalFee] VARCHAR(50) NULL,

	[TradeMemo] VARCHAR(50) NULL,

	[Type] VARCHAR(50) NULL

)