一切从Trade开始(转)

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
)