How To Use WooCommerce to Export Merchandise

by | Aug 5, 2022 | Etcetera | 0 comments

A variety of consumers will turn to WooCommerce as a way to run a full-featured online store using WordPress. The total “go with the flow” involves bringing assets, products, and content material subject matter into both a kind of platforms. Then again, you’ll have the ability to moreover use WooCommerce to export products too.

There are many reasons for why you’d do this. Most regularly, you’ll have some control to carry out, comparable to fixing entries in bulk. Then again, you might also export products if you choose to move your web hosting.

Regardless, working out one of the simplest ways to export your products — and the steps involved — is an excellent arrow to have for your quiver.

Figuring out the best way to export your merchandise — and the stairs concerned — is an impressive arrow to have to your quiver. 🏹 Be informed extra on this information ✅Click on to Tweet

For this tutorial, we’re going to show you one of the simplest ways to make use of WooCommerce to export products. We’ll round up some plugins that can assist you and provide you with a step-by-step tutorial to carry out the method.

First, let’s speak about use cases for exporting, and also the import process, briefly.

Why You’d Want to Export WooCommerce Products

Your entire inventory and stock is within WordPress — in particular, WooCommerce. Exporting the ones products means generating a listing during which you’ll have the ability to art work on the data in another program, away from your store’s arrange.

A spreadsheet showing a list of products from a WooCommerce store.
A spreadsheet of a product export.

You’ll regularly export the ones products into some roughly spreadsheet construction, whether or not or no longer that’s a comma-separated values (CSV) file, an Excel spreadsheet, or most likely a easy text file.

While it could seem like a drastic issue to do, in fact, you’ll regularly export your products for quite a lot of mundane and routine reasons:

  • Efficiency: It’s more straightforward and familiar to batch edit your inventory by the use of a spreadsheet rather than the WooCommerce interface. Plus, you’ll have the ability to use the trustworthy capacity of the spreadsheet app to save some time and effort as neatly.
  • Global error correction: There could also be an issue at the side of your product file that you simply’ll wish to kind on an international level. For instance, you may wish to have an error at the side of your stock conserving unit (SKU) values. Exporting your WooCommerce products permits you to transparent up this issue, and re-import the file in a flash.
  • Migration simplicity: Likelihood is that you’ll even want to improve your webhosting to at least one factor further robust and feature-specific for your needs. Must you export your WooCommerce products, it takes no longer the rest to import the entire file proper right into a new set up, or onto a brand spanking new server.

Speaking of importing, it’s worth working out how to try this previous to you get into the export process. This gives you a superb understanding of how entries relate to the “within” and “outside” worlds (as regards to WooCommerce, at least).

How To Import WooCommerce Products and Orders

On the ground, the import process for WooCommerce products and orders seems simple. In fact, there are lots of cogs that make up all of the wheel.

Over the next few sections, we’ll speak about one of the most essential “need-to-know” portions, and show the best process to import products into WooCommerce.

Basics of a CSV File

Even though we title it a “CSV file,” it’s not really a file type — it’s a file construction. This is regardless of CSV data having the .csv extension.

You’re ready to be told CSV formats using nearly any app that can parse and display text. Most consumers will open a CSV within a spreadsheet app because of this will probably be providing an identical capacity to art work with the values within. Then again, there’s no longer the rest improper, in a technical sense, with using a text editor or another answer.

The necessary factor aspect of a CSV file is its use of a “delimiter.” In basic words, it is a separator and the default is a comma — subsequently the construction displaying “comma-separated values.” When you use the CSV construction, the “translation” software (in our case, WooCommerce and a spreadsheet app) will keep in mind that each chew of information separated via a comma is a singular, individual piece of information:

A text editor showing WooCommerce product data values separated by commas.
Shopper names separated via commas.

Without the comma delimiter, you’ll see the ideas smashed into one cell:

A text editor showing all of the data within merged into
A dataset merged on account of the lack of a delimiter.

The beauty of the CSV construction is how it’s agnostic to not best the program you employ to be told the ideas, however as well as the program you import into. If an app can paintings with CSV values, you’ll have the ability to switch that data nearly anywhere — as long as you’ll have the ability to map the ideas accurately to the program you import it to.

See also  10 Very best Microsoft Place of business 365 Options

How WooCommerce Uses CSV Knowledge

WooCommerce uses CSV data in a similar way to other strategies. You could have quite a lot of fields within WooCommerce that give an explanation for the values for your products:

