PROTOTYPE - Barcode Scanning and NetSuite

Background

Hawaiian Paradise Coffee (HPC) needed a Warehouse Management System (WMS) for all of their picking operations. A picking ticket is used to indicate to the warehouse workers of which product is to be pulled out of the warehouse storage to fulfill a sales order. I evaluated the current picking operation and created a prototype that leverage a 3rd party Barcode scanner with a Django web app that is integrated with NetSuite. This also support the continued effort of reducing paper documents in their operation.

Current Operation

  1. Order desk gets an email or a a phone call from a customer to place a Sales Order

  2. Order desk creates the Sales Order in NetSuite and prints out a picking ticket

  3. Order desk drops the printed picking ticket paper on their desk for a Warehouse employee to come by and grab the picking ticket to pull products off of the shelves

  4. Once each product is pulled and the Sales Order has all of its' items fulfilled, then the warehouse worker writes down the lots of each product pulled on their paper picking ticket and signs it

  5. Once the paper picking ticket gets back to Order Desk, then they will process the data in NetSuite via Item Fulfillment and fulfill and invoice the order

  6. Order Desk prints the invoice to give the delivery driver to drop off the products from the Sales Order to the customer's site and have them signs off as proof of delivery

  7. Once the paper invoice is signed, then it is given to a personnel that will the proof of delivery for Account Receivables to collect payment

Proposed Operation with BarCode

  1. Order desk gets an email or a a phone call from a customer to place a Sales Order

  2. Warehouse workers are in communication with their manager on which Sales Order are in open status that hasn't been fulfilled
    Pasted image 20250417062029.png

  3. Warehouse worker can leverage the WMS below to check for stock supply and utilize FIFO pulling strategy
    Pasted image 20250417062735.png

  4. [NOT YET IMPLEMENTED] Integrate with NetSuite to automatically item fulfill the Sales Order once all the products have been fulfilled in the WMS system straight to Invoice

  5. Delivery drivers can use their tablet to eSign the invoice upon delivery

Video Demonstration

Conclusion

With the prototype WMS shown, we can eliminate the redundancy of Warehouse workers picking up a printed picking ticket, errors of reading case labels, and the physical paper trail processing and storage. With the full implementation of the WMS, we can digitize the entire warehouse process and leverage database and digital tactics for efficiency such as a warehouse worker being able to quickly see the current stock and lots of a product for FIFO pulls.