Send out Order message to customer after import

-- HikaShop version -- : 2.6.2
-- Joomla version -- : 3.5.1

Hi, I have a client who gets a large number of orders a day sometimes 1000 orders in a day during holidays. I have a few questions about this.

They export the orders and re-upload the orders with the order status changed to shipped and I also have a custom field in the order tabled called tracking_number that they type the tracking number in. When the order status is changed to shipped after the import the csv I would like it to email the customers and notify i.e send the order status notification email that the order has shipped.

This is easy to do when I do one order at at time because I can click save and notify after I change the order status and input the tracking number however after i bulk import the order status via a csv I have no idea how to do this.

1)I have 2 questions how do I have it automatically email the customer after an import like this? I am guessing you may use mass actions but I have no clue as to how to go about doing this.
2)If I am able to do what I am asking in question 1 how can I have it stagger the emails I am guessing if a csv is uploaded with 1000 orders in and it emails 1000 customers at 1 time the server could get blacklisted so I would need a way to not send all the emails at once? I talked to my hosting companyy as well and they said it would be better to stagger the emails at a script level rather than on a server level because if it is done on a server level they could time out and not all get sent out.

Thanks,

Josh

Hi, is there even a way to bulk import order status? I thought I had saw a way but now that I am looking a only see a way to export the orders not import them.

Looking at the tables in phpmyadmin for the orders it appears impossible to to do this. I need to be able to export the orders out which is currently possible and then re-import them back in again with the shipping status changed and the tracking number changed.

Adding 1000 tracking numbers manually and 1 by 1 changing the shipping status is going to be impossible for the client.

How can I get this to work?

My client has lower number of orders, but harder emails limits. We have full synchronization with accounting software, but if you need only update orders from csv, it's much easier.
Our setup consists from one custom field and one mass action.
When order is marked as shipped in accounting software, order is updated with shipping id(tracking number) and custom field is set to 1 via remote call to custom plugin.
Mass action is triggered via cron every 5 minutes, filter orders with custom field set to 1, change status of this orders to shipped and send notification email.

Here are our custom fields:

and here is our mass action:



If you are going to update orders over csv file, all you need is very simple cron plugin to read csv file, update orders with tracking number and set custom filed to 1. Mass action will do the rest.

But mass action will not work for you at the moment, because there is one bug in SQL. Bug report is here .