elastic.io Shopware component supports several trigger functions which can be used to query the customer, order and product data from your Shopware instance.

The triggers are:


Query Customers

Before using any listed trigger Shopware account needs to be added. If you have done the account authentication process then here you can just select your added account. If not you can start the process of adding account from here as well.

Customers to get: has 3 options of getting list of customers. Please note that for obvious reasons your Shopware instance should already have customers for this to work.

  1. All customers - this option does exactly as it says.
  2. New customers (without External ID) - this options can be used to get the list of new customers which are not yet synced with any other system, hence without any External ID.
  3. Update Customers (with external ID) - this option is used when already synced customer data needs to be requested, hence the data of customers which have External ID due to syncing.

Customers per request: This option can be used to query customer data in batches of 20, 50, 100, 200, 500, 1000 per request.

Query Customers trigger sends information in 67 unique fields. During the initial export all customers will be exported, after the initial export all the consecutive runs would only export new or updated customer information.

General properties : Id, Group Key, Shop Id, Active Flag, Email, Newsletter opt-in, Referer, Internal Comment, Account Mode, External ID

billing : Billing Company, Billing Country ID, Billing Country ISO, Billing Country Name, Billing Department, Billing Salutation, Billing Number, Billing First Name, Billing Last Name, Billing Street, Billing Street Number, Billing Zip Code, Billing City, Billing Phone, Billing Fax, Billing Vat Id, Billing Birthday, Billing Birthday (YYYY-MM-DD)

shipping : Shipping Company, Shipping Country ID, Shipping Country ISO, Shipping Country Name, Shipping Department, Shipping Salutation, Shipping First Name, Shipping Last Name, Shipping Street, Shipping Street Number, Shipping Zip Code, Shipping City

addresses : Addresses[] -> Address type, Addresses[] -> Company, Addresses[] -> Country ID, Addresses[] -> Country ISO, Addresses[] -> Country Name, Addresses[] -> Department, Addresses[] -> Salutation, Addresses[] -> Number, Addresses[] -> First Name, Addresses[] -> Last Name, Addresses[] -> Street, Addresses[] -> Street Number, Addresses[] -> Zip Code, Addresses[] -> City, Addresses[] -> Phone, Addresses[] -> Fax, Addresses[] -> Vat Id

debit : Debit Account, Debit Bank Code, Debit Bank Name, Debit Account Holder

These fields then can be mapped with the next component fields be that just a simple e-mail component or extensive list of fields in some ERP.


Query Newsletter Subscribers

This trigger is used to query the details of Newsletter subscribers in your Shopware store. To set up this trigger we would only need the details of Shopware instance account:

This trigger would export data in 9 fields from which only Id is required:

properties: Id, Email, First Name, Last Name, Salutation, Is Customer, Group ID, Last Newsletter ID, Last Read ID


Query Orders

This trigger is used to query the details of all orders in your Shopware instance. To use this trigger it is required to provide the credentials for the Shopware instance.

It is also possible to filter and query only those orders which have already an External ID by choosing orders to get. This is useful if you would like to setup your flow in a way to get those orders which have already a record say in your ERP or CRM software.

It is also possible to request the data in batches of 20, 50, 100, 200, 500, 1000 per request if there is some network or request limitation at your Shopware instance.

The output from this request can return an information in ,pre than 70 unique fields depending on the actual setup of your Shopware instance. Here are the field that Query Orders trigger is able to return:

General properties : Id, Number, Customer Id, Payment Id, Dispatch Id, Partner Id, Shop Id, Invoice Amount, Invoice Amount Net, Invoice Shipping, Invoice Shipping Net, Order Time, Transaction Id, Comment, Customer Comment, Internal Comment, Net, TaxFree, Temporary Id, Referer, Cleared Date, Tracking Code, Language Id, Currency, Currency Factor, Remote Address, Documents, payment, shop

details : Details[] -> Article ID, Details[] -> Article Name, Details[] -> Article Number, Details[] -> Article Price, Details[] -> Article Quantity, Details[] -> Article External Id, Details[] -> Tax Rate, Details[] -> EAN, Details[] -> Unit, Details[] -> Pack Unit

paymentStatus : Payment Status Id, Payment Status

orderStatus : Order Status Id, Order Status

customer : Customer -> Id, Customer -> Email, Customer -> External ID, Customer -> Group Key, Customer -> Account Mode

billing : Billing Company, Billing Department, Billing Salutation, Billing Number, Billing First Name, Billing Last Name, Billing Street, Billing Street Number, Billing Zip Code, Billing City, Billing Phone, Billing Fax, Billing Vat Id, Billing country code, Billing country name

shipping : Shipping Company, Shipping Department, Shipping Salutation, Shipping First Name, Shipping Last Name, Shipping Street, Shipping Street Number, Shipping Zip Code, Shipping City, Shipping country code, Shipping country name


Query Products

This trigger can be used to query all of your products from the Shopware instance. For this trigger to work only the credentials part is required.

This tigger can return data in 54 unique fields. The supported field are the following:

General properties : Article Id, Main Detail Id, Tax Id, Name, Description, Description Long, Added date, Pseudo Sales, Highlight flag, Keywords, Meta Title, Changed date, Last Stock flag, Available From, Available To

Variant Id, Number, Kind, Additional Text, Active flag, In Stock Count, Stock Min, Weight, Width, Len, Height, Ean, Position, Purchase Unit, Reference Unit, Pack Unit, Shipping Free flag, Release Date, Shipping Time, Prices JSON string

tax : Tex Id, Tax rate, Tax Name

supplier : Supplier Id, Supplier Name, Supplier Image, Supplier Link, Supplier Description, Supplier Meta Title, Supplier Meta Description, Supplier Meta Keywords

defaultPrice : Default Price Id, Default Price From, Default Price To, Default Price Price, Default Price Pseudo Price, Default Price Base Price, Default Price Percent