Jump to content



Photo
- - - - -

One Page Checkout Support


  • Please log in to reply
2286 replies to this topic

#21   sheepiedog

sheepiedog
  • Members
  • 194 posts
  • Real Name:Deb Humeniuk

Posted 12 April 2009 - 15:46

It seems that there are many problems/issues with this contribution. Can anyone advise that they have it working on a live store successfully with no issues ?

Edited by sheepiedog, 12 April 2009 - 15:47.


#22   Rseasy

Rseasy
  • Members
  • 2 posts
  • Real Name:Chris Lee
  • Gender:Male

Posted 14 April 2009 - 10:07

Hi guys,

Looks like a great contribution but i can't get it working.

I have the following error:

1146 - Table 'rs_os.table_coupons' doesn't exist

select * from TABLE_COUPONS where coupon_code = 'NEW_SIGNUP_DISCOUNT_COUPON'

[TEP STOP]

Does anyone knows how to solve this problem?

Thanks!

#23   Rseasy

Rseasy
  • Members
  • 2 posts
  • Real Name:Chris Lee
  • Gender:Male

Posted 14 April 2009 - 12:37

Hi guys,

Looks like a great contribution but i can't get it working.

I have the following error:

1146 - Table 'rs_os.table_coupons' doesn't exist

select * from TABLE_COUPONS where coupon_code = 'NEW_SIGNUP_DISCOUNT_COUPON'

[TEP STOP]

Does anyone knows how to solve this problem?

Thanks!



Ok I found the solution!

Just need to add those value in SQL DB

# phpMyAdmin MySQL-Dump
# http://www.phpmyadmin.net/

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('To offer a gift voucher', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '0', 'Please indicate the amount of the gift voucher which you want to offer a new customer.<br><br>Put 0 if you do not want to offer gift voucher.<br>', 1, 31, NULL, now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('To offer a discount coupon', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'To offer a discount coupon to a new customer, enter the code of the coupon.<br><br>Leave empty if you do not want to offer discount coupon.<BR>', 1, 32, NULL, now(), NULL, NULL);


#
# Table structure for table 'coupon_email_track'
#

CREATE TABLE coupon_email_track (
unique_id int(11) NOT NULL auto_increment,
coupon_id int(11) NOT NULL default '0',
customer_id_sent int(11) NOT NULL default '0',
sent_firstname varchar(32) default NULL,
sent_lastname varchar(32) default NULL,
emailed_to varchar(32) default NULL,
date_sent datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (unique_id)
);


#
# Table structure for table 'coupon_gv_customer'
#

CREATE TABLE coupon_gv_customer (
customer_id int(5) NOT NULL default '0',
amount decimal(8,4) NOT NULL default '0.0000',
PRIMARY KEY (customer_id),
KEY customer_id (customer_id)
);


#
# Table structure for table 'coupon_gv_queue'
#

CREATE TABLE coupon_gv_queue (
unique_id int(5) NOT NULL auto_increment,
customer_id int(5) NOT NULL default '0',
order_id int(5) NOT NULL default '0',
amount decimal(8,4) NOT NULL default '0.0000',
date_created datetime NOT NULL default '0000-00-00 00:00:00',
ipaddr varchar(32) NOT NULL default '',
release_flag char(1) NOT NULL default 'N',
PRIMARY KEY (unique_id),
KEY uid (unique_id,customer_id,order_id)
);


#
# Table structure for table 'coupon_redeem_track'
#

CREATE TABLE coupon_redeem_track (
unique_id int(11) NOT NULL auto_increment,
coupon_id int(11) NOT NULL default '0',
customer_id int(11) NOT NULL default '0',
redeem_date datetime NOT NULL default '0000-00-00 00:00:00',
redeem_ip varchar(32) NOT NULL default '',
order_id int(11) NOT NULL default '0',
PRIMARY KEY (unique_id)
);


#
# Table structure for table 'coupons'
#

CREATE TABLE coupons (
coupon_id int(11) NOT NULL auto_increment,
coupon_type char(1) NOT NULL default 'F',
coupon_code varchar(32) NOT NULL default '',
coupon_amount decimal(8,4) NOT NULL default '0.0000',
coupon_minimum_order decimal(8,4) NOT NULL default '0.0000',
coupon_start_date datetime NOT NULL default '0000-00-00 00:00:00',
coupon_expire_date datetime NOT NULL default '0000-00-00 00:00:00',
uses_per_coupon int(5) NOT NULL default '1',
uses_per_user int(5) NOT NULL default '0',
restrict_to_products varchar(255) default NULL,
restrict_to_categories varchar(255) default NULL,
restrict_to_customers text,
coupon_active char(1) NOT NULL default 'Y',
date_created datetime NOT NULL default '0000-00-00 00:00:00',
date_modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (coupon_id)
);


#
# Table structure for table 'coupons_description'
#

CREATE TABLE coupons_description (
coupon_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '0',
coupon_name varchar(32) NOT NULL default '',
coupon_description text,
KEY coupon_id (coupon_id)
);

#24   oldschoo

oldschoo
  • Members
  • 163 posts
  • Real Name:beth marquardt

Posted 15 April 2009 - 03:28

Does anyone have Date of Birth Drop Down with this add-on? As if so, please help. What files and info do I need to change?

#25   stukk

stukk
  • Members
  • 8 posts
  • Real Name:James Wood

Posted 17 April 2009 - 01:08

Hey!

Just wanted to say what a fantastic contribution this is! I'm using STS at the moment and have experienced some issues, I think I may opt to turn off STS for a while until there is a solution as it really makes things so much easier for customers.

Do we have any idea if/when an STS integration might happen?

Thanks! James :-)

