Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • smashrc
    replied
    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.

    Leave a comment:


  • ElegantWeddings
    replied
    Originally posted by smashrc View Post
    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.

    Leave a comment:


  • smashrc
    replied
    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

    Leave a comment:


  • ElegantWeddings
    replied
    Originally posted by smashrc View Post
    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.

    Leave a comment:


  • smashrc
    replied
    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

    Leave a comment:


  • ElegantWeddings
    replied
    Originally posted by smashrc View Post
    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

    Leave a comment:


  • smashrc
    replied
    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

    Leave a comment:


  • smashrc
    replied
    Originally posted by cbsteven View Post
    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.

    Leave a comment:


  • ElegantWeddings
    replied
    Originally posted by colaken View Post
    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.

    Leave a comment:


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

    Leave a comment:


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

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

    thanks
Working...
X