CheckoutChamp
Submit TicketStatus
  • CheckoutChamp
  • Funnel Builder
    • Onboarding & Activation
      • Go Live Checklist
    • Dashboard Overview (APP)
    • Creating & Editing Funnels/Pages
      • Funnel Visualizer and Page Builder
        • Funnel Visualizer
          • Page Types
          • Connecting Funnel Pages
            • Route An Arrow For New And Repeat Customers
          • Edit Funnel Settings
            • Tracking Pixels
            • Offers and Upsells
            • Collections
            • Coupons
            • Configure Google Analytics
            • Gateways
            • Affiliates
              • Everflow
            • Sales Tax Profiles
            • Add Ons
              • PAAY Add On
              • Route Add On
              • ShipEngine Add On
              • Google Places
              • Fraud Manager Add On
              • Facebook Messenger
              • reCAPTCHA Enterprise
            • SMTP Accounts
            • Fulfillment Houses
            • Ship Profiles
            • Fonts
            • Payments
              • Affirm
              • Afterpay
              • Amazon Pay
              • Apple Pay
                • Legacy Apple Pay Setup (Apple Pay Plugin)
              • Multi-Pay Rebills
              • BitPay
              • Bancontact
              • BLIK
              • Boleto
              • Google Pay
              • iDEAL
              • Klarna
              • P24
              • PayPal Seamless Checkout
                • Fastlane
              • SEPA
              • Sezzle
              • TWINT
            • Social Proof
            • Maintenance
          • URL Customization
          • Page Templates
        • Page Builder
          • Builder Toolbar
            • Device View Changer
            • Popups
          • Style Manager
          • Layer Manager
            • Hiding and Revealing Elements
          • Building Blocks
            • Basic Blocks
              • Rows & Columns
            • Form Blocks
              • Shopping Cart Element
            • Button Blocks
              • Button & Link Actions
            • Product Blocks
            • Carousel / Slider Blocks
            • Icon Blocks
            • Social Media Blocks
            • Testimonial Blocks
            • Extra Blocks
            • My Element Blocks
        • 🆕Page Builder 2.0
          • 📰New Features!
          • Builder Toolbar
            • Device View Changer
            • Popups
          • Settings & Style Manager
          • Layer Manager
            • Hiding and Revealing Elements
          • Building Blocks
            • Basic Blocks
              • Rows & Columns
            • Form Blocks
              • Shopping Cart Element
            • Button Blocks
              • Button & Link Actions
            • Product Blocks
            • Extra Blocks
              • Bullet List
              • Progress Bar
              • Collapsible List / FAQ Section
              • Testimonial Blocks
              • Carousel / Slider Blocks
              • Survey
              • Timer
            • My Element Blocks
          • Page Building Tips
            • Using Shopify information on a Thank You page
            • Placeholders and Input Formats
            • Hide element if box is checked/ Billing address same as Shipping
            • How to set Anchor Links
            • How to convert a button into a link
            • Adding Age Consent
            • Creating a Split Variation
            • Subscribe & Save
            • Tokens
            • Redirect from CheckoutChamp to externally hosted upsell or Thank You page
            • Duplicate Input Indicator
            • Product Quantity Select
            • Make a button appear after a set amount of time
            • Making A New Section Appear After a Timer Expires
            • Timer - Route to next page
            • Use link or button to initiate a pop-up
            • Convert Checkbox and Radio
            • Lazy Loading
            • Element Toolbar
            • Applying custom fields to inputs
            • Shipping Profiles
            • Duplicating Pages & Funnels
            • Bootstrap Integration
            • Customer File Uploads
            • Product Tiles
            • Variant Selection
              • Product Variant Selection
              • Customized Variant Bundles (Single Variant)
              • Product Checkbox
            • Product Table
            • Hover Effects (adding Pseudo-classes)
            • Page Sizes and Image Dimensions
            • Flex Settings
            • Using the Survey Element
            • Custom Classes
            • Creating a Marketing Opt-in Checkbox
            • Common Page Elements
            • Create a Common Menu
            • Currency Selector
            • Acquire and Send Session Data to 3rd Party
            • Language Replacement Mapping
            • "Upgrade" or Replace a Product
            • Pass custom parameter on URL and store onto order
            • Product Drop Down / Select
            • Genders
            • Keep customers on Upsell Page after buying an upsell
            • Dynamic Order Bumps
            • Dynamic Upsells
            • Main Site Color
      • Adding Local HTML Files
      • Domain Configuration
        • Domain Trouble Shooting
        • DNS Troubleshooting Guide
        • Redirecting your Root (Apex) Domain
        • GDPR by Clym
      • Publishing a Funnel
      • Basic SEO
    • Redirect Storefront to CheckoutChamp
      • BigCommerce Plugin
        • BigCommerce Checkout Redirect
        • Recurring Products
      • WooCommerce Plugin
        • WooCommerce Checkout Redirect
      • Magento Plugin
      • Redirect external funnel to CheckoutChamp Checkout
      • Using Google Analytics with Redirect
    • Customer/Membership Portal
      • Customer Portal (Without Plugin)
      • Membership Portal with CustomClub Plugin
      • SSO with External Sites
    • Account Settings
      • Domain Forwarding
    • Analytics Definitions
  • CRM
    • Getting Started in your CRM!
    • CRM Dashboard
    • CRM Account Settings
      • Fraud Protection
      • CRM Subscription Page
      • Enable Automatic Cancel on Refund and Void
      • Staggered Rebills
    • Customer Section
      • Customer Service
        • Customer Service Tutorial
        • Locate a Customer Record
        • Continuity Purchase Profile
        • Refund/Void a Transaction
        • Cancel an Order
        • Cancel or Pause a Subscription
        • Restart a Subscription
        • C/S Fulfillment Actions
        • Resend emails to customers
        • Rerun a Declined New Sale
        • Merge Existing Customers
      • Order Entry
      • Fulfillment
      • Quality Assurance
    • CRM Setup
      • Product Setup
        • Product Creation
        • Product Variations
          • Variant Bundles
      • Campaign Setup
        • Creating a Campaign
        • Campaign Categories
        • Campaign Types
        • Adding a Product to a Campaign
          • Common Offer Setups
            • T-Shirt Club
        • Auto-Responder Setup
          • Autoresponder Date Formats
        • Shipping Profiles
        • Taxes
        • Campaign Coupons
        • Custom Fields
        • Adding C.O.D. to Campaigns
        • Single Transaction Orders
        • Multi-Currency
      • Call Center Setup
        • Adding and Editing Call Centers
        • Adding Call Center Agents
        • Setting Call Center Commissions
        • Batch Update Call Center Source Values
        • Cancellation Reasons, Refund Reasons, and Call Dispositions
      • Affiliate Setup
        • Adding and Editing Affiliates
        • Affiliate Tracking Link/String
        • Affiliate Pixels
          • Testing and Troubleshooting CPA Pixels
          • Testing CPC Pixels
        • Affiliate Commissions
        • Setting up an Affiliate User
        • Batch Update Affiliate Source Values
        • General External Affiliate Software/Network Setup
        • Facebook Pixel Setup (Direct API)
    • Fulfillment Section
      • Add and Editing Fulfillment House
      • Fulfillment Batch Update
      • Fulfillment Summary Report
      • Bundle Fulfillment
      • Fulfillment Statuses
      • Testing Fulfillment through Order Entry
      • Cash on Delivery setup
        • C.O.D. Order Entry Option
      • Upload Returned Orders
      • Edit Fulfillment Items
      • Fulfillment Inventory
      • Shipping Validation
    • Gateway Setup
      • Gateway List
      • Adding a Gateway
        • Testing Your Gateway Through Order Entry
      • Gateway Integrations
        • Adyen
        • Adyen V2
          • Klarna on AdyenV2
          • PayByBank on AdyenV2
          • Afterpay on AdyenV2
        • Affirm
        • Afterpay
        • Airwallex
          • Airwallex - Alternate Payments
        • Amazon Pay API Integration
        • Apple Pay
        • Authorize.net
        • Bank of America
        • BitPay
        • Braintree
        • Cardinity
        • Cardstream
          • Cardstream - Alternate Payments
        • Celerispay
        • Centrobill
        • Checkout.com
          • Checkout.com - Alternate Payments
        • Corefy
        • Easytransac
        • eMerchantPay V3
          • eMerchantPay - Alternate Payments
        • Everyware
        • Fat Zebra
        • FibonatixV2
        • FlexFactor
        • Gala Technology
          • Gala Technology - Alternate Payments
        • Google Pay API
        • HiPay 3DS
        • Innova
        • iyzico
        • Klarna
        • MARKETFLOW
        • Maverick
        • Merchant Warrior
        • MojoPay
        • Mollie
        • Moonlight Payments
        • MuchBetter
        • MyCPO
        • NMI
          • NMI - useCustomerVault Configuration
        • NomuPay
          • NomuPay - Alternate Payments
          • Klarna on NomuPay
        • OpenPath
          • IoniaPay Instant Direct Payments (OpenPath)
        • PagBrasil
        • Pathly
        • Pay.com
        • PAY.ON
        • Payex-GreenMoney
        • PayGate
        • Paynetworx
        • PayPal Commerce Checkout
          • PayPal Commerce Checkout (Direct API)
          • PayPal Commerce Checkout (Legacy)
            • PayPal Seamless Checkout - 2-Click Upsells (without Reference Transactions)
          • PayPal Commerce Checkout (SDK)
        • Paysafe V2
        • Paystrax
        • PayXpert 3DS V2
        • Pixxles
        • Poynt
        • Priority Payments
        • Quaife
        • Quantum
        • QuickPay
        • Radom
        • RocketGate
        • SafeCharge
        • Sezzle
        • Skrill
        • Solid
        • Splitit
        • Square Payments
          • Square Payments V2 (Checkout Champ builder set-up)
        • Stripe
          • Stripe - Alternate Payments
          • Klarna on Stripe
        • SurePay
        • TruCommerce
        • Trust Payments
          • Trust Payments - Alternate Payments
        • TRX
        • UrPay
        • Vantiv
        • WAAVE
        • WEBPAY
        • WhiteLabel (WL) Payments
        • WithReach
        • WorldLine (Bambora)
        • Worldline V2
          • Worldline V2 - Alternate Payments
        • Worldnet
        • Worldpay
      • Advanced Transaction Routing Interface (ATRI)
        • ATRI Algorithms
        • Cascade Profiles
        • ATRI Settings and Notifications
      • Recycle Billing
      • Standard BIN Mapping
      • PrePaid BIN Mapping
      • Decline Message Mapping
      • Dynamic Descriptors
      • RDR
      • Ethoca Refunds
      • Direct API 3DS Instructions
      • dLocal Properties
      • Zero dollar card verification
    • Reports
      • Customer Reports
        • Order Summary
        • Order Details
          • Order Statuses
        • Cancellation Report
        • Retention Report
        • Revenue Summary
        • Customer Details Report
      • Payment Reports
        • Transaction Summary Report
        • Transaction Details Report
        • Account Updater
        • Card Processing
        • Refund Details
        • Chargeback Details
        • Billing Report
        • Projected Billing
        • Sales Tax
      • Gateway Reports
        • Reserve Report
      • Sale Reports
        • Continuity Report
          • Continuity Purchase Statuses
        • Affiliate Report
      • Call Center Reports
        • Customer Service Report
      • Fulfillment Reports
        • Fulfillment Details
      • UTM Filters
      • Key Performance Indicators - KPIs
    • Admin Setup
      • Plugin Setup
      • Create a User
        • Create an Affiliate User
        • Create An API User
        • Leads Agents
      • Import
        • Import Coupons
      • Export Webhook Profiles
        • Postback Export Profiles
        • FTP Export Profile
        • Export Webhook Field Mapping Options
      • Blacklist
      • Event Logs
      • Test Cards
      • Legacy Data Import
        • CheckoutChamp PGP Encryption Procedures
        • Migrating Data From a Processor To Checkout Champ
    • Plugins
      • Accounting
        • QuickBooks Online Plugin
      • Affiliate Systems
        • Everflow Integration
        • Trackfiliates
      • Analytics and Reporting
        • Wicked Reports
      • Authentication
        • PAAY
          • Authenticating with PAAY 3DS on Landers
        • PAAY 3RI
      • Chargeback Management
        • Fraud Deflect
        • Ethoca
        • Midigator
        • Optimal Alerts
        • ChargebackHelp
      • Data Sources
        • Big Commerce
          • BigCommerce Checkout Redirect
        • Smarty
        • ClickBank
        • Facebook Marketplace
        • FFL Scope
        • FluidPay Account Updater
        • Google Shopping
        • Gorgias
        • HubSpot
        • Listrak
        • OpenBorder
        • Paperform
        • Re:amaze
        • Recharge
        • ShipEngine
        • Shopify
          • Use Shopify Products Without Shopify Redirect
          • Octane AI
        • Triple Whale
        • WooCommerce
          • Using WooCommerce Catalog with Checkout Page
        • Zapier
        • Zendesk
        • DataDojo
        • ViralSweep
      • Debt Collection
      • Email Service Providers
        • Email Service Provider Plugins
        • Email Service Provider General Set Up
        • Active Campaign Deep Integration
        • InboxFirst
        • Klaviyo
        • Constant Contact
        • SendLane
        • Infusionsoft/Keap
        • Sendgrid
        • Ontraport
        • TxtFlo
        • Postscript
        • Maropost
        • Mailchimp
        • ConvertKit
        • Attentive
      • Express Consent
        • Expressed Consent
        • Expressed Consent CRM Configuration
        • Expressed Consent Guidelines
      • FlexPay
      • Fraud Services
        • Fraud Manager
        • Kount Enterprise
        • Device Data Collector Pixel (DDC Pixel)
        • IPQS
        • NoFraud
      • Fulfillment Houses
        • General Fulfillment House Setup
        • AliExpress
        • Amware
        • CJ Dropshipping
        • DesktopShipper
        • FTP Fulfillment Option
        • Fulfillment by Amazon
        • mintsoft
        • ShipBob
        • Shiphero
        • ShipStation
        • Save Rack
        • Store Pickup
        • Pharmacy Hub
        • Promise Pharmacy
      • Identity Verification
        • 1account
        • AgeChecker.net
        • ID.me
      • IVR Systems
      • List Management Services
        • Red Crane Media
        • Sociallity
      • Membership Services
        • Circle.so Webhook Guide
        • General Membership Club Plugin Setup
        • CustomClub
        • MemberMouse
        • Kajabi Webhook Guide
      • Phone Switches
        • ViciDial
        • Ytel
        • Five9 Sales Agent Call Pop
      • Rewards
        • LoyaltyLion
        • Stamped
      • RMA Services
      • Sales Call Tracking Services
      • Shipping Services
        • InsureShip
        • Route
      • SMS
        • ClickSend (Data Shuttle)
        • Twilio SMS Setup
        • SendPlex SMS Plugin
      • SMTP Maintenance
        • SMTP Maintenance Setup
        • Sendgrid SMTP Profile
        • Maropost SMTP Profile
        • Gmail SMTP Profile
      • Tax Services
        • Avalara Tax
          • Enabling and Setting Up the Avalara AvaTax Plugin
          • Add Avalara Tax to a Campaign
          • Add Tax Code to Products
          • Add Freight Tax to Shipping
          • Avalara Tax - Order Entry
        • Interpayments
        • TaxJar
          • Add TaxJar to Campaigns
          • Add Tax Code to Products
          • Add Freight Tax Code to Shipping
          • TaxJar Address Verification- Customer Service/ Order Entry
          • TaxJar Support Page
      • Telehealth
        • Beluga EHR
      • Upsell
        • Integrated Upsell Program
    • Frequently Asked Questions (FAQS)
      • General CRM Questions
      • Order Processing Questions
      • Fulfillment Questions
      • Reporting Questions
      • Affiliate Tracking Questions
      • Developer Questions
      • Builder Questions
      • How-to articles
        • Force Bill a Purchase
        • Submit a Support Ticket
    • Click-to-Cancel
  • API Documentation
    • API Documentation
      • Recommended API Flow
      • Performing API Calls
  • Policies
    • EULA
    • Privacy Policy
    • Acceptable Use Policy
    • Billing Policy
    • GDPR
    • A-C&B
