website fulfillment for a specific client
I'm looking for ideas or suggestions on how to implement this or if it's even possible.
My goal is to have a more automated shipping process, and better tracking of lot codes of items shipped.
We make 7 food products for client A. (these food products are traced via lot codes)
Client A orders from us, and we sell product to them, and go through the normal sales order process, fulfillment, invoicing.
(i.e.: Client A orders 100 of item X from us, we fulfill 100 of X, and invoice them for 100, but we just don't ship the product out, it stays at our facility). And at this point, the 100 units are now completely out of our system. And Dear has recorded the lot code of this 100 item order, as just going to Client A. When technically we are not shipping them to Client A, they will be shipped to a bunch of different website customers of Client A. I need a way to automatically track these lot codes that are going to each customer in case of a recall. Right now I'm using an excel file, and that is not a great option.
I tried asking Dear support about this, and got no helpful responses...
I know I could always just invoice Client A, and then not "fulfill" their order in Dear, but that brings up some logistical issues. If the order is for 100 units. And then say I get 33 website orders for 3 items each. that is 99 total units sold, then I can another order for 5 units. I can no longer fulfill this order, as there is only 1 item left to fulfill on the sales order, but the order is for 5 units. Dear has no way to deal with this as far as I know...
Our client does use shipstation for their web site fulfillment, so I don't know if that helps open any options for a more automated/easier process for us to track their shipments & lot codes.
Any thoughts or ideas on how to implement this?