Skip to content

Orders & CSV export

Review orders with customizations and export them to a spreadsheet

Use with AI

Use with AI

Ready-made prompts Connect your AI to Pasilobus Install the CLI

This page

View as MarkdownPlain text of this page Open in ClaudeAsk about this page Open in ChatGPTAsk about this page

Ready-made prompts

Fill in the parts in angle brackets, then paste into any assistant.

Step by step on your store

Read https://help.pasilobus.com/product-options/orders-export.md. Walk me through orders & CSV export in Product Options for my store, step by step. My theme is <theme name> and I want <what you want to happen>.

Ask your own question

Read https://help.pasilobus.com/product-options/orders-export.md. Answer this about Product Options on my store: <your question>.

Ask Shopify Sidekick

In your Shopify admin, ask Sidekick about Product Options. It searches these guides.

Connect your AI to Pasilobus Beta

Our MCP server lets Claude, ChatGPT, OpenClaw and other MCP clients use your Pasilobus apps. It is in beta and open to every Pasilobus account: you sign in with it when your assistant asks. Tools that change your store are marked as changes, so your assistant asks you first.

https://cloud.pasilobus.com/mcp

In Claude Code, add it, then run /mcp to sign in:

claude mcp add --transport http pasilobus https://cloud.pasilobus.com/mcp

In Claude on the web or desktop, go to Customize › Connectors › Add custom connector and paste the address. In ChatGPT, OpenClaw or another client, add it as a custom connector (MCP) with the same address.

Install the CLI

npm install -g pasilobus

Run your apps from the terminal or a coding agent. These only read, so they are safe to try:

pasilobus product-options groups

List product-option groups, their options and products

pasilobus product-options orders

Recent orders that contain product-option customizations

pasilobus apps lists your apps on the store; pasilobus <app> help lists what each app can do. How it works

On this page
  1. The Orders Page
  2. Choices on Shopify's Order Page
  3. Exporting to CSV
  4. What's in the File
  5. Shipping Address Columns
  6. Why Not Just Use Shopify's Export
  7. Common Uses

Every order that includes a product customization is collected in one place so you can see exactly what each customer asked for — and export it all to a spreadsheet. This is especially useful for production and fulfillment, where you need each option value broken out into its own column rather than buried in a line-item note.

The Orders Page

Open Orders from the app navigation. Only orders that contain product option customizations appear here — plain orders without options are left out to keep the list focused. An order appears as soon as it's placed, including orders waiting for a manual payment capture. Revenue figures count it once it's paid.

Choices on Shopify's Order Page

You can also see each item's choices without leaving Shopify's own order page. Open any order, select the apps icon above the order's cards and pin Product options. The card lists what the customer chose on every item, and uploaded files open from their links. It shows on every order from then on.

For each order you'll see:

  • Order - The Shopify order number, linked to its details
  • Customer - Who placed the order
  • Customizations - How many option values were captured on that order
  • Date - When the order was placed
  • Total - Order value for the customized items

Use the search box to find an order by number or by a customization value.

Exporting to CSV

The Orders page has an Export action in the top bar. It opens a dedicated export page that shows how many orders and line items are included, then a Download CSV button starts the download.

The file downloads directly to your computer, ready to open in Excel, Google Sheets, or Numbers.

What's in the File

The export uses a one row per ordered item layout, which is what makes it useful for production sheets:

  • Each customized product in each order becomes its own row
  • Standard columns come first: order number, date, customer, shipping address, product, variant, SKU, quantity, and item price
  • Every option becomes its own column - the option name is the column header and the customer's choice is the value

So if a customer ordered an engraved bracelet, you'll see the engraving text, font, and any other options each in their own column, right next to the product and shipping details.

Shipping Address Columns

The export includes the shipping address for each order, split into separate columns for easy sorting and mail-merge:

  • Ship name, Address 1, Address 2, City, Province, Zip, Country, Phone

Because address is order-level, every line-item row from the same order repeats that order's address. Orders placed before address capture was added may have blank address fields; new orders always include it.

Why Not Just Use Shopify's Export

Shopify's built-in order export keeps line-item customizations as a single combined properties field, which is hard to read and impossible to sort or filter by a specific option. This export breaks each option out into its own column, so you can filter by font, sort by size, or hand a clean production sheet to your team.

Common Uses

  • Production sheets - Give your workshop a clear list of what to make, with every customization spelled out
  • Fulfillment - Pack and ship with the shipping address and options side by side
  • Backups and analysis - Keep a snapshot of customization data or analyze which options sell

Talk to a person.

The people who build our apps answer support themselves. Send us a message or email us, and a person replies, usually within one business day. There's no chat.