table rate problem

I have a problem with the table rates showing the right price.

I used this

Land,Provincie,Postcode,"Subtotaal bestelling (en hierboven)",Verzendkosten
NLD,*,*,0,3,95
BEL,*,*,0,4,95
DEU,*,*,0,7,95

When I select the NLD country in the checkout I get the right price 3,95. But when I select the other ones I get strange prices like BEl 4,02 or Deu 6,02

Solutions

Differentiate one column with the other by '' or ""quotation mark. And comma in default settings is dot .

As mentioned by @Toon Van Dooren and @fschmengler

Land,Provincie,Postcode,"Subtotaal bestelling (en hierboven)",Verzendkosten
NLD,*,*,0,'3.95'
BEL,*,*,0,'4.95'
DEU,*,*,0,'7.95'

You are using comma's witouth enclosure in a comma seperated csv. This can't be right. Use "3,95".

Similar questions

Table Rate - Item vs Destination
A quick question with regards to the csv which needs to be created for implementing these rules. I have a basic rule where for example shipping to Belgium for one item starts at £3.00 Then for every extra item the total goes up by £1.00 So in the csv the item # of items field would be: And so fourth. However when the quantity is met in the check ou...
How to combine table rate shipping and fixed shipping cost per product?
I'm using the table rates (price) to calculate the shipping costs. There are some products that have fixed shipping costs. I need the shipping rate with the combination of table rate shipping and the fixed shipping cost of a product. For example: I've a total of 7 products in my cart. 5 of these products are covered by the table rate shipping rates...
Rate table shipping showing $0.00 only for certain products
I've added four nearly identical products to my brand new Magento 1.9 store. Each one with complete information, including weights. Then I set up a shipping rate table, and successfully imported the CSV. I confirmed this in the "shipping_tablerate" db table using phpMyAdmin. The CSV that I'm using for debugging looks like this: This rate is reflect...
Table rate for each Category
Is it possible in Magento to use table rate for each category products? I need each of the catergory products use different table rates with different prices and destinations If possible let me know how I can do this? Very Thanks
Magento table rate weight vs destination
I am using magento table rates Weight vs Destination for shipping method. I have added weight up to 3 kg and shipping price according to that. It is working fine. But above 3 kg the shipping price will be INR 25 per KG. For example if the weight will be 5 KG then the shipping price will be 5 x INR 25 = INR 125 How to achieve that in Table Rate.
updating magento table rate shipping method with thousands of zip codes
I'm wondering if i can just do this or not .. did not gave it a try bcz i'm afraid this should not crash my server. For defining table rate shipping, weight vs Destination, I do have 12,000 ZIP Codes, with each one having at least two shipping prices Weight - 0-500grams - $1 - $3 (depending upon the zip/postal code) Weight - 500-1000grams - $3 - $4...

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.