Ready2Order

Created by Maja Bradonjic, Modified on Fri, 30 Sep 2022 at 02:11 PM by Vincent P

TABLE OF CONTENTS









1) Description


ready2order is an Austrian-based company that offers a simple and easy-to-use point-of-sale system designed for small businesses, retail, and restaurants. The cloud-based software works on all devices and ready2order also offer POS hardware. The POS system fulfills the legal requirements in Germany and Austria.





2)Setup


Steps


Step 1: Creating a Task or from Integration Menu


Either while Creating a Task or in the Integrations menu.

 

Enter the name of the integration in the search bar .

 


Step 2: Enter the name of the Integration 


Enter the Name of the Integration.

You can optionally also enter a description .

And press next.

 


Step 3: Prompt for API Key


You Will be prompted for the API Key.

 

 


Step 4: Obtaining API Key


To obtain the API key, you will have to register here to obtain the API token on your email address.

 

At the bottom of the screen you will find "Request API Token" , type out necessary information and continue to your e-mail.

 

 


Step 5: Receiving Email with credentials



You will receive an email with: 

 

Developer token - The Developer-Token is only needed for requesting Grant-Access Token

 

Link to obtain your Grant-Access Token

 

Copy the developer token and click on the blue link as shown below.

 



3) Integration as Source


3.1. Get Customers



3.1.2 Filtering


 Filter by Condition

street 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

email 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

phone 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer_notes 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

CustomerCategory_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Customer_birthday 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customerr_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Customer_number 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Customer_name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Customer_company 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

vatld 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

salutation 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

title 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

zip 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

city 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 


3.1.3 Mapping


Field Name 

Type 

Constant Value 

const 

Customer_id 

number 

Customer_number 

number 

Customer_name 

text 

vatld 

text 

Customer_company 

text 

salutation 

text 

title 

text 

lastName 

text 

firstName 

text 

zip 

text 

city 

text 

street 

text 

email 

text 

phone 

text 

Customer_notes 

text 

CustomerCategory_id 

number 

Customer_birthday 

text 




3.2 Get Products





3.2.1 Filtering



 Filter By Condition

Product_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Product_externalReference 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_itemnumber 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_barcode 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_name 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_description 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_price 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Product_priceIncludesVat 

Is not set, Is set, EqualsNot Equals 

Product_vat 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Product_customPrice 

Is not set, Is set, EqualsNot Equals 

Product_customQuantity 

Is not set, Is set, EqualsNot Equals 

Product_fav 

Is not set, Is set, EqualsNot Equals 

Product_highlight 

Is not set, Is set, EqualsNot Equals 

Product_expressMode 

Is not set, Is set, EqualsNot Equals 

Product_stock_enabled 

Is not set, Is set, EqualsNot Equals 

Product_ingredients_enabled 

Is not set, Is set, EqualsNot Equals 

Product_variations_enabled 

Is not set, Is set, EqualsNot Equals 

Product_stock_value 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Product_stock_unit 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_stock_reorderLevel 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_stock_safetyStock 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Product_sortIndex 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Product_soldOut 

Is not set, Is set, EqualsNot Equals 

Product_sideDishOrder 

Is not set, Is set, EqualsNot Equals 

Product_discountable 

Is not set, Is set, EqualsNot Equals 

Product_accountingCode 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_colorClass 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_type_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Product_created_at 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_updated_at 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_alternativeNameOnReceipts 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Product_alternativeNameInPos 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Productgroup.collection.productgroup_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Productgroup.collection.productgroup_name 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Productgroup.collection.productgroup_description 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Productgroup.collection.productgroup_shortcut 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Productgroup.collection.productgroup_active 

Is not set, Is set, EqualsNot Equals 

Productgroup.collection.productgroup_sortIndex 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Productgroup.collection.productgroup_created_at 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Productgroup.collection.productgroup_updated_at 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Productgroup.collection.productgroup_type_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Productvariation.collection.variation_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Productvariation.collection.variation_name 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Productvariation.collection.variation_price 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Productvariation.collection.variation_stock 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Productingredient.collection.ingredient_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Productingredient.collection.ingredient_name 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Productingredient.collection.ingredient_unit 

Is not set, Is set, EqualsNot EqualsContainNot ContainNot In a Sequence, In a Sequence 