#26   johnnybebad

johnnybebad
  • Members
  • 672 posts
  • Real Name:Johnny

Posted 18 April 2009 - 21:05

First let me say great contribution, having switched off in admin as suggested earlier dont get the duplication, however I am not being directed to domplete payment, it just keeps retuning to the page.

This happens with STS switched on or off, if anyone has it working better with sts, can they let us know how please.

Thanks

Johnny
Getting better with mods but no programmer am I.

#27   morehawes

morehawes
  • Members
  • 176 posts
  • Real Name:Joe
  • Location:Cardiff, United Kingdom

Posted 18 April 2009 - 21:12

if anyone has it working better with sts, can they let us know how please.


Hi, i've not looked into this specifically for one page checkout but one common problem I have found with STS is if the page outputs anything before the HTML begins i.e. before:

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
(or similar)

Then this is ignored by STS. So check for print/echos before the HTML begins, though if it's good code there shouldn't be any. As I say i'm not sure about this but it's always a good place to start looking.

Edited by morehawes, 18 April 2009 - 21:13.

Joe

MacMan strikes again!

Always backup first before listening to me!

#28   johnnybebad

johnnybebad
  • Members
  • 672 posts
  • Real Name:Johnny

Posted 18 April 2009 - 21:29

Hi, i've not looked into this specifically for one page checkout but one common problem I have found with STS is if the page outputs anything before the HTML begins i.e. before:

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
(or similar)

Then this is ignored by STS. So check for print/echos before the HTML begins, though if it's good code there shouldn't be any. As I say i'm not sure about this but it's always a good place to start looking.



Not sure, but I get the error messages on clicking continue if I dont select or tye in the values, but just cant get to pay for anything, will revisit the code tomorrow and the instructions.

thanks for the advice

Johnny
Getting better with mods but no programmer am I.

#29   JFrancis

JFrancis
  • Members
  • 29 posts
  • Real Name:John Francis

Posted 19 April 2009 - 03:14

Ok I found the solution!

Just need to add those value in SQL DB

