How To Bulk Edit WooCommerce Product Prices in Excel

You can bulk edit simple and variable products in minutes, with complete control over your data using tools you already know like Excel. This video focuses on editing WooCommerce product prices, but really there are no limits - with WP All Export and WP All Import you can mass update any WooCommerce product data.

First you choose which products you want to export. Then, you select which data you want to edit and run the export. Next, open the export file in Excel and do whatever you need to do with your pricing. WP All Import will import your modified export file, automatically matching to existing WooCommerce products, adding the new prices.

[cwilkins]

Dear god you saved me hours of editing doing it this way! Just building my site and each item has multiple variables that have to be priced and sku'd individually, and it has literally saved me DAYS of work!

[Kjaer]

Is it possible to do the exact same thing but only with cost prices?

[richmonfandino]

hi,

Can you please help me with the problems in the stock issues, I am importing some items that I want to be out of stock using Wp Export/import but it doesn’t change any stock status. Can you help me with this issue?

thanks

[tomasssss]

Hello! I'm trying to import but I get the message that the csv file has errors. Can you recommend me how to edit the csv file? Thanks

[IvanGerasymchuk]

Is it possible to use woocommerce import in the free version?

[tjmccann]

hi are you using the paid version for this task?

[MicheleToscan]

When I export the file Excel tells me the extension does not match, and then gives a "SYLK" error. When it opens it, all data is scattered around and not in columns. Ideas?

[chandannasta]

If i want to upload large amount of data I have to do like that only what. Is there any way I can get in touch with you or email you or chat with you?

[alessandrogiacani]

Sorry but free version works with updates? i tried and something was wrong ...

[alzaabi]

I hope you add New review with multi language wpml

[PswACC]

Based on what I have read you should Never Open a CSV file in Excel.