The Member Product Purchases Sync is intended for usage in programs where product-level transaction details are stored. The provided data is intended to supply an external system with members’ product-level purchase information with rank and quantity in order to make it easier for analyzing which products that members purchase the most.
This sync is a hybrid in terms of being cumulative and incremental. With each sync execution, all members associated to a transaction that has been posted since the last execution will be included in the file. For these members, their lifetime product-level transaction information will be included in the data. Upon each execution, all current member information is extracted and the completed file is then FTP’d to the predetermined location.
Note: This information is offered as a PDF for portability. Member Product Purchases Sync.pdf
|Contents||All product purchase information for all members who have had a product-level transaction since the last sync was generated.|
|Account Id||String(60)||Primary Account Id for the member|
|Product Item Rank||Numeric(20)||Product Item Quantity Rank Grouped by Member and Product Item (with ties)|
|Product Item External Reference||String(20)||The "SKU" for the product item|
|Product Item Name||String(120)|
|Qty Purchased||Numeric(20)||Quantity purchased by member|
Account Id|Product Item Rank|Product Item External Reference|Product Item Name|Qty Purchased
324443|1|0000000002|BASEBALL BAT 36/34|2