# phpMyAdmin MySQL-Dump
# http://www.phpmyadmin.net/

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('To offer a gift voucher', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '0', 'Please indicate the amount of the gift voucher which you want to offer a new customer.<br><br>Put 0 if you do not want to offer gift voucher.<br>', 1, 31, NULL, now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('To offer a discount coupon', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'To offer a discount coupon to a new customer, enter the code of the coupon.<br><br>Leave empty if you do not want to offer discount coupon.<BR>', 1, 32, NULL, now(), NULL, NULL);


#
# Table structure for table 'coupon_email_track'
#

CREATE TABLE coupon_email_track (
unique_id int(11) NOT NULL auto_increment,
coupon_id int(11) NOT NULL default '0',
customer_id_sent int(11) NOT NULL default '0',
sent_firstname varchar(32) default NULL,
sent_lastname varchar(32) default NULL,
emailed_to varchar(32) default NULL,
date_sent datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (unique_id)
);


#
# Table structure for table 'coupon_gv_customer'
#

CREATE TABLE coupon_gv_customer (
customer_id int(5) NOT NULL default '0',
amount decimal(8,4) NOT NULL default '0.0000',
PRIMARY KEY (customer_id),
KEY customer_id (customer_id)
);


#
# Table structure for table 'coupon_gv_queue'
#

CREATE TABLE coupon_gv_queue (
unique_id int(5) NOT NULL auto_increment,
customer_id int(5) NOT NULL default '0',
order_id int(5) NOT NULL default '0',
amount decimal(8,4) NOT NULL default '0.0000',
date_created datetime NOT NULL default '0000-00-00 00:00:00',
ipaddr varchar(32) NOT NULL default '',
release_flag char(1) NOT NULL default 'N',
PRIMARY KEY (unique_id),
KEY uid (unique_id,customer_id,order_id)
);


#
# Table structure for table 'coupon_redeem_track'
#

CREATE TABLE coupon_redeem_track (
unique_id int(11) NOT NULL auto_increment,
coupon_id int(11) NOT NULL default '0',
customer_id int(11) NOT NULL default '0',
redeem_date datetime NOT NULL default '0000-00-00 00:00:00',
redeem_ip varchar(32) NOT NULL default '',
order_id int(11) NOT NULL default '0',
PRIMARY KEY (unique_id)
);


#
# Table structure for table 'coupons'
#

CREATE TABLE coupons (
coupon_id int(11) NOT NULL auto_increment,
coupon_type char(1) NOT NULL default 'F',
coupon_code varchar(32) NOT NULL default '',
coupon_amount decimal(8,4) NOT NULL default '0.0000',
coupon_minimum_order decimal(8,4) NOT NULL default '0.0000',
coupon_start_date datetime NOT NULL default '0000-00-00 00:00:00',
coupon_expire_date datetime NOT NULL default '0000-00-00 00:00:00',
uses_per_coupon int(5) NOT NULL default '1',
uses_per_user int(5) NOT NULL default '0',
restrict_to_products varchar(255) default NULL,
restrict_to_categories varchar(255) default NULL,
restrict_to_customers text,
coupon_active char(1) NOT NULL default 'Y',
date_created datetime NOT NULL default '0000-00-00 00:00:00',
date_modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (coupon_id)
);


#
# Table structure for table 'coupons_description'
#

CREATE TABLE coupons_description (
coupon_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '0',
coupon_name varchar(32) NOT NULL default '',
coupon_description text,
KEY coupon_id (coupon_id)
);


Hi,

It's looking for the CREDIT CLASS Gift Voucher Contribution, in the includes/classes/onepage_checkout.php file.
There are two snippets of code concerning it. Commenting them out solves the issue a bit more easily.

Regards,

JF

#30   JFrancis

JFrancis
  • Members
  • 29 posts
  • Real Name:John Francis

Posted 19 April 2009 - 03:34

The contribution only works properly with flat rate shipping. It doesn't refresh the order total shipping properly, with shipping modues that increase shipping with added quantities &/or weight.

JF

Edited by JFrancis, 19 April 2009 - 03:37.


#31   johnnybebad

johnnybebad
  • Members
  • 672 posts
  • Real Name:Johnny

Posted 19 April 2009 - 07:11

Well flat rate is working now in sts with paypal standard, be nice to get other payment modules and shipping modules working.

Johnny
Getting better with mods but no programmer am I.

#32   johnnybebad

johnnybebad
  • Members
  • 672 posts
  • Real Name:Johnny

Posted 19 April 2009 - 08:19

Well flat rate is working now in sts with paypal standard, be nice to get other payment modules and shipping modules working.

Johnny



Okay, the multizone shipping does update but only when I swap between flat rate and multizone shipping.

the shipping method box only changes the shipping cost when I refresh the page, so I guess, all thats needed would be to make the shipping method section ajax???? and then it should all update properly???

Also, I am uk based and the tax is showing as UK VAT + USA export, can anyone advise why that would be please.

Thanks

Johnny
Getting better with mods but no programmer am I.

#33   gtgderek

gtgderek
  • Members
  • 13 posts
  • Real Name:Derek

Posted 19 April 2009 - 17:14

I have been able to get Table Rate, Flat Rate, and Free Shipping working with this mod. I have not tried the USPS, UPS, or FedEx shipping modules. The only thing on my wish list is the ability to check out using other payment modules besides Paypal standard.

If I use Paypal Web pro or any other Credit card processing modules, the checkout page will take the customer to the login / register page and people have to go back through the checkout process after they register.

Hopefully someone finds a fix for this login / registry issue so I can use another Credit Card processing module.

Derek

#34   TS153

TS153
  • Members
  • 47 posts
  • Real Name:Terry Scarr

Posted 20 April 2009 - 02:28

I am getting this warning after it seemed to work fine for me.
I turned it off in the admin console just to make sure and now I cant turn it back on or change any of the other values because of it.
Im assuming because no one else has had this problem that it me.

Warning: Cannot modify header information - headers already sent by (output started at /home/ter32222/public_html/musclebeach/admin/configuration.php:42) in /home/ter48888/public_html/musclebeach/admin/includes/functions/general.php on line 22

Any Ideas.
Thankyou.

#35   iyah

iyah
  • Members
  • 122 posts
  • Real Name:Sophia
  • Gender:Female

Posted 20 April 2009 - 15:25

hi,

what a great contribution! thanks so much to the author. well appreciated for your time and hard work!

i have two issues:

1) ajax-loader.gif is not showing although i have checked over and over again and the image is already uploaded to my catalog/images.

