Skip to main content
Updates / WooCommerce Auto Import Products on a Schedule
← All updates
 
Blog

WooCommerce Auto Import Products on a Schedule

Scheduled WooCommerce product imports can automatically update your catalog from an external data source without requiring you to upload and import each new file manually. This is especially useful when suppliers routinely provide updated prices, stock levels, or other product data.

WP All Import can perform these automatic updates using CSV, XML, or Excel files from a URL, an FTP/SFTP location, or your server, at times that you set. You can control which product fields are updated without overwriting other product information.

In this article, I’ll cover the prerequisites, build the import with Automatic Setup, configure the update rules, and schedule it through either Automatic Scheduling or a cron job.

Table of Contents

Prerequisites for Scheduling WooCommerce Product Imports

Successful Manual Update Tests

The first prerequisite for scheduling any process is to successfully run it manually for the first two updates. This is especially important when updating the products in your WooCommerce store because the new information could be displayed to customers within minutes of the import’s completion, and no one wants to publish, say, the wrong prices on a live site.

Why should you test the first two updates?

WooCommerce Auto Import Products - Testing

The first test is to see if you can successfully interpret the data from a supplier file and apply that data to your site. This may involve multiple runs/adjustments and should be done on a test site.

The second test is really a test of your supplier to see if they’re sending you consistent update files (some may change the file’s structure or content format without telling you).

You should only schedule your import to run automatically after you successfully complete both tests.

Accessible File Locations

The other general requirement is that the update files should be placed in a consistent location that is accessible to your import program. When running an import automatically, accessing the import file cannot be dependent on manual actions.

For WP All Import, this means one of the following locations:

  • A URL. The URL should point directly to the file you’re trying to import. If you click this URL in a browser, it should immediately prompt you to download/save the file.
  • An FTP/SFTP site for which you have the necessary credentials. WP All Import lets you record these credentials for subsequent updates.
  • The /wp-content/uploads/wpallimport/files/ folder on your server. This means that you must have some method of loading files into that folder.

How to Set Up and Test a WooCommerce Product Import

Import a New Product Catalog With Automatic Setup

Before scheduling anything, you need an import that works. Automatic Setup builds one from your supplier’s file in a single pass. I’ll use a CSV hosted at a URL for this example, since that’s one of the two file sources a scheduled import can reach on its own.

Step 1: Point WP All Import at the Supplier File

Go to All Import › New Import. The Set up automatically callout sits at the top of the screen, above the manual options. Click it.

Choose the Download from URL tab and paste the URL your supplier gave you. The URL has to point directly at the file: clicking it in a browser should start a download rather than open a page. WP All Import accepts CSV, XML, Excel, JSON, TXT, ZIP, and GZ files up to 256MB, so a zipped supplier feed works here without unpacking it first.

wp-all-import-automatic-select-import-file

Step 2: Choose WooCommerce Products

Select WooCommerce, then Products. This covers simple, variable, and grouped products in the same pass, so a supplier file containing more than one product type doesn’t need splitting.

If anything about the file needs explaining, e.g., prices quoted in a particular currency or variation rows sharing a parent SKU, expand the optional Add Setup Instructions field and say so in plain language. Then click Start Automatic Setup.

wp-all-import-automatic-setup-product-import-type-selection

Step 3: Check the Field Mappings

WP All Import reads the file and maps each column to its WooCommerce field on its own. When it finishes, the screen reports how many fields it mapped and how many records it found, with the full mapping in a collapsible Field Mappings section split into Core WordPress Fields and WooCommerce Import Add-On.

Open it and read down the list. A price column mapped to Regular Price, a SKU column to Product SKU, attribute columns attached to variation logic: every connection is visible before a single product is created. If something needs changing, Manual Setup switches you into the drag-and-drop wizard with the mappings already in place.

wp-all-import-automatic-setup-field-mappings-expanded

Step 4: Run the Import

Click Run Import. WP All Import creates the products as it goes and reports how many records it created, updated, and skipped when it finishes. Check a handful of them under Products › All Products to be certain that everything mapped correctly.

wp-all-import-automatic-setup-import-complete

That import now exists under All Import › Manage Imports, which is where the schedule gets attached later. The next section covers the other half of this: what changes when the file contains products your store already has.

Import an Updated File with Manual Drag & Drop

Imagine that a supplier has sent you the URL for a new import file that contains updated product prices. In this section, I show you how to import this file and then verify the results.

Step 1: Check Your Current Product Prices

Go to Products › All Products in the main WordPress menu and take note of some of the product prices at the top of the list:

WooCommerce Auto Import Products - Initial Prices

Step 2: Create a New Product Import

Navigate to All Import › New Import and initiate a new product import using the Download a file option:

WooCommerce Auto Import Products - Create New Import

Step 3: Review the Product Import File

In this step, check to make sure that WP All Import has correctly interpreted the import file. As you can see from the image below, our sample file is very simple, containing only a few product identifier fields along with updated regular price data.

WooCommerce Auto Import Products - Review Import File

Step 4: Map the New Price Data to the Product Price Field

On the General tab of the WooCommerce Add-On section of the Drag & Drop screen, map the incoming regularprice data element to the Regular Price ($) field:

WooCommerce Auto Import Products - Map Updated Price Data

If the supplier has sent you sale price data instead, you can map the saleprice data element to the Sale Price ($) field.

To continue, click the blue Continue to Step 4 button (not shown).

Step 5: Match Existing Products and Update Only the Regular Price Field

The Import Settings screen appears next. Here, you can tell WP All Import how to match the incoming products to the products in your store, which you do in actions 1 and 2 below:

WooCommerce Auto Import Products - Import Settings

Action 3 lets you specify the fields to update, which you do further down the screen:

WooCommerce Auto Import Products - Import Settings 2

Click the blue Continue button (again, not shown).

Step 6: Complete the Import

On the next screen, click the Confirm & Run Import button. When the import is complete, you should see a screen like this:

WooCommerce Auto Import Products - Import Complete

Step 7: Check the Updated Product Prices

Go back to Products › All Products and confirm that the prices have changed:

WooCommerce Auto Import Products - Check Price Updates

At this point, you have successfully set up and tested your initial import/update. Now, it’s time to configure and test the scheduling process.

Product Import Scheduling

To schedule your import, go to All Import › Manage Imports, locate your recent import, and click the Scheduling Options link on the right-hand side:

WooCommerce Auto Import Products - Manage Imports

This will bring up the Scheduling Options form:

WooCommerce Auto Import Products - Automatic Scheduling Service

WP All Import offers two methods of scheduling: the Automatic Scheduling Service and cron jobs. In this example, we have selected Automatic Scheduling. The interface is self-explanatory and requires only a few seconds to complete. Once you click the Save button, that’s it — your import will run automatically on the schedule you have specified.

The price for this convenience is $19 per month for unlimited sites. For more information on this option, see Run WordPress Import on a Schedule.

You can also schedule your product imports using cron jobs on your server:

WooCommerce Auto Import Products - Scheduling with Cron Jobs

This option is free but significantly less convenient. For more information, see Scheduling Imports Using Cron Jobs.

Once you’ve set up your schedule, just upload a test file (again, on your test site) and wait for the automatic import to take place. When this occurs, check your products and verify that everything went smoothly. If it did, you’re ready to put the whole process into production.

Final Thoughts

The two test runs I opened this article with are the part people skip, and they’re the part that matters most once nobody is watching the import. A scheduled import applies whatever is in the file, including a supplier’s unannounced column change.

What makes this workable is that the setup only happens once. WP All Import builds the field mappings for WooCommerce products from a supplier’s CSV, XML, or Excel file in a single automatic pass, and Automatic Scheduling runs the finished import on the days and times you set without a cron job. After that, a new supplier file becomes a WooCommerce catalog update that happens automatically while you’re doing something else.

WooCommerce Auto Import Products on a Schedule — FAQs

How do I schedule a CSV import in WooCommerce?

To schedule a CSV import in WooCommerce, build the import first, then attach a schedule to it:

  • Create the import in WP All Import using a file source a server can reach on its own, such as a URL, an FTP/SFTP location, or the /wp-content/uploads/wpallimport/files/ folder
  • Go to All Import › Manage Imports and find the import
  • Click Scheduling Options on the right-hand side
  • Choose Automatic Scheduling to set the days and times from inside WordPress, at $19 per month for unlimited sites, imports, and exports
  • Or choose cron jobs, which cost nothing and use trigger and processing URLs you add to your server’s scheduler

Can WooCommerce import products automatically?

No, not on its own. WooCommerce’s built-in importer runs only when you upload a file and click through the importer manually. It has no scheduling of any kind. WP All Import adds automatic product imports to WooCommerce by fetching a CSV, XML, or Excel file from a URL or FTP location on a set schedule and applying it to your catalog without anyone opening the dashboard.

How do I import products into WooCommerce from a URL?

To import products into WooCommerce from a URL, point WP All Import at the file and let it handle the rest:

  • Go to All Import › New Import and click Set up automatically
  • Choose the Download from URL tab and paste a direct link to the file
  • Select WooCommerce, then Products
  • Review the field mappings WP All Import builds from the file
  • Click Run Import, then attach a schedule under Manage Imports if the URL updates regularly

Where do I put the import file so a scheduled import can find it?

A scheduled import needs a file location that doesn’t depend on anyone uploading anything. WP All Import reads scheduled imports from three places:

  • A URL pointing directly at the file, where clicking the link starts a download
  • An FTP or SFTP location, with credentials saved in the import for later runs
  • The /wp-content/uploads/wpallimport/files/ folder on your server

Will a scheduled import create duplicate products instead of updating them?

Not when the import is configured to match. WP All Import matches incoming rows to existing products using a unique identifier such as SKU, and updates the matched products rather than creating new ones. You set this on the Import Settings screen, along with which fields the import is allowed to overwrite, so a price file changes prices and leaves descriptions and images alone.

Get Oxygen

Build it your way with Oxygen.

$199.50 once — unlimited sites, no renewal

Not per year, not per site, not per seat. 60 day money back guarantee.