I have a pricelist provider that contains the following example:
for Canada: 0 to 1kg - 5$, 1 to 2kg - 10$, 2 to 5kg - 20$, 5 to 10kg - 21$
for Europe: 0 to 1kg - 3$, 1 to 2kg - 8$, 2 to 5kg - 10$, 5 to 10 - 18$
for USA: 0 to 1kg - 10$, 1 to 2kg - 15$, 2 to 5kg - 20$, 5 to 10kg - 27$
The only way to realize that I do is the following:
4 records for Canada;
4 records for Europe;
4 records for USA;
But the real pricelist contains 30 locations. For each destination has special prices in 1 kg in the range from 0 to 20 kg. This means that if I want to realize this, I need to do 30 x 20 = 600 entries. And the price list is only for one company.
Is there any option to shorten this?
Example:
Shipping Company 1 - Shipping to Canada - 0 to 1kg - 5$, 1 to 2kg - 10$, 2 to 5kg - 20$, 5 to 10kg - 21$ to be in a record;
Shipping Company 1 - Delivery to Europe - 0 to 1kg - 3$, 1 to 2kg - 8$, 2 to 5kg - 10$, 5 to 10 - 18$ to be in a record;
Shipping Company 1 - Delivery to USA - 0 to 1kg - 10$, 1 to 2kg - 15$, 2 to 5kg - 20$, 5 to 10kg - 27$ to be in a record;
Shipping Company 2 - Shipping to Canada - 0 to 1kg - 5$, 1 to 2kg - 10$, 2 to 5kg - 20$, 5 to 10kg - 21$ to be in a record;
Shipping Company 2 - Delivery to Europe - 0 to 1kg - 3$, 1 to 2kg - 8$, 2 to 5kg - 10$, 5 to 10 - 18$ is a single record.
Shipping Company 2 - Delivery to USA - 0 to 1kg - 10$, 1 to 2kg - 15$, 2 to 5kg - 20$, 5 to 10kg - 27$ to be in a record;
or some similar combination.
It would be much better if it can be realized as example of prestashop, which is in the picture.
I hope I managed to explain the problem correctly.
Can you give some solution?