Jump to content

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

Zero Price Action - Default Rate Topic   - - - - -

  • quesada19
  • Member
  • Members
  • Join Date: 26-Nov 19
  • 47 posts

Posted 14 January 2020 - 02:51 PM #1

Hello everyone.



On the Zero Price action is there a way to default it to 'allow customers to add to cart'?

Its not a major problem but I am trying to make the process of listing a product as simple as possible for my suppliers and think this would help as it could easily be over looked.

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

Posted 14 January 2020 - 06:54 PM #2

Someone will probably come along and tell you which bit to amend in which TPL file, 


You can export all products for now with the "Product code" and "Zero price action" fields and change from R to P,  then bring back in


  • R—do not allow to add the product to cart.
  • P—allow to add the product to cart.
  • A—ask customer to enter the price.

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

  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3948 posts

Posted 14 January 2020 - 08:35 PM #3

Run this query to change it in the database.

ALTER TABLE `cscart_products` CHANGE `zero_price_action` `zero_price_action` CHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'P';