ballashop Posted April 30, 2018 Share Posted April 30, 2018 Hi, We do not have the synchronization with the carrier, we need to change the delivery date because Can someone advise me on how to proceed? Some date do not correspond to the correct delivery ones. thanks for any reply. We use PS 1.6.1.18 Link to comment Share on other sites More sharing options...
ballashop Posted May 5, 2018 Author Share Posted May 5, 2018 Hello, someone who can help me? Obviously I do not pretend it for free. Thanks Link to comment Share on other sites More sharing options...
tztudio Posted January 6, 2020 Share Posted January 6, 2020 I would also like an answer to this question. Is there any way to change the shipping date in the back office, after an item's status has been updated to "shipped"? Thank you : ) Link to comment Share on other sites More sharing options...
ventura Posted January 6, 2020 Share Posted January 6, 2020 To be able to make this type of edition it will be necessary to access the instalation´s database. Order information and status are stored in various tables, so it is best to make a query that updates the information. eg UPDATE ps_order_history os LEFT JOIN ps_orders od ON od.id_order = os.id_order LEFT JOIN ps_order_state ps ON ps.id_order_state = od.current_state LEFT JOIN ps_order_state_lang pl ON pl.id_order_state = ps.id_order_state SET os.date_add = "2020-01-06 15:34:53" -- The new edited Date WHERE od.reference = "XOIPAVKUE" -- The order Reference AND pl.`name` = "Consegnato" -- The Delivery Order Status Please, always when you make an operation of this type in the database, it is convenient to make a backup of the database or of the tables in which you operate 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