Get Started
Screenshot of n8n workflow
FREE TEMPLATE
Generate MySQL Product XML Feeds
8
Views
0
Downloads
13
Nodes
Download Template
Free
Preview Template
Utility Rating
6 / 10
Business Function
Operations
Automation Orchestrator
n8n
Integrations
MySQL
Trigger Type
Manual trigger
Approx setup time ≈ 25 min
Need help setting up this template?
Ask in our free Futurise community
About
Community
Courses
Events
Members
Templates

How to Generate MySQL Product XML Feeds?

Leon Petrou
FREE TEMPLATE
Generate MySQL Product XML Feeds
8
Views
0
Downloads
13
Nodes
Download Template
Free
Preview Template
Utility Rating
6 / 10
Business Function
Operations
Automation Orchestrator
n8n
Integrations
MySQL
Trigger Type
Manual trigger
Approximate setup time ≈ 25 minutes
Need help setting up this template?
Ask in our free Futurise community

Description

Turn your product table into two clean XML files in one run. Ideal for teams that need quick product feeds for partners, marketplaces, or internal checks. It saves time and keeps data consistent because it pulls straight from your database.

The flow starts on click, queries a MySQL table, and takes 16 random products as a sample. From there, it splits into two paths. One path builds a simple tag based XML file. The other creates XML with attributes for systems that need that style. Set nodes map each product field, Item Lists groups all items under a single Products parent, and XML nodes convert the data. Move Binary Data adds file names, and Write Binary File saves both outputs to disk.

To use it, you need read access to your MySQL database and a place to write files on the n8n host. Replace the sample query with your real filters and remove the random limit for production. Expect faster handoffs, fewer copy paste mistakes, and feeds that match partner needs. Great for ecommerce catalogs, reseller feeds, and quick export jobs where two different XML formats are required.

Copy link

Tools Required

n8n
Sign up
$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.
MySQL
Sign up
MySQL Community Edition (GPL) – Free ($0)

What this workflow does?

  • On click start using a manual trigger for controlled runs
  • MySQL query selects 16 random products as a sample with ORDER BY RAND and LIMIT
  • Two Set nodes standardize product fields for simple tags and for attributes
  • Item Lists groups all products under one Products parent element
  • XML conversion creates two variants, one plain and one with attributes
  • Move Binary Data assigns file names and converts JSON to binary for writing
  • Write Binary File saves outputs to the n8n host with dynamic file names
  • Inline notes explain simple XML and attribute based XML choices

What are the benefits?

  • Reduce manual export work from 60 minutes to 5 minutes by creating two XML files in one run
  • Improve data accuracy by 90 percent by exporting directly from the database
  • Support different partner needs with both tag based and attribute based XML formats
  • Handle larger catalogs without extra effort by adjusting the SQL query
  • Connect your database to file storage in a single repeatable flow

How to set this up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with MySQL. See the Tools Required section above for links to create accounts with these services.
  3. In your MySQL server, make sure you have a read only user with access to the products table and permission to run SELECT queries.
  4. Open the MySQL node in n8n, click the Credential dropdown, choose Create new credential, then follow the on screen steps to add host, port, database, user, and password.
  5. Keep the default sample query for testing. Click Execute node to confirm you receive 16 product rows. If empty, check table name and permissions.
  6. Review the two Set nodes. Confirm each field maps to your column names. Update any names that do not match your schema.
  7. Check the Item Lists nodes. Ensure destination field name is Products so the XML has a single parent element.
  8. Open each XML node. The top branch makes simple tags. The lower branch uses attributes. Keep these settings unless a partner needs a different structure.
  9. Open both Move Binary Data nodes and confirm file names simple.xml and intermediate.xml. Adjust names if your partners require specific file names.
  10. Open the Write Binary File node. Confirm the path points to a writable folder on your n8n host, for example /home/node/.n8n. If you see permission errors, change the path or update folder permissions.
  11. Run the whole workflow. Check the execution data for two binary items and verify that both files appear on disk. Open the files to confirm valid XML structure.
  12. If the query needs full catalog export, remove ORDER BY RAND and LIMIT. Consider adding WHERE filters for status or stock to control output size.

Need help or want to customize this?

Ask in the Free Futurise Community.

Similar Templates

n8n
Operations
Automate MySQL Data Cleanup Alerts
Keep your databases lean without manual work. The automation clears old received package records on a schedule and sends a Telegram message so your team knows the job is done. It suits operations teams that need clean data and quick updates. Under the hood, a daily schedule at 8 AM runs two SQL update jobs, one for each MySQL database. You can also start it by clicking execute or by calling a webhook for on demand runs. After each database is cleaned, a Telegram message posts to your team chat to confirm the action. The flow connects a cron schedule, a webhook, two MySQL queries, and two Telegram messages. The result is faster queries, less storage waste, and clear visibility for your team. To set it up, you need access to both MySQL databases and a Telegram bot added to your group. Expect to cut manual cleanup time from hours to minutes and keep systems running smoothly. It works well for warehouses, ecommerce, and logistics teams that manage many package entries and need routine data hygiene with clear proof of completion.
6 views
view
n8n
Operations
Automate MySQL and PostgreSQL Label Printing
Speed up warehouse label work by pulling roll data and product grade details into one clean payload. A simple POST request starts the flow and returns ready to print data. Operations and inventory teams can issue labels faster with fewer errors. The flow begins with a webhook that receives the request. It then fetches print settings from a config service, collects roll details from PostgreSQL, and loads product grade data from MySQL. A function prepares the input, and a merge step ties both datasets together using the movement detail id. The response returns only after the merge completes, so your label app gets one consistent dataset. Setup needs access to both databases and a reachable config endpoint. Expect faster label runs, lower error rates, and less copy paste. Great for cutting rooms, receiving, and production lines where rolls are tracked and labeled often.
13 views
view
n8n
Operations
Connect MySQL Data Insights
Turn a simple chat into a safe way to ask questions about your MySQL data. Team members type a question, the system suggests SQL, runs it when needed, and returns a clear answer with results. It is made for operations and data teams that want fast answers without writing queries by hand. Under the hood, a one time setup loads all table names and column details from MySQL, then saves that schema to a local JSON file for speed. Each chat message reads the schema file, adds your question, and sends both to an AI Agent powered by OpenAI. The agent forms a reply and, when needed, generates a SQL statement. A regex pulls the SQL from the reply. If a query exists, the workflow runs it on MySQL, formats the rows, and shows both the text answer and the table result in the chat. You need an OpenAI key and a MySQL database with proper access. Run the schema build once, then use the chat to explore. Expect faster self service reporting, fewer back and forth requests, and clearer answers. Great for daily checks, ad hoc analysis, and quick lookups across sales, support, finance, and operations.
12 views
view
See More Templates

These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.