Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] Payement Module Update Default Order Status


elari

Recommended Posts

well , i havent add anything yet to my db ,

 

i reinstall OSC , and add the WU mod ,

 

now i got this msg when customer to confirm order : help me , thanks

HEADING_ORDER_STATUS 



1054 - Champ 'osh.new_value' inconnu dans where clause



select os.orders_status_name, osh.date_added from orders_status os, orders_status_history osh where osh.orders_id = '4' and osh.new_value = os.orders_status_id and os.language_id = '1' order by osh.date_added desc



[TEP STOP]

 

Link to comment
Share on other sites

  • Replies 52
  • Created
  • Last Reply

Top Posters In This Topic

did you run the query before ????

 

# $Id: 2_orders_status_dos_install.sql,v 1.5 2003/01/31 12:02:31 elarifr Exp $

 

#Payment Dynamic orders Status

 

#Make following change to table orders_status

ALTER TABLE `orders_status` ADD `orders_status_need_conf` TINYINT( 1 ) DEFAULT '0';

ALTER TABLE `orders_status` ADD `orders_status_final` CHAR( 1 ) DEFAULT '0' NOT NULL ;

 

#Change 2M1229

ALTER TABLE `orders_status` CHANGE `orders_status_need_conf` `orders_status_need_conf` INT( 1 ) DEFAULT '0' NOT NULL

ALTER TABLE orders_status CHANGE orders_status_final orders_status_final INT (1) DEFAULT '0' not null

ALTER TABLE `orders_status` ADD `orders_status_need_conf_id` INT( 11 ) NOT NULL AFTER `orders_status_need_conf` ;

 

#Added / changed 2M1231

ALTER TABLE `orders` ADD `date_finished` DATETIME NOT NULL ,

ADD `orders_status_closed` INT( 10 ) DEFAULT '0' NOT NULL ,

ADD `orders_status_need_conf` INT( 5 ) DEFAULT '0' NOT NULL ;

ALTER TABLE `orders` ADD `orders_status_need_conf_password` VARCHAR( 32 ) ;

 

###########################################################

##### Package Released 2M1231 Happynew year

###########################################################

 

#Added 2N0109 Auto comment orders_status

ALTER TABLE `orders_status` ADD `orders_status_comment` TEXT NOT NULL ;

 

###########################################################

##### Package Released 2N0109 Added autocomment orders status

###########################################################

 

 

###########################################################

##### Package Released 2N0123 Added autocomment orders status

###########################################################

 

# seems to miss check it

ALTER TABLE `orders` ADD `orders_date_finished` DATETIME NOT NULL ;

ALTER TABLE `orders` ADD `orders_status_need_conf_id` INT( 11 ) NOT NULL AFTER `orders_status_need_conf` ;

 

#Added 2n0207 to recall payment module for confirmation

ALTER TABLE `orders` ADD `payment_module` VARCHAR( 32 ) NOT NULL AFTER `payment_method` ;

Link to comment
Share on other sites

take a book and study php

prend un livre et apprend php / mysql

 

as wrote it means the field already exist

 

run query line by line and check where are following error you can have

Link to comment
Share on other sites

tried already and it doesnt seems to work still get this appear at the bottom of customer order history

 

HEADING_ORDER_STATUS

 

1054 - Champ 'osh.new_value' inconnu dans where clause

 

select os.orders_status_name, osh.date_added from orders_status os, orders_status_history osh where osh.orders_id = '2' and osh.new_value = os.orders_status_id and os.language_id = '1' order by osh.date_added desc

 

[TEP STOP]

Link to comment
Share on other sites

it seems the table structure has change on lastest cvs since end jan

 

you can

1/ remove call to the field, but will make / need many change

2/ readd this field in your table order status history (check oscmmerce cvs to see the structure of the osh table as it was before change in catalog/install/oscommerce.sql).

readd the old field and keep the new one

 

this solution will be the best one until i update payment to lastest chaneg planned for ms1

Link to comment
Share on other sites

Does anyone know how to modify this code so you can include your 'affiliation link' to WesternUnion in the shopping cart process? I have looked and can not seem to find it..

 

Thomas

Rainbow Computers

 

http://www.stormpay.com/?50381&OSCF for a alternative to paypal.

A signature is something that reflects its user. - The dictionary

 

The question is not, 'to code, or not to code'

