Update Woocommerce stock by SKU

[ad_1]

Hi. I have 200 items on Woocommerce. I have an Excel file with the same item details, except the number of stocks for each is different than on the website, and the product titles too.

I want to update ONLY the stock number on the website based on the SKUs. Both SKUs on Excel and website are same. How to update the website stocks based on SKUs only? I want only the stock to be updated, not titles or prices.

[ad_2]
1 Comment

  1. Just remove the unnecessarily columns and save excel file as CSV. import the file into Woocommerce. It will match and update the the stocks.

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer