Hi everyone
I have a client who has lots of products that use colour and size options. modifiers are used to increase prices when certain options are selected.
When their suppliers send them price updates they might need to increase the option price modifier on every product within in a category.
This might mean updating the modifier on 50 options by 0.10 across 100 products. Very time consuming to do manually.
They could export the options, edit them in a spreadsheet then re-import but that means carefully editing a string that looks like this:
(store) Colours: S[white///image=exim/backup/images/variant_image/white_p7bu-at.jpg,black///modifier=0.300///modifier_type=A///image=exim/backup/images/variant_image/black_89k6-s3.jpg,red///modifier=0.300///modifier_type=A///image=exim/backup/images/variant_image/red_obc4-qc.jpg,yellow///modifier=0.300///modifier_type=A///image=exim/backup/images/variant_image/yellow.jpg,blue///modifier=0.300///modifier_type=A///image=exim/backup/images/variant_image/blue.jpg]///inventory=N///missing_variants_handling=M///multiupload=N///required=N///status=A; (store) size: S[S,M,L,XL,XXL,XXXL///modifier=0.300///modifier_type=A]///inventory=N///missing_variants_handling=M///multiupload=N///required=N///status=A
Naturally this is daunting for a regular user and not necessarily fast either.
So my question is has anyone found a fast way to update option modifiers?