ohh thank you so much for the information. But why are "Quantity" and "Price" is coming as metric and not dimensions? I am just trying to understand the reasoning behind it. it is kind of difficult to create a view where we want to see cost and quantity of a particular product at the purchase
In the Products List notation, those are standard metrics. Even in your screen shot above from January, that was in the Success Events configuration. Revenue and number of items being sold are traditionally stored as a metric, so that you can have a total number of "product X" sold in whatever period, and a total revenue from those sales... metrics are numbers, so they will add up across the orders and you can also run calculated metrics on them...
https://experienceleague.adobe.com/en/docs/analytics/implementation/vars/page-vars/products
If you want to be able to see these values as actual text dimension data (as in, you want to see a specific, locked in, textual value for each order), then you will need to create some Merchandising eVars to store the values as a dimension.
For example:
You might want to keep the default "visit" expiry, or you may want it to only be part of the Sale hit, or maybe have a custom expiry.. it depends on your needs.
But you will definitely need to make it "Merchandising" and in Product Syntax.
Now, in your products string, you will need to add the new eVars:
";CCMM42255:5G Infinite Premium;250;118.75;;eVar97=250|eVar98=118.75"
Notice I have a double ;; in the string, this is intentional... this is the spot where custom events would be placed, if you had any... since you don't, we need to leave that there and empty.