Individual Product Shipping Prices tripling at checkout

[mrpointy]

I've just installed the Individual Product Shipping Prices contribution & it seems to be working ok, apart from the fact that the amount entered as the shipping price for the item is then trebled at the checkout!

 

My client wants 2 prices for different products - £16 & £68. If I enter £16 as the products shipping cost, the total on the checkout is £48! To get a £16 shipping cost at the checkout, I have to enter the item shipping price as £5.33.

 

I have no idea why this is happening as I followed the instructions with the contribution & apart from this error it seems to work. Any idea where this error could be coming from?

 

I have uninstalled all the other shipping options as I have the problem with the values not being saved (but this is a different problem!)

 

Hope someone has the answer to this quite silly problem :)

 

Thanks

[Stealth1]

Under Admin -> Config -> Shipping/Packaging there is an option for multiplying the rate if the zone is not the one for your country. It is likely set to 3 and your home country probaby isn't set either.

[mrpointy]

Under Admin -> Config -> Shipping/Packaging there is an option for multiplying the rate if the zone is not the one for your country. It is likely set to 3 and your home country probaby isn't set either.

 

Ah, I see! Thanks for that.

 

Unfortunately, the "Indiv Ship Home Country" field just says "223" which doesn't explain much! <_<

 

I've now found the OSC SQL 'countries' table which shows that the UK is 222. All works perfectly now.

 

I've attached the table in case anyone else needs it.

 

('7', 'Anguilla', 'AI', 'AIA', '1');

('10', 'Argentina', 'AR', 'ARG', '1');

('13', 'Australia', 'AU', 'AUS', '1');

('14', 'Austria', 'AT', 'AUT', '5');

('21', 'Belgium', 'BE', 'BEL', '1');

('30', 'Brazil', 'BR', 'BRA', '1');

('38', 'Canada', 'CA', 'CAN', '1');

('43', 'Chile', 'CL', 'CHL', '1');

('44', 'China', 'CN', 'CHN', '1');

('51', 'Costa Rica', 'CR', 'CRI', '1');

('55','Cyprus','CY','CYP','1');

('56','Czech Republic','CZ','CZE','1');

('57', 'Denmark', 'DK', 'DNK', '1');

('60', 'Dominican Republic', 'DO', 'DOM', '1');

('62', 'Ecuador', 'EC', 'ECU', '1');

('67','Estonia','EE','EST','1');

('72', 'Finland', 'FI', 'FIN', '1');

('73', 'France', 'FR', 'FRA', '1');

('74', 'France, Metropolitan', 'FX', 'FXX', '1');

('81', 'Germany', 'DE', 'DEU', '5');

('84', 'Greece', 'GR', 'GRC', '1');

('96', 'Hong Kong', 'HK', 'HKG', '1');

('98', 'Iceland', 'IS', 'ISL', '1');

('99', 'India', 'IN', 'IND', '1');

('103', 'Ireland', 'IE', 'IRL', '1');

('104', 'Israel', 'IL', 'ISR', '1');

('105', 'Italy', 'IT', 'ITA', '1');

('106', 'Jamaica', 'JM', 'JAM', '1');

('107', 'Japan', 'JP', 'JPN', '1');

('113', 'Korea, Republic of', 'KR', 'KOR', '1');

('117','Latvia','LV','LVA','1');

('124', 'Luxembourg', 'LU', 'LUX', '1');

('129', 'Malaysia', 'MY', 'MYS', '1');

('138', 'Mexico', 'MX', 'MEX', '1');

('132','Malta','MT','MLT','1');

('141', 'Monaco', 'MC', 'MCO', '1');

('150', 'Netherlands', 'NL', 'NLD', '1');

('153', 'New Zealand', 'NZ', 'NZL', '1');

('160', 'Norway', 'NO', 'NOR', '1');

('171', 'Portugal', 'PT', 'PRT', '1');

('188', 'Singapore', 'SG', 'SGP', '4');

('189','Slovakia (Slovak Republic)','SK','SVK','1');

('190','Slovenia','SI','SVN','1');

('193','South Africa','ZA','ZAF','1');

('195', 'Spain', 'ES', 'ESP', '3');

('203', 'Sweden', 'SE', 'SWE', '1');

('204', 'Switzerland', 'CH', 'CHE', '1');

('206', 'Taiwan', 'TW', 'TWN', '1');

('209', 'Thailand', 'TH', 'THA', '1');

('215', 'Turkey', 'TR', 'TUR', '1');

('222', 'United Kingdom', 'GB', 'GBR', '1');

('223', 'United States', 'US', 'USA', '2');

('225', 'Uruguay', 'UY', 'URY', '1');

('229', 'Venezuela', 'VE', 'VEN', '1');