• Resolved hamadata

    (@hamadata)


    Hi,

    I am trying to upload the tax csv file but no matter what I do it just fails to do so. Not sure what is wrong. I have created this file can you let me know what it is, is it the format or what?

    Country code,State code,Postcode / ZIP,City,Rate %,Tax name,Priority,Compound,Shipping
    US,AL,,,9.14,STATE TAX,1,0,0
    US,AK,,,1.43,STATE TAX,1,0,0
    US,AZ,,,8.37,STATE TAX,1,0,0
    US,AR,,,9.43,STATE TAX,1,0,0
    US,CA,,,8.56,STATE TAX,1,0,0

    I even did entry and exported the file to make sure it works, I mean by now I could have manually entered the states, but just wanted to make sure it is working properly, aaah the trying to be a nerd in me, lol

    Thanks

Viewing 6 replies - 1 through 6 (of 6 total)
  • 13art

    (@13art)

    I am having the same problem with Product files. It just continually spins as if it’s importing but nothing ever happens and the import never progresses or finishes.

    Margaret S. woo-hc

    (@margaretwporg)

    Hi @hamadata

    I understand that you’re facing difficulty with importing the tax data through CSV.

    From the table you shared it seems that the problem may be with the format.

    Please download the official sample CSV from here:
    https://github.com/woocommerce/woocommerce/tree/master/sample-data

    Modify its content per you requirements, and retry importing.

    If you still face issues, then please share your CSV so we can check. You can use file.io/Dropbox/Google Drive or any online file-sharing service, and share the link here.

    I hope this helps!

    Margaret S. woo-hc

    (@margaretwporg)

    Hi @13art

    I forgot to mention – Since every case is different, please start your own thread and we’ll be happy to check your issue there.
    https://www.ads-software.com/support/plugin/woocommerce/#new-topic-0

    Cheers

    Thread Starter hamadata

    (@hamadata)

    Hi Margaret,

    Thank you for your help, but I did try to base it on the sample provided after several failures, and here is the original sample provide for your reference:

    Country Code,State Code,ZIP/Postcode,City,Rate %,Tax Name,Priority,Compound,Shipping,Tax Class
    GB,*,*,*,20.0000,VAT,1,1,1,
    GB,*,*,*,5.0000,VAT,1,1,1,reduced-rate
    GB,*,*,*,0.0000,VAT,1,1,1,zero-rate
    US,*,*,*,10.0000,US,1,1,1,
    US,AL,12345; 123456,*,2.0000,US AL,2,1,1,

    only thing is if you review the table design where you can enter data manually, there is no field for the “Tax Class”, which is weird and not sure what it is, since it is not present in the table, and there is no explanation what it is.

    these are the fields where you can enter the data manually:

    Country code State code Postcode / ZIP City Rate % Tax name Priority Compound Shipping

    Thanks

    Igor H

    (@ihereira)

    Hello there ??

    It looks the content needs to be formatted correctly in order to work properly.
    CSV format
    Link to image: https://snipboard.io/UinZu8.jpg

    Feel free to add the , necessary to separate each column value, then you can attach a copy of the CSV file created.

    To clarify, regarding tax classes, please refer to this documentation below:
    https://woocommerce.com/document/setting-up-taxes-in-woocommerce/#additional-tax-classes

    For a reference about what is the schema to be used in CSV files, please check:
    https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

    Let us know how it goes.

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, the above info was helpful.

    If you have further questions, please feel free to open a new topic.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘UPLOAD CSV FILE FAIL’ is closed to new replies.