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, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence | |
phone | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer_notes | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
CustomerCategory_id | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Customer_birthday | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customerr_id | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Customer_number | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Customer_name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Customer_company | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
vatld | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
salutation | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
title | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
zip | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
city | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not 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 |
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 Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Product_externalReference | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_itemnumber | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_barcode | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_name | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_description | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_price | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Product_priceIncludesVat | Is not set, Is set, Equals, Not Equals |
Product_vat | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Product_customPrice | Is not set, Is set, Equals, Not Equals |
Product_customQuantity | Is not set, Is set, Equals, Not Equals |
Product_fav | Is not set, Is set, Equals, Not Equals |
Product_highlight | Is not set, Is set, Equals, Not Equals |
Product_expressMode | Is not set, Is set, Equals, Not Equals |
Product_stock_enabled | Is not set, Is set, Equals, Not Equals |
Product_ingredients_enabled | Is not set, Is set, Equals, Not Equals |
Product_variations_enabled | Is not set, Is set, Equals, Not Equals |
Product_stock_value | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Product_stock_unit | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_stock_reorderLevel | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_stock_safetyStock | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Product_sortIndex | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Product_soldOut | Is not set, Is set, Equals, Not Equals |
Product_sideDishOrder | Is not set, Is set, Equals, Not Equals |
Product_discountable | Is not set, Is set, Equals, Not Equals |
Product_accountingCode | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_colorClass | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_type_id | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Product_created_at | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_updated_at | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_alternativeNameOnReceipts | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Product_alternativeNameInPos | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Productgroup.collection.productgroup_id | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Productgroup.collection.productgroup_name | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Productgroup.collection.productgroup_description | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Productgroup.collection.productgroup_shortcut | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Productgroup.collection.productgroup_active | Is not set, Is set, Equals, Not Equals |
Productgroup.collection.productgroup_sortIndex | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Productgroup.collection.productgroup_created_at | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Productgroup.collection.productgroup_updated_at | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Productgroup.collection.productgroup_type_id | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Productvariation.collection.variation_id | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Productvariation.collection.variation_name | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Productvariation.collection.variation_price | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Productvariation.collection.variation_stock | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Productingredient.collection.ingredient_id | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Productingredient.collection.ingredient_name | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Productingredient.collection.ingredient_unit | Is not set, Is set, Equals, Not Equals, Contain, Not Contain, Not In a Sequence, In a Sequence |
Productingredient.collection.ingredient_quantity | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not 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 |
Productgroup | COLLECTION |
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 |
Productvariation | COLLECTION |
Productvariation.collection.variation_id | number |
Productvariation.collection.variation_name | text |
Productvariation.collection.variation_price | number |
Productvariation.collection.variation_stock | number |
Productingridient | COLLECTION |
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 Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Invoice_reference_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Invoice_timestamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_number | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Invoice_numberFull | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_total | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Invoice_totalNet | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Invoice_totalVat | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Invoice_totalTip | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Invoice_address_company | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_vatld | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_salutation | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_title | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_street | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_city | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_zip | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_country | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_email | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_address_phone | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_inPrinterQueue | Is not set, Is set, Equals, Not Equals |
Invoice_priceBase | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_deleted_at | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_deletedReason | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_pdf | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_textBeforeItemsTable | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_text | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_locked | Is not set, Is set, Equals, Not Equals |
Invoice_externalReferenceNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_internalInvoiceReferenceNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_dueDate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_deliveryDate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_Paid | Is not set, Is set, Equals, Not Equals |
Invoice_paidDate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Invoice_testMode | Is not set, Is set, Equals, Not Equals |
Invoice_formatVersion | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Customer_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
CustomerCategory_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Table_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
TableArea_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
PaymentMethod_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
User_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Printer_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
BillType_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Currency_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_timestamp | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_quantity | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_retour | Is not set, Is set, Equals, Not Equals |
Items.collection.item_number | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_serialNumber | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_expirationDate | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_comment | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_price | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_priceNet | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_priceBase | Is not set, Is set, Equals, Not Equals |
Items.collection.item_total | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_totalNet | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_vat | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_vatRate | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_vatCompensation | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_undiscountedSumBeforeLineDiscount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_undiscountedSumBeforeInvoiceDiscount | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_lineDiscountId | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_lineDiscountGroupId | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_lineDiscountName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_lineDiscountPercent | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_lineDiscountNet | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_lineDiscountGross | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_invoiceDiscountNet | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_invoiceDiscountGross | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_discountable | Is not set, Is set, Equals, Not Equals |
Items.collection.paymentMethod_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_updateStock | Is not set, Is set, Equals, Not Equals |
Items.collection.product_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.productgroup_name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.productGroup_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.customer_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.user_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.user_name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.invoice_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.deliveryBill_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.dailyReport_Id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.productUnit_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.table_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.table_name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.payment_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.retourInvoice_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_accountingCode | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Items.collection.item_testMode | Is not set, Is set, Equals, Not Equals |
Items.collection.item_product_price | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_product_priceNet | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_product_vat | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_qty | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_product_vatRate | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_product_vatCompensation | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_product_priceNetPerUnit | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_product_pricePerUnit | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Items.collection.item_product_discountable | Is not set, Is set, Equals, Not Equals |
Address.company | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.vatId | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.salutation | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.title | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.street | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.city | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.zip | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.country | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.email | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Address.phone | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Type.billType_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Type.billType_name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Type.billType_symbol | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Payment.collection.billPayment_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Payment.collection.billPayment_name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Payment.collection.billPayment_value | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Payment.collection.payment_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Payment.collection.referenced_bill_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Discounts.collection.billDiscount_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Discounts.collection.billDiscount_name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Discounts.collection.billDiscount_value | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Discounts.collection.billDiscount_percent | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Discounts.collection.billDiscount_discount_id | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Discount.collection.billDiscount_discountGroup | Is not set, Is set, Greater Than, Less than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
Discounts.collection.billDiscount_created_at | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Discount.collection.billDiscount_updated_at | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not 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 Than, Less Than, Equals, Not Equals, In a Sequence, Not in a Sequence, Between |
Productgroup_name | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Productgroup_description | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Productgroup_shortcut | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Productgroup_active | Is not set, Is set, Equals, Not Equals |
Productgroup_sortIndex | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not in a Sequence, Between |
Productgroup_created_at | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Productgroup_updated_at | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Productgroup_type_id | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not 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 Than, Less Than, Equals, Not Equals, In a Sequence, Not in a Sequence, Between |
Storno_name* | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Storno_description | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
Storno_created_at | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not 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 Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
User_firstName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
User_lastName | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
User_username | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
User_printAccess | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
User_printer | Is not set, Is set, Greater Than, Less Than, Equals, Not Equals, In a Sequence, Not In a Sequence, Between |
User_lastActionAt | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
User_lastLoginAt | Is not set, Is set, Equals, Not Equals, Contains, Not Contain, Not In a Sequence, In a Sequence |
User_trainingsMode | Is not set, Is set, Equals, Not 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 |
Product_ barcode | 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 |
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
Feedback sent
We appreciate your effort and will try to fix the article