stellarweb:
Customer does not remember what version - and does not remember it saying V4 - just EZ Populate. It was an old 1.5.0 website.
HOpe this helps
status Arcos Manu Number Scan Number Name Jpeg File Cost Tubes Cost X3.5 Retail v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_product_is_call v_products_sort_order v_products_quantity_order_min v_products_quantity_order_units v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_tax_class_title v_status v_metatags_products_name_status v_metatags_title_status v_metatags_model_status v_metatags_price_status v_metatags_title_tagline_status v_metatags_title_1 v_metatags_keywords_1 v_metatags_description_1 1 ARC510-00030-01700 ARC510-00030-01700 790524056132 Silver Aluminum Matte ARC510-00030-01700.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01700 /p-czech/ARC510-00030-01700.jpg Silver Aluminum Matte ARC510-00030-01700 6.00 0 0 20 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01710 ARC510-00030-01710 790524056163 Light Gold Matte ARC510-00030-01710.jpg 1.68 1 1.68 5.88 6.00 ARC510-00030-01710 /p-czech/ARC510-00030-01710.jpg Light Gold Matte ARC510-00030-01710 6.00 0 0 30 1 1 10000 XXXX Beads: Seed-Czech Arcos - 2 hole Taxable Goods 1 0 0 0 0 0 1 ARC510-00030-01780 ARC510-00030-01780 790524056231 Copper Gold Matte ARC510-00030-01780.jpg 1.68 1 1.68 5.88 6.00
While the data doesn't come across well formatted, I see the indicators that I expected for it being an older/alternate EP...
In EP4 as discussed in the instructions, the suffix '_1', '_2', '_3', etc. relates to the language that is being used... In one or more of the older versions, v_categories_name_1 was the "parent" category, v_categories_name_2 was the first sub-category off of the parent, v_categories_name_3 was the first sub-sub-category, etc...
In EP4 a specific sub-category would be generated by concatenating each of those (that have content) with the carat '^'...
So:
v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6
shirt long-sleeve no-buttons
for EP4 would be combined in a single field (v_categories_name_1 or (when using the most recent version) v_categories_name_en) to:
shirt^long-sleeve^no-buttons
Where the language_id for the store is 1... While not fully implemented across all import file types, the language_code is now supported to instead use '_en' as the suffix for English instead of the language_id (_1).
A way to accomplish that concatenation if the columns were say g, h, and i with the data starting in row2, then I would go to the next/last v_categories_name_X column, insert a new column, then use something like:
=IF(G2<>"", G2, "") & IF(H2<>"", "^" & H2, "") & IF(I2<>"", "^" & I2, "")
Now of course I wouldn't expect that there would be a "series" of information followed by an empty space then another with data (say _1 and _3 having data, but _2 not having data)...
After I got the result, then I would copy that function down to the last row, then copy the contents in that column for all product and paste special that text into the appropriate column representing the language_id and delete the other v_categories_name_X columns including the one that was created to support this effort...
Basically, EP4 supports multiple languages which older types did not appear to do so and the categories/sub-categories are identified as between each ^.
This is also why it is important to not introduce spaces before/after each category. " shirt" is different than "shirt" and results in category creation/population to the "applicable" category....
