user paid twice for the same certificate?

[pdpinch]

Not sure how this happened, but it seems like we have two fulfilled orders for the same course:

https://mitxonline.mit.edu/orders/receipt/6247
https://mitxonline.mit.edu/orders/receipt/6249

Was perhaps one of them refunded and the database wasn't updated?

I noticed this when looking at https://bi.odl.mit.edu/queries/1189 where it lists two certificates for the same course run.

[arslanashraf7]

So I was looking at the data for these two orders and here are things that I could identify so far:

1. Both of these orders have MM-prod-xxxx reference numbers which means these orders were probably not created through MITxOnline checkout but were migrated over from MM to MITxOnline.
2. Although the orders were for the same course run the purchase difference between these two is almost 2 years, one order being in 2020 and the other one in 2022.
3. I looked at the purchase data for the orders in MM(this and this) and they looked fine as well.

I'm not sure if this was expected for data that was migrated from MM but I think if we were to look more we need to check how we migrated that data and check the cause within MM.

[pdpinch]

Ok, since these are historical MicroMasters orders, I'm not going to worry about it too much.

The user probably made multiple exam attempts, which we could determine by examining their exam authorizations and grades in MicroMasters.