1. EsSa55
  2. RO CSVI
  3. Friday, 19 June 2020
  4.  Subscribe via email
Good Day

I have read your article on the subject of Stockable variants import.

Currently, all our products with variants are set up as individual products.

They would become children of the parent product (to be created).

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

Presumably there is a template to create?

If so, what are the parameters?

Apologies if I have missed something obvious.

TIA

Eddie
Accepted Answer
Accepted Answer Pending Moderation
Solved!

My 2nd mistake was to only include the content of the Parent custom_tile once, rather than 3 times.

It should be:

Stockable custom fields - baby size~Stockable custom fields - baby size~Stockable custom fields - baby size

NOT

Stockable custom fields - baby size


AND

all is now well.

Thanks for your help.

Best

Eddie
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
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
  1. 3 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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
Attachments (2)
  1. 3 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Here's the plugin configs.........
Attachments (2)
  1. 3 weeks ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!