Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Fastest Way Of Updating Option Price Modifiers Rate Topic   - - - - -

 
  • Jmoffat
  • Member
  • Members
  • Join Date: 15-Oct 12
  • 42 posts

Posted 21 October 2016 - 03:07 PM #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?

 



 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4797 posts

Posted 21 October 2016 - 08:15 PM #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


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • sok777
  • Senior Member
  • Members
  • Join Date: 23-Jun 11
  • 411 posts

Posted 14 February 2017 - 09:11 PM #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?



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20759 posts

Posted 15 February 2017 - 06:52 AM #4

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • sok777
  • Senior Member
  • Members
  • Join Date: 23-Jun 11
  • 411 posts

Posted 15 February 2017 - 12:42 PM #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.



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20759 posts

Posted 15 February 2017 - 02:23 PM #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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)