Powered by GitBook
LogoLogo

CheckoutChamp Links

  • Website Builder
  • CRM
  • Status
  • Need more help?

Refer a Friend

  • Referral Program

No account yet?

  • Schedule Sales Demo
On this page

Last updated 1 month ago

Outline

When migrating from another CRM or Gateway you will need to get in contact with the CRM/Gateway that you are running the billings through to let them know that you will be migrating your customers to a new CRM. Let them know that you will need the card numbers and/or rebill tokens to validate our rebill requests (dependent on how the gateway operates).

Once you receive the data from the gateway, you will need to adjust their file so that it contains the headers and data that the CheckoutChamp import is expecting to see. Follow the instructions below to determine which files/data you will need to prepare.

Please be aware that the merchantId, campaignId, and productId are all required values on the Transactions file, and these values are found within your CheckoutChamp CRM. The merchantId is the ID found on the gateway list, the campaignId is the ID found on the campaign list, and the productId is the ID found on the offers/upsells inside the campaign.

When you are ready with the file (or you can do this sooner), please as that is the team who will pull in the data. They are also a great resource if you have any questions about the files.

When it has been determined that the file is ready, my team will send SFTP credentials for the data to be posted into – where then we will pull it from the SFTP and into CheckoutChamp. When the data has been pulled into CheckoutChamp we will request that you look at the imported customers to ensure everything is looking as it should. We will also ask for you to (force the next rebill) so we can confirm that the transaction reaches the gateway properly. It is typically suggested to do a smaller sample file first – and then we can proceed with uploading the rest after it is confirmed that the sample upload was successful.

