CODEWITHSUNDEEP
mysqlwordpresswoocommerce
Soucrit
Soucrit

Reputation: 323

Automatically importing products into Woocommerce

I am trying to find a way to automatically import products into Woocommerce. I was wondering if someone had any experience with this, whether using a CSV or directly writing to the database.

Upvotes: 15

Views: 60886

Answers (3)

ethanpil
ethanpil

Reputation: 2532

  1. The Easy Way:

You can easily import CSV files into WooCommerce using the CSV Import Extension: http://www.woothemes.com/extension/product-csv-import-suite/

Or you can use the more flexible WP All In One Import: http://www.wpallimport.com/woocommerce-product-import/

Automating product import from CSV is possible with this WooCommerce plugin

There is also a free solution via this plugin: https://wordpress.org/plugins/product-import-export-for-woo/

  1. The Hard Way:

Woocommerce Products are regular WordPress posts, with a custom post type of product. This means that each product is stored in the wp_posts table (or replace wp with your table prefix). There are many post_type values here. The ones for WordPress have a post_type="product"

All additional product info is stored in the table wp_postmeta and connected by the post_id column to the wp_posts table. There are many meta key/values used, but the most common ones for WooCommerce are fairly intuitive, such as: _visibiilty, _price, _sku, _stock, _length, _width, _height, etc...

I suggest you manually input several products into the WP Admin and then study the data in the tables to make sure you have all the data you need... then you can write your own custom import suite.

Doing it yourself probably will not work as well as some of the pre-made solutions which provide you with good error checking of the input data, and additional fields and preprocessing functions.

Upvotes: 28

Swapnali
Swapnali

Reputation: 1299

The WordPress Importer will import the following content from a WordPress export file:

  • Posts, pages and other custom post types
  • Comments
  • Products
  • Custom fields and post meta
  • Categories, tags and terms from custom taxonomies
  • Authors

You can use WordPress Importer plugin for import products into Woocommerce.

  • Installation of the Plugin-

    1. Visit Tools -> Import in the WordPress dashboard
    2. Click on the WordPress link in the list of importers
    3. Click "Install Now"
    4. Finally click "Activate Plugin & Run Importer"

  • Usage of the Plugin-

    Step 1 : Go to the Tools -> Import screen

    Step 2 : Click on WordPress.

    Step 3 : Select Input File from a computer.

    Step 4: Click on Import

Video Tutorial- The video tutorial on the following page might also be a good resource for import products -

How to import dummy .xml data in wordpress

Upvotes: 1

mujuonly
mujuonly

Reputation: 11841

If you have CSV full of WooCommerce simple Products , you can import all those along with images from URL in one click with this free plugin

Upvotes: 1

Related Questions