Custom Order Fields

Is there a way to add custom fields to orders? I'm interesting to add a price values in secondary currency.

The point is to save the secondary price(s) based on current exchange rate so if it will change tomorrow the old values to be displayed

Is there a way to add custom fields to orders? I'm interesting to add a price values in secondary currency.

The point is to save the secondary price(s) based on current exchange rate so if it will change tomorrow the old values to be displayed

Hello!

If you want to add additional order total value, you need to create the column in the cscart_orders table in the database, save the value using, for example, 'create_order' hook and display the value on the order detail page in the admin panel design/backend/templates/views/orders/details.tpl.

Note that quite complex changes will be required if you want to show all price values with saved rates in admin panel, store-front and e-mails. For example, in the list of orders there can be 10 orders with individual exchange rate, etc

Note that quite complex changes will be required if you want to show all price values with saved rates in admin panel, store-front and e-mails. For example, in the list of orders there can be 10 order with individual exchange rate, etc

Mmmm...

Yes, it turns not trivial. I see the solution as follows:

To create a table where the rates will be kept for each order no matter how many currencies are installed:

order_id,currency_code,rate

1,USD,60

1,EUR,70

1,BTC,800000

Then I can JOIN this table to build order list based on currently selected currency

Hello,

I want to change some information of right column of Order Detail screen (backend), so I modify the template: “design/backend/templates/views/orders/details.tpl” but nothing changes, why?? (I have cleaned the cache)

Thank you

Hello,

I want to change some information of right column of Order Detail screen (backend), so I modify the template: “design/backend/templates/views/orders/details.tpl” but nothing changes, why?? (I have cleaned the cache)

Thank you

Hello!

Please check if some add-on overrides this template or that place where you added your code (if there is a hook).