Once it has been confirmed that everything is looking good on the imports, and after coordinating with you to ensure the billings in the old CRM/Gateway have been stopped – the last step is for the migration team to enable those migrated customers so that they get picked up on the rebill task moving forward.


Instructions

Legacy Data must be imported into CheckoutChamp via .csv formatted import files.

CheckoutChamp staff will provide support and guidance on creating the file, however, CheckoutChamp staff will not be responsible for manipulating data or modifying files. The accuracy of the data provided in the import files is 100% the responsibility of the CheckoutChamp client. Any request to modify data that was imported as defined in the import files , may result in a billable fee.

It is absolutely critical that the file format provided matches in terms of:

  • Data Type - The data type must match to the specifications defined below. If data format does not meet the specifications, the import will fail.

  • Required - Required fields must be provided in the file. If they are not provided, the import will fail.

Some Common data things to look for:

1. .csv file format is required 2. dateCreated field needs to be format: (YYYY-MM-DD HH:MM:SS) 3. isActiveRecurring column needs to be defined if providing an active account and specifying the next bill date 4. responseType can only be one of these two options: SUCCESS or DECLINE (Exact case and exact spelling) 5. responseText can only be one of these two options: SUCCESS or DECLINE (Exact case and exact spelling) 6. billShipSame column needs to be defined.