The admin panel for WooCommerce, that shows a list of products and the corresponding data fields.
A list of WooCommerce products and data fields.

When you import a selection of items from a CSV file, each price will probably be collated underneath a header — an SKU, product name, variable price, and additional. Then again, those headers will wish to correspond to an appropriate price within WooCommerce.

For instance, you couldn’t import data from an Engine Sort header if your WooCommerce product file doesn’t use that header price. Let’s speak about this when it comes to the import process at the complete.

Importing WooCommerce Products and Orders from a CSV File

The good news is that regardless of the entire background records, the import procedure for WooCommerce products and orders is straightforward. This is on account of WordPress’ delightful interface.

You’ll need a CSV file to try this, and we’re going to use the WooCommerce pattern information. It’s available free of charge, despite the fact that you’ll wish to obtain the WooCommerce plugin record from Within, you’ll find a folder known as sample-data which accommodates data to use:

A macOS Finder window showing three files: sample_products.csv, sample_products.xml, and sample_tax_rates.csv.
WooCommerce’s 3 trend data data.

There are a few ways to import products into WooCommerce. When you’ve got a brand spanking new arrange and run all the way through the Onboarding Wizard, you’ll have the ability to import a CSV file throughout that process:

The WooCommerce Onboarding Wizard, showing four options, including an "Import via CSV" link.
The WooCommerce Onboarding Wizard asking you to import products.

Then again, this will likely most probably best be an risk for brand-new stores and not using a products. We’ll next show you one of the simplest ways to exchange your WooCommerce product data, which moreover covers the import process using a CSV file.

Updating Provide Orders and Products Using a CSV File

The best (and beneficial) way to import WooCommerce products is all the way through the Products > All Products computer screen within WordPress. If you select Get began Import, you will see a dialog to select a CSV file:

The WooCommerce Import Products screen, showing a button to choose a CSV file from your local computer and a checkbox to update existing products.
Choosing a file from the WooCommerce import dialog.

Must you click on at the Show difficult possible choices button proper right here, you’ll have the ability to see some no longer necessary settings for the path of your CSV file along with the selection to use previous mapping settings. Most essential is the selection to select your file’s delimiter. This is going to help if your file doesn’t use commas:

The Show advanced options settings, including a path to a remote CSV file, the option to set the file's delimiter, and a checkbox to use old column mapping settings.
The Show difficult possible choices dialog.

Typically, the process proper right here is understated: Make a selection a CSV file from your laptop, then click on on Continue.

Then again, the extra checkbox right here’s the way in which you’ll substitute products.

The tooltip explains, then again it’ll read about products with an similar ID or SKU and substitute the information to regardless of your CSV file presentations. What’s further, lines throughout the sheet that don’t are compatible with an provide product — i.e. new products — won’t import. This means you’ll have the ability to substitute the file with out a topic data you want, then import it to exchange your inventory, all using one checkbox.

Mapping Product Columns

The Column Mapping computer screen is the way in which you’ll relate the columns within your CSV file to WooCommerce product headings. In fact, WooCommerce does a “highest guess” on this — while you use the trend data or import a file that has origins as an export, this is going to each be precise or close enough:

The WooCommerce Column Mapping screen, showing spreadsheet values on the left, and drop-down menus relating to WooCommerce fields on the right.
The WooCommerce Column Mapping computer screen.

When you check out the ones columns and make any necessary changes that can assist you map columns with accuracy, you’ll have the ability to scroll down and click on at the Run the importer button. From proper right here, WordPress will do the necessary, which would possibly take a while depending on the measurement of your CSV file.

Then again, you’ll see a excellent fortune computer screen once the process completes:

The WooCommerce Product Import screen showing a success message and a button to view the imported products within WooCommerce.
The WooCommerce Import Complete computer screen.

This is all you want to do to import products using the native capacity. Next, we’ll take a look at what WooCommerce supplies when it comes to exporting too.

How To Use WooCommerce to Export Products

To export from WooCommerce, you’ll want to head to the Products > All Products computer screen. Upon getting products within your arrange, there will probably be an extra Export button:

The WordPress Products screen, showing the "Add New", "Import", and "Export" buttons.
The WooCommerce “Export” button.

Then again, while you click on in this without selecting products, no longer the rest will export. You’ll first need to select the products you want to export using the checkboxes throughout the file, then click on at the Export button.

