Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Individual Product Shipping Prices tripling at checkout


mrpointy

Recommended Posts

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

Link to comment
Share on other sites

  • 2 weeks later...

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');

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...