|
The First Import |
Top Previous Next |
|
Once the TradeMe accounts are set up, the server is configured and running Tradar, will import sales data for the last 45 days into TradeMe.
Periodically Tradar will access the TradeMe site via HTTP and download the data available in the sold.csv file. Data can be downloaded for different periods but tRadar will download all available data, including auctions that have been deleted for the last 45 days. This will ensure the database is as complete as possible - particularly in the tracking of refunds which can be completed some time after the auction has finished.
After the sold.csv data has been downloaded from the TradeMe site and stored in memory for processing, the data will first of all be converted and written into a table in Tradar. This table is intended to act as a staging area between on-line data sources and the SALES table which holds all Sales Transaction data.
As each record from the CSV input file is read, Tradar is checked to see if the Sales record already exists.
The key to identifying a unique sales transaction is the Auction Reference and Sales Type (such as buy now, auction and offer). A composite key is required because sales data downloaded from TradeMe can and does have the same Auction reference, for instance if an additional item is sold by a Fixed Price Offer (FPO) to the underbidder on an auction.
In this case two transactions would appear in Tradar, both with the same auction reference number. The first transaction would have a transaction type of “Auction”, the second of “Offer”.
On the first import, no records will exist in Tradar so a new record for each sale will be created. The next step is to mark the sales that have been imported but already concluded as completed.
Marking Closed Sales as Completed How Tradar creates a New Sales Record How Tradar updates existing Sales & Customer Records Admin: Add/Maintain Server Jobs
|