See also  Easy methods to Upload Google Internet Tales to Your WordPress Website online

This may occasionally most probably put across you to a computer screen that shouldn’t need so much input from you — the Export Products dialog:

The "Export Products" dialog, showing three options to select columns to export, and the "Generate CSV" button.
The WooCommerce “Export Products” dialog computer screen.

Proper right here, select the decisions from the dropdowns that correspond to the ideas you’d like to export. When you finish, click on at the Generate CSV button to start out the process and save the CSV to your laptop.

From proper right here, you’ll have the ability to evaluation your CSV using any program you’re pleased with. For instance, Excel is same old, as is Google Sheets.

Then again, while this native process is speedy and simple, it’s not necessarily probably the most flexible or powerful. We’ll speak about this in more depth next.

Hindrances of WooCommerce Native Capacity

The restrictions of WooCommerce’s native export capacity — and that of the import process — won’t show themselves in various day-to-day use cases.

This can be a double-edged sword. On the one hand, you’ll be able to achieve nearly the whole thing you want in various scenarios.

Then again, even though, there are a few limitations that won’t be obtrusive until you come back upon them. For instance, you could not be able to import specific varieties of custom designed data and complicated products in necessarily probably the most optimal way.

That’s the position a plugin can help via bridging the space between the native export process and something tailored to your needs. Automattic recognizes this, which is why they introduced the Product CSV Import Suite WooCommerce extension.

The extension goes above and previous the basic native capacity in quite a lot of ways:

  • You could have further toughen for different WooCommerce extensions, comparable to WooCommerce Pictures, WooCommerce Bookings, and Google Product Feed.
  • There’s a way to import, export, and substitute custom designed and complicated records. Whether or not or no longer you assign merchandise to distributors, add type names to products, or the remaining, you’re ready to nevertheless art work with this data within your CSV file.

Then again, there are further imaginable possible choices than best first-party WooCommerce extensions. You’ll have the ability to moreover use third-party plugins to help export WooCommerce products. We’ll speak about this, and one of the simplest ways to export using a plugin, throughout the final section.

How To Export WooCommerce Products and Orders With a Plugin

Given that a plugin would in all probability offer a better way to export WooCommerce products, you’ll to seek out quite a lot of them to be had available on the market. Next, we’re going to run down quite a lot of plugins to be had available on the market to come up with a style of what’s on offer.

From there, we’ll get into one of the simplest ways to export WooCommerce products using this type of solutions, comparing this to the native way.

Struggling with downtime and WordPress problems? Kinsta is the hosting answer designed to save some you time! Take a look at our options

Plugins for Exporting WooCommerce Products

There are myriad plugins to be had the least bit worth problems that can assist you export WooCommerce products. You’ll moreover to seek out that regardless of the choice of plugins available, a little bit of them do something different to the remainder.

A plugin comparable to WP All Import is further of an all-purpose exporter plugin. The standout function right here’s the drag-and-drop editor. This gives you the danger to build difficult products using an interface similar to a internet web page builder. You’ll have the ability to even design the XML scheme using drag-and-drop, which is incredible while you shudder at the thought to be breaking out your textual content editor.

The WP All Import plugin's schema editor, showing XML code along with user-defined values and parameters within the code.
The WP All Import XML Editor.

Product Import Export is another plugin that is helping CSV and XML formats and has high-compatibility with third-party plugins and WooCommerce extensions. It moreover has another trick up its sleeve.

A green-blue panel for the Product Import Export plugin that lists some of the key features, and includes a WooCommerce logo.
The Product Import Export plugin.

The plugin permits you to organize a couple of Protected Record Switch Protocol (SFTP) channels as a way to time table your imports and exports. This has two benefits: First, you’ll have the ability to transfer data in an efficient way by the use of SFTP; second, you’re taking a “hands-off” way that may reduce errors and increase your efficiency.

While both a kind of solutions are best fee plugins, you could not want to shell out for a solution. WooCommerce Retailer Exporter is a loose plugin with a minimalist point of interest.

A spreadsheet mockup showing WooCommerce products on a purple background with a text
The WooCommerce Store Exporter plugin.

You’ll have the ability to moreover export to remote SFTP formats, along with using POST. This can be a development-level function that will help you if you want to have a custom designed export answer. Then again, if you want to use the plugin as a simple export tool, there’s a one-click risk available to output a spreadsheet that accommodates your data.

See also  Easy methods to Arrange SMTP E-mail with Divi Website hosting via Cloudways

