Help CenterContact support
All Columna: Order Export & Sheets articles

How do I export products, customers or draft orders?

Updated

On this page
  1. Steps
  2. The columns
  3. Verify it worked
  4. What is stored
  5. Troubleshooting

Besides orders, the app downloads your products, customers and draft orders as a CSV, Excel (XLSX), TSV, pipe-separated, JSON or XML file. Each export has a fixed set of columns; you choose what to export, a date range and a status. It is part of the Free plan.

Steps

  1. In the app, open Orders.
  2. Click Products, customers, drafts at the top of the page.
  3. Under What to export, pick Products, Customers or Draft orders.
  4. Under Filters, choose:
    • Date: Created or Last updated, with a From and a To date (both included, in your store’s time zone). Leave them empty to export everything.
    • Status for products (Active, Draft, Archived, Unlisted) and draft orders (Open, Invoice sent, Completed), or Email marketing for customers (Subscribed, Not subscribed). Any exports all of them.
  5. Pick the file format: CSV or Excel (XLSX).
  6. Click Export.

The first time you export each type, Shopify asks you to allow the app to read it: your inventory (for each variant’s weight and shipping setting), your customers or your draft orders. Click Allow. You are asked only once per type.

The columns

  • Products: one row per variant. Product ID, Handle, Title, Vendor, Type, Tags, Status, Created at, Updated at, Variant ID, Variant title, Option1–3 name and value, SKU, Barcode, Price, Compare-at price, Inventory quantity, Weight, Weight unit, Taxable, Requires shipping. A product without variants is one row.
  • Customers: one row per customer. Customer ID, First name, Last name, Email, Phone, Email marketing, Account status, Orders count, Amount spent, Currency, Tags, and the default address (Company, Address 1, Address 2, City, Province, Province code, ZIP, Country, Country code, Address phone), Created at, Updated at.
  • Draft orders: one row per line item, the draft’s own columns repeated on each. Name, Status, Created at, Updated at, Customer, Email, Phone, Line item, Variant, SKU, Vendor, Quantity, Unit price, Subtotal, Shipping, Tax, Discounts, Total, Currency, Tags, Invoice URL, Invoice sent at, Completed at, Order (the order the draft became).

Dates use the date format, and CSV files the delimiter, set under Settings > File format. The columns cannot be changed; templates apply to order exports only.

Verify it worked

  • You see the export’s progress, then the download starts and you see a message such as “Exported 120 rows”.
  • The export appears in History, where Run again repeats it with the same type, filters and file format.

What is stored

The app reads the records from Shopify and builds the file in your browser. Only the export settings are kept in History; the file and its products, customers or draft orders are never stored.

Troubleshooting

You see “This export needs the access Shopify asked you for”. You did not allow the access Shopify asked for. Click Try again or Export and click Allow.

You see “This app does not have permission to read this data from your store”. Reopen the app from your Shopify admin, approve its updated access, then export again.

The file is empty. No record matches the filters. Clear the dates or set the status to Any.

A large store takes a while. Above 2,000 records Shopify prepares the data in one go, which can take a few minutes. Keep the page open until the download starts.

Built and supported by StoreFleet, Shopify app developers since 2021.