Productingredient.collection.ingredient_quantity 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a Sequence, Between 



3.2.2 Mapping



  Field Name Type
  Constant Value Const

Product_id 

number

Product_externalReference 

text

Product_itemnumber 

text

Product_barcode 

text

Product_name 

text

Product_description 

text

Product_price 

number

Product_priceIncludesVat 

bool

Product_vat 

number

Product_customPrice 

bool

Product_customQuantity 

bool

Product_fav 

bool

Product_highlight 

bool

Product_expressMode 

bool

Product_stock_enabled 

bool

Product_ingredients_enabled 

bool

Product_variations_enabled 

bool

Product_stock_value 

number

Product_stock_unit 

text

Product_stock_reorderLevel 

number

Product_stock_safetyStock 

number

Product_sortIndex 

number

Product_soldOut 

bool

Product_sideDishOrder 

bool

Product_discountable 

bool

Product_accountingCode 

text

Product_colorClass 

text

Product_type_id 

number

Product_created_at 

text

Product_updated_at 

text

Product_alternativeNameOnReceipts 

text

Product_alternativeNameInPos 

text
  ProductgroupCOLLECTION

Productgroup.collection.productgroup_id 

number

Productgroup.collection.productgroup_name 

text

Productgroup.collection.productgroup_description 

text

Productgroup.collection.productgroup_shortcut 

text

Productgroup.collection.productgroup_active 

bool

Productgroup.collection.productgroup_sortIndex 

number

Productgroup.collection.productgroup_created_at 

text

Productgroup.collection.productgroup_updated_at 

text

Productgroup.collection.productgroup_type_id 

number
  ProductvariationCOLLECTION

Productvariation.collection.variation_id 

number

Productvariation.collection.variation_name 

text

Productvariation.collection.variation_price 

number

Productvariation.collection.variation_stock 

number
  ProductingridientCOLLECTION

Productingredient.collection.ingredient_id 

number

Productingredient.collection.ingredient_name 

text

Productingredient.collection.ingredient_unit 

text

Productingredient.collection.ingredient_quantity 

number

3.3 Get Bills



3.3.1 Filtering


  Filter By  Condition

Invoice_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Invoice_reference_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Invoice_timestamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_number 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Invoice_numberFull 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_total 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Invoice_totalNet 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Invoice_totalVat 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Invoice_totalTip 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Invoice_address_company 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_vatld 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_salutation 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_title 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_street 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_city 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_zip 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_country 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_email 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_address_phone 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_inPrinterQueue 

Is not set, Is set, EqualsNot Equals 

Invoice_priceBase 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_deleted_at 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_deletedReason 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_pdf 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_textBeforeItemsTable 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_text 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_locked 

Is not set, Is set, EqualsNot Equals 

Invoice_externalReferenceNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_internalInvoiceReferenceNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_dueDate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_deliveryDate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_Paid 

Is not set, Is set, EqualsNot Equals 

Invoice_paidDate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Invoice_testMode 

Is not set, Is set, EqualsNot Equals 

Invoice_formatVersion 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Customer_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

CustomerCategory_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Table_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

TableArea_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

PaymentMethod_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

User_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Printer_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

BillType_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Currency_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_timestamp 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_quantity 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_retour 

Is not set, Is set, EqualsNot Equals 

Items.collection.item_number 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_serialNumber 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_expirationDate 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_comment 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_price 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_priceNet 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_priceBase 

Is not set, Is set, EqualsNot Equals 

Items.collection.item_total 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_totalNet 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_vat 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_vatRate 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_vatCompensation 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_undiscountedSumBeforeLineDiscount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_undiscountedSumBeforeInvoiceDiscount 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_lineDiscountId 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_lineDiscountGroupId 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_lineDiscountName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_lineDiscountPercent 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_lineDiscountNet 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_lineDiscountGross 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_invoiceDiscountNet 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_invoiceDiscountGross 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_discountable 

Is not set, Is set, EqualsNot Equals 

Items.collection.paymentMethod_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_updateStock 

Is not set, Is set, EqualsNot Equals 

Items.collection.product_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.productgroup_name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.productGroup_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.customer_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.user_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.user_name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.invoice_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.deliveryBill_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.dailyReport_Id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.productUnit_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.table_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.table_name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.payment_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.retourInvoice_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_accountingCode 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Items.collection.item_testMode 

