Use an Excel workbook to create or update customer records in AtomicSeller. The first row must contain the exact header names listed below.
Before you start #
- Use an .xlsx workbook.
- Do not use formulas in the cells. Paste calculated values before uploading.
- Format postal codes and phone numbers as text to preserve leading zeros and international prefixes.
- One row represents one customer. Unknown columns are ignored.
Upload the file #
- Open Tools > Upload files.
- In Upload customers file, select Choose File.
- Choose the workbook, then select Upload.
- Review the imported records in the Customers area.
Supported headers #
| Header | Requirement | Description |
|---|---|---|
| MERCHANTKEY | Mandatory | Merchant reference configured in AtomicSeller. |
| COMPANYNAME | Optional | Customer company name. |
| ADR0 | Optional | Additional address information, such as floor or entrance. |
| ADR1 | Optional | First address line. |
| ADR2 | Optional | Second address line. |
| ZIPCODE | Optional | Postal code. Format as text to preserve leading zeros. |
| CITY | Optional | City. |
| Optional | Customer email address. | |
| PHONENUMBER | Optional | Customer landline or main phone number. |
| FIRSTNAME | Optional | Customer first name. |
| LASTNAME | Optional | Customer last name. |
| COUNTRY | Optional | Country name. |
| STATE | Optional | State, province, or region. |
| MOBILENUMBER | Optional | Customer mobile phone number. |
Download a sample #
Start with this sanitized workbook and replace the demonstration values with your own customer data.
Troubleshooting #
- If a row is not imported, check that
MERCHANTKEYis present and matches your AtomicSeller configuration. - Check the email address format before uploading.
- Keep postal codes and phone numbers as text.
- Keep the header spelling unchanged; extra columns that AtomicSeller does not recognize are skipped.