Importing Payments from Easy Digital Downloads
Easy Digital Downloads has the ability to import payments other Easy Digital Downloads stores.
Payment importing is done under Downloads → Tools → Import/Export. On this page you'll find a box labelled Import Payment History.
Your CSV should be comma separated, with fields enclosed by double quotes. The order of the fields is not important, as you'll be mapping them in the next step.
Click Choose File and browse to your file. Then click Import CSV.
Once your file is uploaded you'll see a list of Payment fields that need content, and a dropdown for each one, where you can map where the data is. Each dropdown will be populated with content from your CSV, so you'll be able to map accurately.
Additionally, as you choose a column, a value from the column will appear on the right, taken from the first row of data, as in the example below.
Note: If no data appears in the right column it is NOT a problem. That merely indicates that the row being used for examples doesn't contain data for that column.
The more fields you have the more complete your site data will be, which can be helpful when working with financial statements or customer information. That said, the really vital fields are the customer email, all of the product fields, and the transaction fields.
Mapping Fields From the CSV File
This chart will show which import field should map to which export column.
|Product Field||CSV Column|
|Customer First Name||First Name|
|Customer Last Name||Last Name|
|Customer ID||Customer ID|
|Discount Codes||Discount Code|
|IP Address||IP Address|
|Mode (Live|Test)||Mode (Live|Test)|
|Parent Payment ID||None, not used at this time|
|Payment Method||Payment Method|
|Payment Number|| If your export file has a field called Payment Number it should be used.
If it does not then you may use either Payment ID or leave it blank. If left blank and sequential payments are enabled, they will be auto generated.
|Purchase Key||Purchase Key|
|Purchased Product(s)||Products (Raw)|
|Subtotal||None, not used at this time|
|Transaction ID||Transaction ID|
|Address Line 1||Address|
|Address Line 2||Address (Line 2)|
|State / Province||State|
|Zip / Postal Code||Zip / Postal Code|
Full Mapped Layout
Below is an example of the mapping process immediately before submitting. Note that some are set to ignore and some don't show data on the right. This is expected for the file being imported here. Each import will be a little different, and that's ok.
After submitting you should see a confirmation message similar to this: