Forum Discussion
How to effectively assign many items to multiple categories
Please, I have thousands of items in Excel - products for eshop, in separate rows, to which I need to assign more categories in the category column - from the total number of about 120 categories wit...
I will definitely try it, thank you
I'd suggest to denormalise source data as
First table is SKU with names, another one SKU with categories. With that they could be merged in resulting table, preferably with Power Query. In second table SKU and categories could be selected from drop-down lists.
How to create drop-down lists so that the selected value is plain text suitable for csv and for import into woocommerce?
Drop-down list works only in Excel (xlsx) file. CSV is actually text file, you may add drop-down list while it is opened in Excel, but it will be lost as soon as you save the file in csv format.