This article will provide store owners with a quick guide on how to bulk import their products in WooCommerce in the following steps.
1) Create a Spreadsheet:
Log into your Admin account and navigate to the Dashboard. You need to have created a spreadsheet of your products beforehand. A sample image is given below:
The spreadsheet should contain your product name, description, URL link for the image, product type, category, stock, regular price and sale price where necessary. The spreadsheet may contain at least 40 products.
2) Save it as a CSV File:
Navigate to File. Click on Export to, select CSV. A message should pop up saying Export to CSV. Then click on Next. After the spreadsheet has been uploaded, you should be able to see the updates made on the website. You can open another tab to view the changes made the same way anyone viewing the site would see them.
3) CSV Import:
Navigate to the Dashboard and select CSV Import option. Click Select File and chose a file from your computer system. The file type would have been saved as CSV document. Then click Load and wait while it begins loading. A horizontal bar should show the progress as it uploads each row of your files until the total number is uploaded.
4) Check Update:
Refresh the page to view the changes. If you modified the regular price and sale price columns, then the new figures should have been updated.
5) What Should You Look Out For?
You need to check and make sure that the Post Titles match the URLs so that new products are not created if you only plan to update existing products. Otherwise, this may cause confusion and errors. It is advisable to maintain post titles and only make necessary adjustments in other fields.
Why not explore the advantages of setting up your e-store on the WooCommerce platform? Here at Libra Web Solutions we help cater to your every need concerning online business start-up at affordable rates so do not hesitate to contact us.
Libra Web Solutions is a reputable Ecommerce solution specialist that has transformed 75+ ecommerce ventures worldwide. Our services include WooCommerce and our team of experts are always willing to respond to your business needs with efficiency and quality.