Introduction

JOOR Order Integration (JOINT) is JOOR's standard flat file order export integration tool. We can fully customize the order export file through selecting the file format and which fields to include. Once the integration is live, orders can be manually or automatically selected to export to an FTP, or manually selected to download from the order list page.

Basic Requirements

• Each file can contain one header row of field names, with each column representing one distinct order field.
• We offer four common formats as file options: .csv, .txt, .xls, or .xlsx.
  • A delimiter is required for .csv and .txt files in order to separate out each of the fields in the export. This delimiter can be comma, pipe ("|"), semicolon, tab, or space.
• Orders can be combined into a single flat file, one file per order, or sent as a .zip file.
• Export file names can be configured to include information such as a PO number, customer code, or Unix timestamp.
• Success and error reports based on the order export can be sent to specific email addresses.
• After the export format has been created by JOOR, there are two methods to receive the order flat files:
  • Manually select the orders from the order list page and download in the selected format.
  • Schedule orders to export automatically to an FTP when they are assigned to specific statuses. The most common setting is for orders to export when they are marked as "Approved".

Tips

• Please provide a sample file to which we can build. This will help us complete the custom format as efficiently and accurately as possible.
  • After the initial format is established, we will provide a test file for verification. After the format is approved, we will activate the orders integration.
• We offer the use of a go-live date, which allows the integration to exclude orders created before a certain date. This helps to avoid creating duplicate orders, in case any orders have been previously entered into your system.
• Orders can be set to export up to hourly through a customizable schedule.
• JOOR uses 7 order statuses:
  • In Progress
  • Returned
  • Pending
  • Approved
  • Cancelled
  • Shipped
  • Notes
• Most brands set the integration to export all orders when they reach the Approved status. However, we are able to customize this to trigger the export when orders reach any of these statuses.
• After orders are exported through the integration, they will be marked as exported. Therefore, the next time the integration runs, they will not re-export.
  • If you would not like an order to export, you can mark it as Exported. It will then be ignored when the integration runs.
  • If an order has already been exported and you would like it to re-export, you can mark it as Force Export. It will then export the next time the integration runs.
• If any fields are required, we are able to set up validation in the integration to fail unless those fields are populated.
  • Fields can also be made required without exporting in the file, if this is requested.

Order Export Fields