Back to blog
6 min read Import Guides

Automatic Supplier Feed Import for WooCommerce (Hourly or Daily)

When you sell a supplier’s products, their prices and stock change every day. Updating them by hand means you sell things that are out of stock or at last week’s price. Most suppliers publish a feed for this: a CSV or XML file at a fixed address that they update on their side. The setup below downloads the feed every hour or every day and updates your products by SKU.

We tested it with Import Export by RockStarLab 2.1.27 and the PRO add-on 2.1.7, WooCommerce 11.2 and WordPress 7.1. Importing WooCommerce products is a PRO feature; schedules are in both versions.

Short Answer

  1. Go to Import Export → Import → WooCommerce Products.
  2. Paste the feed address in Or import a file from a URL and click Fetch File.
  3. Map the columns, match by SKU and run the import once.
  4. Open Import Export → Schedules, pick that import as the Source Job, choose Recurring and Hourly (or Daily) and save.
  5. Every run downloads the current feed and updates prices and stock. Check the Jobs Log after the first runs.

What You Need from the Supplier

  • A direct address of the file, for example https://supplier.example.com/feeds/prices.xml. Opening it in a browser should show or download the file itself, not a login page.
  • A stable SKU per product. It connects the feed rows to your products, so it must not change between feeds.
  • A format the plugin reads: CSV, XML, JSON, XLSX or ODS. For XML feeds, see How to Import WooCommerce Products from an XML Supplier Feed; that guide uses the same feed as this one.

Our example feed has three products with SKU, title, price, sale price, stock, category and images. In the morning the Rain Parka is on sale at $79 and the Wool Cap is out of stock.

Step 1: Back Up the Site

A scheduled import changes products without anyone watching. Make a backup before you set it up: UpdraftPlus Backup Now, your host’s backup, or ask an AI agent to run rsl-ie/updraftplus-backup-start. See How to Create a WordPress Website Backup and Restore It. Regular automatic backups are a good idea for any store that imports on a schedule.

Step 2: Import the Feed from Its URL

Open Import Export → Import and choose WooCommerce Products. Below the upload area, paste the feed address in Or import a file from a URL and click Fetch File:

Import Step 2 Upload File with the field Or import a file from a URL containing https://cdn.example-supplier.com/images/feed.xml and a Fetch File button
Paste the feed address instead of uploading a file.

The server downloads the file and checks it like an upload. The file card shows where it came from:

File card: feed.xml, 1.55 KB, XML, Downloaded from https://cdn.example-supplier.com/images/feed.xml
The server downloaded the feed and checked it like an upload.

Go to Field Mapping and click Auto Map; drag any column it did not recognize to its field. Then, on Import Options, set Check for Existing Items by Field to SKU, keep If Match Found: Update, and choose what new SKUs should do: Create adds new supplier products to your store, Skip updates only products you already sell.

Import Options: Check for Existing Items by Field SKU, If Match Found Update, If No Match Found Create, Automatically Import Media Files checked
Products are matched by SKU on every run.

Start the import. This first run creates or updates the products and becomes the template for the schedule:

Import Completed Successfully: Successful 3, Updated 3, Created 0, Failed 0
The first run, which the schedule repeats.

Our products after the first run, with the sale on the Rain Parka and the Wool Cap out of stock:

Products before the scheduled run: Rain Parka in stock 14, 89.00 crossed out 79.00; Wool Cap out of stock 0, 24.00; Leather Belt in stock 40, 35.00
Morning: the parka is on sale, the cap is out of stock.

Step 3: Schedule the Import

Open Import Export → Schedules and fill in Add schedule:

  • Name: something you will recognize, such as “Supplier feed: prices and stock”.
  • Source Job: the import you just ran. Search by its number from the result screen or the Jobs Log.
  • Run type: Recurring.
  • Repeat: Hourly, Twice daily, Daily or Weekly. Ask the supplier how often the feed changes; there is no point in fetching it more often.
  • First execution: when the first run should happen.
Add schedule form: Name Supplier feed: prices and stock, Source Job #54 import woo_product completed, Run type Recurring, Repeat Hourly, First execution 08/11/2026 17:30
An hourly schedule based on the URL import.

Click Add schedule. Each run creates a new import job with the same mapping and options. Because the source job was imported from a URL, every run downloads the feed again, so it always works with the supplier’s current file.

Step 4: Check the Scheduled Runs

In the afternoon our supplier changed the feed: the Rain Parka sale ended and the regular price became $84, 25 Wool Caps arrived, and the Leather Belt went up to $37. At the next run the schedule list shows the time of the last run, the job it created and the next run:

Schedules list: Supplier feed: prices and stock, source job #54, Hourly, next run 2026-11-08 18:00, last run 2026-11-08 17:22 Job #55, Active
The last run created job #55; the next one is due at 18:00.

The new job is in Import Export → Jobs Log, next to the first one. Open it to see what was updated and any warnings, such as images that could not be downloaded:

Jobs Log: #55 and #54 Import WooCommerce Products, completed, 3 of 3 items
Each scheduled run is a job in the Jobs Log.

And the products follow the feed: the parka has no sale price anymore, the cap is back in stock with 25 pieces, and the belt costs $37:

Products after the scheduled run: Rain Parka 84.00 without sale, in stock 14; Wool Cap in stock 25, 24.00; Leather Belt 37.00, in stock 40
Afternoon: prices and stock follow the new feed.

Make the Schedule Run on Time

Schedules run through WP-Cron, which WordPress starts when someone visits the site. On a store with little traffic, an hourly import can start late. For exact timing, ask your host to call wp-cron.php every few minutes from a real server cron job, and add define( 'DISABLE_WP_CRON', true ); to wp-config.php so WordPress does not also start it on visits.

Keep Only What the Feed Should Control

The mapping of the source job is used for every run. If you edit product titles, descriptions or images in WooCommerce, remove those columns from the mapping before you schedule the import; otherwise the next run writes the supplier’s version back. A typical price-and-stock feed needs only:

  • SKU to find the product,
  • Regular price and Sale price (an empty sale price ends a sale),
  • Stock (a number turns on stock management; 0 makes the product out of stock).

To change the mapping later, run a new import from the same URL with the new mapping, then edit the schedule and select the new job as the Source Job.

Common Mistakes

  • A link that needs a login. The server cannot log in to the supplier’s portal. Ask for a public feed address, often with a key in it (?key=…), and keep that address private.
  • Scheduling before checking the first import. Look at a few products after the manual run. A wrong mapping repeated every hour spreads quickly.
  • If No Match Found: Create on a full catalog feed. If the supplier lists 20,000 products and you sell 300, every run would add the rest. Use Skip to update only your products.
  • Two schedules for the same feed. They would update the same products twice. Keep one schedule per feed.
  • Products dropped from the feed. The import does not delete or hide products that are no longer in the feed. Check them from time to time, or ask the supplier to keep discontinued items with stock 0.

FAQ

Can I import a feed from FTP or Google Drive?

The URL import uses HTTP and HTTPS. Google Sheets can publish a sheet as CSV at a public address (File → Share → Publish to web → CSV), which can be used as the feed address. FTP addresses and drive share pages that open a preview do not.

Does it re-download product images every time?

No. An image is downloaded once; later runs reuse it as long as the link stays the same.

How do I stop the automatic import?

Delete the schedule in Import Export → Schedules. The products and the past jobs stay as they are, and you can add the schedule again later from the same source job.

Do I need PRO?

For WooCommerce products, yes. With the free plugin you can import posts and pages from a URL and schedule those imports the same way.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

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

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE