ietax Posted November 29, 2013 Posted November 29, 2013 Hi, I need to change the order status using mysql commands Let me explain, I created a PHP script that automatically generates shipping labels for paid orders and I automatically inserts the generated shipping number (from script) in table ps_orders (shipping number field). For each order I have to go in the tab orders and modify it as shipped. How can I automate this step? I should tell to my script to "mark the order as shipped" by sql and PHP now i have the following steps: - PHP create shipping code - PHP and MYSQL enter it in the field shipping_number and the next must be...... - modify the item as shipped (by PHP and MYSQL) I have seen that is also enhanced the delivery_number column and delivery_date but have not found the field "shipping State" ... Thanks, I hope I was clear Share this post Link to post Share on other sites More sharing options...
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
Already have an account? Sign in here.Sign In Now