The Scenario
You are an e-commerce operations manager. You are migrating to MailerLite from your old ESP and you have 1,200 historical orders in a Google Sheet — customer email, order ID, total value, and currency — exported from your old platform.
MailerLite's abandoned-cart and post-purchase automation flows use order history to decide who gets which emails. If those 1,200 orders are not in MailerLite before the automations go live Friday, every existing customer starts from zero — no purchase history, no re-engagement triggers, nothing.
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 writing a script or paying a developer to write one
- 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 spreadsheet 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 sheet 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 — the import runs from the SheetXAI sidebar
- Automations qualify correctly from Friday's go-live
The row-level outcome is what matters. If 23 rows failed because the email addresses do not match any subscriber record, 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 rarely clean. SheetXAI handles cleanup and the import in the same prompt.
When order values are in the wrong format
The export has values like "£49.99" with the currency symbol in the number field. MailerLite expects a plain decimal.
Strip the currency symbol from column C and convert to a plain decimal number. 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. You cannot import those without one.
Skip any rows where column A is blank. For all rows with an email, import the order into MailerLite shop [ID] using email in column A, order ID in column B, total in column C, and currency in column D. 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 MailerLite automations only care about recent purchase history.
Filter to orders where column E (order date) is on or after 2024-01-01. Import the filtered rows into MailerLite shop [ID] using email in column A, order ID in column B, total in column C, and currency in column D. Write SUCCESS or ERROR into column F.
When the data needs deduplication and currency normalization before import
The export has some duplicate order IDs from a platform bug, and the currency column has mixed values ('USD', 'usd', 'US Dollar').
Deduplicate by order ID in column B, keeping the first occurrence. Normalize column D to 3-letter ISO currency codes (USD, GBP, EUR). 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 does the cleanup and the import together. You see the outcome in the Sheet, not in a results page.
Try It
Get the 7-day free trial of SheetXAI and open your historical order export, 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 or the MailerLite in Google Sheets overview.