Jump to content

Automate shipments: how to insert the SENT object in the database?


Recommended Posts

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


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...