Help CenterContact support
All Columna: Order Export & Sheets articles

Columna: Order Export & Sheets

Orders to CSV or XLSX with line-item properties.

33 guides

  1. Add calculated columns and format numbers and dates per columnAdd a column that works out a number from your order fields, such as a line total, a net amount without tax or a price with VAT.
  2. How do I add metafield, fulfillment and payment columns?Add metafields, tracking numbers, line item fulfillment status, payment and refund details to an export template.
  3. How do I add more Google Sheets syncs?With Pro you can send orders to more than one spreadsheet, each sync with its own Google account, template and filters.
  4. How do I change the CSV delimiter and date format of my exports?Choose the CSV delimiter and the date format your spreadsheet software expects, for example when a CSV opens in a single column in Excel.
  5. How do I change the sender name and reply-to of the app's emails?Set the name your emails show and the address replies go to, for scheduled exports, production lists and the order emails your suppliers get.
  6. How do I check my Google Sheets sync for missed orders?Compare the orders in Shopify that match a sync with the orders in your Google sheet, to find any order the sync missed.
  7. How do I email each supplier only its own order items?Add your suppliers with the vendor names they ship, and the app emails each one an Excel file with only its items from each new order.
  8. How do I get the production list by email every day?The production list email sends your team the products to prepare for one pickup or delivery day, every day, without opening the app.
  9. How do I export an EU OSS or IOSS VAT report?Shopify collects EU VAT at checkout, but its tax report only shows the tax collected, not the taxable amount per country.
  10. How do I export an order from a Shopify Flow workflow?Columna adds the action Export order with Columna to Shopify Flow. When a workflow runs it, the app sends that one order through one of your scheduled exports: with the…
  11. How do I export orders with line item properties?Export orders to a CSV or Excel file with custom options, such as engraving text or gift messages, each in its own column.
  12. How do I export products, customers or draft orders?Besides orders, the app downloads your products, customers and draft orders as a CSV, Excel (XLSX), TSV, pipe-separated, JSON or XML file.
  13. How do I export selected orders from Shopify admin?Use the Export orders link in Shopify admin to export just the orders you picked, without setting up dates or filters in the app.
  14. How do I filter orders before I export them?Use the filters on the Orders page to choose which orders go into your file: by date, status, fraud risk, tag, payment method, discount code, POS location, shipping…
  15. How do I start a Shopify Flow workflow when an export stops working?Columna adds the trigger Columna export failed to Shopify Flow. It starts your workflows when a Google Sheets sync, its weekly check or a scheduled export stops working…
  16. How do I create, edit, duplicate or delete export templates?Templates decide which columns appear in your exported file. This article shows how to manage them on the Templates page.
  17. How do I export payouts or a sales journal for my accountant?Four presets on the Accounting tab of Templates build accounting files without setting up columns.
  18. How do I plan production by pickup or delivery date?Bakeries, caterers and other made-to-order food shops let customers pick a pickup or local delivery day at checkout.
  19. Get an export template that matches your 3PL, accountant or ERP fileIf your warehouse, 3PL, accountant or ERP needs a file with specific columns, send the app a sample of that file or paste its column names.
  20. How do I run a past export again?The History page lists every export you ran in the last 90 days, newest first, so you can run the same export again in one click without setting up the filters.
  21. How do I save scheduled exports to Dropbox?A scheduled export can save its file to a folder in Dropbox instead of emailing it, so your team or accountant finds every file in one place.
  22. How do I save scheduled exports to Google Drive?A scheduled export can save its file to a folder in Google Drive instead of emailing it, so your team or accountant finds every file in one place.
  23. How do I get an order export by email every day, week or month?A scheduled export emails a file from a saved template every few hours, every day, week or month, or for every new order, for example to you, your warehouse or your…
  24. How do I send scheduled exports to a webhook?A scheduled export can send its file to your own HTTPS endpoint with a POST request: an ERP or warehouse system, an automation tool such as Make, Zapier or n8n, or a…
  25. How do I share an export template with a code?Every template can be copied as a short text code. Paste that code in another store, or send it to someone, and they get the same template: its name, columns, column…
  26. How do I export sales totals by SKU, vendor, product or day?A template can write a summary instead of one row per order or line item: one row per SKU, vendor, product type, product and variant, day, week or month, with the number…
  27. How do I sync new orders to Google Sheets?Use Google Sheets sync to keep a spreadsheet up to date without exporting by hand.
  28. Which template preset should I use?Columna has ready-made templates, called presets, for sales reports, packing, dropshipping, delivery, accounting and more.
  29. Upload scheduled exports to Amazon S3 or S3-compatible storageA scheduled export can upload its file to a bucket on Amazon S3, or on a service that works like it, such as Cloudflare R2, Wasabi, Backblaze B2 or MinIO.
  30. How do I upload scheduled exports to an FTP or FTPS server?A scheduled export can upload its file to an FTP server instead of emailing it, for example to a warehouse, 3PL or ERP that only offers FTP.
  31. How do I upload scheduled exports to an SFTP server?A scheduled export can upload its file to an SFTP server instead of emailing it, for example to your warehouse, 3PL or ERP.
  32. What does the Pro plan add?Columna has two plans. Pro adds unlimited orders and the features that run on their own, without opening the app.
  33. How do I write tracking numbers from Google Sheets back to Shopify?With Pro, tracking numbers that you or your suppliers type into your synced spreadsheet fulfill the orders in Shopify.

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