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
- How to Set Up and Test a WooCommerce Product Import
- Product Import Scheduling
- Related Info
- Related Videos
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?

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.

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.

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.

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.

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:

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:

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.

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:

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:

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

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:

Step 7: Check the Updated Product Prices
Go back to Products › All Products and confirm that the prices have changed:

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:

This will bring up the Scheduling Options form:

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:

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.
WooCommerce Auto Import Products on a Schedule — Related Info
- Official Documentation: Recurring Imports Overview
- Official Documentation: Updating Prices to Existing Products
- Official Documentation: How to Import WooCommerce Products from CSV and XML
- The 5 Best WooCommerce Product Import Plugins
WooCommerce Auto Import Products on a Schedule — Related Videos
Get Oxygen
Build it your way with Oxygen.
Not per year, not per site, not per seat. 60 day money back guarantee.