Hello,
I need to use mass upload transactions to upload pricing conditions with scales (key combination: sold-to/material) but due to the large amount of combinations I am trying to find ways to simplify the mass upload as much as possible.
Regarding the scaling part, I was wondering if I can upload in one line the volume scales per sold-to/material combination.
For example: customer A, material X
volume scales and prices:
1-10 kg --> 3 EUR
10-20 kg --> 2 EUR
20-30 kg --> 1 EUR
------------------------------------------
I would like my mass upload excel file to look like:
Customer - material - Scale 1 - price 1 - Scale 2 - price 2 - Scale 3 - price 3
A - X - 10 - 3 - 20 - 2 - 30 - 1
Instead of
Customer material Scale price
A X 10 3
A X 20 2
A X 30 1
In this example, I reduce the lines of my upload file from 3 to 1.
Do you may know if they is any way that I could do that? Any transaction? Or any type of scales that I need to use?
Thanks in advance for the support,
Kind Regards