Resolved Is it possible to import this CSV file?

Hello Andrej,
You want to import these products into VirtueMart? Do you want to import them as Multi variants in VirtueMart? If not tell us the custom field type you want to use.

Hello,

yes I want to import CSV into virtuemart as product multivariants.

Field type: Color. Size, Availability

Please see attachments ;-)

Best regards
Andrej

Hello Andrej,
You have Color. Size, Availability as columns in the file which is good. All you need is to setup multi_variant_title and multi_variant_fields like explained in Importing Multi Variant custom field document. multi_variant_title will be the name of the Multi Variant field you have created and multi_variant_fields will have values Color~Size~Availability only for parent product row.

To do that
1. Add multi_variant_title and multi_variant_fields as template fields along with other fields
2. Create a conditional rule to add values to these fields only for parent product. You can do that by checking if parent product SKU is empty. See attached screenshot. Apply this rule on parent product SKU field.
3. Run import and check. Before running import on import preview page see if multi_variant_title and multi_variant_fields gets values as applied in the rule.

Hello,

ok I try it

Please, how does the RO CSVI know which product has which variants when there is no SKU available in the imported
file?
Is it possible to update products over time, for example - stock status, size, color when the original CSV file changes?

Best regards
Andrej

Hello Andrej,

Please, how does the RO CSVI know which product has which variants when there is no SKU available in the imported
file?

There should be one unique field value in import file to identify the existing product in database. Unique field can be product_sku or product_mpn or product_gtin. Otherwise RO CSVI will not import the product and would throw error that required field is missing. Another way is to use virtuemart_product_id to update existing products. This field won't work to create new products.

Is it possible to update products over time, for example - stock status, size, color when the original CSV file changes?

You can set import as a cron job and make it run with time. Check Setting up a cron job in RO CSVI document.

Hello,

There should be one unique field value in import file to identify the existing product in database. Unique field can be product_sku or product_mpn or product_gtin. Otherwise RO CSVI will not import the product and would throw error that required field is missing. Another way is to use virtuemart_product_id to update existing products. This field won't work to create new products.

so I can use the first ID column and save it in the VM as product_sku - so I will always have a unique product identifier, can it be so?

Best regards
Andrej

Hello Andrej,

Yes, you can use the ID column as SKU as long as the values are unique. If they are not unique, any existing product will be overwritten.