Jump to content

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

Store Wide Price Change For An Option Rate Topic   - - - - -

 
  • Traveler
  • Senior Member
  • Members
  • Join Date: 02-Feb 07
  • 932 posts

Posted 22 September 2021 - 03:27 AM #1

Store wide price change for an option:

 

I have several product options setup so a customer can select a product and on the product page there is the option to add an upgrade to the product for an additional charge.

 

​I want to change the upgrade price for all products at one time and I can't see how to do this as when I change the option price on the option page it doesn't change at the proctor level so it looks like I am missing a step any ideas?

 

​I can go to each product and make the change but this is too slow...

 

 


Version 4.9.2


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

Posted 22 September 2021 - 05:11 AM #2

For example, in phpMyAdmin use

UPDATE cscart_product_option_variants SET modifier = '25' WHERE modifier > 0;

and

UPDATE cscart_ult_product_option_variants SET modifier = '25' WHERE modifier > 0;

where 25 - is the required value in primary currency


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 1210     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 4025     CS-Cart + YOUPI      USD 1459      Multi-Vendor Ultimate       USD 7500 (6000)


 
  • Traveler
  • Senior Member
  • Members
  • Join Date: 02-Feb 07
  • 932 posts

Posted 22 September 2021 - 09:14 AM #3

Thank you for your idea.

 

I don't understand your post but I thank you for trying to help!

 

It looks like by default using a button or menu item etc you are saying I can't make a storewide change to an option - instead it will require some coding...

 

Strange that CS cart would have forgotten to add this feature maybe you are not understanding me...


Version 4.9.2


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

Posted 22 September 2021 - 01:24 PM #4

As far as I understand, you want to change option modifier price in bulk. Our solution allows to do it through direct requests to database


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 1210     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 4025     CS-Cart + YOUPI      USD 1459      Multi-Vendor Ultimate       USD 7500 (6000)


 
  • Traveler
  • Senior Member
  • Members
  • Join Date: 02-Feb 07
  • 932 posts

Posted 22 September 2021 - 03:15 PM #5

Duplicate


Version 4.9.2


 
  • Traveler
  • Senior Member
  • Members
  • Join Date: 02-Feb 07
  • 932 posts

Posted 22 September 2021 - 03:17 PM #6

Editing Option.png

 

Apologies if I was not clear does this screenshoot help? Is this what you thought I meant?

 

Example six folds are currently $40 on all my product pages but I want them to be $50 as in my screen shot - but they are still $40.

 

So I think I am doing something wrong...


Version 4.9.2


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

Posted 23 September 2021 - 06:55 AM #7

How many store-fronts do you have?


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 1210     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 4025     CS-Cart + YOUPI      USD 1459      Multi-Vendor Ultimate       USD 7500 (6000)


 
  • Traveler
  • Senior Member
  • Members
  • Join Date: 02-Feb 07
  • 932 posts

Posted 23 September 2021 - 09:17 AM #8

Only one store front with maybe 3,000 products and 30 categories.


Version 4.9.2


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

Posted 23 September 2021 - 01:26 PM #9

So, you want to change option price modifier for 3000 items from USD 40 to 50 at once. Right?


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 1210     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 4025     CS-Cart + YOUPI      USD 1459      Multi-Vendor Ultimate       USD 7500 (6000)


 
  • Traveler
  • Senior Member
  • Members
  • Join Date: 02-Feb 07
  • 932 posts

Posted 23 September 2021 - 01:57 PM #10

So, you want to change option price modifier for 3000 items from USD 40 to 50 at once. Right?

 

Something like that - After checking just now I see that I have 347 categories and 4,000 products some products have no add-on price options, and  some have three and some have five or six. 

 

Currently I only want to change one add on by adding 10 dollars so from 40 to $50 dollars.

 

I assumed that there must be an easy non code way to do this as I am allowed to easily change the price to $50 on the page that I posted a screen shot of. But I can't find a solution taht is easy to do...


Version 4.9.2


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

Posted 24 September 2021 - 05:30 AM #11

Unfortunately, there is no way to do it from the admin panel. So use sql requests in phpmyadmin as per my example

 

Just in case make database backup


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 1210     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 4025     CS-Cart + YOUPI      USD 1459      Multi-Vendor Ultimate       USD 7500 (6000)


 
  • Traveler
  • Senior Member
  • Members
  • Join Date: 02-Feb 07
  • 932 posts

Posted 24 September 2021 - 06:22 AM #12

Thank you for trying to help!


Version 4.9.2