The Scenario
You are an e-commerce operations manager. You are migrating to MailerLite and you have 1,200 historical orders in an Excel workbook — customer email, order ID, total value, and currency — exported from your old platform.
MailerLite's re-engagement automations use order history to decide who qualifies. If those 1,200 orders are not in MailerLite before the automations go live Friday, every existing customer starts from zero.
The bad version:
- You check MailerLite's docs and find the e-commerce shop import endpoint
- You realize the CSV import in the MailerLite UI only covers subscribers, not orders
- You contact support, who point you to the API
- You spend Wednesday afternoon arranging for a developer to write the import script
- The developer finishes Saturday
- The automations run for two days treating your best customers as new leads.
The fast version is one prompt Thursday morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the MailerLite e-commerce API row by row and writes the outcome back — no script, no developer, no delay.
Open the SheetXAI sidebar and type:
Bulk import the orders in this workbook into MailerLite shop [ID] using customer email in column A, order ID in column B, total value in column C, and currency in column D — write SUCCESS or ERROR into column E for each row.
SheetXAI reads the 1,200 rows, calls the MailerLite orders API for each one, and writes SUCCESS or ERROR into column E. By Thursday afternoon you have a full picture of what landed and what needs a second pass.
What You Get
A complete order import with per-row outcomes:
- 1,200 orders pushed to the MailerLite shop
- SUCCESS or ERROR written into column E for every row
- No script or developer needed
- Automations qualify correctly from Friday's go-live
If 23 rows failed, you know which 23. You fix them and rerun just those rows.
What If the Data Is Not Quite Ready
Historical order exports from old platforms are never clean. SheetXAI handles cleanup and the import together.
When order values have currency symbols in the number field
The export has values like "£49.99" with the currency symbol embedded.
Strip the currency symbol from column C and convert to a plain decimal. Then bulk import all rows into MailerLite shop [ID] using email in column A, order ID in column B, cleaned value in column C, and currency 'GBP' for all rows. Write SUCCESS or ERROR into column E.
When some rows have missing email addresses
A small number of guest checkout orders did not capture an email.
Skip any rows where column A is blank. For all rows with an email, import the order into MailerLite shop [ID]. Write SUCCESS, ERROR, or SKIPPED into column E.
When you only want orders from the past two years
The full export goes back seven years but automations only care about recent history.
Filter to orders where the order date in column E is on or after 2024-01-01. Import the filtered rows into MailerLite shop [ID]. Write SUCCESS or ERROR into column F.
When the data needs deduplication and currency normalization before import
The export has duplicate order IDs and mixed currency formats ('USD', 'usd', 'US Dollar').
Deduplicate by order ID in column B, keeping the first occurrence. Normalize column D to 3-letter ISO currency codes. Then bulk import all rows into MailerLite shop [ID] using email in column A, order ID in column B, total in column C, normalized currency in column D. Write SUCCESS or ERROR into column E.
The pattern: one prompt cleans and imports. The outcome is in the workbook, not in a results page.
Try It
Get the 7-day free trial of SheetXAI and open your historical order export in Excel, then ask it to push the orders into your MailerLite shop. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to import e-commerce customers into MailerLite from Excel or the MailerLite in Excel overview.