Entity related Sales

Entity_sales_doc.txt

Regards the building of collections of documents for entity reporting.

  Prerequisites:
    Import of entities
    Import of products
    Import of users

  Actions:
    Import of historic sales
    Import of joining/leaving mailinglists

  An Entity Sale Doc:
    Measures:
      Price paid
      Price list
      Currency
      Discount (%)
      Price paid GBP
      Price list GBP

    Dimensions:
      EntityId
      ProductId
      UserId
      Coordinates [lat, lng]
      Date
      Year
      Month
      Country
      City
      Postcode
      WorldRegion

Import Entity Sale Command

  product_id:      <- SaleProduct.ProductID
  entity_id:       <- Derived 
  user_identifier: <- Buyer.UserID || ContactDetails.Email
  ip_address:      <- Payment.IPAddress
  date:            <- Payment.DateCreated (rfc2822 format e.g. 21 Feb 2011 18:53:36 +0400)
  country:         <- ContactDetails.CountryIso
  city:            <- ContactDetails.City
  postal_code:     <- ContactDetails.PostalCode
  price_paid:      <- SaleProduct.Price
  base_price:      <- SaleProduct.BaseProductPrice
  rate_to_gbp:     <- SaleProduct.AccountToGBPExchangeRate
  currency:        <- SaleProduct.CurrencyIso
  sale_id:         <- Sale.Key