Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Lifetime Licenses Are Ending Soon, Get Yours Before They're Gone
 - 
Read More
Pricing

You may have seen some references on our site to annual licensing or renewals.

All plugins currently come with a lifetime license, no matter what the site says.

We’re currently running tests before we make the switch to annual pricing. Check the Discounts tab to purchase our other plugins and get a lifetime license before they’re gone.

I Understand I Have a Lifetime License

Lifetime licenses are only available for a short time!

SPECIAL OFFER 
Save 50% OFF For a Limited Time!
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing lifetime licenses will be unaffected so get in while you can!
  • 90-Day Money-Back Guarantee
  • Fast World Class Support
  • Unlimited Sites
  • Free Lifetime Updates
  • Easy to Use
  • Developer Friendly
Risk free! Cancel at any time with our 90-day guarantee.
"All Import/Export is an awesome suite of tools. It gets me out of some tough challenges."
Eric Karkovack, Freelance Writer
"WP All Import - Versatile, and I have saved so much time with it over the years."
Matt Andrews, Full Stack Web Developer
"@WPAllImport just let me import 3000 products from some arbitrary Excel to WooCommerce w/ a few clicks, including images and categories."
Joris Witteman, Developer / Designer

Wait, Don’t Miss Your Chance for a Lifetime License!

@glitzformals
"This plugin is a game changer for my situation. I’m stunned at how fast and effortless the import process is."
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."

90-Day Guarantee

Not 100% happy? Let us know and we’ll promptly send you a refund.

Free Updates For Life

Pay once for unlimited installs, even client sites. No renewal fees.

World Class Support

Over 9 years experience with WordPress imports and exports.

Your Last Chance for a Lifetime License!

We are soon moving to yearly licenses only. Once lifetime licenses are gone, they're gone forever.
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."

90-Day Guarantee

Not 100% happy? Let us know and we’ll promptly send you a refund.

Free Updates For Life

Pay once for unlimited installs, even client sites. No renewal fees.

World Class Support

Over 9 years experience with WordPress imports and exports.
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

Updating Prices to Existing Products

WooCommerce products store their prices in standard custom fields, and those prices can be updated using WP All Import. This guide explains how to update the price for your existing products using an external file that contains the new prices.

Table of Contents

Understand How to Update Your Prices

Current scenario: You have existing products on your site, either created manually or imported by you. You have a separate XML or CSV file containing your new prices, and you want to synchronize the prices on your site with the new prices from your file. If so, this guide is for you.

You only need these instructions if you have a separate file with new prices to import. If the same file used to import your products also contains the updated prices, you can just Run Import (in All Import › Manage Imports) and re-run the import process to bring in the new prices.

Each record from your import file should have at least a new price and an identifier to let WP All Import match the correct price to the correct product from your site. The most common identifier is SKU.

Step 1: Set Up Existing Items Import

Navigate to All Import › New Import and create a new import process:

Updating Prices Create New Import

We specified a URL to our new prices file since that will let us set up a schedule to automatically download and import the prices from this URL every day.

Click on Continue to Step 2 to move along.

Step 2: Review Import File

The Review Import File screen appears in Step 2 of the import process.

Updating Prices Review Import File

You can skip this screen by clicking on Continue to Step 3.

Step 3: Map Import Fields with New Price

Locate the WooCommerce Add-On section and specify the new price in the General tab:

Updating Prices Map Price General Tab

All other import fields can be left alone since we're only updating price here. For example, there is no need to change the Product Type or anything other than the price.

Click Continue to Step 4 (not shown).

Step 4: Match Existing Products and Update Only Price Custom Fields

Now you need to define how to match the existing products and what to update. The import may warn you that the title is empty. You can safely ignore this message since we're not updating titles.

Use SKU to Match Existing Products

Select Custom field, and the _sku custom field will be automatically targeted. Then, drag and drop your SKU import field to the Value text box:

Updating Prices Match by SKU

That way, each record from your file will be matched with each existing product from your site based on SKU.

Tell WP All Import Which Fields to Update

Now you need to specify the correct custom field names for prices using the Choose which data to update option in Step 4. We should update the _regular_price and _price custom fields alike. If we use sale pricing, we should also update the _sale_price custom field.

Note that we disable the Create new and Remove options since we only want to update prices on existing products.

Updating Prices Decide What to Update

Specifying which custom fields to update is very important to avoid importing wrong/empty data or erasing existing data.

If the custom field you wish to update doesn't appear, you can type it in and hit Return/Enter.

Step 5: Run Import Process to Update Prices

You can now run the import process to bring the new prices into your existing WooCommerce products. Review the new prices via Products › All Products.

You can easily configure WP All Import to automatically re-check the price XML or CSV file at a specific interval to keep your product prices always up to date using our Automatic Scheduling Service.

Frequently Asked Questions

How to Update Price for Variable Products?

This guide applies to updating both simple or variable product prices since the process is the same regardless of the product type. Just make sure to match your variable products with something truly unique, such as SKU or product variation ID.

How to Automate or Schedule the Price Update Import?

You can automate your price's import using our available options:

  • Automatic Scheduling: optional and monthly paid service that can be used directly from within WP All Import's interface. Learn more: Run WordPress Import on a Schedule.
  • Manual Cron Jobs: set up manual cron jobs in your server and automate this price update import. This is included with WP All Export Pro out of the box. Learn more: Scheduling Imports Using Cron Jobs.

What Add-Ons Do I Need to Update WooCommerce Products?

To update the price in your WooCommerce products, you need to have the WooCommerce Import Add-On active on your site, along with WP All Import.

Related Docs

Learn how to update and sync product stock levels with an external feed.

Shows you how to import WooCommerce products using WP All Import.

Step-by-step instructions on how to update existing data from your WordPress site.

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee

Lifetime support. Lifetime updates. Pay once.

Import
Pro Package
$199
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export
Pro Package
$199
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross