syncX: Order Export (Exportible)

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

By default, 

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

• Select Date Range 
  If you would like to export within a certain time frame, you can set the order date range. 
  
  
• Order Since
  You can use this option to select the specific days for your orders. However, if you set a date range preferred, 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 Exportible before. 

You can change those settings according to your preference. 

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

• Choose the column name from the list provided and input the value in the column value. Then, choose to include/exclude for Export.
• You can also apply and/or conditions to all included filters.
  
• The column value supports the wildcard. For example: if you input this Shirt*, all values beginning with Shirt will be affected (e.g., Shirt blue, Shirt red, Shirt green, etc.)
• Exclude entire order when the Line items filter is applied means that when SKU ABC123 is excluded, the entire order won't be exported if one of the items in the order has the SKU ABC123.

For example:

(a) You would like to have order tags - Success and Fullfillment Status - Fullfilled only to be filtered. Then you can use the and condition. 



Outcome: Exported only with order tags Success and fullfillment status as Fulfilled


(b) You would like to have order tags - success & exported and Fullfillment Status - Fullfilled only to be filtered. Then you can use the or condition. 



Outcome: Exported all the order tags with success, exported and fullfillment status Fulfilled

You can add multiple alternate export values in the Advanced Settings (Sorting) section.

For example:

When the Fullfillment Location Name is set as the US and you would like to change it to the United States. 

• One order per row 
  Enabling this option allows you to merge the order to one column instead of exporting one order item per row. 
  
  
• Compress Same Column Value 
  To avoid showing repeated values, each order item is in the same order.

  
  

  
  
• Sort by Field 
  You can utilize this function to arrange the field by Order ID, Created At, Updated At, or Define Sort.
  
  
• Sort direction 
  You can utilize this function to sort items in either ascending or descending order.