bamboozled Posted January 12, 2011 Share Posted January 12, 2011 I had a customer who purchased an item and said the method of payment they wished to use wasbankwire, they then changed their mind and phoned with card details.However, they were unable to change the method of payment at their end.I changed the status as 'payment accepted'.Is this the only way possible, or can the customer change the method of payment? Link to comment Share on other sites More sharing options...
rocky Posted January 12, 2011 Share Posted January 12, 2011 Nope, the customer can't change their payment method, and neither can you in the Back Office. The only way is to manually edit the ps_orders table in your database. Link to comment Share on other sites More sharing options...
bamboozled Posted January 12, 2011 Author Share Posted January 12, 2011 hi,when you say"manually edit the ps_orders table in your database"do you mean what I did, which was use the 'Payment Accepted' option? Link to comment Share on other sites More sharing options...
rocky Posted January 12, 2011 Share Posted January 12, 2011 No, I mean use phpMyAdmin to edit your database, then change the value of the "payment" filed in the ps_orders table to match the changed payment method. Link to comment Share on other sites More sharing options...
bamboozled Posted January 12, 2011 Author Share Posted January 12, 2011 sorry to be so dumb, but I don't understand where "phpMyAdmin" is and what you are describing? Link to comment Share on other sites More sharing options...
rocky Posted January 13, 2011 Share Posted January 13, 2011 phpMyAdmin lets you manually edit your database. You can find it in the "Databases" section of cPanel on your server. Link to comment Share on other sites More sharing options...
bamboozled Posted January 13, 2011 Author Share Posted January 13, 2011 hi, thankyou I found this in c-panel and changed the payment manually,but then went back to back office to check what the customers order looked like now -nothing appears to have changed?and clicked on payment accepted which has duplicated the information from before.How do I delete this?2011-01-13 18:41:20 Payment accepted (K. RENNIE)2011-01-12 10:19:30 Payment accepted (K. RENNIE)2011-01-11 16:21:15 Awaiting bank wire paymentthis is the full page on c-panel Link to comment Share on other sites More sharing options...
rocky Posted January 14, 2011 Share Posted January 14, 2011 Changing the "payment" and "module" should have changed the payment method displayed on the Orders tab, though you shouldn't have any spaces in the "module" field. The order status history is stored in the ps_order_history table. Link to comment Share on other sites More sharing options...
bamboozled Posted January 14, 2011 Author Share Posted January 14, 2011 BRILLIANT - Yet again you have SOLVED my issue,many thanks. Link to comment Share on other sites More sharing options...
rocky Posted January 14, 2011 Share Posted January 14, 2011 Great. Please edit your first post and add [sOLVED] to the front of the title. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now