Ecommerce data export

Hello,

The Kentico does not provide any built in export functionality for exporting the order related data. What are the recommended way to do that so that the orders can exported along with all items/products/customer details.

If anyone has implemented those or had any idea regarding that


Environment

  • Xperience by Kentico version: [31.6.2]

  • .NET version: [10]

  • Execution environment: [SaaS]

Answers

Hi Victor, thanks - that matches what I found too, there's no built-in export in the admin UI for order data.

To add some concrete detail for anyone hitting this: order data is stored as regular system objects, so it's fully queryable via the API even though there's no UI for it:

For actually producing the export, a scheduled task (for recurring exports) or a small custom admin UI page/button (for on-demand exports by business users) are the supported extension points:

Then just serialize the queried objects with something like CsvHelper or ClosedXML. Also worth noting - on SaaS there's no direct DB/SQL access, so this API-based approach is the correct route there too: https://docs.kentico.com/documentation/developers-and-admins/saas/differences-saas-private-cloud

The Dancing Goat sample project is a good reference for how these objects get queried in practice.

To response this discussion, you have to login first.