JSON in Mergado#
In Mergado, the most commonly used file formats are XML and CSV. However, the Editor also accepts JSON, TSV, and TXT. It may happen that a supplier provides a JSON feed and you need to upload it to Mergado. If the JSON does not load or returns an error when creating a project, the most common cause is an incorrect format or content of the feed.
What is JSON?#
JSON is a lightweight text format for data exchange. It is human-readable and at the same time easily processed by programs — a universal language for passing structured data between systems.
What should a JSON feed look like?#
To be able to upload a JSON feed URL into Mergado, it needs to be a list (array) of objects.
Example of a prepared and valid JSON array with two items:
[
{
"ITEM_ID": "342",
"AVAILABILITY": "preorder",
"URL": "https://wp533.mergadoshop.com/produkt/woocommerce-simple-product-test/",
"NAME_EXACT": "WooCommerce Simple product TEST",
"CURRENCY": "EUR",
"VAT": "21",
"PRICE": "0.068302",
"PRICE_VAT": "0.08",
"IMAGE": "https://wp533.mergadoshop.com/wp-content/uploads/2020/06/tricko-nastvany-bily-tygr-white-edition.jpg",
"PARAM": [
{
"NAME": "Size",
"VALUE": "SM | S | M | L"
},
{
"NAME": "EAN",
"VALUE": "ean222"
},
{
"NAME": "Ear accessories",
"VALUE": "Second property, example"
}
],
"STOCK_QUANTITY": "0",
"DESCRIPTION_SHORT": "[WCMC]",
"CATEGORY": "Pillows",
"CATEGORY_ALTERNATIVE": [
"Uncategorized",
"Tea, coffee"
],
"PRODUCTNO": "SKU01-6",
"VISIBILITY": "public",
"CATALOG_VISIBILITY": "visible"
},
{
"ITEM_ID": "11089",
"AVAILABILITY": "in stock",
"URL": "https://wp533.mergadoshop.com/produkt/voyage-451-mikina-damska/?attribute_pa_barva=cerna&attribute_pa_varianta=xs",
"NAME_EXACT": "Voyage 451 Women's Sweatshirt - black, XS",
"CURRENCY": "EUR",
"VAT": "21",
"PRICE": "650",
"PRICE_VAT": "786.5",
"IMAGE": "https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_01_cw600.jpg",
"PARAM": [
{
"NAME": "Color",
"VALUE": "black"
},
{
"NAME": "Variant",
"VALUE": "XS"
}
],
"STOCK_QUANTITY": "156",
"DESCRIPTION": "slightly fitted cut with side seams\nfull-zip metal zipper\nzipper pull with engraved logo\nlined hood with drawstring\ninner neckline finished with tape\nraglan sleeves with decorative stitching\nkangaroo-style patch pockets\nbottom hem and sleeve cuffs made of 2:2 rib knit with 5% elastane\ncontrast details\ninner side unbrushed slightly fitted cut with side seams\\nfull-zip metal zipper\\nzipper pull with engraved logo\\nlined hood with drawstring\\ninner neckline finished with tape\\nraglan sleeves with decorative stitching\\nkangaroo-style patch pockets\\nbottom hem and sleeve cuffs made of 2:2 rib knit with 5% elastane\\ncontrast details\\ninner side unbrushed",
"DESCRIPTION_SHORT": "Fill knit fabric, inner side unbrushed\n100% cotton (color 12 - composition may vary - 85% cotton, 15% viscose)",
"CATEGORY": "Uncategorized",
"VISIBILITY": "public",
"CATALOG_VISIBILITY": "visible",
"IMAGE_ALTERNATIVE": [
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_01_aw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_01_bw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_01_cw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_01_aw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_01_bw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_02_cw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_02_aw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_02_bw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_12_cw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_12_aw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_12_bw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_71_cw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_71_aw600.jpg",
"https://wp533.mergadoshop.com/wp-content/uploads/2025/03/451_71_bw600.jpg"
],
"SHIPPING_WEIGHT": "500 g",
"ITEMGROUP_ID": "11088",
"VARIANT_DESCRIPTION": "slightly fitted cut with side seams\\nfull-zip metal zipper\\nzipper pull with engraved logo\\nlined hood with drawstring\\ninner neckline finished with tape\\nraglan sleeves with decorative stitching\\nkangaroo-style patch pockets\\nbottom hem and sleeve cuffs made of 2:2 rib knit with 5% elastane\\ncontrast details\\ninner side unbrushed"
}
]Practical examples#
- You have a JSON from a supplier and Mergado does not load it when creating a project → check whether it is a list of objects in the format shown above.
- Your project output needs to be XML, but your JSON contains element names that are not valid for XML (e.g. they start with a number or contain spaces) → these elements need to be hidden in the project if the goal is XML output.
Tips#
- Native JSON formats that Mergado supports (currently only Shopify) do not need to follow the format described above.
- Need to convert a different JSON (or any file in general) into the required list-of-objects format? This can often be done via the Blending Bull extension.
- JSON, like CSV, may contain element names that are invalid for XML — if your target is XML output, hide them in the project.
FAQ#
Can I use a JSON feed in Mergado?#
Yes. In addition to XML and CSV, the Editor also supports JSON, TSV, and TXT.
What is the most common reason a JSON feed fails to load?#
A format or content that does not match the requirements.
How must the JSON be structured for it to be uploadable?#
As a list (array) of objects: [ { …product_1… }, { …product_2… } ].
Does this format apply to all “native” JSONs?#
No. Native JSON formats in Mergado (currently only Shopify) do not need to follow it.
I have a different JSON — how do I convert it to the required format?#
This can often be done using the Blending Bull extension.
What if the JSON contains names that are unsuitable for XML?#
If your output is XML, hide elements in the project that are invalid for XML (e.g. they start with a number or contain spaces).