Is not set, Is set, EqualsNot Equals 

Items.collection.item_product_price 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_product_priceNet 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_product_vat 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_qty 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_product_vatRate 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_product_vatCompensation 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_product_priceNetPerUnit 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_product_pricePerUnit 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Items.collection.item_product_discountable 

Is not set, Is set, EqualsNot Equals 

Address.company 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.vatId 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.salutation 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.title 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.street 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.city 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.zip 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.country 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.email 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Address.phone 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Type.billType_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Type.billType_name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Type.billType_symbol 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Payment.collection.billPayment_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Payment.collection.billPayment_name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Payment.collection.billPayment_value 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Payment.collection.payment_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Payment.collection.referenced_bill_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Discounts.collection.billDiscount_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Discounts.collection.billDiscount_name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Discounts.collection.billDiscount_value 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Discounts.collection.billDiscount_percent 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Discounts.collection.billDiscount_discount_id 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Discount.collection.billDiscount_discountGroup 

Is not set, Is set, Greater ThanLess thanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

Discounts.collection.billDiscount_created_at 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Discount.collection.billDiscount_updated_at 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 




3.3.2 Mapping


Field Name 

Type 

Constant Value 

const 

Invoice_id 

number 

Invoice_reference_id 

number 

Invoice_timestamp 

text 

Invoice_number 

number 

Invoice_numberFull 

text 

Invoice_total 

number 

Invoice_totalNet 

number 

Invoice_totalVat 

number 

Invoice_totalTip 

number 

Invoice_address_company 

text 

Invoice_address_vatld 

text 

Invoice_address_salutation 

text 

Invoice_address_title 

text 

Invoice_address_firstName 

text 

Invoice_address_lastName 

text 

Invoice_address_street 

text 

Invoice_address_city 

text 

Invoice_address_zip 

text 

Invoice_address_country 

text 

Invoice_address_email 

text 

Invoice_address_phone 

text 

Invoice_inPrinterQueue 

bool 

Invoice_priceBase 

text 

Invoice_deleted_at 

text 

Invoice_deletedReason 

text 

Invoice_pdf 

text 

Invoice_textBeforeItemsTable 

text 

Invoice_text 

text 

Invoice_locked 

bool 

Invoice_externalReferenceNumber 

text 

Invoice_internalInvoiceReferenceNumber 

text 

Invoice_dueDate 

text 

Invoice_deliveryDate 

text 

Invoice_Paid 

bool 

Invoice_paidDate 

text 

Invoice_testMode 

bool 

Invoice_formatVersion 

number 

Customer_id 

number 

CustomerCategory_id 

number 

Table_id 

number 

TableArea_id 

number 

PaymentMethod_id 

number 

User_id 

number 

Printer_id 

number 

BillType_id 

number 

Currency_id 

number 

Items 

COLLECTION 

Items.collection.item_id 

number 

Items.collection.item_timestamp 

text 

Items.collection.item_quantity 

number 

Items.collection.item_retour 

bool 

Items.collection.item_number 

text 

Items.collection.item_serialNumber 

text 

Items.collection.item_expirationDate 

text 

Items.collection.item_name 

text 

Items.collection.item_comment 

text 

Items.collection.item_price 

number 

Items.collection.item_priceNet 

number 

Items.collection.item_priceBase 

bool 

Items.collection.item_total 

number 

Items.collection.item_totalNet 

number 

Items.collection.item_vat 

number 

Items.collection.item_vatRate 

number 

Items.collection.item_vatCompensation 

text 

Items.collection.item_undiscountedSumBeforeLineDiscount 

text 

Items.collection.item_undiscountedSumBeforeInvoiceDiscount 

text 

Items.collection.item_lineDiscountId 

number 

Items.collection.item_lineDiscountGroupId 

number 

Items.collection.item_lineDiscountName 

text 

Items.collection.item_lineDiscountPercent 

text 

Items.collection.item_lineDiscountNet 

text 

Items.collection.item_lineDiscountGross 

text 

Items.collection.item_invoiceDiscountNet 

text 

Items.collection.item_invoiceDiscountGross 

text 

Items.collection.item_discountable 

bool 

Items.collection.paymentMethod_id 

