We have a list of Dealers with Canadian Postal Codes.
We generate a list of monthly sales from our e-commerce website, that tracks the Canadian Postal Code of the buyer.
We want a script that will match the nearest Dealer to each purchase made online, and use a % calculation of the total sale to be allocated to that dealer.
Example:
Import list
Joe Smith, 123 Any Street, Calgary, Alberta,T4R3E2,$1875.00
Export list
Joe Smith, 123 Any Street, Calgary, Alberta,T4R3E2,$1875.00,Dealer #27,T4R4R5,$93.75
This script will run as a desktop app, and all information will be saved to a Database