Jump to content

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

Changing currency rate changes old order invoices ? Rate Topic   - - - - -

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 03 June 2013 - 11:44 AM #1

Hi Cs-carters,

I am running mve 3.0.3
My audience is kuwait, so I had kept base currency as USD and secondary currency as KWD with some rate.
Now, when I want to change the rate it affects old invoices in KWD
Should currency rates be part of the invoice ?
Has anyone faced this issue before ? If yes whats the workaround ?

regds,
Shikhar
Cs-cart tips at shikhar.me

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 11 June 2013 - 01:32 PM #2

Hi Cs-carters,

Cs-cart support replied that its a standard functionality, they could do custom development.
I believe currency rate should be part of the invoice and the invoice in secondary currency shouldn't change ever.

Anyways, I fixed it somehow by modifying old invoices and products prices in my primary currency.
So it shows up fine in secondary currency with new conversion rate.
Cs-cart tips at shikhar.me

 
  • Scott_C
  • Senior Member
  • Members
  • Join Date: 23-Jun 11
  • 452 posts

Posted 23 June 2013 - 07:29 AM #3

^ agreed.

 
  • StellarBytes
  • Senior Member
  • Members
  • Join Date: 08-Aug 11
  • 1807 posts

Posted 23 June 2013 - 08:20 PM #4

I don't (yet) run with multiple currencies, but this is a major worry if I am interpreting this correctly...

You set up USD and KWD, with currency values like this, as an example:

USD = 1
KWD = 1.50

Your completed orders/invoices all show the total order price being USD $100, KWD 150.

Now you change the KWD currency rate to 1.4, so your old orders/invoices show a total order of USD100 and KWD 140...is that what you mean?

This may well be a game changer for me with using CS-Cart for a new store, especially considering CS-Cart expect you to pay for "custom development" to fix what is effectively a "working as designed, yet faulty in practice" function.
Hire StellarBytes for CS-Cart Design & Development Services

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 24 June 2013 - 07:41 AM #5

StellarBytes, Yes you are absolutely correct, this is what will happen.
Even if Cs-cart modifies code to show customers' invoice with previous conversion rate, I would be happy.
Though strictly speaking it should be everywhere. But I don't know how big a change that will be and how much affect it will have on reports by making them slow.
Cs-cart tips at shikhar.me

 
  • Traveler
  • Senior Member
  • Members
  • Join Date: 02-Feb 07
  • 916 posts

Posted 24 June 2013 - 01:22 PM #6

"to fix what is effectively a "working as designed, yet faulty in practice" function."

Clearly a design bug

Version 4.9.2


 
  • StellarBytes
  • Senior Member
  • Members
  • Join Date: 08-Aug 11
  • 1807 posts

Posted 24 June 2013 - 01:28 PM #7

"to fix what is effectively a "working as designed, yet faulty in practice" function."

Clearly a design bug

If CS-Cart are requesting you to pay for "custom development", then it isn't a bug as far as they are concerned. It works how they intended. There is no database table which stores previous currency rates, so they clearly made an oversight, or didn't see the need for this functionality. Maybe that's just how things are done in Russia, I don't know. Without putting too much thought into this, I would have thought based on previous quotes I have received for "custom development" that this will cost more than the original CS-Cart license.
Hire StellarBytes for CS-Cart Design & Development Services

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 24 June 2013 - 02:00 PM #8

I think you can store conversion rates in order data and use it. I wanted to fix it that way, but it wasn't much of a paining area for me as we work in KDs only, so didn't work on it.
Cs-cart tips at shikhar.me

 
  • djhosken
  • Member
  • Members
  • Join Date: 27-Jul 12
  • 38 posts

Posted 26 June 2013 - 02:13 AM #9

This is clearly a bug. It can not be seen any other way! I have the same issue. Have USD, AUD and EUR currencies. If a customer places an order in EUR, and the exchange rate changes, the EUR total of invoice changes.

