Importing products via CSV
One of my first WooCommerce projects was for a large furniture company that had its own proprietary database, where it kept all of its product information. This database was where it added new products, updated prices, added photos, and placed products into categories.
The company wanted its website to reflect what was in the database. So, we had two options:
- Integrate with WooCommerce so that every database change is mirrored on the website
- Export products into a CSV file and import it into WooCommerce
Functionally speaking, both approaches achieve the same results. However, having to maintain integration with an unfamiliar proprietary database sounds like a lot of work and a potential headache. Conversely, exporting products into a CSV file is easy, and it’s equally easy to import that CSV into WooCommerce.
We’re now going to look at how you can import a CSV file into your WooCommerce store.
Importing a CSV
From...