Below are the formats for the 3 possible files involved in the process:

  • Transactions*

  • Customer Notes

  • Additional Customer Details

*Required

Depending on the information you intend to retain, you may choose to import customer notes and additional customer details.

- Transactions - The transactions file is the most important file. This holds information on all the individual transactions that have been issued against customer cards. It also contains data related to recurring continuity and upcoming billing dates as well was tracking numbers related to order shipments.

Field Definitions:

*NOTE: The final file should be a .csv file. We highly recommend quoting all cells to avoid formatting issues with strings that contain commas or quotation marks. Pay extra attention to the Card Number field as spreadsheet files have a bad habit of truncating card numbers to 15 significant digits.

- Customer Notes - The Customer Notes file contains exactly that -- notes on customer service actions that affect customer orders.

Field Definitions:

- Additional Customer Details - So you store as much information about every customer as possible? We do too! This file is for all the additional information you collect on customers, such as custom fields, club memberships and website username / passwords.

Field Definitions:

Providing the files to CheckoutChamp :

  • Since these files contain credit card numbers and bank account numbers, they cannot be transferred over email. Your CheckoutChamp Legacy Import Specialist will provide you with a secure sftp account to which to can post the files. Once your files are transferred to the CheckoutChamp SFTP site, the CheckoutChamp team will work with you to import your data.

