Bulk Import of Shipping rates through SQL (Shipping method restrictions)

1 month ago
We have received a FedEx shipping price list that is based on weight and on Country, so entering it manually would be a lot of work. I am looking into importing it through an SQL.

The only question that I need an answer to is where in database is defined if a shipping method is available in a certain country?

I can see that in ShippingMethodRestrictions table all the countries and all the shipping methods are listed but can not see what is available where.

Thank you.
1 month ago
Remember, "Please mark the checkbox(es) for the country or countries in which you want the shipping method(s) not available"

SELECT ShippingMethod_Id, sm.Name as ShippingMethodName, Country_Id, c.Name as CountryName
  FROM ShippingMethodRestrictions smr
  JOIN ShippingMethod sm on sm.Id = smr.ShippingMethod_Id
  JOIN Country        c  on c.Id = smr.Country_Id
order by c.Name, sm.Name
1 month ago
just saw you reply, thank you,!!!! I will try and report if I managed to sort it out.