how can i import the shipping fee by uploading csv file?

[colaken]

how can i import the shipping fee by uploading csv file?

thanks

[cbsteven]

There is a field called "shipcost". That should do it.

[ElegantWeddings]

how can i import the shipping fee by uploading csv file?

thanks

Can you be more specific? Are you talking about the custom shipping methods or per product?

For per product, what @cbsteven is correct, this will be an extra shipping fee you are charging per quantity for each product.

[smashrc]

There is a field called "shipcost". That should do it.

Where can I find the field called shipcost? I checked around and still can't find it.

[smashrc]

I want to import csv too but I can't find any where do do that.

My problem is I'm switching shopping cart from OScommerce to 3dcart. My OScommerce shipping fee is calcaulate by total weight according to different country. The OScommerce will add up all the items weight then look at which country to ship to and then search the right price of the shipping fee database table. The shipping fee table looks the following:

Country, 0-100, 101-200,201-300 ............
USA, 1,2,3.........
UK,1.5,3,4.5.........
French,2,4,6............

So, if a customer brought somethhing of the total weight is 250 and ship to UK. His shipping fee is 4.5

This table is so big, for one shipping method called "economy" it contains 5000 fields. I have total 3 shipping methods "economy" "EMS" "priority" that is talking about 15000 fields of data have to enter in the 3dcarts.

Want to know what is the best way to import my tables in the 3dcart? thanks

[ElegantWeddings]

Where can I find the field called shipcost? I checked around and still can't find it.

It is in your Product (Import/Export) file

[smashrc]

thanks so much for your help.

I have like 30000 products. So, I need to upload the files 30000 times. Does anybody know any easier way for human? :-) thanks

[ElegantWeddings]

thanks so much for your help.

I have like 30000 products. So, I need to upload the files 30000 times. Does anybody know any easier way for human? :-) thanks

If you are asking about setting up custom shipping methods, see here:
https://support.3dcart.com/3dcart/Kn...hipping-method


If you are asking about adding a extra shipping cost per product:
https://support.3dcart.com/3dcart/Kn...mport-products
(See #21 is the shipcost)


You don't have to import 30000 times, each row on the spreadsheet is a product line. Basic spreadsheet software allows 65536 rows; therefore, only 1 import file is needed.

[smashrc]

Thanks again.

Actually, I'm trying to set up the shipping method by weight. As you know my shipping table is like this:

Country, 0-100, 101-200,201-300 ............ total 40 columns
USA, 1,2,3.........
UK,1.5,3,4.5.........
French,2,4,6............
total 120 rows



If I use the 3dcart "Custom by Weight" method then I need to create so many "Custom by Weight" for each country ( each country has different shipping fee). I have to add 120 times as I have 120 countries :-(

Do you think there is any way to speed this up? thanks

[ElegantWeddings]

Thanks again.

Actually, I'm trying to set up the shipping method by weight. As you know my shipping table is like this:

Country, 0-100, 101-200,201-300 ............ total 40 columns
USA, 1,2,3.........
UK,1.5,3,4.5.........
French,2,4,6............
total 120 rows



If I use the 3dcart "Custom by Weight" method then I need to create so many "Custom by Weight" for each country ( each country has different shipping fee). I have to add 120 times as I have 120 countries :-(

Do you think there is any way to speed this up? thanks

We did this manually one at a time for each weight range and country.

[smashrc]

Thank you so much. I just asked if 3dcart can help if I paid for the custom programming. Hope this don't charge me too high price.