number 

Items.collection.item_updateStock 

bool 

Items.collection.product_id 

number 

Items.collection.productgroup_name 

text 

Items.collection.productGroup_id 

number 

Items.collection.customer_id 

number 

Items.collection.user_id 

number 

Items.collection.user_name 

text 

Items.collection.invoice_id 

number 

Items.collection.deliveryBill_id 

number 

Items.collection.dailyReport_Id 

number 

Items.collection.productUnit_id 

number 

Items.collection.table_id 

number 

Items.collection.table_name 

text 

Items.collection.payment_id 

number 

Items.collection.retourInvoice_id 

number 

Items.collection.item_accountingCode 

text 

Items.collection.item_testMode 

bool 

Items.collection.item_product_price 

number 

Items.collection.item_product_priceNet 

number 

Items.collection.item_product_vat 

number 

Items.collection.item_qty 

number 

Items.collection.item_product_vatRate 

number 

Items.collection.item_product_vatCompensation 

text 

Items.collection.item_product_priceNetPerUnit 

number 

Items.collection.item_product_pricePerUnit 

number 

Items.collection.item_product_discountable 

bool 

Address 

COMPLEX 

Address.company 

text 

Address.vatId 

text 

Address.salutation 

text 

Address.title 

text 

Address.firstName 

text 

Address.lastName 

text 

Address.street 

text 

Address.city 

text 

Address.zip 

text 

Address.country 

text 

Address.email 

text 

Address.phone 

text 

Type 

COMPLEX 

Type.billType_id 

number 

Type.billType_name 

text 

Type.billType_symbol 

text 

Payment 

COLLECTION 

Payment.collection.billPayment_id 

number 

Payment.collection.billPayment_name 

text 

Payment.collection.billPayment_value 

text 

Payment.collection.payment_id 

number 

Payment.collection.referenced_bill_id 

number 

Discounts 

COLLECTION 

Discounts.collection.billDiscount_id 

number 

Discounts.collection.billDiscount_name 

text 

Discounts.collection.billDiscount_value 

text 

Discounts.collection.billDiscount_percent 

text 

Discounts.collection.billDiscount_discount_id 

number 

Discount.collection.billDiscount_discountGroup 

number 

Discounts.collection.billDiscount_created_at 

text 

Discount.collection.billDiscount_updated_at 

text 




3.4 Create Product Group



3.4.1 Filtering


Filter by 

Condition 

Productgroup_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot in a SequenceBetween 

Productgroup_name 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Productgroup_description 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Productgroup_shortcut 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Productgroup_active 

Is not set, Is set, EqualsNot Equals 

Productgroup_sortIndex 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot in a SequenceBetween 

Productgroup_created_at 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Productgroup_updated_at 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Productgroup_type_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot in a Sequence, Between 


3.4.2 Mapping



Field Name

Type

Constant Value 

const 

Productgroup_id 

number 

Productgroup_name 

text 

Productgroup_description 

text 

Productgroup_shortcut 

text 

Productgroup_active 

bool 

Productgroup_sortIndex 

number 

Productgroup_created_at 

text 

Productgroup_updated_at 

text 

Productgroup_type_id 

number 




3.5 Get Storno


3.5.1 Filtering


Filter By

Condition 

Storno_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot in a SequenceBetween 

Storno_name* 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Storno_description 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

Storno_created_at 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 



3.5.1 Mapping


Field Name 

Type 

Storno_id 

number 

Storno_name 

text 

Storno_description 

text 

Storno_created_at 

text 




3.6 Get Users





3.6.1 Filtering



Filter by 

Condition 

User_id 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

User_firstName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

User_lastName 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

User_username 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

User_printAccess 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

User_printer 

Is not set, Is set, Greater ThanLess ThanEqualsNot Equals, In a SequenceNot In a SequenceBetween 

User_lastActionAt 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

User_lastLoginAt 

Is not set, Is set, EqualsNot EqualsContainsNot ContainNot In a Sequence, In a Sequence 

User_trainingsMode 

Is not set, Is set, EqualsNot Equals 



3.6.2 Mapping



Field Name 

Type 

Constant Value 

const 

User_id 

number 

User_firstName 

text 

User_lastName 

text 

User_username 

text 

User_printAccess 

number 

