Cold Storage Inventory System


The current version only has 4 procedures:


            Order Maintenance.

Orders are either transfer or shipment orders. Transfer orders move the pallets to other warehouses on the system. Shipment orders remove the pallets from the inventory as a shipment to a customer.

In order to work with an order, the user must assign the order to the session, either by creating a new order or selecting an existing open order. Once an order is assigned to the session the user may; modify the order type and information, use the inventory maintenance to assign (stage) pallets to the order and transfer or ship the pallets assigned to the order.


            Order History.

Displays closed orders and allows the user to display details, print and unship orders. There is also a pallet history display that shows the history of any pallet on the order. I haven't allowed uses to unship a transfer order because users have the ability to transfer pallets back to the original warehouse if necessary.


The Order History now has a Price-Charge option that allows a user to price and apply expenses to the shipped fruit. The expenses are applied using three types of charges that would print on an invoice: Sales to A/P, Sales to Cost of Sales+FOB, Sales to Cost of Sales. Two additional types that are not printed and and only apply to Cost of Sales+FOB to A/P and just Cost of Sales to A/P. There is a create excel/csv button that allows the transfer of this data to other accounting systems. All charges to COS/FOB are prorated according to box count.


            Inventory Maintenance.

The user is allowed to display the inventory and change pallet location and memo fields. A ticket may be split into smaller box counts. Once the user has assigned an order to the session, tickets may be assigned or released from the order.


Pallet Upload Maintenance.

This provides upload capabilities from other systems. Pallet data is loaded into a excel file with a csv extension (comma separated values). An example file is available to save on the users system. There are three functions available to the user. Upload – move the csv file from the user system to the web hosting site and add the file name to the Upload Maintenance screen. Edt – The user selects the file for edit and adds to the inventory. If there are no errors, the pallets are added to the inventory. Dlt – Allows the user to remove the uploaded file from the system but the inventory is not changed. Rmv – Removes the uploaded pallets from the inventory and returns the uploaded file to unedited status. User may not remove a file that has shipped or staged pallets, these pallets have to be released from their orders.


            Reset the system.

Because this is a test system the reset will reload the original inventory and un-assign and orders.

In order to test the system with a large inventory there is a Reset Inventory Big. This loads an inventory with a large number of pallets.


The pallet information is free form and doesn’t require species, variety, label or pack tables. Uploading pallet data involves saving a excel spreadsheet of pallet data as a csv file and uploading it into the system. Implementing barcode readers would not be difficult and only require access to a browser and the internet.


The system is written in PHP using MySQL and runs on most system running internet service so there are no expensive “Per seat” license fees.


Additional features to come:

  1. Most anything suggested by my friends and customers
  2. Company specific inventory access.
  3. Create PDF Bill of Lading for shipments.
  4. Control of sorts on inventory drill down. - Done 07/2011



  1. 05/29/2010 added Login by type of user.
  2. 06/02/2010 added the ability to split tickets.
  3. 06/06/2010 added Inventory Select Species Filter.
  4. 06/08/2010 added Order History and Pallet History.
  5. 06/18/2010 added Pallet Upload Maintenance
  6. 04/01/2011 added User Selected Inventory Sort on Drill Down
  7. 07/18/2011 added Invoice Price/Charges Option
  8. 07/18/2011 removed the Inventory Update Verification Display

Return to Inventory System