WooCommerce Importing Products

Importing products can reduce development time dramatically. With a properly constructed XML or CSV file, the time it takes to add hundreds, or thousands of products is hours, instead of days or weeks.

The key to making the import process quick, is to understand the data your products have, and how to build the import file so that your data not only shows up where you want, but will function properly also. Simple products are, well, simple. Each product only has one row in the CSV file, or one set up data in an XML. Variable products take a little more work, but we’ll cover that later on.

[rs-space space=”35″/]

First, let’s get acquainted with the built in fields that WooCommerce includes.

[rs-space space=”35″/]

[rs-box_content style=”basic_block” txt_color=”” bkg_color=”#edeff5″ bkg_opacity=”1″ brd_color=”#edeff5″ brd_opacity=”1″ link=”” new_win=”no”]

WooCommerce Fields

Example product to help visualize where the fields go:

[rs-button label=”Example WooCommerce Product” link=”http://framework.sparklogix.com/product/woocommerce-demo-product/” new_win=”yes” full_width=”no” position=”left” size=”btn-large” type=”btn-primary” class=”” wrap=”no”/]

[rs-space space=”55″/]

    • Title
    • Main image
    • Gallery images
    • Price (and Sale Price)
    • Short description
    • Main description
    • Attribute dropdowns (if a variable product)
    • SKU
    • Categories
    • Tags
    • Stock related fields:
    • Manage stock (yes or no)
    • Stock amount
    • Stock status
    • Backorderability

[rs-space space=”55″/]

Additional Information tab shows any attributes attached to the product. (Used with our Layered Nav / Product Filter)

[rs-space space=”35″/]

A couple others that can show up are:

Upsell SKU

Up-sells are products which you recommend instead of the currently viewed product, for example, products that are more profitable or better quality or more expensive. These show up at the bottom of the product page.

[rs-space space=”35″/]

Cross-sell SKU

Cross-sells are products which you promote in the cart, based on the current product.

[rs-space space=”35″/]

More info:

WooCommerce Upsells and Cross-sells

[rs-image img_url=”https://www.sparklogix.com/wp-content/uploads/2016/08/visible-woocommerce-product-fields.jpg” link=”” alt=”Visible WooCommerce product fields” width=”” height=”” class=”” type=”primary” border=”default” new_win=”no” margin=”” pos=”center” wrap=”no”/]

[rs-space space=”35″/]

Other Built-in Fields

Some of the main ones that you should be aware of are:

  • Weight
  • Height
  • Length
  • Width
  • Tax settings (see the link below to find more details)

[/rs-box_content]

[rs-space space=”55″/]

For more details on all the fields, and the values that are accepted, this is the best place:

WooCommerce CSV Header fields

[rs-space space=”55″/]

Custom Fields

There is also the option of custom fields. Usually the Product Attributes are sufficient to cover any custom data about a product, but more functionality could be needed, and that’s what we’re here for.

As for the actual import, we prefer to use WP All Import instead of WooCommerce’s CSV Import Suite

[rs-space space=”35″/]

More detail on the importing options can be found here:

[rs-columns gutters=”gutter”]

[rs-one_half]

http://www.wpallimport.com/documentation/woocommerce/overview/

[/rs-one_half]

[rs-one_half]

http://www.wpallimport.com/documentation/woocommerce/variable-products/

[/rs-one_half]

[/rs-columns]

I’ll be doing another post about how to use this import tool, but their┬ádocumentation and videos will provide a good overview of how it works if you’re curious.

I hope this helps to clarify what if possible with WooCommerce, and importing content. There are a lot of details and variances with this aspect of setting up a new WooCommerce store, which I can’t cover all in one post. If you have a specific question, I’d be glad to try and answer below in the comments, or you can contact me directly in Basecamp (if you’re already a client).

[rs-space space=”35″/]

Leave a Reply

Your email address will not be published. Required fields are marked *