PGP Key found

Col

Name

Type

Required

Description

A

customerId

varchar(20)

Y

Your internal customer id for this customer

B

orderId

varchar(20)

Y

Your internal order id for the order associated with this transaction

C

dateCreated

datetime (YYYY-MM-DD HH:MM:SS)

Y

The timestamp of the transaction

D

campaignId

integer

Y

The CheckoutChamp campaignId that indicates which campaign to import this order into.

E

productId

integer

Y

The CheckoutChamp campaign productId that indicates which product within the campaign, the transaction was for. (Found on the campaign page)

F

isActiveRecurring

bit 0=false 1=true

Y

Whether this transaction was made on a currently active continuity product

G

nextBillDate

date (YYYY-MM-DD)

Y - IF isActiveRecurring=1

The next scheduled billing date for the active continuity product

H

paySource

ENUM (CREDITCARD, CHECK, or PREPAID)

Y

How the customer paid for the product

I

cardNumber

integer (max 19)

Y - IF paySource=CREDITCARD

Full credit card number used for payment

J

cardExpiryMonth

integer (MM)

Y - IF paySource=CREDITCARD

Month in which the card expires (must include leading zeros)

K

cardExpiryYear

integer (YYYY)

Y - IF paySource=CREDITCARD

Year in which the card expires (must be 4 digits)

