I'm starting a food growing business. When I plant a crop, I assign a lot number to the plants in a particular location. That lot number is then used to track the crop from planting through delivery to a customer and, if needed, to execute a recall of the products.
I have a farm management system for tracking the lot number while growing the crop, but once it is sold, I need a way to associate the lot number with the orders placed by customers so that I know who purchased the crops from any particular lot.
When I'm fulfilling an order, how can I specify the lot numbers for the products included in that order?
Thanks in advance for any help you can provide.