tenashi:
I don't see a reply to this thread, but I have been spinning my wheels with the same issue. Some of us newbies are way over our heads with a lot of ZC; so even "simple" instructions often need to be broken down into smaller pieces. In my case, I have a small wine shop, so my products are wines from a large number of producers, and I want categories of about a dozen regions, a few price ranges, and a few colors. Not that complicated. After loading several sample products and categories, I downloaded the product file and found that each product was listed several times, once for each subcategory, and that seemed wrong.
However, I don't know how to make use of this statement: "To achieve this, each v_categories_names_1, v_categories_names_2 correspond to a language installed in your system, and individual category names are separated by the Carat "^" symbol. For Example: Bar Supplies^Glass Washers^Brushes" A sample file illustrating this would be extremely helpful, along with some details about how the sample file accomplishes this. Not to mention, I have NO idea what the term "language" means in this context...!
Then the question after that would be, okay, what are the rules for naming and uploading my data file? I see the download file has a name like "FullEPYearDayTime.csv," so no help there.
Btw, my site (under construction) is https://www.artisanwineclub.com...
All help appreciated, thanks.
This is how I would do it:
First create Region categories (top category, ie: California, Italy, French, ...)

Second create Color categories per region (subcategory, ie: Reds, Whites, Roses, ...)

Third create Wine bottle for specific region and Color (Products. ie: Wine Red A, Wine Red B, ...)

When you export from EP4, **Complete Products (with Metatags) ** You should get a csv file similar to the following (The Horizontal record 1,2 & 3 and NOT rows 5 through 37, I transposed it, for you to see all cells!)

As for the language, I only use English, so I guess it's for carts that offer multilingual carts?
I hope it helps.