L

achRoutingNumber

integer

Y - IF paySource=CHECK

Routing number of the customer's bank

M

achAccountNumber

integer

Y - IF paySource=CHECK

Account number of the customer's bank account

N

achAccountType

ENUM (SAVINGS or CHECKING)

Y - IF paySource=CHECK

Bank Account Type

O

merchantId

integer

Y

CheckoutChamp Id for the merchant account the transaction was billed against

P

merchantTxnId

varchar(30)

Y

transactionId returned by the merchant processor

Q

txnType

ENUM (SALE, AUTHORIZE, CAPTURE, REFUND)

Y

The type of transaction

R

subTotal

decimal

Y

product price before shipping and taxes applied

S

shipTotal

decimal

Y

shipping charged for the order

T

salesTax

decimal

Y

sales tax charged for the order

U

totalAmount

decimal

Y

Sum of salesTax / subTotal / shipTotal (Must add up correctly)

V

responseType

ENUM (SUCCESS or DECLINE)

Y

Result of the transaction, was it successful?

W

responseText

ENUM (SUCCESS or DECLINE)

Y

Any additional response information returned by the processor

X

authCode

varchar(20)

N

Authorization Code returned by the processor

Y

parentTxnId

varchar(30)

Y - IF txnType=REFUND or txnType=CAPTURE

The parent transaction against which a refund or capture transaction was run

Z

firstName

varchar(30)

Y

Customer's first name

AA

lastName

varchar(30)

Y

Customer's last name

AB

address1

varchar(30)

Y

Billing Address Line 1

AC

address2

varchar(30)

Y

Billing Address Line 2

AD

city

varchar(30)

Y

Billing Address City

AE

state

varchar(30)

Y - IF country=US or country=CA

Billing Address State

AF

country

char(2) -standard ISO 2 country codes

Y

Billing Address Country

AG

postalCode

varchar(20)

Y

Billing Address Postal Code

AH

phoneNumber

numeric (no dashes or parentheses)

Y - IF emailAddress is not present

Primary Phone number of customer.

AI

homePhone

numeric (no dashes or parentheses)

N

Home telephone number

AJ

cellPhone

numeric (no dashes or parentheses)

