Help CenterContact support
All Columna: Order Export & Sheets articles

Get an export template that matches your 3PL, accountant or ERP file

Updated

On this page
  1. Request a template
  2. Add the template
  3. Columns we could not match
  4. What the app reads and sends
  5. Troubleshooting

If 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. We build an export template with the same columns in the same order. This is included in every plan.

The template arrives as a template code in the support chat right away. You add it with Import template, as a new template. Your other templates stay as they are.

Request a template

  1. In the app, open Templates. At the top of the page, select Request a template. You can also select Request a template in the row under the templates, or at the top of a new template. The window “We build your template for you” opens.
  2. Under What is the file for?, choose 3PL or warehouse, Accountant or bookkeeping, ERP or inventory system or Something else.
  3. Select Choose a sample file, then pick a CSV or Excel (.xlsx) file from your computer. Or, under Or paste the column names, paste the header row copied from the file, or one column name per line.
  4. Check the column names under “We found … columns”. If you picked the wrong file, select Choose another file.
  5. Select Send to support.

Add the template

  1. The support chat opens with the answer “Your template is ready”. It names the template, says how many columns it has and shows the template code. The code starts with COLUMNA-TPL-1:.
  2. Copy the whole code.
  3. In Templates, select Import template, paste the code in Template code, then select Import.
  4. The template is added to My templates. Its name says which file it is for, for example “3PL file (from your sample)”. Rename it in the template editor if you like.

To check it, export a few orders with the new template and compare the file with your sample.

Columns we could not match

The app matches each column name to an order field. It knows common names in English, German, French, Spanish, Italian and Japanese, for example “Order No”, “Bestellnummer”, “Ship to city”, “PLZ” or “Qty”. It matches shipping and billing addresses by words like “Ship to”, “Delivery”, “Bill to” or “Rechnung”.

A column it cannot match is kept in its place with its name, so the file keeps the layout your 3PL, accountant or ERP expects, but the column is empty. The answer in the chat lists these columns. To fill one:

  1. Open the template, select Add column and add the field that column should hold.
  2. Drag the new column next to the empty one, give it the same name and remove the empty one.
  3. Save the template.

If you are not sure which field to use, reply in the support chat with what the column should hold, and support tells you which field to pick.

What the app reads and sends

The app reads only the first row of your file (the column names) in your browser. It never reads rows with order or customer data. The column names, what the file is for and the template code are sent to support.

Troubleshooting

You see “Choose a CSV or Excel (.xlsx) file.” The file is another type. Save your sample as CSV or .xlsx, or paste its column names instead.

You see “We couldn’t read the column names in this file. Check that it is a CSV or Excel (.xlsx) file with column names in the first row.” The file is damaged or has no column names in row 1. Fix the file and choose it again, or paste the column names.

You see “The first row of this file is empty. Put the column names in the first row and try again.” Move the column names to the first row of the file, then choose it again.

You see “We couldn’t send the column names. Try again, or open the support chat and paste them.” Select Send to support again. If it fails again, open the support chat and paste the column names there.

The import says the code is not valid. Copy the whole code from the chat again, from COLUMNA-TPL-1: to its last character, and paste it once more.

Related: How do I share an export template with a code?

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