Hi,
I'm not sure if i have the correct title on this thread, here is what i am trying to achieve.
I have 4 shipping templates.
1. Flat Rate Envelopes
2. Small Box
3. Medium Box
4. Large Box
I also have an excel sheet that has products, each product has one of those shipping methods above.
Ex:
Blue stripped socks > Flat Rate Envelope
Blue Stripped Shoes > Medium Box
etc
etc..
For Flat rate envelope, shipping costs 6.95
Small Box = 7.80
Medium Box = 11.20
Large Box = 17.90
How do i assign the value so in a separate cell, it will give me the price?
<tbody>
</tbody>
I would like shipping price to be auto filled when shipping template specifies a value
I'm not sure if i have the correct title on this thread, here is what i am trying to achieve.
I have 4 shipping templates.
1. Flat Rate Envelopes
2. Small Box
3. Medium Box
4. Large Box
I also have an excel sheet that has products, each product has one of those shipping methods above.
Ex:
Blue stripped socks > Flat Rate Envelope
Blue Stripped Shoes > Medium Box
etc
etc..
For Flat rate envelope, shipping costs 6.95
Small Box = 7.80
Medium Box = 11.20
Large Box = 17.90
How do i assign the value so in a separate cell, it will give me the price?
SKU | Product | Shipping Template | Shipping price |
1234 | ABC | Small Box | |
5678 | DEF | Medium Box |
<tbody>
</tbody>
I would like shipping price to be auto filled when shipping template specifies a value