Jump to content

Change a delivery date within order page


ballashop

Recommended Posts

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

change-date-delivery.png

Link to comment
Share on other sites

  • 1 year later...

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

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
×
×
  • Create New...