This is not an allowable method for continual processing. This feature is only to be used for one-time importing of data.
This is an older method of processing cards that is generally not recommended due to the security risks. Years ago, merchants would compile an excel spreadsheet of transactions and card numbers that required processing. This is generally a bad idea as it implies that there is an unencrypted flat file located somewhere in your business. The PCI Data Security Standard prohibits merchants from storing unencrypted copies of credit card data.
This feature is present in PayJunction's system to allow merchants to move away from the unencrypted storage of credit card data by allowing them to upload it into PayJunction's secure facilities.
To important your customer data, you may follow the instructions in this article for batch processing and set the transaction amounts to $1.00. Upon completion of the file upload process, void all of the newly imported transactions. This will keep your customers info and credit card data securely in PayJunction's systems for future recharging and refund use (and allow you to discard any unencrypted copies of this data that may reside at your facility).
Essentially a $1.00 temporary charge will appear on your customer's credit cards; however, these temporary charges will be removed once they are fully voided.
Note that standard transactions fees do apply for importing data.
We recommend using Excel, or Notepad to create a CSV (Comma Separated Value) file. The file you upload must follow a specific format as described below:
|Column 1||Action - Specify if you want to "charge", "refund", or "authorize" the card.|
|Column 2||Credit Card Number - The 13 to 16 digit credit card number to charge.|
|Column 3||Expiration Date - The 4 digit expiration month and year [mmyy]|
|Column 4||Name - The customer's name (with no special characters).|
|Column 5||Invoice - The invoice number of the transaction (if applicable).|
|Column 6||Amount - The amount to charge the customer (ex. 1.00, or 53.29)|
|Column 7||Address - The billing street address associated with the credit card.|
|Column 8||Zip - The billing zip code associated with the credit card|
|Column 9||Verification - The CVV verification pin on the back of the customer's card.|
Note: Currently there is no "State" code, only address and zip.
The format for the batch processing file is as follows:
"action", "credit_card_number", "expiration", "name", "invoice", "amount", "address", "zip", "verification"
As an example, a file will contain many rows that appears as follows:
"charge", "4444333322221111", "0110", "John Smith", "", "1.00", "12 main st.", "90210", "123"If a field is blank, you must enter it as quote-quote (i.e. ""). This will maintain the correct ordering of fields and indicate that the field should be blank. Failure to do so may "misalign" your data and transactions.
If a field is blank, you must enter it as quote-quote (i.e. ""). This will maintain the correct ordering of fields and indicate that the field should be blank. Failure to do so may “misalign” your data and transactions.
To export from Excel follow these steps:
- Make sure all rows are treated as Text formatting. Click Edit > Select All, click Format > Cells..., select Text
- Review and make sure that Excel has not "truncated" or accidentally mangled part of your data. If you are sure your data looks correct, then proceed.
- Export the Excel file converting it to a CSV file. Click File > Save As..., change the format to CVS or Windows CSV.
- Log into your PayJunction account and make sure you are in the "old app". Then, under the Process menu, select Upload A File.
- Select the appropriate Terminal (most accounts will only have one, in which case the default is fine).
- Click the Choose File button and select your generated CSV file.
- Do not check Allow Duplicate (unless you are absolutely sure that you would like to be able to process the same transaction file twice).
- Click Save.
- Your transactions will be in a pending processing state (denoted by a clock icon) as our system processes your transactions.
- Upon completion a green check mark will be displayed. You can check the status of your batch upload by selecting Process from the main menu and then clicking View Upload History.
Optional Step for merchants importing customers that they do not actually want to charge:
- If the transactions are $1.00 imports that you do not intend to charge your customer, you should void the imported transactions. Click the Details link to the left of your completed upload:
- Optional Step for merchants importing customers that they do not actually want to charge (CONTINUED): Set the Page Size to 100.
- Optional Step for merchants importing customers that they do not actually want to charge (CONTINUED): Click Select: All on Page.
- Optional Step for merchants importing customers that they do not actually want to charge (CONTINUED): Click Void.
- Optional Step for merchants importing customers that they do not actually want to charge (CONTINUED): Click Pages 2, 3, etc. repeating the void process as necessary to void all imported charges.
If you are importing more than 1,000 transactions it may be beneficial to programmatically send PayJunction the information through our PayJunction API Speak with a Level 2 representative for more information.