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

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

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

    thanks

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

    Comment


    • #3
      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.
      Elegant Weddings +
      www.elegantweddingsplus.ca
      www.elegantweddingsplus.com

      Comment


      • #4
        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.

        Comment


        • #5
          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

          Comment


          • #6
            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
            Elegant Weddings +
            www.elegantweddingsplus.ca
            www.elegantweddingsplus.com

            Comment


            • #7
              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

              Comment


              • #8
                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.
                Elegant Weddings +
                www.elegantweddingsplus.ca
                www.elegantweddingsplus.com

                Comment


                • #9
                  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

                  Comment


                  • #10
                    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.
                    Elegant Weddings +
                    www.elegantweddingsplus.ca
                    www.elegantweddingsplus.com

                    Comment


                    • #11
                      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.

                      Comment

                      Working...
                      X