Creation of a New Sales Record

If the sales record is not found in Tradar it is added as a new record and allocated a unique key.

Next, the existing customer records in Tradar are checked to see if the customer already has a record in Tradar. If they have purchased from you in the last 45 days they will have a an existing record.

If the customer does not exist	A new customer record is created and the customer data from the sold.csv downloaded from TradeMe is used to update the address book. If the customer has sent their address through TradeMe this will be included in the customer address book record.
If the customer does exist	The customers address book in Tradar is compared to what is in the sold.csv from TradeMe. If the TradeMe data differs from Tradar, then Tradar is updated with the new data from TradeMe.

Where the data in the TradeMe sales record is blank or empty (this happens when a customer has not sent their address via TradeMe at the time of the download), the existing data in the address book will not be overwritten.

Following the processing of the customer record, a new sales record will be created using data from both the Sale and Customer record. The duplication of data in the Sales table (for instance, Delivery Address) is intended to cover those situations where the delivery address alters between transactions. Additionally, should the customers details change later, the original sales record will retain the details that were correct at the time of sale.

Shipping Details

The Shipping Details part of the sales record holds the Shipping Details as entered on the original auction and selected by the customer on TradeMe at the time they placed their bid.

This provides an easy cross reference to the shipping options offered on the auction when negotiating with the customer without the need to check the auction on TradeMe.

Product Code

Product Code details may also be “looked up” in the Auctionitis Product database. Auctions loaded by Auctionitis can have a product code associated with them, and also a product type (although the relationship between the two is not currently strongly enforced).

The Product code is found in the Auctions table in the Auctionitis database. As well as updating the Product Code in the Sales record, a record should also be added to the Products table if the product code does not already exist. As more than one Auctionitis database might exist per account, the Auctionitis database pointer stored in the ACCOUNTS table should be used to retrieve the correct product code from the Auctions datable.