N

Cellphone number

AK

workPhone

numeric (no dashes or parentheses)

N

Work telephone number

AL

emailAddress

emailAddress (must be valid format)

Y - IF phoneNumber is not present

Customer's email address.

AM

billShipSame

bit 0=false 1=true

Y

Whether or not the shipping address is the same as the billing address

AN

shipFirstName

varchar(30)

N

Shipping First Name

AO

shipLastName

varchar(30)

N

Shipping Last Name

AP

shipAddress1

varchar(30)

Y - If billShipSame=0

Shipping Address Line 1

AQ

shipAddress2

varchar(30)

Y - If billShipSame=0

Shipping Address Line 2

AR

shipCity

varchar(30)

Y - If billShipSame=0

Shipping Address City

AS

shipState

varchar(30)

Y - If country=US or country=CA

Shipping Address State

AT

shipCountry

char(2) -standard ISO 2 country codes

Y - If billShipSame=0

Shipping Address Country

AU

shipPostalCode

varchar(20)

Y - If billShipSame=0

Shipping Address Postal Code

AV

affId

varchar(20)

N

CheckoutChamp affId

AW

subAffId

varchar(20)

N

Sub affiliate id associated with order

AX

shipDate

date (YYYY-MM-DD)

N

Date on which the order was shipped

AY

shipCarrier

varchar(20) (ex. USPS, FedEx, etc)

N

Carrier responsible for shipment

AZ

shipMethod

varchar(20)

N

Carrier's shipment method (ex. Express, 3-day Ground, etc)

BA

trackingNumber

varchar(20)

N

Order Tracking # assigned by the carrier

BB

isChargedback

Boolean('0' or '1')

N

Indicates that the specific transaction has been charged back by the card holder.

BC

chargebackTotal

Decimal (xx.xx format)

Y-if isChargedback

The amount of the chargeback.

BD

chargebackDate

Date (YYYY-MM-DD)

Y-if isChargedback

The date on which the chargeback was issued.

BE

chargebackReasonCode

varchar(10)

Y-if isChargedback

Card issuer's chargeback code.

BF

externalToken

varchar(50)

N

A token identifying the customer payment source at the 3rd party gateway. This is commonly used to run existing rebills when the full card numbers are unavailable and when gateway-supported. -note: if provided, cardNumber column may be masked with either x's or asterisks.

BG

quantity

integer

N

The quantity of the product. If not provided or not greater than 0, then it will be set to 1.

BH

variantDetailId

integer

N

The CheckoutChamp variantDetailId that indicates which variant of the product the transaction was for. (Found on the product page). The variant must exist on the CheckoutChamp product.

BI

password

varchar(30)

N

Membership password for a third-party site

BJ

companyName

varchar(50)

N

Customers company

BK

cancellationDate

date (YYYY-MM-DD)

Y - IF status of order is CANCELLED

The date the product was cancelled

Col

Name

Type

Required

Description

A

customerId

varchar(20)

Y

Your internal customer id for this customer. This must match the customerId in the transactions file

B

dateCreated

datetime (YYYY-MM-DD HH:MM:SS)

Y

the date the note was taken

C

agentName

varchar(20)

N

Name of the individual customer service agent. (Leave empty for system notes)

D

noteText

varchar(500)

Y

The note itself

Col

Name

Type

Required

Description

A

customerId

varchar(20)

Y

Your internal customer id for this customer. This must match the customerId in the transactions file

B

loginId

varchar(30)

N

loginId or username for a third-party site

C

password

varchar(30)

N

password for a third-party site

D

custom1

varchar(50)

N

standard custom field 1

E

custom2

varchar(50)

N

standard custom field 2

F

custom3

varchar(50)

N

standard custom field 3

G

custom4

varchar(50)

N

standard custom field 4

H

custom5

varchar(50)

N

standard custom field 5

  1. CRM
  2. Admin Setup

Legacy Data Import

PreviousTest CardsNextCheckoutChamp PGP Encryption Procedures
  • Outline
  • Instructions
place a request to our migration team
Force Bill a few customers
here