### HANDLING NULLS
NA = None
CA = 'CAN'

### COMMERCEHUB
commercehub_dict = {'A': None,
 'B': 'BR', 						# Bill To Address
 'C': None,
 'D': None,
 'E': 'BU',							# Bill to City
 'F': 'L',							# Bill to Company Name
 'G': None,							# Bill to Country
 'H': None,							# Bill to County
 'I': NA,							
 'J': 'BZ',							# Bill to Day Phone
 'K': 'CA',							# Bill to Email
 'L': 'CD',							# Bill to Name
 'M': None,
 'N': None,
 'O': None,
 'P': 'CF',							# Bill to Postal Code
 'Q':None,
 'R': 'CH',							# Bill to State
 'S':None,
 'T':None,
 'U':None,
 'V': None,							
 'W':None,
 'X':None,
 'Y': None,							
 'Z': None,
 'AA': None,
 'AB': 'E',
 'AC': NA,
 'AD': NA,
 'AE': 'L',
 'AF': None,
 'AG': None,
 'AH': None,
 'AI': 'AI',						# Customer Order Number
 'AJ': None,
 'AK': None,
 'AL': None,
 'AM': 'AM',						# Description
 'AN': 'AN',						# Description 2 (French?)
 'AO': None,
 'AP': None,
 'AQ': None,
 'AR': 'AR',						# Insert Date
 'AS': 'AS',						# Insert Date/Time
 'AT': 'AT',						# Line Count 
 'AU': None,
 'AV': None,
 'AW': None,
 'AX': None,
 'AY': None,
 'AZ': None,
 'BA': None,
 'BB': None,
 'BC': None,
 'BD': 'BD',						# Merchant
 'BE': None,
 'BF': None,
 'BG': None,
 'BH': 'BH',						# Order Date
 'BI': 'AI',
 'BJ': None,
 'BK': 'BK',						# PO Number
 'BL': None,
 'BM': 'BM',						# Quantity
 'BN': None,
 'BO': None,
 'BP': None,
 'BQ': 'Canada Post - Expedited Parcel',	# Shipping Method
 'BR': 'BR',						# Ship to Address
 'BS': 'BS',						# Ship to Address 2
 'BT': 'BT',						# Ship to Address 3
 'BU': 'BU',						# Ship to City
 'BV': None,
 'BW': CA,
 'BX': None,
 'BY': 'US',						# Ship to Customer Number
 'BZ': 'BZ',						# Ship to Day Phone
 'CA': 'CA',						# Ship to Email
 'CB': 'CB',						# Ship to First Name
 'CC': 'CC',						# Ship to Last Name
 'CD': 'CD',						# Ship to Full Name
 'CE': None,
 'CF': 'CF',						# Ship to Postal Code
 'CG': None,
 'CH': 'CH',						# Ship to Province
 'CI': None,
 'CJ': None,
 'CK': None,
 'CL': None,
 'CM': None,
 'CN': 'CN',
 'CO': None,
 'CP': None,
 'CQ': 'CQ',						# UPC
 'CR': 'CR',						# Vendor SKU
 'CS': None}

commercehub2_dict = {'A': None,
 'B': 'BR', 						# Bill To Address
 'C': None,
 'D': None,
 'E': 'BU',							# Bill to City
 'F': 'L',							# Bill to Company Name
 'G': None,							# Bill to Country
 'H': None,							# Bill to County
 'I': NA,							
 'J': 'BZ',							# Bill to Day Phone
 'K': 'CA',							# Bill to Email
 'L': 'CD',							# Bill to Name
 'M': None,
 'N': None,
 'O': None,
 'P': 'CF',							# Bill to Postal Code
 'Q':None,
 'R': 'CH',							# Bill to State
 'S':None,
 'T':None,
 'U':None,
 'V': None,							
 'W':None,
 'X':None,
 'Y': None,							
 'Z': None,
 'AA': None,
 'AB': 'E',
 'AC': NA,
 'AD': NA,
 'AE': 'L',
 'AF': None,
 'AG': None,
 'AH': None,
 'AI': 'AI',						# Customer Order Number
 'AJ': None,
 'AK': None,
 'AL': None,
 'AM': 'AM',						# Description
 'AN': 'AN',						# Description 2 (French?)
 'AO': None,
 'AP': None,
 'AQ': None,
 'AR': 'AR',						# Insert Date
 'AS': 'AS',						# Insert Date/Time
 'AT': 'AT',						# Line Count 
 'AU': None,
 'AV': None,
 'AW': None,
 'AX': None,
 'AY': None,
 'AZ': None,
 'BA': None,
 'BB': None,
 'BC': None,
 'BD': 'BD',						# Merchant
 'BE': None,
 'BF': None,
 'BG': None,
 'BH': 'BH',						# Order Date
 'BI': 'AI',
 'BJ': None,
 'BK': 'BK',						# PO Number
 'BL': None,
 'BM': 'BM',						# Quantity
 'BN': None,
 'BO': None,
 'BP': None,
 'BQ': 'BQ',						# Shipping Method
 'BR': 'BR',						# Ship to Address
 'BS': 'BS',						# Ship to Address 2
 'BT': 'BT',						# Ship to Address 3
 'BU': 'BU',						# Ship to City
 'BV': None,
 'BW': CA,
 'BX': None,
 'BY': 'US',						# Ship to Customer Number
 'BZ': 'BZ',						# Ship to Day Phone
 'CA': 'CA',						# Ship to Email
 'CB': 'CB',						# Ship to First Name
 'CC': 'CC',						# Ship to Last Name
 'CD': 'CD',						# Ship to Full Name
 'CE': None,
 'CF': 'CF',						# Ship to Postal Code
 'CG': None,
 'CH': 'CH',						# Ship to Province
 'CI': None,
 'CJ': None,
 'CK': None,
 'CL': None,
 'CM': None,
 'CN': 'CN',
 'CO': None,
 'CP': None,
 'CQ': 'CQ',						# UPC
 'CR': 'CR',						# Vendor SKU
 'CS': None}

 ### GROUPON
