Please enable JavaScript.
Coggle requires JavaScript to display documents.
Amazon Buyer and Order Details Data Capturing Plan - Coggle Diagram
Amazon Buyer and Order Details Data Capturing Plan
Buyer Info Table
Fields
Buyer ID
Create Internal
Buyer id
Foreign Key Connector
Buyer Name
Capture from Shipping Label
Buyer Full Address
Buyer State
Buyer City
Buyer Pincode
Last Shipping Address
Total Orders
Capture from File Name
Next Time Onwards Update from Identifying Buyer(Sum of Orders for Self+Others)
Order For Self
If B.Add=Ship.Add > Order for Self+1 else Order for Other+1
Order For Others
Order Frequency
Pref Payment Mode
Total Returns
Prevalent Return Reason
Most Order Items Order
Using Buyer ID > Combine Rows from Order Table to Compute
Order Info Table
Fields
Order No//ID
From Shipping Label
Invoice No
Items Ordered
Item Quantity
Order Status
Purchase Date
Shipment Date
Today
Payment Mode
Order Amt
Refunds Table
Refund Inspection
Refund Processing
Refund reason
Manual Updates
Order Id
Refund Amount
Refund Type