mrpointy

January 19, 2010

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

January 5, 2010

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

August 3, 2009

I'm using PayPal Website Payments Standard. Assuming the order e-mail is sent when the buyer returns to the site from Paypal using auto return the problem could be that I've just noticed that I don't have an ipn.php page in my store!! Is this where the issue lies?

So should I be redirecting to checkout_success.php instead? Or to http://www.website.co.uk/ext/payment/paypal/standard_ipn.php which does exist?

I followed the instructions from a tutorial to the letter, but obviously something isn't working right!

August 3, 2009

Did you ever get any response on this from Paypal?

Did you ever get any response on this from Paypal?

I'm using PayPal Website Payments Standard, but don't have any ipn.php page in my store, so should I be redirecting to checkout_success.php instead?

August 3, 2009

Thank you two for your information. Since my last note, I called PayPal twice - the last call earlier this week. I was informed that PayPal is currently working on this issue and should have it rectified by next week. I asked the man I spoke with if he would let me know when it is done and he said he would email me. I will post any findings when I hear from him. michele

Did you ever get any response on this from Paypal?

August 3, 2009

I'm having the same problem! :angry:

When I tested the module, using my own e-mail address, it worked perfectly. But since adding the store owners e-mail address, it hasn't worked on any orders at all! It's very frustrating & as yet, it appears no-one seems to have any answer? :huh:

Anyone managed to fix this problem? Or anyone else have any idea what's going on?

Has anyone tried uninstalling & re-installing the module?

July 22, 2009

I've tried to install the Featured Products 1.6.3 contribution, but despite following all the instructions, I have a problem with Step 13 (unlucky for some!).

The instructions say:

Step 13:

Edit /catalog/index.php and change the two instances of FILENAME_NEW_PRODUCTS to FILENAME_FEATURED:

FIND (two instances of this occurs, both must be changed):

Change to:

Unfortunately, when I change the above I get the following errors:

Warning: main(includes/modules/FILENAME_FEATURED) [function.main]: failed to open stream: No such file or directory in /home/sites/exclusivechocolates.co.uk/public_html/index.php on line 313

Warning: main() [function.include]: Failed opening 'includes/modules/FILENAME_FEATURED' for inclusion (include_path='.:/usr/share/pear') in /home/sites/exclusivechocolates.co.uk/public_html/index.php on line 313

This is despite uploading the file featured.php to the includes/module folder as instructed!

Any ideas what I should do?

Thanks

July 22, 2009

I have got the SQL code but i'm unsure what I should be doing with it?

# --------------------------------------------------------
# $Id: featured_products_english.sql,v 1.3 2008/08/22 22:30:20 aa0001 Exp $

#
# Table structure for table `featured`
#
# Find and replace '18' to the next `configuration_group_id` available
# in table `configuration_group`

CREATE TABLE `featured` (
 `featured_id` int(11) NOT NULL auto_increment,
 `products_id` int(11) NOT NULL default '0',
 `featured_date_added` datetime default NULL,
 `featured_last_modified` datetime default NULL,
 `expires_date` datetime default NULL,
 `date_status_change` datetime default NULL,
 `status` int(1) default '1',
 PRIMARY KEY  (`featured_id`),
 KEY `idx_products_id` (`products_id`)
) ENGINE=MyISAM;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('18','Featured', 'Featured Products Display', '18', '1'
);

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) VALUES ('Display Featured Products', 'FEATURED_PRODUCTS_DISPLAY', 'true', 'Set to true or false in order to display featured.', '18', '1', now(), now()
);

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) VALUES ('Maximum Display of Featured', 'MAX_DISPLAY_FEATURED_PRODUCTS', '6', 'This is the maximum amount of items to display on the front page.', '18', '2', now(), now()
);

UPDATE `configuration` SET `set_function`="tep_cfg_select_option(array('true', 'false')," WHERE `configuration_key`='FEATURED_PRODUCTS_DISPLAY';

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function) VALUES ('Include Sub Categories When Displaying Featured Products', 'FEATURED_PRODUCTS_SUB_CATEGORIES', 'true', 'Set to true or false in order to display featured including sub categories.', '18', '3', now(), now(), "tep_cfg_select_option(array('true', 'false'),");

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, set_function) VALUES ('Specials Only When Displaying Featured Products', 'FEATURED_PRODUCTS_SPECIALS_ONLY', 'false', 'Set to true or false in order to display only on special featured products.', '18', '4', now(), now(), "tep_cfg_select_option(array('true', 'false'),");

Run the above sql in your sql interface (eg phpmyadmin) to the database for your site.

Open phpmyadmin & enter the code into the sql box provided under the SQL tab. You need to change the number 18 in the code to whatever next id is available in the configuration group table. Mine was 16.

July 3, 2009

I'm very confused by this Worldpay Junior option!

I'm setting up oscommerce for someone who told me he wanted to accept Paypal. However, now I've set his store up, he tells me he has a Worldpay account and wants to use that instead/as well.

When I look at the Payment modules, the only Worldpay option is "Worldpay Junior", but Worldpay only offer Business Gateway & Business Gateway Plus in the UK for online payments.

Their website says they do integrate with osCommerce, so I presume I just use this Junior option rather than download a further add-in?

June 24, 2009

I've tried to install this contribution, but it just doesn't appear in my admin panel!

The SQL ran fine, all the files have been uploaded, but there's no sign of the contribution in my admin. It's really frustrating <_<

"Run the included box_selection.sql on your catalog database. This will add the new section to the administration interface. Load up the admin interface and look around. You should now have a shiny new section AT THE BASE OF THE RIGHT COLUMN called "InfoBox Admin", with the 20 info box display options in that subsection."

No, I don't :( Saying that, I don't have a right column either!!

Any idea why it doesn't work if there are no error messages?!!!

I'm using 2.2 RC2........is this the problem? Doesn't this contribution work with that version?

June 24, 2009

I've tried to install this contribution, but it just doesn't appear in my admin panel!

The SQL ran fine, all the files have been uploaded, but there's no sign of the contribution in my admin. It's really frustrating <_<

"Run the included box_selection.sql on your catalog database. This will add the new section to the administration interface. Load up the admin interface and look around. You should now have a shiny new section AT THE BASE OF THE RIGHT COLUMN called "InfoBox Admin", with the 20 info box display options in that subsection."

No, I don't :( Saying that, I don't have a right column either!!

Any idea why it doesn't work if there are no error messages?!!!

mrpointy

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by mrpointy

Individual Product Shipping Prices tripling at checkout

Individual Product Shipping Prices tripling at checkout

Paypal Order Emails Not Being Sent

Please help, orders not coming through

Please help, orders not coming through

Paypal Order Emails Not Being Sent

Featured Products

Featured Products

Worldpay update?!

[Contribution] Infobox Admin

[Contribution] Infobox Admin

Browse

Activity