customer-import
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
customer-import [2011/06/08 01:52] – [Importing subscription from PayPal Website Payments Pro] earlyimpact | customer-import [2011/12/20 19:10] (current) – matt | ||
---|---|---|---|
Line 4: | Line 4: | ||
- | - Select " | + | - Select " |
- Browse for the import file. Note, this file must be in the " | - Browse for the import file. Note, this file must be in the " | ||
- After you locate your file click " | - After you locate your file click " | ||
- | - If you receive a "success" | + | - Select the "Import Option" |
- Map the matching columns. | - Map the matching columns. | ||
- Click "Map Fields" | - Click "Map Fields" | ||
- | - Review the mappings and click "Go to Step 4" | + | - Review the mappings and click "Start Import Now" |
- Your records will be imported and the results will be posted on the screen. | - Your records will be imported and the results will be posted on the screen. | ||
+ | ===== Import Options ===== | ||
- | ===== Sample | + | ==== Import |
+ | Import existing profiles from your payment gateway. | ||
- | {{:sample_import.zip|Sample CSV File}} | + | Notes: |
+ | * The Subscription ID from the gateway is required | ||
+ | * The Customer is NOT emailed | ||
+ | * You can add your own password | ||
+ | * You can add your own account number | ||
+ | * The gateway is NOT contacted, the customer is NOT billed until their next payment date. | ||
+ | * A large number of records can be processed at once | ||
+ | ==== Import and Create ==== | ||
+ | Import a list of customers & credit cards. | ||
- | ===== Recommended Import Column Names ===== | + | Notes: |
+ | * No Subscription ID is required. It is created during the import | ||
+ | * Credit card details are required in the proper format for your gateway | ||
+ | * The Customer is emailed a receipt | ||
+ | * You can add your own password, but existing customers passwords cannot be modified | ||
+ | * You can add your own account number | ||
+ | * The gateway is contacted, the customer is billed (if not FREE Trial) | ||
+ | * The first payment date is the date of the import | ||
+ | * Small batches only. Since the gateway is contacted you cannot process large files. | ||
- | |||
- | * FirstName | ||
- | * LastName | ||
- | * Account | ||
- | * Password | ||
- | * SubscriptionID | ||
- | * LinkID | ||
- | * NextBillingDate | ||
- | * BillingFirstName | ||
- | * BillingLastName | ||
- | * BillingCompany | ||
- | * BillingAddress | ||
- | * BillingAddress2 | ||
- | * BillingCity | ||
- | * BillingRegion | ||
- | * BillingPostalCode | ||
- | * BillingCountry | ||
- | * BillingPhone | ||
- | * ShippingFirstName | ||
- | * ShippingLastName | ||
- | * ShippingCompany | ||
- | * ShippingAddress | ||
- | * ShippingAddress2 | ||
- | * ShippingCity | ||
- | * ShippingRegion | ||
- | * ShippingPostalCode | ||
- | * ShippingCountry | ||
- | * ShippingPhone | ||
- | * CardNumber | ||
- | * CardType | ||
- | * ExpMonth | ||
- | * ExpYear | ||
- | * SecureCode | ||
- | * RegularAmt | ||
- | * TrialAmt | ||
- | * RegularTax | ||
- | * TrialTax | ||
- | * RegularShipping | ||
- | * TrialShipping | ||
- | * IsShippable | ||
- | * ShipName | ||
- | * TaxName | ||
- | * AgreedToTerms | ||
- | * LanguageCode | ||
+ | ===== Sample Import File ===== | ||
- | ===== Importing subscription from PayPal Website Payments Pro ===== | + | {{: |
- | ==== History Export ==== | ||
- | You can export subscription information by leveraging the ability to export historical data from your PayPal account. | + | ===== Recommended Import Column Names ===== |
- | The key piece of information you will need for a successful import | + | ^ Column Name ^ Meaning ^ |
+ | | Email | The customer' | ||
+ | | FirstName | The customer' | ||
+ | | LastName | The customer' | ||
+ | | Account | Optional remote account number or ID | | ||
+ | | Password| Option password | ||
+ | | SubscriptionID | This is the subscription id from your gateway. This is not needed if you are creating new subscriptions. We can help you obtain the subscription ids from your gateway. Instructions for PayPal | ||
+ | | LinkID | This is the Package' | ||
+ | | NextBillingDate | This is only used for existing subscriptions. If you are creating new subscriptions, | ||
+ | | BillingFirstName | The customer' | ||
+ | | BillingLastName | The customer' | ||
+ | | BillingCompany | The customer' | ||
+ | | BillingAddress | The customer' | ||
+ | | BillingAddress2 | The customer' | ||
+ | | BillingCity | The customer' | ||
+ | | BillingRegion | The customer' | ||
+ | | BillingPostalCode | The customer' | ||
+ | | BillingCountry | The customer' | ||
+ | | BillingPhone | The customer' | ||
+ | | ShippingFirstName | The customer' | ||
+ | | ShippingLastName | The customer' | ||
+ | | ShippingCompany | The customer' | ||
+ | | ShippingAddress | The customer' | ||
+ | | ShippingAddress2 | The customer' | ||
+ | | ShippingCity | The customer' | ||
+ | | ShippingRegion | The customer' | ||
+ | | ShippingPostalCode | The customer' | ||
+ | | ShippingCountry | The customer' | ||
+ | | ShippingPhone | The customer' | ||
+ | | CardNumber | Valid credit card. Not needed for importing existing subscriptions. | | ||
+ | | CardType | Card type (e.g. Visa) | | ||
+ | | ExpMonth | 2 digit exp. month | | ||
+ | | ExpYear | 4 digit exp. year | | ||
+ | | SecureCode | 3 or 4 digit CVV2 code | | ||
+ | | RegularAmt | valid amount, no currency symbol, decimal separator | | ||
+ | | TrialAmt | valid amount, no currency symbol, decimal separator | ||
+ | | RegularTax | valid amount, no currency symbol, decimal separator | ||
+ | | TrialTax | valid amount, no currency symbol, decimal separator | ||
+ | | RegularShipping | valid amount, no currency symbol, decimal separator | ||
+ | | TrialShipping | valid amount, no currency symbol, decimal separator | ||
+ | | IsShippable | Set to true if there is shipping. Value is boolean (e.g. TRUE)| | ||
+ | | ShipName | Shipping service used. | | ||
+ | | TaxName | Tax code or description (e.g. PA sales tax) | | ||
+ | | AgreedToTerms | Set to true if customer agreed to terms. Value is boolean (e.g. TRUE) | | ||
+ | | LanguageCode | Any valid ISO code (e.g. en-US) | | ||
- | To get this piece of information included in your History export you need to click the link on the right column called "// | + | ===== Import Errors ===== |
- | At the bottom of the page "// | + | You may send us your import file for error checking prior to your import. We will check your file for errors and send it back to you. However, should your import file contains an error (e.g. invalid credit card number), then the import wizard will stop at that row. The wizard will prompt you to remove all successfully imported rows prior to the error. This will ensure you do not re-import the same rows when you fix the error. |
+ | |||
+ | ===== Importing subscription from PayPal Website Payments Pro ===== | ||
- | After you export your history as a CSV file, you will you need to modify the file so it contains one customer per line. | + | Please contact us for details. |
- | The result should look like the sample file provided above. | + | ===== Importing subscription from Authorize.net ===== |
- | ==== Subscription Profiles Export ==== | + | Please contact us for details. |
- | You can also export subscription information by exporting "// |
customer-import.txt · Last modified: 2011/12/20 19:10 by matt