groupon_dict = {'A': None,
 'B': 'I',
 'C': None,
 'D': None,
 'E': 'K',
 'F': 'H',
 'G': 'CA',
 'H': 'CA',
 'I': NA,
 'J': NA,
 'K': NA,
 'L': 'H',
 'M': None,
 'N': None,
 'O': None,
 'P': 'N',
 'Q':None,
 'R': 'L',
 'S':None,
 'T':None,
 'U':None,
 'V': 'I',
 'W':None,
 'X':None,
 'Y': 'K',
 'Z': 'H',
 'AA': 'CA',
 'AB': 'K',
 'AC': NA,
 'AD': NA,
 'AE': 'H',
 'AF': None,
 'AG': None,
 'AH': NA,
 'AI': 'A',
 'AJ': 'N',
 'AK': None,
 'AL': 'L',
 'AM': 'W',
 'AN': None,
 'AO': None,
 'AP': None,
 'AQ': None,
 'AR': None,
 'AS': None,
 'AT': None,
 'AU': None,
 'AV': None,
 'AW': None,
 'AX': None,
 'AY': None,
 'AZ': None,
 'BA': None,
 'BB': None,
 'BC': None,
 'BD': 'Groupon',
 'BE': None,
 'BF': None,
 'BG': None,
 'BH': 'NEED DATE',
 'BI': 'A',
 'BJ': None,
 'BK': 'A',
 'BL': None,
 'BM': 'R',
 'BN': 'NEED DATE',
 'BO': None,
 'BP': None,
 'BQ': 'Canada Post - Expedited Parcel',
 'BR': 'I',
 'BS': None,
 'BT': None,
 'BU': 'K',
 'BV': None,
 'BW': CA,
 'BX': 'L',
 'BY': 'US',
 'BZ': NA,
 'CA': NA,
 'CB': 'H',
 'CC': 'H',
 'CD': 'H',
 'CE': NA,
 'CF': 'N',
 'CG': None,
 'CH': 'L',
 'CI': None,
 'CJ': None,
 'CK': None,
 'CL': None,
 'CM': None,
 'CN': None,
 'CO': None,
 'CP': None,
 'CQ': 'IGNORE ME',
 'CR': 'IGNORE ME',
 'CS': None}

 ### STAPLES
staples_dict = {'A': None,
 'B': 'AE', # Address Line 1
 'C': 'AF', # Address Line 2
 'D': None,
 'E': 'AH',
 'F': 'AD',
 'G': CA,
 'H': CA,
 'I': NA,
 'J': NA,
 'K': NA,
 'L': 'AD', # customer name
 'M': None,
 'N': None,
 'O': None,
 'P': 'AK', # postal code
 'Q':None,
 'R': 'AI', # province
 'S':None,
 'T':None,
 'U':None,
 'V': 'AE',
 'W':None,
 'X':None,
 'Y': 'AH',
 'Z': 'AD',
 'AA': CA,
 'AB': 'AH',
 'AC': NA,
 'AD': NA,
 'AE': 'AD',
 'AF': None,
 'AG': None,
 'AH': NA,
 'AI': 'E', # order number / PO number
 'AJ': 'AK',
 'AK': None,
 'AL': 'AI',
 'AM': 'Q',
 'AN': None,
 'AO': None,
 'AP': None,
 'AQ': None,
 'AR': None,
 'AS': None,
 'AT': None,
 'AU': None,
 'AV': None,
 'AW': None,
 'AX': None,
 'AY': None,
 'AZ': None,
 'BA': None,
 'BB': None,
 'BC': None,
 'BD': 'Staples',
 'BE': None,
 'BF': None,
 'BG': None,
 'BH': 'NEED DATE',
 'BI': 'E',
 'BJ': None,
 'BK': 'E',
 'BL': None,
 'BM': 'R', # Quantity
 'BN': 'NEED DATE',
 'BO': None,
 'BP': None,
 'BQ': 'Canada Post - Expedited Parcel',
 'BR': 'AE',
 'BS': 'AF',
 'BT': None,
 'BU': 'AH',
 'BV': None,
 'BW': CA,
 'BX': 'AI',
 'BY': 'US',
 'BZ': 'AM',
 'CA': 'AL',
 'CB': 'AD',
 'CC': 'AD',
 'CD': 'AD',
 'CE': NA,
 'CF': 'AK',
 'CG': None,
 'CH': 'AI',
 'CI': None,
 'CJ': None,
 'CK': None,
 'CL': None,
 'CM': None,
 'CN': 'U',
 'CO': None,
 'CP': None,
 'CQ': 'IGNORE ME',
 'CR': 'N',
 'CS': None}