What is the Mergado Orders extension?#

Mergado Orders is an extension for automatically retrieving order data from online stores running on the Eshop-rychle.cz platform. It processes this data into a machine-readable format (CSV feed) for further use. The main strength of the extension lies in the subsequent processing of data in Mergado Editor.

The extension is ideal for:

Online marketers and agencies who need to work efficiently with customer data directly in Mergado Editor, for example for more precise ad targeting or advanced segmentation.
Marketers working with dynamic ad campaigns (Sklik, Google Ads, etc.).
Agencies managing online stores running on Eshop-rychle.cz.

Currently, the extension only supports online stores running on the Eshop-rychle.cz platform. If you run an online store on a different platform and would be interested in support for it, let us know via Mergado support.

Pricing and billing#

Using the Mergado Orders extension is completely free for Mergado Editor users and is available with no additional charges.

Use of the extension is tied to one online store in Mergado and is free regardless of the volume of data downloaded.

Since the extension is free, it has no trial period.

Data aggregation – The way order data is grouped in the resulting export (CSV feed).
- Aggregation by email – Each row in the export represents one unique customer with aggregated purchase statistics, address, and a list of purchased products.
- Aggregation by products – Statistics focused on the sales performance of individual items.
- Aggregation by days (time period) – Aggregated statistics on the online store’s performance by individual day.
Aggregation days – The time period (7, 30, 90, 180, or 360 days) for which the extension downloads data retroactively.
CSV feed – The output file (export) containing the data, which serves as a source for Mergado Editor or other tools.

What you need to start using Mergado Orders#

A user account in Mergado Editor.
An online store running on the Eshop-rychle.cz platform.
The API URL, which you can find in the Eshop-rychle admin.

How to get the orders API URL from the Eshop-rychle admin#

Log in to the Eshop-rychle admin.
In the top menu, click the Online store section.
In the left menu, select the Export section.
At the bottom of the page under the API heading, you will find the URL you need — URL with orders. Make sure you have the Enable orders API option checked.

Key features#

Automatic order data download – The extension automatically downloads data from Eshop-rychle via API for the selected time period. Data can be structured by customer (email), products, or time period.
Export to CSV feed – Data is generated into a clear file ready for further processing in other tools such as Mergado Editor and PPC Wolf, Google Sheets and Looker Studio, or for sending to ad platforms (Sklik, Google Ads).
Advanced segmentation – Exports include data such as the customer’s email, list of purchased products, number of orders in the given period, total spend, customer type (business/individual), and more. This allows you to segment customers by spend, location, type, or purchased products.
Integration with other tools – Easy data transfer to PPC Wolf for creating audiences in Sklik and Google Ads, or import to Google Sheets and Looker Studio.
Data updates – Data is downloaded to storage at midnight and output files are automatically updated every day at 8:00 AM.
Security – Option to restrict feed downloads to Mergado systems only (restricted to a specific IP address) to protect sensitive customer data.

Working in Mergado Orders#

You can activate the extension in the Mergado Store: I want to activate → select the online store for which you want to enable the extension → Enable.

In the Mergado Orders extension interface, you will see the Connections overview page, where you can see all your created exports. For each export, you can use the relevant icons to edit the export, copy the export URL, open it, refresh data, delete it, or click the Mergado logo icon to be redirected straight to creating a new project.

On the Connections overview page, you will also find the New connection button, which starts the process of creating a new data export.

How to create a connection to Eshop-rychle for downloading data?#

In the extension interface, click New connection.
Enter a Name for the connection.
Choose the Aggregation type:
- Email – For sorting data by customer (email)
- Product – For sorting data by individual products
- Day – For statistical data sorted by individual days
In the Aggregation days field, choose the time period for which data should be downloaded (7, 30, 90, 180, or 360 days).
Optionally check Restrict feed access to the Mergado system only to protect downloaded data (recommended especially when working with sensitive data, e.g. customer data).
Enter the API URL, which you obtain from the Eshop-rychle admin.
Save by clicking Create.

How to understand the data and elements from Mergado Orders#

Mergado Orders exports data as a CSV file, so data is organized into clear columns by individual elements. For all export types, you can select the time period for which data should be downloaded in settings (7, 30, 90, 180, or 360 days).

You also choose by which criterion you want to sort the data in settings:

1. Export by customer email (segmentation and retargeting)#

This export type is key for creating marketing audiences. Each row represents one unique customer, whose email is linked to all purchase statistics and address data.

EMAIL – The email address used to place the order. Serves as the primary identifier for matching in Mergado Editor and subsequent export to PPC platforms.
VAT_ID – The customer’s VAT number. If this element is filled in, the customer is a business customer (B2B).
BILLING_CITY – City from the billing address. Ideal for geographic campaign targeting.
BILLING_COUNTRY – Country from the billing address. Ideal for geographic campaign targeting.
SHIPPING_CITY – City from the delivery address. Ideal for segmentation by actual delivery location (e.g. local campaigns).
SHIPPING_COUNTRY – Country from the delivery address. Ideal for segmentation by actual delivery location (e.g. local campaigns).
CONVERSIONS_ITEMS – List of purchased products. If a customer bought multiple items, they are separated by commas in the cell. This element is key for cross-sell campaigns (e.g. offering accessories for an already purchased product).
CONVERSIONS_VALUE_VAT – Total value of the customer’s orders including VAT.
CONVERSIONS_VALUE – Total value of the customer’s orders excluding VAT.
CONVERSIONS_QUANTITY – Number of product units the customer purchased in the selected period. Helps identify bulk buyers.

