Download orders from JOOR

Overview

Orders that are marked as 'Approved' in JOOR can be downloaded into Cin7 Omni.

Products in downloaded orders will be matched to products in Cin7 Omni using their Universal Product Code (UPC).

If you download an order containing a product with a UPC that cannot be matched to a Cin7 Omni barcode - perhaps because it is incorrect or it does not exist - the line item will still appear in the order, but the stock for this item will not be diminished.

It is therefore very important that your barcodes match JOOR UPCs exactly.

Download orders

  1. From the left navigation, select Integrations, then select JOOR.
  2. Select Download Orders.
    Cin7 Omni will download all 'Approved' orders from JOOR and set their status in JOOR to 'Approved (API exported)'.

The orders will now appear in the Sales Orders module.

Downloaded fields

Order Details

JOOR FieldCin7 Omni FieldNotes
Order IDReference"JR-" prefix is added to the reference in Cin7 Omni to help identify JOOR orders
Created DateCreated Date
Created By Email or Shipping EmailEmailCan be selected in Cin7 Omni module settings
Customer Purchase OrderCustomer PO No
Start Ship DateETD
Order Delivery NameProject NameIf Order Delivery Name is not set then the Project Name will be the name of the JOOR module
CommentsInternal Comments
Order CurrencyCurrency
Tax StatusCan be selected in Cin7 Omni module settings
Order DiscountDiscount
Order Shipping TotalFreight
Order TotalTotal
Payment Method NamePayment Method

Billing and Shipping Details

JOOR FieldCin7 Omni FieldNotes
Shipping CodeCin7 Omni Contact ID
Customer Buyer NameFirst Name
CompanyCompany
Address 1Street Address
Address 2Suburb
CityCity
RegionState
Post CodePost Code
CountryCountry
PhonePhone

Line Item Details

JOOR FieldCin7 Omni FieldNotes
Item NumberCodeProducts may also be matched on item UPC
Item NameName
Item Unit PricePrice
Item Price AdjustmentDiscount

Color Size Details

JOOR FieldCin7 Omni FieldNotes
Item ColorOption 1
Item SizeOption 3

Was this article helpful?

Have more questions? Submit a request