Visser Labs – WooCommerce Plugins
  1. Home
  2. Knowledge Base
  3. WooCommerce Store Exporter Deluxe
  4. How to export WooCommerce data to RSS
  1. Home
  2. Knowledge Base
  3. File Formats
  4. How to export WooCommerce data to RSS

How to export WooCommerce data to RSS

Some systems only accept data as an RSS-style XML feed, and a spreadsheet won’t do. You can’t pick that format on the Quick Export screen, so it’s easy to assume the plugin doesn’t offer it. Store Exporter Deluxe does, as RSS 2.0, through Scheduled Exports.

You’ll set the feed header, create a scheduled export in RSS 2.0, check what the file contains, and open it. One thing to know up front: the file is a structured data feed, not a blog-style feed. It holds one <item> per record, with one element per export field, and it isn’t built for subscribing to in a feed reader.

Prerequisites

RequirementDetails
PluginStore Exporter Deluxe 5.4.4 or later, active and licensed
WooCommerceActive, with at least one record of the type you want to export
Administrator accessYou’ll need an account with access to the WordPress admin dashboard

RSS 2.0 isn’t one of the File Format tiles on the Quick Export screen, and it isn’t offered in Export Templates. It appears only in the Export Format dropdown when you create or edit a scheduled export, as described below.

Step 1: Set the RSS feed header (optional)

Every RSS file starts with a header that describes the feed as a whole. You set it once, and it applies to every RSS export.

  1. Open WooCommerce → Store Export from the WordPress admin menu.
  2. In the sidebar, click Settings under the SYSTEM group.
  3. Open the Export Formats section.
  4. Find the RSS Format card, which holds the feed header fields.
  5. Type a name for the feed into Title Element, for example “Product export for My Store”.
  6. Type your website address into Link Element. It doesn’t have to be the location of the feed itself.
  7. Type a short summary into Description Element.
  8. Click Save Changes.
The RSS Format card in Settings with Title Element, Link Element, and Description Element filled in

If you skip this step, the export still works. The header’s title, link, and description are just left empty. See the troubleshooting section below if a system you feed the file into rejects that.

Step 2: Create a scheduled export

  1. Open WooCommerce → Store Export, then click Scheduled Exports in the EXPORTS group of the sidebar.
  2. If the screen says scheduled exports are currently disabled, click Enable Scheduled Exports first.
  3. Click New Schedule.
  4. On the General step, enter a name in the Schedule Name field. This name only appears in your WordPress admin.
  5. Choose what to export from the Export Type dropdown. RSS 2.0 is available for any type in the list.
  6. Choose RSS 2.0 from the Export Format dropdown.
  7. Under Export Fields, choose All Fields, Use Template, or Saved Selection.
The General step of the Add New Scheduled Export wizard with Export Format set to RSS 2.0

The rest of the wizard works the same as for any other format:

  • Filters: narrows what’s exported. Skip it to export every record of the chosen type.
  • Method: chooses where the file goes: Archive to Media, Save to Server, Send as Email, POST to URL, or FTP / SFTP. RSS isn’t tied to one delivery method. Pick Archive to Media for your first run, because it’s the easiest way to check the file.
  • Scheduling: sets how often the export runs.
  • Advanced: sets per-schedule options such as the log level.

Click Create Schedule to save it.

For detailed instructions on every step, see How to schedule exports in Store Exporter Deluxe.

Step 3: Run the export

  1. On the Scheduled Exports screen, find your schedule in the list.
  2. Click the three-dot menu in the Action column of its row.
  3. Click Execute Now.
The row menu on the Scheduled Exports screen open, with Execute Now highlighted

The export runs in the background. Once it finishes, click Archives in the EXPORTS group of the sidebar. Runs recorded in the audit log appear under Export History. An Execute Now run shows Manual Run as the trigger, with the schedule’s name below it. Any others appear under Legacy Archives, further down the page. Click Download on the row to save the file. It ends in .xml.

The Archives screen with the RSS export listed under Export History as a Manual Run and its Download link on the right of the row

What the file looks like

The file is RSS 2.0 XML. A Products export looks like this, trimmed to a few fields:

<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
  <channel>
    <title>Product export for My Store</title>
    <link>https://example.com</link>
    <description>Daily product feed for My Store</description>
    <item>
      <productid>226</productid>
      <productname>Yoga Studio Session</productname>
      <slug>yoga-studio-session</slug>
      <description>&lt;p&gt;Book a 60-minute yoga session at our studio.&lt;/p&gt;</description>
      <category><![CDATA[Uncategorized]]></category>
    </item>
  </channel>
