Forum Discussion
Find total quantity sold of each product
Hi everyone, I have product name in columns: A, C, E, D, G, I, K, M, O, Q, S, U, W, Y, AA, AC, AE, AG, AI, AK, AM, AO, AQ, AS, AU, AW, AY, BA, BC, BE, BG, and in columns B, D, F, H, J, L, N, P, R, ...
so what I want to achieve is that I want to be able to track how much of each product I sell daily and at the end of the month to have total values.
e.g.
product name total sold
prod a 5
prod b 6
But have no idea how to achieve it.
I also have a problem configuring In stock, In stock changes and sold columns. At the end of the working day I remove values from sold column as tmr is a new day and new sales will occur. but in order to track how much of each product left I manually subtract from In stock chnages - sold. For instance, as you can see in the short video, Product A, in stock = 10, sold = 2, In stock changes = 8. so 8 units of Prod A is left, and the next day I will subtrack sold from In stock chnages which is 8 for now, in this case, I can see how much of Product A I had initially and how much left after each working day.
I know this is a wrong approach, I came up with this BS:))) I just do not know how to do it properly.
e.g.
product name total sold
prod a 5
prod b 6
But have no idea how to achieve it.
I also have a problem configuring In stock, In stock changes and sold columns. At the end of the working day I remove values from sold column as tmr is a new day and new sales will occur. but in order to track how much of each product left I manually subtract from In stock chnages - sold. For instance, as you can see in the short video, Product A, in stock = 10, sold = 2, In stock changes = 8. so 8 units of Prod A is left, and the next day I will subtrack sold from In stock chnages which is 8 for now, in this case, I can see how much of Product A I had initially and how much left after each working day.
I know this is a wrong approach, I came up with this BS:))) I just do not know how to do it properly.