Description
Magelon Export creates a product feed from your WooCommerce store that Google Merchant Center can read. It’s a CSV file at a fixed URL, so you set it up once in Merchant Center (or in Magelon) and the plugin keeps it current from then on.
We built it because we run Google Shopping campaigns for a lot of shops, and most feed problems we see come down to the same few things: missing brands, wrong prices, variations that never make it into the feed. So those are the parts we paid most attention to.
What it does
- Exports simple products and every variation of variable products. Each variation gets its own price, SKU, image and attributes, and they’re grouped together with
item_group_id, the way Google expects. - Sends prices with the currency and, outside the US and Canada, with tax included, which is what Google requires. Scheduled sales come with their start and end dates.
- Lets you map your own data to Google’s fields: categories, brands, product attributes, custom fields and ACF fields. Brands work with WooCommerce Brands, Perfect Brands and YITH Brands.
- Uses the GTIN field that’s built into WooCommerce, or your SKU as the ID or MPN if you prefer, and fills in
identifier_existsfor you. - Converts descriptions to plain text and leaves out hidden products, drafts and anything without a price.
Staying up to date
When you add, edit or delete a product, or stock changes after an order, the feed is updated about 10 minutes later. If you’re doing a bulk edit or an import, all those changes go into a single update, so your server isn’t rebuilding the feed thousands of times.
On top of that, the plugin checks the feed on a schedule you pick: every 15 minutes, 30 minutes, hour, 4 hours, or once a day. If nothing has changed, the check does nothing. The feed is always rebuilt at least once a day anyway, which catches changes WordPress doesn’t hear about, like imports that write straight to the database.
Big catalogues are exported in small batches in the background, and the old feed stays in place until the new one is complete. Google never downloads a half-finished file.
If you don’t want your full catalogue sitting at a URL anyone could guess, you can switch on a private feed URL with a random code in it.
Installation
- Install the plugin from Plugins > Add New, or upload the
magelon-exportfolder towp-content/plugins/. WooCommerce needs to be active. - Go to Tools > Magelon Export, map your fields and save.
- Click “Start export” to create the first feed.
- Copy the feed URL from the same page into Google Merchant Center, or into Magelon.
FAQ
Where is the feed?
At /wp-content/uploads/magelon-export/products.csv. If you turn on the private feed URL, the file name gets a random code added to it. Either way, the exact URL is shown on the settings page.
How often is the feed updated?
About 10 minutes after a product changes, if “Update after product changes” is switched on (it is by default). Separately, the plugin checks for changes on the schedule you choose, from every 15 minutes to once a day, and rebuilds the feed at least once a day no matter what.
Keep in mind that Google reads your feed on its own schedule, usually once a day for a scheduled fetch. A fresh feed helps most when Google, or another tool, fetches it often.
Will this slow down my site?
It shouldn’t. Exports run in the background in batches, a busy hour of orders or a big import ends up as one update instead of many, and checks that find nothing to do finish almost instantly.
Should prices include tax?
Google wants prices with tax in most countries, and without tax in the US and Canada. The plugin works this out from your store address. If you need something different, you can change it on the settings page.
How are variable products exported?
Each variation is its own item in the feed and the parent product is left out. All variations of a product share the same item_group_id, which is the parent’s ID, or the parent’s SKU if “Use SKU as product ID” is on.
Which products are left out?
Drafts, private products, products set to Hidden in the catalogue, grouped products, disabled variations and products without a price. Developers can change this with the magelon_export_include_product filter.
Can I add my own fields?
Yes. The magelon_export_custom_product_fields filter adds fields to the mapping list:
add_filter( 'magelon_export_custom_product_fields', function ( $fields ) {
$fields['_custom_field'] = 'Custom Meta Field';
return $fields;
} );
To make all your ACF fields available:
add_filter( 'magelon_export_custom_product_fields', function ( $fields ) {
if ( ! function_exists( 'acf_get_field_groups' ) ) {
return $fields;
}
foreach ( acf_get_field_groups() as $group ) {
foreach ( (array) acf_get_fields( $group['key'] ) as $acf_field ) {
$fields[ $acf_field['name'] ] = 'ACF: ' . $acf_field['label'];
}
}
return $fields;
} );
Are there other hooks?
magelon_export_columnschanges the feed columns.magelon_export_rowchanges a product’s row before it’s written.magelon_export_include_productincludes or leaves out a product.magelon_export_custom_field_valuechanges the value of a custom field.magelon_export_descriptionandmagelon_export_pricechange descriptions and price formatting.magelon_export_batch_sizesets how many products go in each batch (500 by default).magelon_export_change_delaysets how long to wait after a change before updating, in seconds (600 by default).magelon_export_completedruns after each export, with the file path and the number of products.
The feed isn’t updating on its own
The schedule relies on WP-Cron, which only runs when someone visits your site. On a quiet site, ask your host to set up a real cron job for wp-cron.php. You can also look under WooCommerce > Status > Scheduled Actions for jobs starting with magelon_export.
Where can I get help?
Post in the support forum or email us at support@magelon.com.
Changelog
1.2.0
- New: the feed updates about 10 minutes after products change. Edits that happen close together are bundled into one update.
- New: scheduled checks skip the export when nothing has changed, and the feed is still rebuilt at least once a day.
- New: check intervals of 15 minutes, 30 minutes, 1 hour, 4 hours or daily. The weekly option is gone, and sites that used it move to daily.
- New: the settings page shows the last product change, any waiting update and the next check.
1.1.0
- Fixed brand, category and other mappings getting lost after saving the settings. Old settings are repaired automatically.
- Fixed
identifier_existssaying “no” for products that have a GTIN. - Variable products now export each variation as its own item, with its price.
- Prices now include the currency, and tax where Google requires it.
- Scheduled sales include their dates, and expired sales are no longer exported.
- The feed is only replaced once an export has finished, and large catalogues export in batches in the background.
- Deleting the plugin now cleans up everything it stored.
- Corrected the minimum PHP version to 7.4.
- Descriptions are plain text, backorder products show as “backorder”, and empty image links are gone.
- Tighter permission checks, an optional private feed URL and a choice of prices with or without tax.
1.0.7
- Previous release.