2. Export by products (sales performance statistics)#

This export serves to analyse how well specific products from your online store are performing. You can see which products sold, in what quantities, and at what values during the selected period.

ITEM_ID – Unique product identifier as recorded in the Eshop-rychle system.
CONVERSIONS – Number of unique orders containing the given product.
UNITS_SOLD – Total number of units sold of the given product.
ITEM_VALUE – Product price excluding VAT.
ITEM_VALUE_VAT – Product price including VAT.
CONVERSIONS_VALUE – Total revenue generated by this product excluding VAT.
CONVERSIONS_VALUE_VAT – Total revenue generated by this product including VAT.

3. Export by days / time period (online store performance over time)#

This export type provides aggregated statistics on the online store’s order performance day by day. You can see how many products were sold on a given day and at what values — ideal for importing into reporting tools like Google Sheets or Looker Studio.

DATE – The date the statistics relate to.
CONVERSIONS – Total number of orders placed on the given day.
CONVERSIONS_VALUE – Sum of the values of all orders for the given day excluding VAT.
CONVERSIONS_VALUE_VAT – Sum of the values of all orders for the given day including VAT.

Practical tips for marketers#

Identifying VIP customers – Using the CONVERSIONS_VALUE_VAT element (in the customer export), you can create a query in Mergado Editor for customers with spend above e.g. 5,000 CZK and offer them a special loyalty discount.
B2B campaigns – By setting the condition “VAT_ID is not empty” in a query, you instantly get a list of business customers for targeted communication.
GDPR notice – When using the EMAIL element for retargeting campaigns, always use only data from customers who have consented to ad personalization.

FAQ#

What is Mergado Orders and what is it used for?#

Mergado Orders is a free Mergado Editor extension that automatically downloads order data from online stores running on the Eshop-rychle.cz platform and converts it into a CSV feed for further use — for example for customer segmentation or retargeting campaigns.

Who is the extension suitable for?#

Primarily for online marketers and agencies managing online stores on the Eshop-rychle.cz platform who want to work with customer data in Mergado Editor — for example to create audiences in ad platforms like Sklik or Google Ads.

Does Mergado Orders work with online store platforms other than Eshop-rychle.cz?#

Currently, the extension only supports the Eshop-rychle.cz platform. If you’re interested in support for another platform, let us know via Mergado support.

How much does Mergado Orders cost?#

The extension is completely free for Mergado Editor users, regardless of the volume of data downloaded.

How do I activate the extension?#

Activate the extension in the Mergado Store by clicking “I want to activate”, then select the online store for which you want to enable the extension and confirm by clicking “Enable”.

Where do I find the API URL for connecting to Eshop-rychle?#

In the Eshop-rychle admin, go to Online store → Export → API section (bottom of the page). Make sure the “Enable orders API” option is checked and copy the URL with orders.

What are “aggregation days” and how should I set them?#

Aggregation days determine the time period for which the extension downloads data retroactively (options are 7, 30, 90, 180, or 360 days). Adjust the choice to your purpose — for short-term campaigns 30 days is sufficient, for analysing VIP customers or seasonal trends 180 or 360 days is more appropriate.

Why should I restrict feed access to the Mergado system only?#

This setting restricts feed downloads to Mergado’s IP address, protecting sensitive customer data from unauthorized access. Recommended especially for email-type exports, which contain personal customer data.

How often is data in the extension updated?#

Data is downloaded to storage every night at midnight. Output files (CSV feeds) are then automatically updated every day at 8:00 AM.

What types of exports can I create in the extension?#

The extension offers three data aggregation types: by customer email (for segmentation and retargeting), by products (for sales performance analysis), and by days (for tracking online store performance over time).

Can I have multiple exports with different settings?#

Yes, in the connections overview you can create any number of exports with different aggregation types or different time periods.

What specifically can I use data from Mergado Orders for?#

Data can be used to create retargeting audiences for campaigns in Sklik or Google Ads (using the PPC Wolf extension), to segment customers by spend, location, or purchased products, or to track sales statistics in Google Sheets or Looker Studio.

How do I get data from Mergado Orders into Google Sheets or Looker Studio?#

Copy the export URL from the connections overview and paste it into Google Sheets using the =importdata("URL") function. You can then easily connect the data from Google Sheets to Looker Studio. See the detailed guide How to add actual sales statistics from Mergado Orders to Google Sheets or Looker Studio.

How can I use data for retargeting campaigns?#

Create an export with aggregation type Email, transfer the data to Mergado Editor, and use the PPC Wolf extension to send customer audiences to Sklik or Google Ads. See the detailed guide How to send data from Mergado Orders to Sklik and Google Ads.