Export Template Field Filters
IN THIS GUIDE
Field Filters are available within export templates to give you more control over what does (or doesn't) get included with your export files. This guide goes over the different filters that can be used. Refer back to the Building Export Templates guide for more information on export templates.
These filters allow you to make some changes to your export template, such as replacing, formatting and/or skipping certain data. To access the Field Filters in your export template, look at the lower right corner of the template page, underneath the list of Available Fields:
Click Add Filter and a box will pop up where you can add these filters:
If more than one filter is needed, click Add Filter for each new one. Each filter will only work for the Field Name entered. There are three types of Field Filter: Search & Replace, Date Format and Skip Line.
Search & Replace
Search & Replace is a way to replace specific data from your orders. This is useful if you need to change a SKU, an address, a shipping method, etc. If you can target the field name, you can replace the data. As an example, if you need to replace a SKU, the Field Name to Target should be "code", then put the SKU from your order(s) first followed by = and the SKU you need to replace it with, one per line:
When you export using this filter, where the SKU is hoth4595 in an order:
The SKU will have been replaced in the exported file based on the filter, as seen here:
For another example, if the shipping method on the order is "Standard Carrier":
But the exported file needs to specify what that method is, using the Search & Replace filter is a quick way to edit those details in the export without changing the order itself.
With this filter, your export will reflect the replacement value:
Date Format allows you to alter the format of dates from your orders.
Where the orders in this example have the default date format (Y-m-d H:i:s):
This example filter, set to d-F-Y, changes the date format in the exported file:
Skip Line allows you to remove lines from the export file. This lets you exclude specific lines from a field that you otherwise want added to your export template. For instance, if you want to export all of your Closed orders but leave out a specific SKU, you can target the code field name and enter the SKU you want left out in the value box.
This could also be useful if you want to exclude a shipping country on an export:
Or a specific type of item based on the product name:
As an example, let's say you want to export all of your orders excluding any that are in a specific folder. "Folder Name" must be a field added to the export template in order to skip one of your folders in the exported file. To skip all the orders in one folder, target the folder_name field, select Skip Line and add the name of the folder you want to skip as the value. In this example, we'll be skipping the folder named "Skip":
When exporting this group of orders, notice the two orders in the Skip folder:
The orders in the Skip folder will not be included in the exported file: