Jump to content

  • Quick Navigation

Can anyone recommend a good system for batch coding?

Share this

  • You cannot start a new topic
  • Please log in to reply
4 replies to this topic


    Grade - Active

  • IFSQN Active
  • 5 posts
  • 0 thanks

  • United States
    United States

Posted 17 January 2019 - 12:23 PM

We have a very fast paced cookie company and I am just starting to embark on the SQF journey.  I hired someone to help write the code for the desk audit but after that what do I need to do to move forward...to stay in compliance?


Also, as far as documentation....I am having a very hard time figuring out batch coding.  Can anyone recommend a good system I can put in place?  Thank you for youe help



  • IFSQN Fellow
  • 5,566 posts
  • 1527 thanks

  • Canada
  • Gender:Not Telling

Posted 17 January 2019 - 01:51 PM

The most straightforward way is to 


A) make up a product code for EACH finished good


B) Code each unit of finished product with that code + plus the date of production.


So you could mark your production sheets with a product code like


CC1 (chocolate chip 1 ounce)071719 (today's date)


That way you have ALL the ingredients that went into that batch on 1 piece of paper. Then sales would also need to use the same coding when product is sold. Now you have traceability from ingredient to your consumer.


There is some fantastic software out there where ingredients and finished goods (any rework if you have any) get scanned in and out to simplify things for you.


The batch code just needs to be an identifier that separates it from all other batches

Please stop referring to me as Sir/sirs


    Grade - AIFSQN

  • IFSQN Associate
  • 27 posts
  • 6 thanks

  • United States
    United States

Posted 17 January 2019 - 03:16 PM

Do you have any software systems in place that could integrate lot tracking and work orders? If not I'd suggest starting a spreadsheet to track both raw and finished goods with lot numbers from receiving/creation date out to an end date or ship date. Another option would be a Julian date (19017). Also consider an extra prefix in case you have a mixed lot so 19017A could represent product made today that contained sugar lot A and 19017B contains sugar lot B. If you run multiple shifts you could reflect that as well.



  • IFSQN Fellow
  • 4,701 posts
  • 1149 thanks

  • United States
    United States
  • Gender:Male
  • Interests:Just when I thought I was out - They pulled me back in!!!

Posted 18 January 2019 - 02:25 AM

I am bias, but I would recommend you have a consultant visit to do a full gap/compliance consulting audit.


As to the other question - take a look at www.focus-works.com  makers of the SQF Sentinel system and systems for the baking industry and others.

All the Best,


All Rights Reserved,

Without Prejudice,

Glenn Oster.

Glenn Oster Consulting, LLC -

SQF System Development | Internal Auditor Training | eConsultant

Martha's Vineyard Island, MA - Restored Republic





    Grade - FIFSQN

  • IFSQN Fellow
  • 4,264 posts
  • 1305 thanks

  • United Kingdom
    United Kingdom
  • Gender:Male
  • Location:World
  • Interests:My main interests are sports particularly football, pool, scuba diving, skiing and ten pin bowling.

Posted 18 January 2019 - 04:02 AM

Hi cookielady3,


I find this simple system works quite well:


Attached File  Batch Traceability.png   486.8KB   1 downloads


Finished product would be identified by batch code and best before date.


Kind regards,



Share this

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users