I’ve searched for an answer to this and have yet to find it. Will consider hiring someone to handle this use case, too.
My e-commerce platform allows me to create a number of custom fields that are essential for me to use in several ways, but it provides no way to edit them in bulk. In fact, it will only export those fields in a single cell like this:
AWG=10;Color=Black;“Number of Conductors=4”;“Conductor type=Stranded”;CSA=YES;“Insulation=EPDM - Ethylene Propylene Diene Monomer”;“Jacket type=Thermoset CPE”;
Not every product uses all the same fields, though many do. That means there is no consistent number of values in every cell. It could be several or 16 or …something else.
Also, I don’t know why it puts quotes around some fo the value pairs but not others. It seems not to do it for short ones. Very odd.
I would like to:
- Expand the one cell into columns using the value label before the “=” then populate the product row with the custom value that comes after the “=”.
- Edit values as I see fit.
- Re-compress all those cells back into one for an import back into my e-commerce system.
Thanks for reading and considering my case!