WebToffee Logo
  • Home
  • Plugins
  • Blog
  • Documentation
  • Support
Login
0

  • Getting Started
    • Plugin setup
    • Import/Export Products
    • Import/Export Product Reviews
    • Import/Export Product Tags
    • Import/Export Product Categories
  • Import
    • Import products with attributes
    • Import google drive images
    • Import grouped products
    • Import products using URL
    • Importing downloadable products
    • Import subscription products
    • Import products using CSV
    • Import products with images
    • Updating evaluation fields on Import
    • Import products from MS Excel
    • Import products with categories
    • Import products from Google Spreadsheet
    • Import composite products
    • Import external/affiliate products
    • Import variable products from CSV
  • Export
    • Export products to CSV
    • Batch export products
    • Exporting products by category
    • Export definite number of products
    • Export product variations[v-3.8.5]
    • Export product lists[v-3.8.5]
    • Export products to MS Excel
    • Export product with categories
    • Export products with images
    • Export variable products
    • Export products with attributes
  • Meta Data
    • Import product metadata from CSV
  • Bulk Edit
    • Bulk update product category
    • Bulk upload variable products
    • Bulk upload products
    • Bulk update product price
  • FTP Cron Schedules
    • Cron Import products using multiple CSVs
    • Cron scheduled Import-export
    • Export products via SFTP
  • Code Snippet
    • Set email alert on cron import
    • Export without user restrictions
    • Export/Import bundled products
    • Export/Import product variation images
    • How to filter and export WooComm...
    • Alter product data
    • Compatibility with YITH Product Bundle
    • Export reviews with no ratings
    • Import images from multiple columns
    • Support for WebP images
  • Advanced Topics
    • Migrate from Shopify to WooCommerce
    • Update simple and variable products
    • Import/Export custom fields
    • Update inventory data
    • Import/Export products to Google Spreadsheets
    • Updating product stock
    • Plugin visibility on a multisite
    • WPML Compatibility
    • Thumbnail regeneration failure on product import
    • Import/Export product bundles
    • Set up cron when site activity is less
    • Export WPML multilingual products
    • Update product variations without SKU
    • Steps to import WPML products
    • Duplicate entry in the media library
    • Memory limitations on Import/Export
    • Import/Export product images in ZIP
  • Troubleshooting
    • Finding PHP Error Logs
    • Resolve “Call to undefined function mb_detect_encoding()”
    • Resolve post ID conflicts on import
    • Troubleshooting Guide-Products
    • Maximum file upload size
  • Third-Party Compatibility
    • Plugins
  • FAQ
    • Frequently asked questions
  • Changelog
    • Version 1.1.2

Documentation/Product Import Export Plugin for WooCommerce/How to Bulk Update Price in WooCommerce

How to Bulk Update Price in WooCommerce

Last updated on July 19, 2021

The screenshots and content you are viewing may correspond to an older version. We are in the process of updating the documentation to reflect the current version. Until then, you may refer to the latest set up guide for an insight.

WooCommerce gives provision to update every single aspect of a product very easily. But what if you need to update the details of hundreds or thousands of products? Editing and updating products one by one is exhausting and impractical.

When it comes to e-commerce, the price of a product is an important parameter that needs to be updated now and then. With our product import-export plugin, you can bulk update product prices of both simple and variable products without having to do it manually one by one.

In this article, let us see how the price of products can be bulk updated in just a few easy steps:

  • Export products into CSV
  • Import product back using updated CSV

Export products into CSV

Let us begin with exporting the products from your store into a CSV file which can then be edited for updating product price. The steps involved in exporting products are given below:

  1. On successfully installing and activating the plugin, navigate to WooCommerce > Product Im Ex from your dashboard.
  2. By default the Product Export panel opens up as shown below:
