I run a company selling vegetable seeds based in Australia. I use Woocommerce as the ecommerce platform. I am looking for a developer who can help develop an additional function within the backend of Woocommerce order page that can bulk populate an order field with different values for each order.
I have many orders each day and to pack these efficiently I use a wave picking system where I allocate each order an individual packing station number. Each packing station number corresponds to a packing location in my warehouse.
I currently allocate packing station numbers by exporting orders to a CSV file and then pasting in the packing station numbers into the CSV. I then have to save the file and reimport the order data into woocommerce which then updates a custom order field with each orders packing station number. . This is time consuming and if you stuff up the settings on the import you can override order data. It's also clunky and difficult to explain to my employees who are not all good with computers.
What I am after
I would like an additional bulk function in the orders page of the Woocommerce backend. I would like to be able to select all the processing orders/orders that need packing and then apply a bulk function which would immediately add a packing station number to each order.
At the moment I allocate packing station numbers based on the size of the order. The biggest order gets the lowest number. The packing station number is made up of two parts. A letter prefix which indicates the shelf and a number suffix which indicates a box.
Packing stations progress as below and there is a total of 206 packing station spots. We tend only to have that many order in a day during the busy period and when we are quiet we might only need the first couple of rows.
A01 - A24
B01 - B26
C01 - C26
D01 - D26
E01 - E26
F01 - F26
H01 - H26
So for example if we only had 50 orders the bulk action would only add packing station numbers up to B26. A01 would be the largest order and B26 would be the smallest order.
I hope what I am after makes sense to you. It would be good to hear back from you.
Thanks for your time