A Step-by-Step Guide to Adding Variations using the Bulk Product Sync Plugin in WooCommerce

Bulk Product Sync Plugin in WooCommerce

Bulk Product Sync Plugin in WooCommerce

Bulk Product Sync Plugin in WooCommerce, The Bulk Product Sync (GoogleSync) plugin is a great solution for managing WooCommerce products, categories, and soon, orders and customers. Variable products can be easily added in just a few seconds. However, some clients may face issues while adding variations using Google Sheets. This guide will help you understand how to add variations using the Bulk Product Sync plugin in WooCommerce.

    1. In WooCommerce, there are two types of attributes: Global and Custom (local to the product).
    2. Global attributes are created from the WooCommerce > Attributes menu and can be used with any product once it is created.
    3. Custom attributes are local to the product in which they are created.
    4. It is recommended to use Global Attributes, however, custom attributes can also be created with the Bulk Product Sync Plugin.

To add variations, you first need to add attributes to the parent product. There are two types of attributes, Global and Custom.

Bulk Product Sync Plugin in WooCommerce

Global Attributes

woocommerce google sync
    • Let’s say you have already created a global attribute called Colors and defined its terms (options) like Red, Green, and Blue.
    • Inside the parent product, the value of the attributes column should be like this:
      [{"id":1,"position":0,"visible":true,"variation":true,"options":["Red","Green","Blue"]}]
    • id is the ID of the global attribute
    • position is the attribute position
    • visible is the visibility on the frontend under product details
    • variation is whether to use as variation
    • options are the options or the terms for this parent product

Once the attributes are defined inside the parent products, you can start adding variations under this product like:

    • The parent_id column must contain the ID of its parent
    • The type of the product will be variation
    • And most importantly, the value of the attributes column should be like this:
      [{"id":1, "option":"Green"}]
    • Here, the id is the ID of the global attribute and option value is Green.

Custom Attributes:

custom attributes
    • Custom attributes are added in a very similar way as Global, but the only difference is that this does not have the ID, instead, we use the name key.
    • For example, if you want to add Sizes as a custom attribute (which is not added as Global), the attributes value for the parent will be like this:
      [{"name":"Sizes","position":0,"visible":true,"variation":true,"options":["Small","Medium","Large"]}]
    • Here, you will notice that we used name instead of id and its value is Sizes, and the rest of the format is the same.
    • And for variations, you can set it with the following value:
      [{"name":"Sizes", "option":"Large"}]

So, it is important to understand the difference between these types of attributes in WooCommerce before you start adding variations using the Bulk Product Sync Plugin.

Leave a Reply

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

Contact Us

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.

    Your Name (required)

    Your Email (required)

    Subject

    Your Message