Help CenterContact support
All Columna: Order Export & Sheets articles

How do I share an export template with a code?

Updated

On this page
  1. Copy a template code
  2. Import a template from a code
  3. Verify it worked
  4. Columns that work differently in another store
  5. Troubleshooting

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 names, column order, column settings (custom text, combined fields, calculations, replaced values, empty-cell fallbacks, number and date formats), rows, and file options. Support can also build a template for you and send you its code.

The code holds no order or customer data and nothing that belongs to your store.

Copy a template code

  1. In the app, open Templates, then the My templates tab.
  2. On the template’s row, select the Copy template code icon. You can also open the template and select Copy template code at the top of the page.
  3. You see the message “Template code copied”. The code is on your clipboard and starts with COLUMNA-TPL-1:.

If the Shopify admin does not let the app use your clipboard, the window “Copy the template code” opens instead. Select all the text in Template code, copy it, then select Done.

In the template editor, the code includes changes you have not saved yet.

Import a template from a code

  1. In the app, open Templates.
  2. At the top of the page, select Import template. The window “Import a template” opens.
  3. Paste the code into Template code. Line breaks and spaces around the code are fine, for example when it was wrapped in an email.
  4. Check the template name and the number of columns shown below the field.
  5. Select Import.

Verify it worked

  • After step 5, you see the message “Template imported”. The window closes and the My templates tab lists the new template.
  • Importing always adds a new template. Your existing templates are never changed.
  • If you already have a template with the same name, the new one is called “name (imported)”, or “name (imported) (2)” and so on.

Columns that work differently in another store

  • Metafield columns stay in the template even when your store has no matching metafield definition. They export as empty cells until the metafield exists and has values.
  • Line item property and note attribute columns read the same key in your orders. They are empty when your orders do not use that key.
  • A column this version of the app does not know is kept and marked Unknown column in the editor. It exports as an empty column. The import window tells you how many such columns the code has.

Troubleshooting

You see “Paste a template code.” The field is empty. Paste the code, then select Import again.

You see “This is not a template code. A template code starts with COLUMNA-TPL-1:” You pasted other text. Copy the code again from the template, or ask the sender for it.

You see “This code is incomplete or damaged. Copy the whole code again and paste it.” Part of the code is missing or changed, which often happens when only part of a long line was copied. Copy the whole code again.

You see “This code does not contain a valid template. Ask for a new code.” The code was edited by hand or made by another tool. Ask for a new code copied from the app.

You see “This code comes from a newer version of Columna. Reload the app and paste it again.” Reload the app page so it uses the latest version, then paste the code again.

You see “This text is too long to be a template code. Paste one code only.” You pasted more than one code or a whole document. Paste only the code.

You see “Could not import the template”. The app could not save to your store. Select Import again. If it keeps failing, open the support chat in the app.

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