One to many mapping



I have a requirement where i want to realign/ redistribute the Sales History from 1 SKU to many SKUs. Lets say, i have SKU A with 1000 units sales history. I now need to realign 400 and 300 units from SKU A to SKU B and SKU C, who have 500 and 200 units sales history of their own, respectively.

So after the redistribution, SKU A will have only 300 units left. SKU B will have 500 + 400 = 900 units and SKU C will have 200 + 300 = 500 units of sales history.

I currently have reporting module with SKU A, B, C along with thir Sales History numbers but no mechanism to realign.

Could you please help?

Thank you.


  • Dikshant

    Do you just want manual adjustments, where users will add or remove the numbers? Or you want to track each transaction of that has been added or removed from each SKU? How are you visualizing it right now?

  • SuhasDesai

    @Dikshant We want to first create mappings of SKU A to other SKUs like B or B & C (Single or multiple mappings). After that the user will enter how much forecast needs to be redirected to mapped SKUs.