How do I create, edit, duplicate or delete export templates?
On this page
Templates decide which columns appear in your exported file. This article shows how to manage them on the Templates page.
Create or edit a template
- Open Templates in the app.
- Click Create template, or use the edit action on a row in the My templates tab. To start from a ready layout, open a preset tab and click Customize on a preset (see “Which template preset should I use?”).
- Enter a Template name. A name is required.
- Choose Rows: One row per order or One row per line item.
- Click Add column. The Add columns window opens. Use Search fields to find the fields you want, then click Done.
- Rename a column by editing its name, remove it, or drag it to reorder. The preview shows the first rows built from your orders.
- Click Save. You see “Template saved”.
A template needs a name and at least one column before it can be saved. When the shop has no orders yet, the preview uses sample orders and says “No orders to preview yet, so this preview uses sample orders.”
Field groups
The Add columns window lists the fields in these groups:
- Order, Customer, Shipping address, Billing address and Line item: the standard Shopify order fields.
- Line item properties and Note attributes: custom keys, such as engraving text or a gift message. The app finds them by scanning your recent orders (“Scanning recent orders for custom properties…”).
- Order metafields, Product metafields and Variant metafields: the metafield definitions of your store.
- Accounting: refund, transaction, tax and presentment currency columns.
Each column in the list shows its group next to its name. See “How do I add metafield, fulfillment and payment columns?” for the full list of these columns.
Special columns
Click Add special column next to Add column to add a column that does not read a Shopify field:
- Custom text: the same text in every row. Set it in Text in every row.
- Combined fields: several fields joined into one cell. Add them under Fields to join with Add field, and choose the Separator.
- Calculation: a number worked out from fields and numbers with +, −, × or ÷, such as Unit price × Quantity. See “How do I add calculated columns and format numbers and dates per column?”.
- Row number: 1, 2, 3 and so on.
Replace values in a column
Click the settings icon on a column to open Settings for that column. Under Replace values, click Add replacement, then enter the value in Find and the new value in Replace with. Cells that exactly match the left value are replaced with the right value. Use it, for example, to turn a Shopify status into the word your 3PL expects.
The same window sets what an empty cell shows (If empty), and for money, number and date columns the Number format or Date format of that column only. See “How do I add calculated columns and format numbers and dates per column?”.
File options
Under Details, below Rows:
- Include header row: untick it when the system that reads the file expects no column names.
- One row per unit (only with One row per line item): a line item with quantity 3 becomes 3 rows with quantity 1 each, so every personalized item gets its own row.
- Add a column for every other key (only when the template has a line item property or note attribute column): every other property or note attribute found on your orders also gets its own column at the end. Untick it to export only the columns you added.
- File name: leave it empty for
orders-{date}. You can use the tokens{date},{time},{template}and{shop}. Only letters, digits, dot, dash and underscore are kept, up to 100 characters. The app shows an example file name below the field.
Bundles
When a customer buys a bundle made with Shopify Bundles or another bundle app, Shopify adds each product in the bundle to the order as its own line item and links them to the bundle. Columna can show that link:
- Bundle columns (Line item group): Bundle name, Bundle SKU, Bundle quantity, Bundle group ID, Quantity per bundle, Bundle components (“2× Mug; 1× Tea”) and Bundle row (“Bundle” or “Component”). They are empty for products not sold in a bundle. Quantity already counts every bundle sold: 2 gift boxes with 2 mugs each show Quantity 4 and Quantity per bundle 2.
- Bundles (one row per line item only):
- One row per component (default): every product in the bundle has its own row, with the price Shopify gave it.
- One row per bundle (components in one cell): one row per bundle sold, with the bundle name, bundle SKU and bundle quantity in the Line item, SKU and Quantity columns, the bundle price and total, and the products in Bundle components.
- Bundle row, then its component rows: the bundle row (without amounts, so totals are not counted twice) followed by one row per product, handy for picking lists. Quantities appear on both, so sum Quantity on one kind of row only (filter on Bundle row).
- When a line item filter or a supplier email keeps only some products of a bundle, the bundle row lists just those products and leaves its amounts empty, so a partial amount is never read as the bundle price.
- Bundle line items: All line items, Only bundle components, or Leave out bundle components. Orders left with no matching line items are skipped.
These settings are saved with the template, so scheduled exports, Google Sheets syncs, SFTP uploads and supplier emails that use the template follow them too. Only bundles Shopify links on the order are recognised; a bundle sold as one ordinary product stays one line.
Duplicate a template
Use the duplicate action on a row. The copy is named “{name} (copy)” and you see “Template duplicated”.
Delete templates
- On the Templates page, use Search templates to find the template.
- Use the delete action on a row, or tick several rows to delete them together.
- Confirm the “Delete template?” dialog.
Exports you already downloaded are not affected.
Troubleshooting
- Delete is replaced by “Keep at least one template”: you selected every template. The app always keeps at least one, so leave at least one unselected.
- “Add at least one column to see a preview.”: the template has no columns yet. Click Add column.
- “No orders to preview yet.”: the preview needs orders in your shop.
- “{name} is already added”: that field is already a column in the template.
- “Could not save the template”: try saving again.