The overall plugin is one we’re going to show throughout the next section. Complicated Order Export for WooCommerce is just so simple as WooCommerce Store Exporter, with higher flexibility when it comes to its output settings.

The WordPress dashboard, showing the "Export Orders" options, including numerous filters, data range options, and output formats.
The Difficult Order Export plugin’s dashboard.

You get a plethora of output settings that, depending for your needs, you’ll price. The usual suspects are there — CSV, XML, and XLS formats — and there are also PDF and HTML formats available.

You moreover get a tab-separated values (TSV) file construction. While this isn’t as flexible as the facility to set the delimiter, it does come up with a long-lasting risk while you revel in using that construction for your data.

How To Export WooCommerce Products Step via Step

In reality, the process you’ll take to export WooCommerce products will probably be different depending on the plugin you choose. We’re going to use the Difficult Order Export for WooCommerce plugin proper right here, and we’ll speak about one of the most essential fundamental steps for the process.

When you arrange and switch at the plugin, you’ll want to seek for the similar profile settings. In most cases, a plugin will assist you to create a faithful export profile. This lets you save a singular setup to use yet again.

For Difficult Order Export for WooCommerce, it’s underneath the WooCommerce > Export > Profiles section:

The WordPress back end, showing the Profiles section to export orders. There is a list of columns, complete with information on formats and data ranges, and also an actions icon menu.
The Export Profiles section of the plugin.

We can art work with the Copied from “Export Now” profile — while you click on on it, you’ll come to an intensive computer screen with the fields you want as a way to whole an export to your liking:

The full profiles screen, showing export data ranges, bulk action settings, filter settings, and more within WordPress.
The Export Orders computer screen showing a single profile.

From proper right here, you’ll want to adjust settings in line with the following:

  • Date range: There must be a date range that matches the ideas you want to export, and not more.
  • Output construction: You’ll desire to select the correct output construction. CSV will be the default for plenty of methods, despite the fact that it’s your decision a reproduction in XML too.
  • Columns: The filters assist you to choose the columns you export, so this must be where you spend the vast majority of your attention.

Difficult Order Export for WooCommerce has myriad filters for you to select the best range of your output data. For instance, we’ve filters for products weight, whether or not or no longer the product is a backorder (as a custom designed field price), variable function, and additional:

The Export Order dialog, showing a list of filters and range values, along with format output options, and custom date settings.
Enhancing product filters in WordPress.

Then again, this doesn’t limit the choice of columns you’ll see for your spreadsheet. For this plugin, you’ll open up the “Prepare fields to export” menu:

A list of green fields with attributes for an individual product, and a purple "Remove all fields" button.
The Field Export file in WordPress.

When you set the ones, it’s a good idea to save some your changes and profile for long term use. From there, you’ll have the ability to run an export.

For this plugin, you’ll use the WooCommerce > Export Orders > Export Now computer screen if you want to have a handy guide a rough fundamental export, or the Export button at the bottom of a profile if you want to have that particular one:

The bottom of an export profile, showing a number of buttons including the Export option.
The Export button within WordPress.

This may occasionally most probably save a CSV file to your laptop that accommodates the ideas export:

A Google Sheets document showing the data export from WordPress, including the columns set in the export dialog screen.
A Google Sheets document that accommodates the export data from WordPress.

When you carry out your changes, you’ll have the ability to save and import the spreadsheet once more into WooCommerce and WordPress without fuss.

Wish to expedite your WooCommerce workflow? Get started right here 🚀Click on to Tweet


The facility to get data out of and into WooCommerce is a fundamental and essential one. As such, WooCommerce supplies native ways to do each and every. While the built-in importing process is straightforward, intuitive, and relatively error-free, the native export capacity isn’t always the most productive way.

This put up has looked at using plugins to export WooCommerce products, and the good news is there are lots of solutions available. Upon getting your CSV file, you’ll have the ability to open it in Google Sheets, Excel, or even a textual content editor to test it. From there, you’ll have the ability to import the file once more into WooCommerce and substitute your products.

Do you export WooCommerce products regularly, and if so, what’s your methodology? Let us know throughout the comments section beneath!

The put up How To Use WooCommerce to Export Merchandise seemed first on Kinsta®.

WP Hosting

[ continue ]

WordPress Maintenance Plans | WordPress Hosting

read more


Submit a Comment

Your email address will not be published. Required fields are marked *