How to create new order status while module Installations.

[nisargPresta]

Hi all,

 

   Can any one help me with code for creating new order status/email  templates during installation. It can be simillar as the paypal order status "Awaiting Paypal payment".

 

Thanks in Advance.

[PascalVG]

There are two tables involved:

ps_order_state

ps_order_state_lang

 

(ps_ = prefix)

 

On installation, make your SQL statement with INSERT INTO ....   (Google if you're not sure about the syntax)

 

Easiest is to make the state manually in your own shop, with all settings correctly set, and then just copy these values in the INSERT INTO values part

 

Then just execute the sql statement for each table, using this   ($sql is string that holds the SQL query)

 

 Db::getInstance()->executeS($sql);

 

 

On uninstal, you could do a DELETE FROM.... WHERE .... query and again execute it

 

 

Hope this helps,

pascal.