Hi Sergey,
I am importing data from my old OSE Membership. For the same plan, you can define different currencies there. When I imported the data, all the old sales data is in USD although some of them were sold for EUR. Is there a way to display the old subscriptions in the currency they were sold for? Or Emerald was build to work with only one currency for each plan?
This will always create a problem if somebody like me changes the currency of the product according to the buyers country. The easiest way to solve this is to add another column (currency) to the subscriptions table. So no matter what currency the plans has, subscriptions will be recorded with its own currency when sold and in the history will have the right currency. Actually you are doing this with the amount. No matter what the amount of the current plan is, in the history the (s)old prices are being kept.
If you add currency column to the subscriptions table, you can display the sales page in the admin like this:
If the currency field is empty, get the currency from the plans table, if the currency has a value, read it from the currency subscriptions table.
Thank you once again. Kind regards,
Hakan
Hi Sergey,
I am importing data from my old OSE Membership. For the same plan, you can define different currencies there. When I imported the data, all the old sales data is in USD although some of them were sold for EUR. Is there a way to display the old subscriptions in the currency they were sold for? Or Emerald was build to work with only one currency for each plan?
This will always create a problem if somebody like me changes the currency of the product according to the buyers country. The easiest way to solve this is to add another column (currency) to the subscriptions table. So no matter what currency the plans has, subscriptions will be recorded with its own currency when sold and in the history will have the right currency. Actually you are doing this with the amount. No matter what the amount of the current plan is, in the history the (s)old prices are being kept.
If you add currency column to the subscriptions table, you can display the sales page in the admin like this: If the currency field is empty, get the currency from the plans table, if the currency has a value, read it from the currency subscriptions table.
Thank you once again. Kind regards, Hakan