ballashop Posted February 18, 2022 Share Posted February 18, 2022 Hi, I noticed in the back end that some orders gave € 0.00 on the label: "total paid from registration" even if the order is complete and shipped. Via query on the db: SELECT * FROM ps_orders WHERE reference = "ordernumber"; and I found a field called "valid" the value was 0. UPDATE `ps_orders` SET` valid` = '1' WHERE `ps_orders`.`id_order` = orderid; After making the change to 1, the data reappeared: I would like to ask the community if this change can affect other tables, if there are relationships with this data so it would be better not to change it. Thanks for any reply. Balla 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