Knowledge Base

Neto By Maropost

Add and Edit Export Templates

Access Data Export Templates

In your Maropost Commerce control panel, navigate to Settings & tools > Export Data.
Click the Perform Complex Export button, and choose Use Existing Custom Export Templates.

Tip: Export templates can also be accessed from Settings & Tools > All Settings & Tools, then clicking Data Export Templates.

Add a Data Export Template

Tip: Templates can be created in the last step of the export and import wizards. This gives you a starting point to make more advanced changes.

On the data export templates page click the Add New button in the top right corner of the page.
Select Add New Export Template.

Populate the initial template details:

Field Name	Description	Example
Export Type	Choose what type of data to export, inventory (products), category/content, customer, order or payment	Inventory Export
Export Sub-Type		None
Export Status	Inactive export templates will never automatically generate a data file.	Active
Export Template Name	The template name helps you identify it in the list of export templates.	Facebook product feed
Export Template Description	An internal description for your export template. Optional.	In-stock products advertised on Facebook
Export Group	Categorise what the export template will be used for. Optional.	Comparison Shopping Sites
File Name	Determine how the file will be named once it is created, including the file extension. The list of tags can be used to add the creation date and/or time.	facebook.csv
File Type	The format of the file that will be created.	CSV Data

Click the Save Changes & Continue button. Your template will now be saved, and new settings will be available to set up.

Field Name	Description	Example
Send File To	Determines what to do with the file once it is created.	FTP
Location or Email Address	If FTP, email, or URL/Webservice is selected, the delivery address is entered in this field.	ftp.myftpserver.com.au
FTP Username	Username to log into the FTP server or webservice.	username
FTP Password	Password to log in to the FTP server or webservice.	password
Passive FTP	Select to connect via passive mode. Note that active mode does not work.	True
Binary Mode	Choose between Binary and ASCII transfer modes. Binary is recommended, particularly if you have selected UTF-8 encoding.	Binary
Overwrite File If Exists	When selected, any existing files with the same name will be replaced.	True
Flag File Path	Path for files with the .flg extension.
Request Method	Choose POST so that the data can be exported to the desired location.	POST
Authentication Method	Choose the authentication method for the webservice	Standard
Request Headers	Set the HTTP request headers for the webservice.
Form Data Name	Name of the form in the HTTP request.
Additional Form Data	Any additional data associated with the form.
Error Handling	Define the messages that return a successful and unsuccessful response.
Export Schedule	Choose schedule for when the file will be created.	Daily 12am
Record Each Export in Batch Export History Log	If selected, each time the file is created, a record of the event will be written to batch exports history log.	True
Export Priority	Choose the priority that this export task will run. Lower numbers (excluding 0) mean the task will run before others with a higher number.	50

Scroll down the page to until you see the File Builder, Filter, and Find & Replace tabs. Here you can define what data is exported from Maropost Commerce in your template.

File Builder

The file builder is broken up into five sections, and depending on the format of your file different sections need to be set up.

File Header

Also referred to as the column headers, the file header is a label used to identify what the data is in each column. The header is a free text field so that it can be defined according to the receiver's specifications. For example:

Google - (Plain text, tab separated)

MPN id title description link price brand condition image_link quantity product_<span class="hljs-built_in">type</span> availability

Facebook - (CSV)

"id","availability","condition","description","image_link","link","title","price","brand"

The file header only prints once for the entire export template.

File Body - Header, Body, and Footer

The file body is where you determine which fields will populate your product file. You can use a combination of Maropost Commerce B@SE tags, logic, and static values to dynamically build the data file. They must also conform to the file type. For example, a CSV file body may look like:

"[@SKU@]","in stock","new","[%format type:"csv" rmhtml:&#39;1&#39; noeol:"1" maxlength:"5000" %][@description@][%/format%]","[@image_full@]","[@url@]","[@model@]","[@store_price@]","[@brand@]"

You can add B@SE tags by using the Insert Data Tag drop down menus, and clicking the Insert button. The tag will appear in the file body where your cursor was located.

All three file body sections all work in the same way. What’s important to know about these sections is that they each export for each record, in a loop.

The main reason you’d use this is when exporting sales orders. The file body - header can export the order ID, total, tax, etc, and then the file body - body can export each orderline on the order.

If you only need to export one line per record type (e.g. products) use the File Body - Body section.

File Footer

Like the file header, the file footer prints once per export template. Unless your recipient requires footer text, leave this area blank.

Filter

The filter tab allows you to set rules which determine the products which will be exported. If you set multiple filters, products must meet all conditions to be included in the file.

You can also set which units that weight and dimensions should be exported in. The template will automatically convert your product dimensions to the units you select here.

Find & Replace

The find and replace tab is used to identify data in specific columns and overwrite it with a replacement on export.

Field	Description	Field Type
Find	The value you want to find when importing your file.	String
Replace	The value that will be substituted for the found value.	String
Exact Match	Enforce exact match or allow partial match within words.	Boolean (`y`, `n`)
Reg Exp	Allow/deny regular expressions in the find or replace fields.	Boolean (`y`, `n`)
Replace All	Replace all values or just the first match.	Boolean (`y`, `n`)
Case Sensitive	Enforce matching by case.	Boolean (`y`, `n`)
Multi Line	Search multiple lines (if any).	Boolean (`y`, `n`)
Template	Which area of the export template to perform the find and replace.	See accepted values below.
Category		See accepted values below.
Tag	The Maropost Commerce field that the find and replace is performed on.	String
Priority	The order in which the find and replace rules should be run (ascending).	Integer

You can manually set up the find and replace settings, or import a file to add them. Import files must be in the below format:

Find,Replace,Exact Match,Reg Exp,Replace All,Case Sensitive,Multi Line,Template,Category,Tag,Priority

Template, category and tag must conform to specific values.

Template

Template refers to which section of the import template you want to perform the find and replace.

Template Section	Import Value
All Templates	Leave blank
File Header Only	`fileheader`
Content Header Only	`header`
Content Body Only	`body`
Content Footer Only	`footer`
File Footer Only	`filefooter`

Tag

The tag in your file must match the B@SE tag of the specific field. Refer to your template file body for the specific tag you want to use.