Fastest Way Of Updating Option Price Modifiers

General General Questions
1

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?

2

export them to .csv like about but open it in excel as seperate cells, we find it quite easy then to update by percentages etc

3

Hi,

There are following parameters added to every option in export table:

///inventory=Y///missing_variants_handling=M///multiupload=N///required=N///status=A

Do I really need them in import table? I mean the string is already big enought without this. And if I can just delete this "extra", I prefer to do it.

There is nothing said in the user guide about that.

Any suggestions?

4

On the Administration -> Import data -> Products click on the "?" icon to see instructions for product options import format

5

I checked it.

It sais

{%Option ID[_L]%}%Option name%: %Option type%[{%Variant 1 ID%}%Variant 1%,{%Variant 2 ID%}%Variant 2%,{%Variant N ID%}%Variant N%]

and there is nothing about this part ///inventory=Y///missing_variants_handling=M///multiupload=N///required=N///status=A

That means it is not needed for import.

Why export and import format is different for this field. What is the sense if I do not write this line in import file and get it back after first export and have to delete it again.

6

I checked it.

It sais

{%Option ID[_L]%}%Option name%: %Option type%[{%Variant 1 ID%}%Variant 1%,{%Variant 2 ID%}%Variant 2%,{%Variant N ID%}%Variant N%]

and there is nothing about this part ///inventory=Y///missing_variants_handling=M///multiupload=N///required=N///status=A

That means it is not needed for import.

Why export and import format is different for this field. What is the sense if I do not write this line in import file and get it back after first export and have to delete it again.

I have just checked demo and you are right. These parameters can be used in the import, but they are not necessary