Has any one lodged a bug for this? Or, does any one know if this is fixed in upcoming V4 release?

 
  • Scott_C
  • Senior Member
  • Members
  • Join Date: 23-Jun 11
  • 452 posts

Posted 26 June 2013 - 06:47 AM #10

Valentin, on this forum (Vali) is a great web developer I've been using. He has a fix for this if you're willing to pay for it and consider it important enough to the running of your store (I do, and he has already applied the fix).

 
  • Hungryweb
  • Senior Member
  • Authorized Reseller
  • Join Date: 10-Feb 12
  • 1265 posts

Posted 26 June 2013 - 12:19 PM #11

Thank you @Scott_C for your appreciation, the fix is not done yet but we are almost there ;)

---
Valentin

 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 26 June 2013 - 12:21 PM #12

@Vali Sell it to Cs-cart team after you are done.
Cs-cart tips at shikhar.me

 
  • preudomme
  • Junior Member
  • Members
  • Join Date: 03-Mar 09
  • 43 posts

Posted 06 February 2014 - 10:16 AM #13

Thank you @Scott_C for your appreciation, the fix is not done yet but we are almost there ;)

---
Valentin


Any progress about this?
2.1.4 / Live
4.2.1 / Devel

 
  • djhosken
  • Member
  • Members
  • Join Date: 27-Jul 12
  • 38 posts

Posted 26 October 2015 - 05:42 AM #14

Has this been fixed yet? I am in the process of upgrading our store, and this was one of the few really annoyiing bugs contained in CS Cart. Can not believe it hasn't been fixed yet. All that has to be done is that the currency and currency rate should be stored with each order. Else, there is no way to reproduce old invoices with correct values. Clearly a bug.



 
  • shikhar
  • Senior Member
  • Members
  • Join Date: 09-Oct 11
  • 156 posts

Posted 26 October 2015 - 08:04 AM #15

I don't think it has been fixed yet.  A workaround is to update your earlier order with the new currency conversion rate.  That's how I did it and never changed the rate after that :P


Cs-cart tips at shikhar.me

 
  • Alafoss
  • Member
  • Trial users
  • Join Date: 12-Feb 13
  • 20 posts

Posted 14 March 2017 - 12:34 PM #16

Any update on this matter?  

 

Kind of strange and (in some cases illegal) that the amount on old invoices changes if the currency rate changes.

 

Let me know if anyone knows an update :)



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20777 posts

Posted 14 March 2017 - 01:01 PM #17

Any update on this matter?  
 
Kind of strange and (in some cases illegal) that the amount on old invoices changes if the currency rate changes.
 
Let me know if anyone knows an update :)


Check amount in the base currency. Amounts will be always correct in this case
GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • Alafoss
  • Member
  • Trial users
  • Join Date: 12-Feb 13
  • 20 posts

Posted 14 March 2017 - 01:18 PM #18

No, that is not entirely true:

 

If you have for example two currencies with USD as base:


USD = 1
EUR = 1.50

Your completed orders/invoices all show the total order price being USD $100, EUR 150.

Now you change the EUR currency rate to 1.4, so your old orders/invoices show a total order of USD100 and now EUR 140.

 

That is very strange that it does modify already received orders.



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20777 posts

Posted 14 March 2017 - 01:24 PM #19

No, that is not entirely true:

 

If you have for example two currencies with USD as base:

USD = 1
EUR = 1.50

Your completed orders/invoices all show the total order price being USD $100, EUR 150.

Now you change the EUR currency rate to 1.4, so your old orders/invoices show a total order of USD100 and now EUR 140.

 

That is very strange that it does modify already received orders.

 

In CS-Cart currency rate is used to display base amount in the selected currency. Unfortunately, rates are not stored anywhere


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • Alafoss
  • Member
  • Trial users
  • Join Date: 12-Feb 13
  • 20 posts

Posted 14 March 2017 - 01:28 PM #20

Which is cleary a bug? Right?

 

As for account and tax reasons among others is 'illegal' to not store and then modify already paid and processed invoices?