Screen: ShopSite > Utilities > Database > Download
Download Associates File Format
Each line in the downloaded file reflects a sale from an associate referral (except for the first line), and the fields in each line are separated by tabs. The first line indicates the name and sequence of each field found in the remaining records. Here are the definitions of each field:
- RefName
- The name of the Associate, as defined on the Associates screen. You can sort the information by this field to separate the orders referred by each associate.
- OrderNum
- The ShopSite order number for the transaction.
- ShpName
- The "Ship To" name from the order.
- ShpEmail
- The "Ship To" e-mail address from the order.
- ProductTotal
- The total value of the products ordered. This does not include any discounts or coupons.
- GrandTotal
- The total value of the order, including coupons, discounts, tax, and shipping.
- Date
- The date and time of the order.
- PayType
- Number code for the payment type used. Only on the Thank You screen. The number codes correlate to the following payment types:
- 0 - Visa
- 1 - MasterCard
- 2 - Discover
- 3 - American Express
- 4 - Purchase Order
- 5 - Cash On delivery
- 6 - Check
- 7 - PayPal (standard)
- 8 - Generic Payment Option 1
- 9 - Generic Payment Option 2
- 10 - Diner's Club
- 11 - Fire Pay
- 12 - eCheck
- 13 - WorldPay
- 14 - PayPal Express
- 15 - Google Wallet
- 16 - NetBanx
- 17 - Solo
- 18 - Switch
- 19 - Delta
- 20 - Visa Electron/UK
- 21 - JCB
- 22 - Maestro
- 99 - No payment required
- Sub-total
- The product subtotal after applying any coupons or discounts. This value does not include tax, shipping, and surcharges.
- Commission
- The commission amount owed to the Associate. This value is calculated from the Sub-total and the Commission setting for the Associate.
