Jump to content

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

Allow payment by points with sql query? Rate Topic   - - - - -

 
  • circlecity
  • Member
  • Members
  • Join Date: 12-Oct 06
  • 40 posts

Posted 03 April 2012 - 08:03 PM #1

is it possible to set all current products to "Allow payment by points" with a sql query?
Michael
CS-Cart Version 2.2.2

 
  • Alt-team
  • CS-Cart Developer
  • Authorized Reseller
  • Join Date: 18-Jan 11
  • 2823 posts

Posted 04 April 2012 - 11:53 AM #2

Hello, circlecity!

Please, try the following query

UPDATE`cscart_products`SET`is_pbp`='Y';

Best regards, Alt-team

ADD-ONS  Web development service  | CS-Cart dedicated developers

Buy MULTIVENDOR - USD 1250 (14% off)   Buy CS-CART LICENCE - USD 345 (13% off)

 Email - manager@alt-team.com | Skype - Altteam    


 
  • Alt-team
  • CS-Cart Developer
  • Authorized Reseller
  • Join Date: 18-Jan 11
  • 2823 posts

Posted 04 April 2012 - 11:54 AM #3

Sorry, font is too small. The query is

UPDATE `cscart_products` SET `is_pbp` = 'Y';

ADD-ONS  Web development service  | CS-Cart dedicated developers

Buy MULTIVENDOR - USD 1250 (14% off)   Buy CS-CART LICENCE - USD 345 (13% off)

 Email - manager@alt-team.com | Skype - Altteam    


 
  • circlecity
  • Member
  • Members
  • Join Date: 12-Oct 06
  • 40 posts

Posted 05 April 2012 - 01:52 PM #4

Worked like a charm!

Thank you
Michael
CS-Cart Version 2.2.2