</rss>

Here’s how the file is put together:

  • One item per record: each product, order, customer, or other record becomes its own <item>.
  • One element per field: each field becomes a child element named after its column label, lowercased with spaces and most symbols removed. So Product Name becomes productname.
  • Field names, not feed names: items don’t carry the standard RSS <title>, <link>, <pubDate>, or <guid> elements. The <description> element holds the product’s Description field, not a feed summary.
  • Special characters are escaped: characters such as < and & are escaped so the file stays valid XML. Product categories are written as CDATA.
  • The header comes from Step 1: the channel’s <title>, <link>, and <description> hold what you typed under RSS Format in Settings → Export Formats.
  • The output is indented: the file uses indentation and line breaks, so it’s easy to read.

The g namespace in the first line is part of every RSS export, but the plugin doesn’t write Google’s product feed fields. Don’t expect the file to work as a ready-made Google Merchant Center feed.

Format-specific options

RSS exports use fewer options than other formats. Here’s what applies and what doesn’t:

SettingApplies to RSS?Details
Title Element, Link Element, Description ElementYesSet under Settings → Export Formats → RSS Format. They fill the channel header.
Character EncodingYesSet under Settings → General. The plugin writes the choice into the file’s first line. The default is UTF-8, which is the safest choice for systems that read the file.
Grouped Product Formatting, Product Image Formatting, Product Gallery FormattingYesShown in the wizard’s File & Data Formatting section. They change how those product values are written inside each <item>.
Header FormattingNoThe wizard shows it, but RSS files have no header row.
Excel FormulasNoThe wizard shows it, but it only affects CSV, TSV, XLS and XLSX output.
Column DelimiterNoA CSV setting. It doesn’t appear in the wizard once you choose RSS 2.0.
Field Delimiter and Line Ending Formatting (in Settings → Export Formats → CSV Format)NoCSV and TSV only.

Opening your RSS file

The file is saved with an .xml extension, so any tool that reads XML can open it.

  • Web browser or code editor: open the file in a browser, VS Code, or any text editor. Most browsers show the XML as a collapsible tree.
  • Excel: use Data → Get Data → From File → From XML to load the items as rows. If you mainly want a spreadsheet, a CSV or Excel export is simpler.
  • Your own code or an integration tool: every mainstream language can parse XML, and most import tools accept an XML URL or file.
  • Feed readers: a feed reader expects each item to have a title, a link, and a date. RSS items from Store Exporter Deluxe don’t have them, so a reader may load nothing useful.

Troubleshooting

The feed’s title, link, and description are empty
Those header elements come from Title Element, Link Element, and Description Element in Settings → Export Formats → RSS Format. They’re blank until you fill them in and click Save Changes. Then run the export again. Files you’ve already exported don’t change.
A system I’m importing into says the RSS file is invalid
Check two things. First, fill in the three header fields under RSS Format, because the RSS 2.0 standard expects a channel title, link, and description. Next, check whether the system expects standard item elements such as <title>, <link>, and <pubDate>. Store Exporter Deluxe names item elements after your export fields, so a strict feed validator or a feed reader may reject it. In that case, the XML format is usually the better fit.

Frequently asked questions

Why isn’t RSS 2.0 on the Quick Export screen?
RSS 2.0 is available only in Scheduled Exports. The File Format step on Quick Export offers CSV, TSV, XLS, XLSX, and XML. To get a one-off RSS file, create a schedule and click Execute Now.

A new schedule is saved as active and runs daily, so it keeps making a file after your one-off run. If you only need one file, pause the schedule with its Active toggle, or delete it, after the run.
Why does my RSS file end in .xml and not .rss?
Store Exporter Deluxe saves RSS exports with an .xml extension. The content is still RSS 2.0, so you can rename the file to .rss if the system you’re feeding needs that.
Can I use an RSS export as a Google Shopping feed?
No. The file declares Google’s namespace, but the plugin names each element after your export fields, not after Google’s product feed attributes. Use a dedicated product feed plugin for Google Merchant Center.
What’s the difference between RSS and XML?
Both produce XML. XML puts each record under a node named after the export type, with a root <store> node. RSS wraps the same records in an <rss> and <channel> structure with <item> nodes. Choose RSS only when the system you’re feeding expects that wrapper. Otherwise, XML is the simpler choice.

Need help?

If you’re using Store Exporter Deluxe and run into an issue this article doesn’t cover, open a support ticket and our team will help you get your RSS export working.

If you’re using the free Store Exporter plugin, ask on the WordPress.org support forum and our team will get back to you there.

Was this article helpful?

Related Articles

Resources & Help