官术网_书友最值得收藏!

Bulk-uploading products with a CSV File

By now, you should have a pretty good idea of how you can configure your products. You're probably ready to set up all of your products and get this WooCommerce site up-and-running! If you only have a handful of products, I encourage you to do so. If you have hundreds or thousands of products, you can save yourself a whole lot of time by learning how to upload products in bulk.

Getting ready

You'll need to have installed and activated the Product CSV Import Suite plugin, available at http://www.woothemes.com/products/product-csv-import-suite/.

You should also have a simple product in your store.

Tip

There are free CSV uploaders in the WordPress.org repository that you could use. I would, however, advise caution. They're not as well maintained and, if there is a bug, your database could be filled with thousands of records that clutter everything up.

How to do it…

There's a trick to uploading your products that most people aren't aware of. It adds an extra step in the beginning, but it makes the whole process much easier. The first part is actually exporting some products from your store. By exporting them, you'll know the exact format you have to use to upload them.

  1. From the WordPress admin, go to WooCommerce | CSV Import Suite.
  2. Click on the Export Products tab.

    There are a bunch of settings on this page. You could very easily limit how many products are exported. This isn't really a concern for new stores. If you have a 100 or fewer products, just export everything.

  3. Click on Export Products. A woocommerce-product-export.csv file should be saved to your computer.
  4. Now open the downloaded file with your favorite calculation program. I like Sheets in Google Docs, but you could also use Microsoft Excel or Numbers for Macs.
    How to do it…

You can now use the existing products in your exported file as a template for new products. I have a red poster and a blue poster in my sheet. I'm going to use those as a template for a green poster.

Tip

You can leave the ID and post_date fields blank. They will be automatically calculated.

Now that you have your CSV file created, you can upload it. Follow these steps:

  1. From the WordPress admin, go to WooCommerce | CSV Import Suite.
  2. Click on the Import Products button.
  3. Click on the Choose File button and select the file from your computer.
    How to do it…

    Note

    At this point, you'll see a screen asking you to map fields from your CSV file to the fields in the database. If you exported a CSV file first, you shouldn't have to map any fields. It still is worth a quick check to make sure the fields in the CSV file are matching the fields in the database.

  4. Click on Submit at the bottom of the page and wait for the products to upload.

There's more...

The CSV Import Suite can import either only simple products or only variable products. Don't try to import both at the same time. The steps are almost identical. Instead of clicking on the Import Products button on the CSV Import Suite screen, you must click on the Import Variations button.

Note

The process of uploading variable products is slightly different and is documented at http://docs.woothemes.com/document/product-csv-import-suite-importing-product-variations/.

主站蜘蛛池模板: 汉沽区| 梅河口市| 中卫市| 古田县| 临汾市| 公安县| 通河县| 修武县| 新绛县| 南投县| 南和县| 兰溪市| 长春市| 津南区| 探索| 襄城县| 延寿县| 丹寨县| 泰来县| 嘉祥县| 浏阳市| 云安县| 岑溪市| 乌海市| 沁水县| 额尔古纳市| 玉山县| 应用必备| 新乡县| 江都市| 偃师市| 忻州市| 长泰县| 阳城县| 宁河县| 虹口区| 天镇县| 福泉市| 集安市| 杨浦区| 南涧|