Skip to Content
0
Nov 22, 2019 at 10:53 AM

Mass upload prices with volume Scales

1119 Views Last edit Nov 22, 2019 at 12:41 PM 2 rev

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