Jump to content
Sign in to follow this  
elari

[Contribution] Payement Module Update Default Order Status

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]

 

Share this post


Link to post
Share on other sites

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` ;

Share this post


Link to post
Share on other sites

i got this msg when runs the query that you ask :

 

Error

 

SQL-query :

 

ALTER TABLE `orders` ADD customers_company varchar( 32 )

 

MySQL said:

 

 

Nom du champ 'customers_company' d?j? utilis?

 

whats the problem ?

Share this post


Link to post
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

Share this post


Link to post
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]

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

just back to work

 

i plan to make change for ms1 next week :(

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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 :)

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

i have send by mail to galapago

hope this is good mail, or pm your real mail

elari

Share this post


Link to post
Share on other sites

:thumbsup: :lol:

Thanks !! Thanks elari !!

 

Thanks to be pending of this forum !

 

Merci ? ?tre en suspens de ce forum

 

 

Miguelm :rockedover:

Traducci?n de altavista Babel Fish en Fran?ais:

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

It is not PID , its MCTN, my friend was mistaken.

 

Also, i am not able to download the contribution from your site.

Share this post


Link to post
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 :((

Share this post


Link to post
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

Share this post


Link to post
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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×