How do I fix this?

2) I also get that error message:

1146 - Table 'rs_os.table_coupons' doesn't exist

select * from TABLE_COUPONS where coupon_code = 'NEW_SIGNUP_DISCOUNT_COUPON'



I have the Discount Coupon Code contribution installed.
Should I add the above solution to my database or will I need to uninstall the Discount Coupon Code and install the Credit Class & Gift Voucher Contribution?

Any help would be much appreciated.

Thanks in advance....I hope.

#36   NimaP

NimaP
  • Members
  • 158 posts
  • Real Name:wdwad
  • Gender:Male

Posted 20 April 2009 - 18:34

what credit card module works for you guys? the one that comes with RC2 does not work. it just sends me to a blank page. same thing with another credit card with cvv2 module.

#37   johnnybebad

johnnybebad
  • Members
  • 672 posts
  • Real Name:Johnny

Posted 20 April 2009 - 20:52

everything seems to be working, except the only issue I have at the moment is that the orders in admin, dont assign the customers details but the billing and shipping address are assigned.

I am guessing this means that the one page checkout does send billing and shipping but not customer?

I will check a few things out first, make sure I didnt delte them when I was rejigging a few things.

When I get the gift voucher mod installed and working on its own I will let you know how I get on with the integration.

Great mod, and I will be doing a lot more testing once, have had a few teething problems, mainly around the settings regarding currency and addresses, and once they were sorted out most of the shipping and payment mods appeared to work okay.

Thanks

Johnny
Getting better with mods but no programmer am I.

#38   iyah

iyah
  • Members
  • 122 posts
  • Real Name:Sophia
  • Gender:Female

Posted 20 April 2009 - 21:21

hi.

can anyone help with the ajax-loader.gif and the contributions i mentioned above?

thx

#39   redrum

redrum
  • Members
  • 218 posts
  • Real Name:Fredrik
  • Gender:Male

Posted 20 April 2009 - 22:02

hi,

what a great contribution! thanks so much to the author. well appreciated for your time and hard work!

i have two issues:

1) ajax-loader.gif is not showing although i have checked over and over again and the image is already uploaded to my catalog/images.

How do I fix this?

2) I also get that error message:




I have the Discount Coupon Code contribution installed.
Should I add the above solution to my database or will I need to uninstall the Discount Coupon Code and install the Credit Class & Gift Voucher Contribution?

Any help would be much appreciated.

Thanks in advance....I hope.


1. Whats your url?

2. Check this post for the solution. Dont add anyting into the database to get rid of this error message.

Edited by redrum, 20 April 2009 - 22:04.


#40   johnnybebad

johnnybebad
  • Members
  • 672 posts
  • Real Name:Johnny

Posted 20 April 2009 - 22:21

I have another issue, the products box in checkout.php displays as below:-

Products Model Products Name Quantity Price Each Total Price
MSINTKB Microsoft Internet Keyboard PS/2 £69.99 £139.98
DVD-BLDRNDC Blade Runner - Director's Cut £30.00 £30.00
PC-UNTM Unreal Tournament
- Version: Download: Windows - English £89.99 £89.99


Sub-Total: �259.97
United Kingdom (Royal mail/courier): �15.00
VAT (17.5%): �45.49
Total: �320.46

Where � is actually £, however its not being displayed as such, I am guessing that this is a character output thing, as when i do a view source all show as £.

The product prices come from cart.php and the others come from the order_total module I think, so how do i get them all to display on the site in checkout.php as £

Thanks

Johnny
Getting better with mods but no programmer am I.