the question is, 'if we do not code, are we really alive?'

-- anonymous

Link to comment
Share on other sites

Affiliation link, you've not only set up to process payments through a service ie: paypal or western Union, but have been setup to get a cut of the action.. say for example 2% of fee's charged to all orders processed.

 

For example, I am set up with stormpay.com as an affiliate (this is automatic) and my advertising link is..

http://www.stormpay.com/?50381

 

I want to include somthing like that in the processing of the order. In my mind it would allow not only allow the order process to be completed, but that my 'affiliation' be credited for the % fee's from that sale..

 

I hope that explains it succinckly?(sp?)

 

Thomas

A signature is something that reflects its user. - The dictionary

 

The question is not, 'to code, or not to code'

the question is, 'if we do not code, are we really alive?'

-- anonymous

Link to comment
Share on other sites

Affiliation link, you've not only set up to process payments through a service ie: paypal or western Union, but have been setup to get a cut of the action.. say for example 2% of fee's charged to all orders processed. I want to include somthing like that in the processing of the order. In my mind it would allow not only allow the order process to be completed, but that my 'affiliation' be credited for the % fee's from that sale..

Thomas

it means ?

customer pay 100% to payment gateway

you need to make an order total module (like ot_xmember) that will calculate x % from order but without changing total order

the shop get 100% payment of order ....

& the checkout process will then credit your account from the ot x% amount....

 

 

ithink it should be done, but it has nothing to do with this thread :)

Link to comment
Share on other sites

just back to work

 

i plan to make change for ms1 next week :(

 

'til the releasing of the ms1 version, can you email me a dos-payment 2n0901 copy, please.

 

I can't download it from your site

 

Merci d'avance,

 

E. Pierre

 

which email ?

 

if you work on ms1 shop, it will not work since comment field have been removed changed from orders/orders_history. it work if you keep old field comment in orders

Link to comment
Share on other sites

  • 4 weeks later...

Hi Elari !

 

please, which is the file accounting.php in /admin/includes/application_top.php

 

define('FILENAME_ACCOUNTING', 'accounting.php');

 

I can?t see in the zip file or where is my mistake ???? :shock:

 

miguelm

Link to comment
Share on other sites

Elari, while testing out the Western Union Payment Contribution

 

I got this error on the top of the page, while the rest of the page appeared normally.

 

 

 

Parse error: parse error in /usr/local/apache/htdocs/unlockgsm/test_checkout/catalog/includes/languages/english/modules/payment/moneyorder.php on line 14

 

 

Also, i get this under Payment INformation

 

Make Payable To:

First Name: My First Name

Last Name: My Last Name

Adress: My Adress

Zip Code: My Zip

City: My City

Country: My Country

Phone: My Phone

Your order will not ship until we receive MCTN payment number !.

 

It does not list my name etc.

 

 

Moreover, my friend talked to western union and they said that they require a Personal Identification Number (PID) if the Order amount if less than $2000.

 

Is this feature included in your contribution

 

And when will you be releasing the new version of Western Union

 

 

Thanks

Link to comment
Share on other sites

these are default value for payment field. just have to edit them and enter your own information.

WU is not finished, i have to rewrite some part of Dos Payment before finishing WU

1/ order status must be reimplemented the same way decided by hpdl (it is a little bit diff from the way i had made and hpdl did not keep the way i wrote)

2/ with ms1 comment field has been changed and i have to adjust this way for checkout confirmation so that customer can come back after order and complete order with payment information like mctn number

3/ i have already wrote some part of order confirmation by password

try to make an order on my demo page by using cod and then use link like

 

http://www.unlockgsm.com/test_checkout/cat...ent_confirm.php

 

it will be used for wu for customer to enter mctn information.

 

4/ i have to find some time :((

Link to comment
Share on other sites

you can also try wu payment to see how it will work :)

 

just use this link

http://www.unlockgsm.com/test_checkout/cat...ent_confirm.php

 

and provide order number and password to confirm wu mctnand sender information

 

 

i have no information about the PID ???????

here western union nether asked any PID number to make or receive money

 

 

i will try to make some screenshot of checkout payment confirmation to see how it will be used

Link to comment
Share on other sites

HIya elari

 

I checkout out the WU payment contribution and its working great.

 

Also, can this be completed in time. Where can i download this contribution as the download from your site is not working.

 

Can you email me the file?

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...