User_printer 

number 

User_lastActionAt 

text 

User_lastLoginAt 

text 

User_trainingsMode 

bool 

loginLog 

COMPLEX 

LoginLog_lastActionAt 

text 

LoginLog_userAgent 

text 



4) Integration as Target


4.1. Create Products





4.1.1 Mapping



* = required (depending on the selected UID)

Field Name 

Type 

Product_name* 

text 

Product_price* 

number 

Product_vat* 

options 

Product_itemnumber 

text 

Product_externalReference 

text 

Productbarcode 

text 

Product_description 

text 

Product_priceIncludesVat 

bool 

Product_customPrice 

bool 

Product_customQuantity 

bool 

Product_fav 

bool 

Product_highlight 

bool 

Product_expressMode 

bool 

Product_stock_enabled 

bool 

Product_ingridients_enabled 

bool 

Product_variations_enabled 

bool 

Product_stock_value 

number 

Product_stock_unit 

text 

Product_stock_reorderLevel 

number 

Product_stock_safetyStock 

number 

Product_sortIndex 

number 

Product_soldOut 

bool 

Product_sideDishOrder 

bool 

Product_discountable 

bool 

Product_accountingCode 

text 

Product_colorClass 

text 

Productgroup_id 

options 

Product_type 

options 

Product_alternativeNameOnReceipts 

text 

Product_alternativeNameInPos 

text 

Product_active 

bool 





4.2 Create Customers

    




4.2.1 Mapping



* = required (depending on the selected UID)

Field Name 

Type 

FirstName* 

text 

LastName* 

text 

CustomerCategory_id 

options 

Customer_number 

number 

Customer_name 

text 

vatld 

text 

Customer_company 

texty 

salutation 

text 

title 

text 

zip 

text 

city 

text 

street 

text 

email 

text 

phone 

text 

Customer_notes 

text 

Customer_birthday 

text 




4.3 Create Product Group




4.3.1 Mapping



* = required (depending on the selected UID)

  Field Name  Type

Productgroup_name* 

text 

Productgroup_id 

number 

Productgroup_description 

text 

Productgroup_shortcut 

text 

Productgroup_active 

bool 

Productgroup_sortIndex 

number 



4.4 Create Storno




4.4.1 Mapping



* = required (depending on the selected UID)

Field Name 

Type 

Storno_name* 

text 

Storno_description 

text 

Storno_created_at 

text 




4.5 Create Users





4.5.1 Mapping



* = required (depending on the selected UID)

Field Name 

Type 

User_password* 

text 

User_username* 

text 

User_firstName 

text 

User_lastName 

text 

User_printAccess 

number 

User_printer 

number 

User_trainingsMade 

bool 





4.6 Create Invoice




4.5.1 Mapping



* = required (depending on the selected UID)

Field Name 

Type 

PaymentMethod_id* 

options 

User_id* 

options 

Items* 

COLLECTION 

Item_quantity 

text 

Item_name 

text 

Item_comment 

text 

Item_price 

text 

Item_vatRate 

text 

Item_priceBase 

text 

Items.Product_id 

options 

Items.Discount_id 

options 

Items.Discount_value 

text 

Items.Discount_unit 

text 

BillType_id 

options 

Printer_id 

number 

Invoice_inPrinterQueue 

number 

Invoice_textBeforeItemsTable 

text 

Invoice_text 

text 

Invoice_externalReferenceNumber 

text 

Inovice_priceBase 

text 

Invoice_testMode 

bool 

createPDF 

bool 

pdfFormat 

text 

Invoice_showRecipient 

bool 

Invoice_paid 

bool 

Invoice_dueDate 

text 

Invoice_paidDate 

Text 

Address 

COMPLEX 

Address.company 

text 

Address.vatId 

text 

Address.salutation 

text 

Address.title 

text 

Address.firstName 

text 

Address.lastName 

text 

Address.street 

text 

Address.city 

text 

Address.zip 

text 

Address.country 

options 

Address.email 

text 

Address.phone 

text 







5) Frequently used Workflows


Send Bill from ready2order to eBay 


Send Bill Type from ready2order to Dragdropr Instantshop 


Send Country from ready2order to WooCommerce 


Add Product Group from Shopify to ready2




6) Related Content


How to integrate Ready2order


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article