Array ( [0] => GDPR Cookie Consent [1] => CCPA [2] => Getting Started [3] => Changelog [4] => GDPR [5] => Add and Categorise Cookies [8] => Auto-block cookies with Script Blocker [13] => Create Privacy Policy Page [15] => Customize Cookie Notice [18] => Customize Settings Pop up [19] => Change Toggle button color [21] => Display Cookie List [22] => FAQ [23] => Getting Started [24] => Multilingual Support [25] => Overview [26] => Import Export Suite for WooCommerce [28] => Order / Coupon / Subscription Export Import Plugin for WooCommerce [29] => PayPal Express Checkout Payment Gateway for WooCommerce [30] => Changelog [31] => Getting Started [32] => Issue Refund [34] => Video Tutorial [35] => Print Invoice, Packing Slip, Delivery Note & Label for WooCommerce [36] => Address Label [39] => Changelog [41] => Credit Note [43] => Delivery Note [45] => Dispatch Label [47] => FAQ [48] => Invoice [49] => Adding meta data [50] => Customizations [51] => Email PDF Invoice [52] => FAQ [53] => Getting Started [54] => Invoice Number [55] => Multilingual Support [56] => Overview [57] => Packing Slip [58] => Customizations [59] => Getting Started [60] => Pick List [62] => Proforma Invoice [65] => Shipping Label [68] => Product Import Export Plugin for WooCommerce [69] => Smart Coupons for WooCommerce [70] => Abandoned Cart Discount [71] => Advanced Coupon Options [72] => Bulk Generate [73] => Changelog [76] => Getting Started [78] => Import Coupon [80] => Sales Countdown Timer [81] => SignUp Coupon [82] => Store Credit [84] => Volume/Quantity based coupon [85] => Stripe Payment Gateway for WooCommerce [86] => Alipay [87] => Apple Pay [88] => Changelog [89] => Compatibility with Subscription [90] => Getting Started [93] => SCA Ready [94] => Stripe Checkout [95] => Stripe Overview [96] => Stripe via Credit Card [97] => Troubleshoot [98] => Video Tutorial [99] => Subscriptions for WooCommerce [100] => Changelog [101] => Email Notifications [102] => FAQ [103] => Getting Started [104] => Manually Add or Modify Subscriptions [105] => Subscriptions Payment Gateway Guide [106] => URL Coupons for WooCommerce [107] => Changelog [108] => FAQ [109] => Getting Started [110] => Import URL Coupons [111] => QR Code Coupon [112] => WordPress Users & WooCommerce Customers Import Export )

Documentation/Product Import Export Plugin for WooCommerce/How to bulk update price in WooCommerce

How to bulk update price in WooCommerce

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. With our product import export plugin, you can bulk update each and every single data of your product without having to do it manually one by one. When it comes to e-commerce, the price of a product is an important parameter that needs to be updated now and then. 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

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

    3.  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.
    4. 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

    5. 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

    6. 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

  3. Enable the update products if exists checkbox to update existing products as shown above. Existing products are identified by their product ID/SKU.
  4. 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 into your store on import.
  5. From the mapping page, submit to import the updated product price.
  6. 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 our documentation and product page to know more about the product import export plugin.

 

  • Was this article helpful ?
  • YesNo