In this article, we will be going over the steps required to import products with variations to your WooCommerce store, as well as cover some useful tips and tricks along the way.
This article could be viewed as a continuation of our previous one, where we covered the basics of sending and updating products in WooCommerce.

First of all, variations and their attributes need to be properly set in WooCommerce.
Otherwise, SyncSpider will not read them while mapping.

e.g. WooCommerce that has a brand, color, and size as variables would have this in the mapping section:

To add the variations, kindly go to your WP dashboard, and under Products, click on Attributes, as shown in the picture below:

and that after naming the attribute and adding its slug, configure the attribute by clicking configure terms:

Parent SKU

The source of products you are sending to WooCommerce doesn't need to have the Parent Product. If they don't simply check this option when configuring the target integration (WooCommerce):

Then, from your source integration, map the Parent SKU (UID):

Now, provided your source has the data similar to this (we are using a sheet as an example):

However, if you wish to add parent products manually, the sheet (or whatever source) would need to look something like this:

With that out of the way, it is time to finish up our mapping:

You would need to map all pa_variation fields as follows:

Use Constant Value set to true for "visible on frontend" and "used for variation" fields:

And lastly, based on the variation in question (e.g. size, brand, color), map the corresponding field and set the non mapped values action to Map automatically or create dynamically, as shown in the picture below:

Additionally, the following fields would have to be mapped with constant values:

NOTE: You can set whichever Status based on your needs except for "Draft". The draft will interfere with the variations.


We hope you found this Article helpful :)

If you still have any questions or inquiries left unanswered, please email us at [email protected].

Additionally, you can shoot us a message via our website's chat widget or get in touch with us on our Facebook page, and our Customer Support Representatives will be more than happy to assist you.

Did this answer your question?