Importing Feature Variants

I will be importing feature variants and have some questions before I start. I did a feature export to tab delimited CSV and found that the Variants field of feature Brands contained a list of brand names delimited by a comma and space. If I have a list of brands which I want to import into cs-cart Brands feature variants, how do I escape any non-delimiting commas in my list values the variants field?

For instance, suppose my Brands list is:

"companyA,

companyB,

companyC, Inc. ,

companyD"

Then how do I escape the comma in "CompanyC,Inc." The result i got after adding a dummy variant "testco, inc." and exporting is:

companyA, companyB, companyC, companyD, 'testco.inc.'"

So it seems the variant with a comma needs to be enclosed in single quotes while the whole list also needs to be enclosed in double quotes.

Will importing a list of variants overwrite an existing list of variants? I'm afraid that multiple imports might erase all the descriptions and SEO entries made in my existing variants. Can one import a list of variant names without losing the contents of the other fields? If a list of variants which does not contain every existing variant is imported, what happens to the pre-existing variants which are not imported?

Thanks in advance.

I discovered by testing that when importing variant values, any pre-existing variant values along with associated data will be deleted if the variants are not in the current import list. Otherwise all data will be preserved. So all update imports need to contain every value. Strings with commas need to be enclosed in single quotes and any double-quoted strings need to get another set of double quotes.

I discovered by testing that when importing variant values, any pre-existing variant values along with associated data will be deleted if the variants are not in the current import list. Otherwise all data will be preserved. So all update imports need to contain every value. Strings with commas need to be enclosed in single quotes and any double-quoted strings need to get another set of double quotes.

Good to know thanks