WooCommerce Product Export
WooCommerce Product Export
  •  The export product panel consists of several filters by which you can customize the output generated. Since additional export filters are not necessary in this case, let’s go ahead and click on Export Products (CSV) to export all the products from your store into a CSV file.
  • Now that we have obtained the CSV file, the necessary changes can be made into it. As we are dealing with how the product price can be changed, we will update the sale_price of the product (Hoodie). Currently, its price is $42 as shown below, let us update its price to $40.
  • Hoodie-Product view
    Hoodie-Product view
  • Open the CSV file and update the price of the product from the sale_price column of the CSV. We can update it from $42 to $40 as shown below.
  • Update product price
    Update product price
  • Save the updated CSV file. This file can be used to import product updates back into the store.
  • Import products using updated CSV 

    The products can be imported back with the updated price in the following manner:

    1. Navigate to WooCommerce > Product Im Ex
    2. Move on to the Import section. Attach the updated CSV file from your system.
    Product Import-Bulk update product price
    Product Import-Bulk update product price
  • Enable the update products if exists a checkbox to update existing products as shown above. Existing products are identified by their product ID/SKU.
  • Proceed to upload file and import for moving to the mapping fields.
    Note: Optionally, while uploading the CSV for updating product detail, either

     

    • Upload the CSV by deleting all other columns except the column to which the change is made or else
    • Choose Do not import for all other columns except the column to which the change is made from the Map field section.
      This can be done only in cases where product detail specified in the CSV and that contained in the store is different and you do not want to update these changes other than the required ones ( in this case: price) to get reflected in your store on import.
  • From the mapping page, submit to import the updated product price.
  • On successfully merging products, you can see that the product price is updated to the latest value.
  • Product price updated successfully
    Product price updated successfully

    Refer to our documentation and product page to know more about the product import export plugin.

    • Was this article helpful?
    • Yes, thanks!Not really
    Get the plugin

    On this page

    • Export products into CSV
    • Import products using updated CSV

    This article posted in Bulk Edit, Documentation, Knowledge Base, Product Import Export Plugin for WooCommerce and tagged bulk update, price, Products, woocommerce

    Written by

    Shesna

    Shesna is a technical content writer for WebToffee. She is familiar in working closely with the SMEs to break down complex technical information into a concise, easy to understand manner.

    Comments (2)

    1. Marc Cognet

      Marc Cognet

      July 20, 2021

      HI there i have the basic plug in where i edit csv files to import vias your plug in and works great but wan to buy the premium at a stage soon but i have a question.

      I get feeds from suppliers directly etc and i save and work on them. can this plug in work out the cost from supplier and automatically add a margin to this? or must i do that manually?

      Reply
      • Alan

        Alan

        July 26, 2021

        Hi,

        Using the pro version plugin you can modify the price value while importing without actually changing them in the CSV file.

        Reply

    Got any query? Please leave a comment or reach out to our support

    Cancel reply

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

    We develop awesome WordPress plugins & WooCommerce extensions to help build successful online businesses.

    © 2021 WebToffee. All rights reserved.

    Our plugins

    • GDPR Cookie Consent
    • PDF Invoices & Packings Slips
    • Product Import Export Plugin
    • User & Customer Import Export
    • Import Export Suite
    • Sequential Order Numbers
    • Smart Coupons for WooCommerce
    • URL Coupons for WooCommerce
    • PayPal Express Checkout
    • Stripe Payment Gateway
    • Subscriptions for Woocommerce
    • Product Catalog Sync for Facebook
    • PrintNode for PDF Invoices
    • Order, coupon, subscriptions for WooCommerce
    • WordPress Backup and Migration
    View more +

    Get Started

    • Plugins
    • Testimonials
    • Affiliates
    • We're hiring

    Help & Support

    • Documentation
    • Documentation (Basic)
    • FAQ
    • Support

    Company

    • Terms & Conditions
    • Privacy Policy
    • Refund policy
    • Support policy
    • License Activation

    © 2021 WebToffee. All rights reserved.

    We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies. However you may visit Cookie Settings to provide a controlled consent.
    Cookie settingsACCEPT
    Privacy & Cookies Policy

    Privacy Overview

    This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of the basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website, to store user preferences and provide you with content and advertisements that are relevant. Such cookies will be stored on your browser but only upon procuring consent.

    You will also have the option to opt-out of these cookies should you want to. But opting out of some of these cookies may have an effect on your browsing experience as per the descriptions elucidated against the respective categories below.

    Necessary
    Always Enabled

    The cookies defines under this category are absolutely essential for the website to function. Hence they are loaded by default irrespective if user consent.

    CookieDescription
    PHPSESSIDThis cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user sessions on the website. The cookie is a session cookie and is deleted when all the browser windows are closed.
    viewed_cookie_policyThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not a user has consented to the use of cookies. It does not store any personal data.
    Analytics

    Analytics cookies help us understand how our visitors interact with the website. It helps us understand the number of visitors, where the visitors are coming from, and the pages they navigate. The cookies collect this data and are reported anonymously.

    CookieDescription
    _gaThis cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randomly generated number to identify unique visitors.
    _gat_gtagIdentification code of website for tracking visits.
    _gidThis cookie is installed by Google Analytics. The cookie is used to store information on how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
    _hjidHotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
    _hjIncludedInSampleThis cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate heatmaps, funnels, recordings, etc.
    has_recent_activityThis cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
    tk_aiGathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
    tk_lrThis cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
    tk_orThis cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
    tk_qsGathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
    tk_r3dThe cookie is installed by JetPack. Used for the internal metrics for user activities to improve user experience.
    Advertisement

    Advertisement cookies help us provide our visitors with relevant ads and marketing campaigns.

    CookieDescription
    _fbpThis cookie is set by Facebook to deliver advertisements when they are on Facebook or on a digital platform powered by Facebook advertising after visiting this website.
    frThe cookie is set by Facebook to show relevant advertisements to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook Pixel or Facebook social plugin.
    Preferences

    Preference cookies are used to store user preferences to provide them with content that is customized accordingly. This includes the language of the website or the location of the visitor.

    CookieDescription
    _gh_sessThis cookie is used to preserve users' states across page requests.
    Save & Accept