Magento 2.2.5 I´m importing tble rate excel file but I´m getting error

[Plat]

Hi Dears 

I´m getting error while I´m imorting table rate excel file for Shipping method.

Somebody can help me?

Regards

Manuel 

[Manish Mittal]

Hello @Plat

Please share what error you are facing, I can not able see your attached image. 

[Plat]

Dear @Manish Mittal follow the attached pics:

[Tarandeep Singh]

@PlatYou are still missing the images. Make sure when you upload the image you are able to see it and then post the updates. Alternatively, you can upload the image on your server or 3rd party website like Google drive, Yahoo etc and share the URL.

Problem solved? Please give 'Kudos' and accept 'Answer as Solution'.

[Plat]

Hi @Tarandeep Singh

I inserted the image on last post, but I´ll post again. Follow the images:;

[Plat]

Dears

Follow the links of image:

https://drive.google.com/file/d/1LZl3xI48rZKh1-_Q4Vy1AY-7CyfWRuQT/view?usp=sharing

https://drive.google.com/file/d/1Q8OszvGJex2VVgxmoierP9mUxO_7ZWlt/view?usp=sharing

[Tarandeep Singh · Accepted solution]

Hi @Plat,

There seems to be multiple issues. #1 is the country name. You have to use country code instead of country name which is "AO". Same applies to states as well. You need to use state code instead of name.

As Magento does not has state list for your country you cannot use the state code in the import. Either you have to use "*" in state field while importing data or you have to first add those states in the Database manually or using some SQL. Once you have those record you will be able to add states.

Problem solved? Please give 'Kudos' and accept 'Answer as Solution'.

[Manish Mittal]

Hello @Plat

Please find attached image for your reference to import excel.

Magento only allows 2 digit code, so it should work for you. Please let me know if you still face any issue.

[Plat]

Hi @Manish Mittal

I did the same format, but I´m still receiving the same error when I´m importing the file.

For moe detail, see my excell format:

Follow the error:

Regards

Manuel Barbosa

[Manish Mittal]

@Plat

I can not see the attached images. can you please share your excel with me so I will download and try at my end.