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

1. 从店铺取得时间 
   

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

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

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

3. 获取单笔交易的详细信息
   

   taobao.trade.fullinfo.get (tid,field) 可以更新到用户信息表

   1. 只有在交易成功的状态下才能取到交易佣金，其它状态下取到的都是零或空值
   2. 只有单笔订单的情况下Trade数据结构中才包含商品相关的信息
   3. 获取到的Order中的payment字段在单笔子订单时包含物流费用，多笔子订单时不包含物流费用
4. 通过交易列表取得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)

一切从Trade开始(转)