Resolved Stockable variants import

Hello Eddie,

I wish to import some stockable variants into many products, so where does the csv file get imported to?

Stockable variants are custom fields in VirtueMart. So import of csv file will be added as a custom field for a product. After import, You can check Custom fields tab on VirtueMart Product edit page.

Presumably there is a template to create?

Yes, you need to create VirtueMart Product import template.

If so, what are the parameters?

The fields you need in import file are product_sku(required field), product_parent_sku, custom_title, custom_value, custom_multiple.

An example content will be

product_sku","product_parent_sku","custom_title","custom_value","custom_multiple","product_name","product_price"

"10001","","Size and Color~Size and Color","stockablecustomfields~stockablecustomfields","Y~Y","Parent product","123"

"10001brbl","10001","Size~Color","M~Green",,"Child Medium Green",

"10001brge","10001","Size~Color","L~Red",,"Child Large Red",

You need to define number of children a product has in parent row. Like in the above example, parent(10001) has two children(10001brbl, 10001brge) so custom_title, custom_value and custom_multiple takes 2 values of child product. This is also explained in Stockable variants import under Creating the CSV file section. Let me know if that helps.

Hello Tharuna

I set up the template and csv but unfortunately it does not work as I had intended.

My child products already exist and I have created a parent product for them.

This template creates each of the child products and the parent again.

Or, have I misunderstood its purpose as I only wish to add the stockable variants to the existing products?

Best

Eddie

Hello Eddie,
Creating products again should not happen if you have the products already in the database. Can you post the debug log of the import and sample of import file? To get the debug log check How to get debug information? document.

Hello Tharuna

Ok, my first mistake was that I entered the VM product id rather than the product sku.

Having corrected that, the Parent/Child side seems to work ok but the stockable custom fileds are not added to the Parent Product Custom Fields page.

So, there are no variants on any of the Child products.

"Baby Age/Size" is a customfieldsforall string.

The files are attached.

Best

Eddie

Here's the plugin configs.........