Update order tracking from Text

With Fulfilleo you can fulfill orders or individual items based on data extracted from plain text.

If tracking information is included in the body of an email, not as an attachment, you can extract this information, by setting the Channel to Email, and the File source to Email body.

Setting file source to email body

In Data Mapping section you need to set Format to Text, and specify mapping for Order Number, and Tracking Number. Optionally, you can add Tracking Company, Tracking URL, SKU, and Quantity fields. In order to fill those fields, you need to provide regular expressions that will match text contents of the email that the automation will process.

All emails to be processed by Fulfilleo automation must have a consistent format.

Data Mapping section of Fulfilleo automation

Example

Consider an email in the following format:

Email example

To create regular expressions that will match the contents of the email above, you simply need to enter the whole line that precedes the actual value to be extracted.

Data mapping for the example email

Fulfilleo automatically adds a capturing group in brackets at the end of every Data Mapping element. It is responsible for extracting the concrete information from the surrounding text. The capturing group expression added by Fulfilleo is (.*), which is the most generic expression, allowing a match regardless of the data format. You can add that capturing group explicitly, but it isn't necessary as it is added automatically under the hood.

Data mapping with capturing groups included

You can specify a different capturing group based on the data format for particular Data Mapping element. In the example above, the order number is expressed only with digits, doesn't have any letters or special characters. In that case, we can specify the capturing group in such a way that it will only match actual numbers: ([0-9]+). When you're specifying a different capturing group, you must include it in the Data Mapping field explicitly.

Data mapping section with specified capturing group

Example

Let's consider an email with a different format.

Different email format example

Once again we have to provide each line of text preceding the concrete data. It is crucial that the text is identical, you have to be careful not to add additional spaces or change the letter cases.

Data Mapping section for a different email format