iDevAffiliate - Affiliate Tracking Software - Affiliate Program Software

Table Structure for Importing Affiliates

Column Name	Data Type	Description
id	Numbers Only, No Spaces	N/A
username	Numbers and Letters Only, No Spaces	N/A
password	Numbers and Letters Only, No Spaces	N/A
approved	Numbers Only	1 = approved, 0 = not approved
suspended	Numbers Only	1 = suspended, 0 = not suspended
payable	Letters	Name to make checks payable to.
tax_id_ssn	Numbers/Dashes	Tax ID/SSN/VAT
company	Letters and Numbers	N/A
f_name	Letters	N/A
l_name	Letters	N/A
email	Email Address	N/A
address_1	Letters and Numbers	Address Line 1
address_2	Letters and Numbers	Address Line 2
city	Letters Only	N/A
state	Letters Only	N/A
zip	Letters and Numbers	N/A
country	2 Letters - Abbr. Country: US, CA, DE, etc.	N/A
phone	Numbers/Dashes	N/A
fax	Numbers/Dashes	N/A
url	Website URL including http://www.	Affiliate's website URL.
pp	Numbers Only	1 = Pay via PayPal, 0 = Do not pay via PayPal
paypal	Email Address	PayPal account address.
type	Payout Type - Numbers Only	1 = Percentage, 2 = Flat Rate , 3 = PPC
level	Numbers Only	Leave set to 1
a1	Numbers Only	Leave set to 1
a2	Numbers Only	Leave set to 1
a3	Numbers Only	Leave set to 1