Q: Formatting in Order Export

With formatting, you are able to choose how to export the values of the fields formatted. The formatting only available for certain fields. <img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/2043330401488/original/Uv4RwU-O3mjgZDQMQjYlpainFmSWgM13wA.png?1650467467" alt="" width="500" height="462" /> | Formatting | Result | | ---- | | None | Do not apply any formatting | | Remove non-alphabet | Remove any character that is not alphabet (A-Z, a-z) | | Remove non-numeric | Remove any character that is not a digit (0-9) | | Remove non-alphanumeric | Remove any characters that are not alphabets (A-Z, a-z) and numeric (0-9) | | Convert text to uppercase | All characters will be uppercase (A-Z) | | Convert text to lowercase | All characters will be lowercase (a-z) | | Capitalize all the words | Only the first character of the words will be uppercase (A-Z) | <img src="https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/2043330401558/original/725rk1DWKFIMbupn3GPoz5Pde9jyKBDNKA.png?1650467479" alt="" width="500" height="190" /> Enabling the Remove Carriage Return will wrap multiple lines as a single line

Question 1

Export single or bulk orders through Shopify admin

Accepted Answer

To export single or multiple orders, please follow these steps:

Navigate to your Orders page on your Shopify admin page.
Click on the order(s) that you wish to export.
To access the menu options, click on the three dots located on the header.
Look for Exportible to Export order(s).

You will be navigated to the Exportible dashboard.
You can download or export the selected order according to the Data File setup.

Question 2

File Formatter for JSON & XML

Accepted Answer

To structure the data export, use the File Formatter for JSON and XML files. Select this option in Filter/Source Settings under Choose Export Method, then pick either JSON or XML. The File Formatter option will then appear.

JSON example:

```json { "header": { "dateCreated": "{{ "now" | date: "%Y-%m-%d %H:%M:%S" }}" }, "dataHeader": { "encodingTableCode": "E-Shop" }, "data": { "orders": [{% for item in items %} { "delivery": { "name": "{{ item[1]["Customer Name (Shipping)"] }}", "streetAndNumber": "{{ item[1]["Shipping Address 1"] }}", "city": "{{ item[1]["Shipping City"] }}", "zip": "{{ item[1]["Shipping ZIP"] }}", "phone1": "{{ item[1]["Shipping Address Phone"] }}" }, "lineItems": [{% for line in item[1][nil] %} { "lineId": "{{ line["Product ID"] }}", "itemCode": "{{ line["SKU"] }}", "ean": "{{ line["SKU"] }}", "quantity": {{ line["Quantity"] | times: 1 }}, "unitOfMeasure": "VNT", "vatCode": 0, "unitNetPrice": {{ line["Product Price"] | times: 1}}, "unitPriceVAT": {{ line["Product Price"] | times: 1.23 }}, "vatAmount": {{ line["Product Price"] | times: 0.23 }}, "netAmount": {{ line["Product Price"] | times: 1}} }{% if forloop.last == false %},{% endif %} {% endfor %}] }{% if forloop.last == false %},{% endif %} {% endfo

Question 3

Merging and Formatting

Accepted Answer

To access and customize the Merging and Formatting settings, click on the more text next to the fields you want to configure.

You will see the Formatting and merging fields in the settings.

The formatting field is only available for certain supported fields.

The Merging field is available for all fields. This is how to use the Merging field.

The fields are expressed in such a way {{ item['Field Name'] }}

For example:

Merging field Shipping Address 1 and Shipping Address 2. You will need to add the formula as follows for each field

| {{ item["Shipping Address 1"] }} {{ item["Shipping Address 2"] }}

Multiply the Sum of the Total Line Item Price by 2.35 by using a times filter with a value of 2.35.

| {{ item["Sum of Total Line Item Price"] | times: 2.35 }}

If currency formatting is applied to your source settings, then this formula will ensure that it will perform similarly to the previous example but with formatting retained. The value of the first and last filters must match the currently applied formatting value to retain source formatting.

| {{ item["Sum of Total Line Item Price"] | currencytonumber: "#.###,###" |

Question 4

App Privacy Policy

Accepted Answer

Exportible Privacy Policy

Exportible "the App” provides Exports Order to CSV "the Service" to merchants who use Shopify to power their stores. This Privacy Policy describes how personal information is collected, used, and shared when you install or use the App in connection with your Shopify-supported store.

Personal Information the App Collects

When you install the App, we are automatically able to access certain types of information from your Shopify account: We use Order API to generate the export file.

We collect personal information directly from the relevant individual, through your Shopify account, or using the following technologies: “Cookies” are data files that are placed on your device or computer and often include an anonymous unique identifier. For more information about cookies, and how to disable cookies, visit http://www.allaboutcookies.org. “Log files” track actions occurring on the Site, and collect data including your IP address, browser type, Internet service provider, referring/exit pages, and date/time stamps. “Web beacons,” “tags,” and “pixels” are electronic files used to record information about how you browse the Site.

How Do We Use Your Personal Information?

We use the personal information we collect from you and your customers in order to provide the Service and to operate the App. Additionally, we use this personal information to: Communicate with you; Optimize or improve the App; and Provid

Question 5

Formatting in Order Export

Accepted Answer

With formatting, you are able to choose how to export the values of the fields formatted. The formatting only available for certain fields.

| Formatting | Result | | ---- | | None | Do not apply any formatting | | Remove non-alphabet | Remove any character that is not alphabet (A-Z, a-z) | | Remove non-numeric | Remove any character that is not a digit (0-9) | | Remove non-alphanumeric | Remove any characters that are not alphabets (A-Z, a-z) and numeric (0-9) | | Convert text to uppercase | All characters will be uppercase (A-Z) | | Convert text to lowercase | All characters will be lowercase (a-z) | | Capitalize all the words | Only the first character of the words will be uppercase (A-Z) |

Enabling the Remove Carriage Return will wrap multiple lines as a single line

Question 6

Filter orders to be exported

Accepted Answer

The first section of the filter in the data file settings allows you to specify which orders to export.

1. Status filter

By default,

Order Status is set to Open Fulfillment Status to Any Payment Status to Any

2. Order range

Select Date Range You can set the order date range if you would like to export within a certain time frame.
Order since You can use this option to select the specific days for your orders. However, if you set a preferred date range, this option will be ignored. This setting is based on exporting at the current time and is initially set to 10 days.
Date range preferred You can use this option to select the date range from the start date to the end date of your orders.
Only export newer orders By enabling this option to export orders that have not been exported using syncX: Order Export before.

||| You can change those settings according to your preference

3. Column filter

In the Filter by Columns section, you can add multiple filters to be included or excluded in the export.

![](https://s3.amazonaws.com/cdn.freshde

Frequently Read Articles

Browse All Categories