Tracing Tools for Food Supply Chains

0
2019-02-22 15:15:53
FoodChain-LabBioStockManagerChainPointeQ TraceEcertEmydexTracewiseValueGoiTradeCashmereTraceAllFoodLogiQ ConnnectLINKFRESHi-LiKe PlatformWherefourJustFoodERPFood Traceability by Acctivatefarmsoft post harvestbcFoodWinFDSTrax-IT
General Info
Image
Websitehttps://foodrisklabs.bfr.bund.de/foodchain-lab/http://www.biostockmanager.at/https://www.chainpoint.com/http://www.verifytechnologies.com/food-traceabilityhttp://www.intact-systems.comhttp://www.emydex.com/http://www.tracewise.com/https://www.valuego.it//index_en.jsphttp://www.itradenetwork.com/https://cashmeresystems.comhttps://www.traceall.cahttps://www.foodlogiq.comhttps://www.linkfresh.com/https://www.holonix.it/en/i-like-platform/https://wherefour.comhttp://www.justfooderp.comhttp://www.acctivate.comhttp://www.farmsoft.comhttp://www.bcfooderp.comhttp://www.fooddecisionsoftware.com/http://www.merit-trax.com
Evaluation SourcePublications:
  • https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0151977

Github:
  • https://github.com/SiLeBAT/BfROpenLab
  • https://github.com/SiLeBAT/fcl-client
  • https://github.com/SiLeBAT/fcl-server

Other:
  • Own experience
Websites:
  • http://www.fab4minds.at/ACM/faces/form/cms/web/index.jsp?menu_sid=5054

Other:
  • http://docplayer.org/1701581-Der-biostockmanager-stufenuebergreifende-herkunfts-und-qualitaetssicherungssysteme-herkunftssicherung-in-der-oekologischen-lebensmittelwirtschaft.html
  • EFSA report
Websites:
  • https://www.chainpoint.com/solutions/reportsandanalytics/

Others:
  • https://info.chainpoint.com/download-our-sustainability-impact-whitepaper
  • EFSA report
Capterra::
  • https://www.capterra.com.de/software/123510/eq-trace

Websites:
  • http://www.verifytechnologies.com/food-traceability
Capterra::
  • https://www.capterra.com.de/software/141616/ecert

Websites:
  • http://www.intact-systems.com

Others:
  • EFSA report
Websites:
  • http://www.emydex.com/

Others:
  • EFSA report
Websites:
  • http://www.tracewise.com/

Others:
  • EFSA report
Websites:
  • https://www.valuego.it//index_en.jsp

Others:
  • EFSA report
Capterra:
  • https://www.capterra.com.de/software/81764/itrade


website:
  • http://www.itradenetwork.com/
Capterra:
  • https://wwhttps://www.capterra.com.de/software/162263/cashmere


website:
  • https://cashmeresystems.com
Evaluation of demo version

Capterra:
  • https://www.capterra.com.de/software/144181/traceall


website:
  • https://www.traceall.ca
Capterra:
  • https://www.capterra.com.de/software/81673/foodlogiq


website:
  • https://www.foodlogiq.com
Capterra:
  • https://www.capterra.com.de/software/145448/linkfresh


website:
  • https://www.linkfresh.com/
Websites:
  • https://www.holonix.it/en/i-like-platform/

Others:
  • EFSA report
Capterra::
  • https://www.capterra.com.de/software/172134/wherefour

Websites:
  • https://wherefour.com
Capterra::
  • https://www.capterra.com.de/software/59114/justfooderp

Websites:
  • http://www.justfooderp.com
Capterra::
  • https://www.capterra.com.de/software/94790/acctivate-inventory-software

Websites:
  • http://www.acctivate.com
Capterra:
  • https://www.capterra.com.de/software/154152/farmsoft-post-harvest

Websites:
  • http://www.farmsoft.com
Capterra::
  • https://www.capterra.com.de/software/130612/bcfood

Websites:
  • http://www.bcfooderp.com
Capterra::
  • https://www.capterra.com.de/software/14142/winfds

Websites:
  • http://www.fooddecisionsoftware.com/
Capterra::
  • https://www.capterra.com.de/software/85021/trax-it

Websites:
  • http://www.merit-trax.com
Other Ressources (e.g. video)Video:
  • https://foodrisklabs.bfr.bund.de/wp-content/uploads/2015/02/foodchain_lab_demo.mp4

Flyer:
  • https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/media/Flyer_FoodChain_Druck_v02.pdf

Tutorials:
  • https://foodrisklabs.bfr.bund.de/foodchain-lab-tutorial/
Videos:
  • Image:
    https://vimeo.com/146056791
  • "One step forward" traceability (Sales portal):
    https://vimeo.com/145979376
  • Traceability for all ingredients (Production portal):
    https://vimeo.com/146041631
  • Traceability management (Quality portal):
    https://vimeo.com/146039383
  • “One step backwards” traceability (Purchases portal):
    https://vimeo.com/146039416
Image video:
  • https://youtu.be/iylz1005kZs
explanatory videos
  • https://www.emydex.com/about-us/video/emydex-explained-food-processing-traceability-software/
Brochures, Case Studies, Customer Segments, Product Data Sheets, Whitepaper, Ebook, videos:
http://www.itradenetwork.com/resources/
Recall request video:
https://www.goconsensus.com/app/view/y/9zjjcb4c?autoplay=true

Ebooks, Fact Sheets, Webinars, Demos:
https://www.foodlogiq.com/resources/
Image video
https://youtu.be/e0ES1v0_Q4w

5 min video podcasts:
https://linkfresh.com/en/about/video/
Ressources:
https://wherefour.com/food-resources/
White Papers, Customer Stories, Webinars, Blog Posts, Testimonials:
  • http://www.justfooderp.com/resources/
Image video:
  • https://www.farmsoft.com/fresh-produce-inventory/video.html
Farmsoft Brochure:
  • https://farmsoft.com/farmsoft-fresh-produce-inventory-management.pdf
webinar:
  • https://youtu.be/bX4vFEzFDSw
Screenshots:
  • http://www.fooddecisionsoftware.com/features
Open SourceYesNoNoNoNoNoNoYesNoNoNoNoNoNoNoNoNoNoNoNoNo
Pricingfreeno infono infono infono infono infono infono infono infono infono infono infono infono infoStarter Plan:
  • $169 per month, for solo operators
Producer Plan:
  • $259 per month, for companies with a team
More Info:
  • https://wherefour.com/pricing/
Monthly Cloud Subscription:
  • $300 per month / shared user
One time implementation and services investment:
  • Foundation: $95k
  • Professional: $125k
  • Enterprise: $300k
no infoon requestCost is comprised of the various componentsPurchase Option:
  • Local installation
Subscription Option:
  • SaaS (Software as a Service / on the Cloud)
no info
Target audience
Purpose of the software
  • investigations of food- or feed-borne outbreaks
  • Cross-step origin system
  • quality assurance system
  • having insight into the supply chain
  • complete food business management solutions
  • "Integrity Management Solutions"
  • Audit and certification management
  • traceability and quality management
  • Food processing software
  • Solution for real-time Material Tracking & Tracing
  • Product Quality Management (PQM) of products
  • IoT technology platform
  • integrated system for products traceability
  • support on logistical process from source to consumption
  • greater transparency
  • Supply chain management solutions for the food and beverage industry
  • Food & Beverage ERP Solutions
  • Enterprise resource planning
  • Implement food safety and quality assurance processes
  • Suppliers management
  • Visualise safety and quality issues across the supply chain.
  • Reduce the impact of FSMA and food recalls
  • Address food safety issues when they occur.
  • Enterprise Resource Planning
  • Software solutions for the fresh produce industry
  • Modular solution
  • Product Lifecycle Knowledge
  • Control production
  • Maintain quality and safety
  • Know where everything is at all times
  • Improve food safety of food manufacturers and distributors
  • Streamline operational efficiency
  • Manage business growth
  • QuickBooks Inventory Management Software
  • Agricultural Software for the fresh produce industry
  • Traceability and quality management in the post harvest space
  • ERP Software Designed for the Food Industry
  • Managing Food
  • Enhances Processing, MRP, Inventory, Traceability, Warehousing and Distribution Systems
  • farm to fork traceability solution
Supply chain(s)
  • generally applicable for all supply chains
  • ecological food and feed supply chains, e.g. cereals, milk, spices, vegetables, water, seeds, bakery products
Very broad:
  • food & beverage
  • animal feed
  • agriculture
  • cosmetics
  • minerals
  • pharmaceuticals
  • cotton
  • food
  • food
  • feed
  • Beef
  • Lamb
  • Pork
  • Poultry
  • Fish & Seafood
  • Dairy
  • Fresh Produce
  • Further Processing
  • Cold Storage
  • Vegetables – fresh & frozen
  • Mills
  • Animal food factories
  • Ready meals
  • Eggs
  • Dairy
  • Potatoes
  • Breweries
  • Bottleries
  • Meat industry
  • food
  • beverages
  • food and beverage
  • food and beverage
  • food
  • agriculture
  • food
  • food
  • agriculture
  • Bakeries
  • Chocolate
  • Confectionery
  • Snacks
  • Frozen Foods
  • Prepared Packaged Foods
  • Sauces
  • Dressings
  • Ingredients
  • Flavorings
  • Spices
  • Meat
  • Seafood
  • Poultry
  • Beverages
  • Beer distributors
  • Wine distributors
  • Food importers
  • Seafood distributors
  • Meat distributors
  • Produce distributors
  • Wholesale bakeries
  • Frozen food processors
  • Dairy & cheese process manufacturers
  • Coffee roasters & distributors
  • food
  • food
Target Group
  • Food Safety authorities
  • Feed Safety authorities
  • producer communities
  • brand associations
  • sales organizations
  • coverage: DE, AU, HU, SK, CZ
Very broad:
  • farmers
  • suppliers
  • subcontractors
  • ...
  • Coverage: world
  • large-scale food processors
  • food industry
  • food companies
  • consumer
  • food and beverage manufacturers
  • operators
  • retailers
  • grower-shippers
  • distributors
  • logistics providers
  • Food Manufacturing
  • Food Distribution
  • Food industry
  • Restaurant Operators
  • Food Retail and Grocery
  • Food Distributors
  • Food Importers
  • Grower, Packer, Shippers
  • Fresh produce industry (growers, packers, shippers.)
  • Food
  • Beverage
  • Natural Product Manufacturing
  • food industry
  • food manufacturers
  • food distributors
  • Beverage and food distributors
  • solutions for many other idustries
  • Medium to large fruit and vegetable producers
  • Packers
  • Wholesalers
  • growers
  • processors
  • manufacturers
  • packers
  • shippers
  • distributors
  • brokers
  • retailers
  • food distributors
  • food manufacturers
  • producers
  • slaughterhouses
  • packers
  • processors
  • retailers
Supported languages
  • English
  • German
  • Spanish
  • Hungarian
  • English
  • Russian
  • Mandarin
  • many more...
  • English
  • English
  • English
  • English
  • English
Usersapprox 500> 100
  • Installations: >30
  • Users: 40000
customer selection:
  • https://www.intact-systems.com/customers/
Client list:
  • https://www.emydex.com/customers/
  • Barilla Special Edition to Expo2015 in Future Food District – Milan 2015
more than 5,000 customers:
http://www.itradenetwork.com/customers/
List of some customers:
https://www.foodlogiq.com/customers/
  • https://wherefour.com/#a (scroll down)
  • http://www.justfooderp.com/ (scroll down)
  • thousands of users in over 14 countries
http://www.bcfooderp.com/our-clients/
  • Customers across North America
Platform
Web / Cloud basedYesYesYesYesYesNoNoYes java, jsp, mysql, html, owl, Mondrian, Google charts and/or high chartsYesYesYesYesYes Web portalYesYesYes Microsoft DynamicsYesYesYes Microsoft DynamicsYes
Mobile AppNoYesYesYesYesNoNoYesYes MobileYes iPad, desktop, phoneYes Android or iPhone Add-onYes Mobile devicesYes Mobile devicesYesYesYesNoYesYesNo
Desktop / InstalledYes Windows / Linux / MacOSNoNoNoNoYes win .Net, SQL ServerYesNoNoNoYes WindowsNoYes Certified for Microsoft DynamicsYesNoNoNoYesNoYes
Features
Data collection / exchange interfaces / assurance of quality
  • Excel templates with well-defined structure (https://foodrisklabs.bfr.bund.de/templatebacktracing/)
  • xsd structure
  • JSON schema
  • many interfaces, not yet with FCL
  • many formats, e.g. xls, csv, xml, JSON, web services

  • different plausibility checks, e.g. mass balance
  • manual data entry via a web browser or app
  • xls
  • csv
  • xml
  • web services
  • well-defined API
  • SingleSignOn
  • SAP

  • different plausibility checks, e.g. mass balance
  • eliminates duplicate data entry
  • link with bar code scanners
  • link with bar code label printers
  • recording of the traceability and HACCP quality data (one step backward)
  • automatic linkage of supplier lot and trace codes to purchase order number
  • API
  • Data upload through web forms
  • excel upload features and interfaces
  • standard GS1 conform interfaces
  • generated ITN numbers (Internal Traceability Numbers)
  • barcoded labels and handheld scanning terminals
  • Backward and forward traceability along the supply chain
  • Traceability in the intermediary steps of the supply chain (e.g. storage, logistic)
  • Backend database structure containing 100s of tables
  • Tracing the path of raw materials, half-finished products or sell units through the intermediate process stages
  • Data exchange through standard OPC protocol
  • Bi-directional data exchange: capturing of real-time data or control of production steps based on live data
  • XML
  • Microsoft Excel
  • SQL
  • Data collection from different sources along the whole supply chain
  • Manual data entering
  • Data upload from on-field sensors
  • Heterogeneous data sources: files of any format and nature
  • Interaction with devices/sensors in a typical IoT ecosystem.
  • domain ontology
Data collection:
  • Trading partners can automatically append key data elements to orders or shipping notifications
    • GTIN
    • Lot no.
    • COOL codes
    • manufacture and expiration dates
    • buyer and supplier item codes
    • logistical data
    • RPC data
    • nutritional data
    • pallet information
  • Real-time manufacturing information
Stepwise data collection / backward, forward:
  • trace from final product to purchase orders
  • trace from purchased item to finished products, work orders, inventory items.
Stepwise data collection / backward, forward:
  • Export of trace back / forward is possible in the report section as
    • PDF
    • Word
    • Excel

  • CSV import
    • customers
    • suppliers
    • locations (meaning warehouse, cooling room, production area, receiving area)

Data quality:
  • Catalogues for data elements: Received goods, inventory, order, items, suppliers, recipes, products, packing plans, customers, units of measurement, reasons for not using ingredients
  • Internal validity checks:
    • Inspection of received goods: date, truck door seal, odor, harmful material, intact load, refrigeration, trailer temperature
    • Ingredients: Check for shelf life in product plan
    • Inventory: Verified that product arrived at location (e.g. warehouse); material release, product release, release history
    • Several amount checks and plausibility checks in the setup of new product / new batch
  • Helping functions for data input: Catalogues, drop-down menus
Internal validity checks:
  • Date picker
Helping functions for data input:
  • Templates for communication, withdrawal of products
Exchange interface:
  • API
Manufacturing characteristics:
  • throughput
  • process rate management
  • status per line
Product characteristics:
  • Name
  • ID/Barcode
Lot characteristics:
  • Lot no
Data quality:
  • Validation and error handling
  • automated electronic data interchange processing
  • traffic light colour scheme (RAG rating)
Catalogues for data elements:
  • Product type
  • date
  • reason for new data entry (e.g. production)
Helping functions for data input:
  • Dropdown lists
  • Management of the entire product lifecycle
  • print barcode labels
  • download report as an Excel file
  • ad hoc distributed queries
  • API library for creation of connected apps in JustFood
  • Tracking of serial numbers and lot numbers using barcode technology and software.
  • Optional support for barcoded products
  • Recognition of lot numbers when received, shipped or both
  • Mobile device receiving and picking with product code and lot number scanning
  • Recording and management of expiration dates by lot number
  • Handling multiple lots of the same ingredients
  • Storage of product metrics such as weight, height, length and volume
  • Maximum batch based traceability by scanning or selecting inventory when added to batches
  • Instant tracking of all produce to the customer, transport company, dispatch documentation
  • QR code labels, EAN 128 , GS1, PTI, Tesco, Walmart, Woolworths, Coles, Aldi, Pick N Save, Loblaw, La Martina compliant labels
  • API for custom reporting or financial integration:
    • https://www.farmsoft.com/fresh-produce-inventory/api.html
    • https://www.farmsoft.com/doc/api.pdf
  • True relational data model
  • Related data always linked to the relevant records and available at the click of a mouse
  • Lot tracking: quick identification of a customer in a recall situation
    http://www.fooddecisionsoftware.com/features#Lot_Tracking
  • Food Recall template, request at:
    http://www.fooddecisionsoftware.com/food_recall
  • Description of "Recall Plan Templates":
    http://www.fooddecisionsoftware.com/recall_plan
Slaughterhouse data:
  • http://merit-trax.com/slaughterhouse-software-systems/
Food Processing data:
  • http://merit-trax.com/food-processing-software/
Meat processing data:
  • http://merit-trax.com/slaughterhouse-software-systems/
Food Distribution & Warehouse data:
  • http://merit-trax.com/trax-it-food-distribution-and-warehousing/
Data analytics (e.g. in terms of outbreak investigation)
  • Simulations of hypotheses
  • Tracing-Score for detecting nodes in the network having high probability being part of the outbreak
  • fabTracer: tool for searching and visualizing supply chains (visio like)
  • ChainPoint Analytics - typical data analytics, not specialized for outbreak investigations
  • On-time analysis: real-time monitoring
  • Include your own database queries
Analysis method of the connections and complexity (e.g. hot spots) of the food supply chain:
  • Report: Supplier, ingredients, product, customer
  • Production plan: Ingredients in stock, BBD
Possibility for on-time analysis:
  • All available for tracing back and forward
  • Report possible at any time
  • Analysis method of the connections and complexity (e.g. hot spots) of the food supply chain: Data from Restaurant Operators, Food Retail and Grocery, Consumer Packaged Goods, Food Distributors, Food Importers, Grower, Packer, Shippers are all connected.
  • Possibility for on-time analysis: yes
Possibility for on-time analysis: yes
  • Traceability of input raw materials and components
  • Traceability of outputs
  • Timing analysis of the material flow
  • On-time analysis
  • Analytics for JustFood: isolate, calculate and track the business metrics
  • Convenient and powerful lookup of specific lot number by product or by customer
  • Handling of variations in input recipe to allow for substitute items and changes in quantities
  • Online real-time data throughout the system
  • SQL-based business intelligence
Data visualizations / Reporting
  • Visualization of Delivery Networks (https://foodrisklabs.bfr.bund.de/en_tracing/)
  • Temporal and spatial flow of material
  • various graph layout algorithms
  • GIS (https://foodrisklabs.bfr.bund.de/geo-visualization-in-foodchain-lab/)
  • reports (Crystal reports)
  • realtime batch tracing
  • B2B interfaces
  • visio style for supply chains
  • export into e.g. pdf, rtf, xls, csv
  • SQL Server Reporting Services (SSRS)
  • Tableau
  • Maps
  • Graphs
  • Charts
  • Tables and flow charts
  • tables
  • graphical network view of supply chain
  • backwards, forwards and mass balance traceability reporting from factory door to door
  • graphical representation of real-time traceability reporting
  • Personalization of reports
  • Lot genealogy shows lot history through process flow (tree-like structure)
  • Customised MS Office reporting
  • Design & print your personal quality reports
  • Export to Excel, HTML, XML and ASCII
  • Creation of charts
  • Workflow Wizard to define the flow of any product within a food production chain
  • web-based GUI
  • Reporting and Business Intelligence capabilities: Mondrian, open source Online Analytical Processing server (OLAP)
Traceability from the Field all the Way to the Consumer:
  • Real-time analytics

http://www.itradenetwork.com/wp-content/uploads/2017/01/iTrade-Item.pdf
  • Data is presented as tables.
  • Suppliers, ingredients, products and customers are shown in the report.
  • Food chain shown in the graphical interface: Graph with symbols for types of business
  • Physical material flow shown in the graphical interface: Map with suppliers
  • Video:
    https://www.goconsensus.com/app/view/y/jx8jf3p2?autoplay=true
  • Jet Global Business Analytics
  • Microsoft Excel dashboard
  • Live reporting
  • tables
  • reports
  • Analytics for JustFood: distills data into meaningful real-time visualizations
  • pre-built reports, visualizations, templates and data elements
  • customize report layouts in other Microsoft products
  • access reports from any device (laptop, tablet, smartphone)
  • generate reports from any module
  • Storage of a photo or image of each product
  • Printing of lot numbers, expiration date and catch weights on invoices
  • Searching and reporting: Manage, view and report on source, expiration date, lot, inspection and quarantine information and comply with regulatory requirements.
  • Reporting by any date span
Tracing
Meaning of tracing
  • Lot-based and company internal tracing of all supply chains possible in order to be able to reconstruct whole delivery networks
  • Lot-based tracing of the whole supply chain seemingly possible
  • tracing possible up to arbitrarily small granularity
  • intra company tracing possible
  • tracing possible up to arbitrarily small granularity
  • one step forward and one step back food traceability
Levels of traceability:
  • Supply Chain Monitoring
  • Volume based mass balancing
  • Batch traceability

Backward and forward traceability:
  • all along the supply chain from raw material to finish
  • 100% Traceability reporting from factory door to door
  • integrated, real-time product traceability (forward and backward)
  • quality management in discrete, batch and continuous process environments
Data gathering along different stages of the supply chain:
  • in the exact places of origin
  • production
  • conversion
  • storage
  • delivery
  • “One step forward, one step back” traceability enables trading partners to communicate product attributes across the supply chain
  • Fresh Food:
    iTrade Item gives consumers the possibility to link the first and last mile of the supply chain by mobile or web look-up from any device
    http://www.itradenetwork.com/wp-content/uploads/2017/01/iTrade-Item.pdf
  • iTrade PTI: helps to identify, capture and share the GS1® data. iTrade PTI is a series of solutions centered on the three components of a true, GS1® compliant, traceability system
    http://www.itradenetwork.com/wp-content/uploads/2017/01/iTradeNetwork_PTI.pdf
  • Efficient traceability of products in the event of a recall
  • Knowing for any item on a sales order, what purchase orders it connects to
  • One step forward and one step backward
  • Trace by supplier receipt (date, P.O., truck ID, shipping manifest number, supplier product ID), best before date, product name, production date, lot number, inventory status, customer
Track + Trace
Real-time tracking of products at the lot level
  • Full track forward and trace back capability
  • Ability to record or create Global Trade Identification Number (GTIN) references and traceability throughout the supply chain.
  • Complete traceability of products (by single item, product category, lot, etc.)
  • Enforce lot numbers across all of your inventory items
  • Maintains each lot number throughout the production process
  • Tracks user who did the transaction, the date and time
  • bidirectional traceability: account for the raw materials through the production process to finished product
  • Tracking of serial numbers and lot numbers
General:
  • Tracking both up and down the supply chain, directly to specific application areas, suppliers of specific batches/lots of inventory

'Always on' traceability:
  • capturing of traceablity details at the earliest possible point in the supply chain
  • no redundancy
  • permanant preservation
  • identification using many recall factors.
  • Lot traceability
  • Support with potential product recalls
  • Support with tracking product expiry dates
  • Recognized among the leaders within the field of food processing and value chain traceability.
  • Offering expertise for food traceability systems through software and consultants.
Step back and forward (e.g. EU 178/2002, FSMA etc.)Yes EU 178/2002Yes EU 178/2002Yes EU 178/2002Yes EU 178/2002, FSMA, SFCAYes EU 178/2002Yes EU 178/2002Yes EU 178/2002Yes EU 178/2002YesYes FSMAYes SFCA, FSMAYes FSMANoNoYes FSMAYes FSMANoNoNoYes FSMA, SFCA
Other
Features interesting for FCL
  • Establishment of interfaces between both tools
  • Central Dashboard
  • data collection pipeline with notifications and option to reject and correct!
  • Dashboard
  • chat function between data collectors
  • interface to API
  • SingleSignOn
  • interface to SAP
  • camera, location sensor and barcode scanner
  • read barcode labels
  • API
  • GS1 conform interfaces
  • Backend database structure
  • Creation of charts
  • Mobile dashboard
  • Farm-to-fork traceability
  • trace from ingredient or from final product
  • Trace from ingredient or from final product or from customer
  • Central Dashboard
  • Barcode scanner
  • API
  • Real-time visualisation of supply chains with graph containing symbols for types of business
  • Blockchain traceability https://blog.linkfresh.com/linkfresh-and-blockchain-traceability
  • read barcode labels
  • download reports as Excel file
  • API
  • Barcode reading
  • Multiple lots of the same ingredients
  • farm to fork
  • Report by any date span
Comments
  • Website "not secure" error - certificate not up to date
  • data collection established with automatic information system (SMS, email)
  • data collection established with approval options for the step forward or backward
STOP here! No further - yet
Description
  • tracking lot codes of each product shipped to each customers
  • management of production on a batch (lot code) basis
  • management of ingredient traceability data
  • transactions can track to serial numbers within an individual batch code
  • communication between stakeholders of the entire food and feed supply chain: between farmers and factories, and factories and cold stores or factories and supermarkets via webforms or web-services
FBO characteristics: Inventory, demand planning
Station characteristics: Inventory, demand planning, cost control, CRM, traceability; EDI integration, label printing, scanning integrations
Product characteristics: Inventory: Food / beverage name, category, description, weight, expiration date; raw materials, sub-assembly, finished goods
  • Spatial resolution: All locations are recorded. Example data set contains all locations in one Building.
  • Temporal resolution: No times
  • Transformations / Processing steps: Stored recipes describe changes in food composition, food texture and mixing verbally, but there is no split into sub-foods like raw milk -> skim milk + cream.
  • FBO characteristics: Contains food process chain, items (food, packing material), recipes, products, suppliers, customers, storage
  • Station characteristics: Company name, address, phone, email, website, company-specific prefixes for material, product, recipe, pallet; federal number, license number, province number, location/premise ID
  • Product characteristics: Food and packing items: Special instructions, shelf life; organic, non-GMO, fair trade, kosher; allergens; supplier, recipes; Std. Cost Products: ID, description, type, quantity, shelf life, GTIN code; production area; lot no
  • Lot characteristics: Lot no, product name, date, batch
  • Surrogate information for missing entries: Minimal information for food: Name, best before date; name can be anything
  • No sampling results recorded
  • No vague information or probabilistic tracing
  • Catalogues for data elements: Received goods, inventory, order, items, suppliers, recipes, products, packing plans, customers, units of measurement, reasons for not using ingredients
  • Internal validity checks:
    • Inspection of received goods: Date, truck door seal, odor, harmful material?, intact load, refrigeration, trailer temperature; accepted/rejected Ingredients: Check for shelf life in product plan
    • Inventory: Verified that product arrived at location (e.g. warehouse) Material release, product release, release history Several amount checks and plausibility checks in the setup of new product / new batch
    • Not checked whether string or integer or date column -> all free text
  • Helping functions for data input: Catalogues, drop-down menus
  • Specific for Critical Traceability Points: Inventory\Cycle count: Location in the company with container IDs
  • Distinction of mandatory, recommended and voluntary information: Mandatory for new items: Name, shelf life
  • Central data management
  • Data ownership: Roles with access and editing rights are defined.


Complete Traceability Reporting
  • Trace by Suppler Receipt (Date, P.O., truck ID, Shipping manifest number)
  • Trace by Supplier product ID, Lot Number, Best Before Date
  • Trace by Production date, Lot number produced
  • Trace by Inventory Status
  • Trace by Customer sold to, Picked, Delivered
  • Supports mock recall procedures and provides complete customer and suppler contact details

Inventory Management
  • Raw Material, Work In Progress and Finished Goods Inventory Management
  • Label Inventory Items with custom printed, unique labels or use supplier provided identification
  • Inventory status (On Hand, Held, Scraped, Consumed)
  • ERP functions for where used, how many products can be produced based on inventory, etc.

Application Security:
  • User Names and Passwords - define all users of the system
  • Customizable Roles and Permissions assignable by user, group or custom
  • Limits all pages and functions based on permissions - Not available, View Only, Add/Edit/Delete
  • Tracks important activities by user - Know who and when a recipe was changed, etc.

Warehouse Storage Tracking:
  • Define unlimited, customizable warehouse storage locations
  • Put away, locate and pick warehouse, inventory buy location
  • Re-useable or custom Container (Pallet, Skid, Bin)identification labels
  • Receive raw materials to staging area and then put-away functions, or direct put-away
  • First In/First Out automatic ingredients Pick Lists

Recipe Definitions:
  • Allergens definitions (85 known Allergens pre-defined and totally customizable)
  • Ingredient allergens identification
  • Non-GMO, Organic designations (By Ingredient - Recipe definition automatic based on Ingredients)
  • Know quantity production (Produce a batch of product) runs
  • Continuous Production (Automated packaging line) runs
  • Optional forced batch weights by product
  • Track Ingredients Backward
  • Trace Products Produced Forward
  • Global Standards
  • Enterprise resource planning (ERP) Functions
  • Low cost of ownership with purchase or monthly subscription options available
  • Centralized, secured database storage of all information
  • Unlimited:
    • Ingredients
    • Suppliers
    • Recipes
    • Products
    • Customers
    • Users
    • Installed clients
    • Mobile Devices
  • FBO characteristics: Name, ID, GLN, address, Category (type of business), contact person
  • Station characteristics: Manage regulations, customer demands
  • Product characteristics: batch, lot no, date, destination, source location, quantity, withdrawal y/n, use-by date, number of withdrawn units
  • Lot characteristics: batch, lot no, date, destination, source location, quantity, withdrawal y/n
  • Total Traceability
  • Real-time data
  • Production and Inventory Management
  • Barcoding
  • Quality Control
  • Consignment / Grower Accounting
  • Pooling
  • Farming
  • Automatic and Promo Pricing
  • Case, Lot, Pallet Tracking
  • Mobile Warehouse Management
  • Inventory Control
  • Analytics and Reporting
  • Innovative Mobile and Touchscreen Technologies
  • Station characteristics: place of production in company
  • Product characteristics: Name, code, place of production in company, lot, amount, date of production, rejection reason
  • Lot characteristics: Name, code, place of production in company, lot, amount, date of production, rejection reason
  • Specific for Critical Traceability Points: Management of the different stages of production processes. Via the production data sheet’s management, raw materials and components can be tracked, the use of resources can be monitored in real-time and operators are supported in the sequence of activities to be carried out.
  • Lot tracking: Lot, description, barcode, vendor, location, expiration, lot cost, on hand, unit cost, status
  • Complete lot number tracking – from raw materials through finished goods
  • Pack products into different sizes or containers and generate lot codes through that process.
  • Produce reports for a single inventory item from the originating vendor to all end-user customers – even through the manufacturing process
  • See what lots and quantities were shipped to customers for a date range.
  • what suppliers gave which ingredients, which lots they went into and which customers received them
  • shipping: automatically put lot codes on orders and invoices => you always know exactly which lots and quantities went to which customers
  • complete forward, backward or bi-directional trace report
  • Recipes, grouped formulas: Creation of complex, multi-step production processes that model the same way the products are produced in the real world
  • bi-directional ingredient and product traceability and recall
  • various trace methods, e.g. Origin -> Usage
  • Item tracing characteristics: Lot no, description, serial no, item no, item description, location code, quantity, remaining quantity, already traced
  • expiration date management (FEFO)
  • lot tracking
  • serial tracking
  • experiment with new formulas and ingredient amounts
  • compare current recipes and processes with new combinations
  • serial number: unique number assigned to identify a specific item.
  • lot number: identification number assigned to products indicating the batch or lot in which the product was manufactured or processed.
  • lot numbers traceability
  • purchasing information for each product including published price, last price, lead time and purchase history for any number of vendors
  • Support variable yield
  • Account for spillage and waste
  • Substitute ingredients in recipes
System CategoryTracing software supporting foodborne disease outbreak investigationsGlobal provider of supply chain management solutions for the food and beverage industryFood & Beverage ERP Solutions
Company nameGerman Federal Institute for Risk AssessmentiTrade network Inc.Cashmere Systems LLC
Company addressMax-Dohrn-Str. 8-10
10589 Berlin
Germany
Corporate Headquarters
4160 Dublin Blvd., Suite 300
Dublin, CA 94568
PO BOX 629
Ian McManus
SANTA BARBARA, CA 93102
USA
Tracing capabilities
  • Building a food chain from farm to fork; start at any position in the food chain and follow ingredients / products stepwise from food producers to cases of foodborne disease outbreaks (forward tracing) and back via ingredients to primary producers. The traceability of food, feed, food-producing animals, and any other substance intended to be, or expected to be, incorporated into a food or feed shall be established at all stages of production, processing and distribution.
  • Food and feed business operators shall be able to identify any person from whom they have been supplied with a food, a feed, a food-producing animal, or any substance intended to be, or expected to be, incorporated into a food or feed. To this end, such operators shall have in place systems and procedures which allow for this information to be made available to the competent authorities on demand.
  • Food and feed business operators shall have in place systems and procedures to identify the other businesses to which their products have been supplied. This information shall be made available to the competent authorities on demand.
  • Lot characteristics: Lot number, product name, delivery, BBD
  • iTrade offers the only Traceability solutions with full supply chain trace-forward and trace-back
  • iTrade’s automated, closed-loop Ship & Trace solution provides “one step forward, one step back” traceability, enabling trading partners to communicate product attributes across the supply chain. Persisting PTI Key Data Elements (KDEs) in association with order history aids in protecting consumers in the event of potential future food safety recalls and protects your brand from associated exposure.
  • iTrade has incorporated critical workflow logic and data elements to enable comprehensive supply chain visibility with the goal of simplifying traceability to make it more efficient and cost effective for all trading partners. With iTrade’s Ship & Trace solution, all trading partners, regardless of commodity, system constraints, size and technical capabilities can automatically append PTI KDEs to POs or ASNs, including GTIN, Lot #s, COOL codes, manufacture and expiration dates, buyer and supplier item codes, logistical data, RPC data, nutritional data and pallet information. Your traceability data is linked to iTrade’s Order Management System, creating a tightly integrated system with a single source of data. After shipments are received, all PTI data is persisted throughout the payment and invoice process, allowing trading partners to perform USDA COOL audits by searching within iTrade’s Order Management System.

Product data sheet "Traceability from the Field All the Way to the Consumer": http://www.itradenetwork.com/wp-content/uploads/2017/01/iTrade-Item.pdf

Product Sheet "Transportation Management": http://www.itradenetwork.com/wp-content/uploads/2015/09/iTrade_Transportation_Management.pdf

Typical EDI workflow with iTrade: http://www.itradenetwork.com/wp-content/uploads/2018/07/EDI-Overview.pdf

For recalls, quality control, and customer satisfaction, traceability is a must>

  • Cashmere Systems has made traceability simple, affordable and accessible by small and large companies alike.
  • Our system streamlines business processes, improves traceability, and speeds up inspections.
  • Whether you deliver to retail or restaurants, tracking back to the farm, to delivery is important to get to the cause of quality issues.
Modules / Functionalities
  • Data Collection
  • Data Management
  • Data Validation / Enrichment
  • Visualization of Food Delivery Networks
  • User defined Simulations
  • Geographical analysis

Data Structure:
  • Arbitrarily granular according to data source
  • Spatial mapping within one station
  • Temporal mapping daily
  • Completeness according to EFSA 2016 (DEMOS)
  • FBO: Supplier, receiver, delivery, dates, amount
  • Station: address, type of business
  • Activities: delivery2delivery
  • Lot number, product name, delivery, BBD
  • Deterministic score
  • Plausibility checks: Search for up duplicates

Analytical functions:
  • Reconstruction of the food supply chain
  • Evaluation of connections: Scoring
  • Temporal flow of material
  • Development of product weights
  • Deterministic evaluation of contamination
  • Reduction of the supply chain to relevant parts with metaknodes
  • Geocoding
  • Geographical clustering with GIS Cluster
  • Simulations based on cross contamination

Interface
  • Visualization of the food delivery network: GIS, various graph layout algorithms
  • Data excahnge formats: XML, JSON, Knime Workflox

End-to-End Supply-Chain Solutions

  • Analytics
  • Quality
  • Traceability
  • Data Services
  • Planning
  • Contracts
  • Procurement
  • Logistics
  • Inventory
  • Purchasing
  • Traceability

FBO characteristics: Inventory, demand planning

Station characteristics: Inventory, demand planning, cost control, CRM, traceability; EDI integration, label printing, scanning integrations

Product characteristics: Inventory: Food / beverage name, category, description, weight, expiration date; raw materials, sub-assembly, finished goods

Stepwise data collection / backward, forward: With our tracing reporting tool you can trace starting with a final product down to the purchase orders, and from the purchased item to all of the finished products, work orders, and inventory items.

test criteria
FCL Certificate1
FCL Certificate2
Embed
  • 2018-10-22 22:35:17
    2019-02-22 15:15:53
  • English
  • Unlisted
  • Creative Commons License CC-BY-SA 3.0 / GNU FDL
    Manage backups

Comments

No comments yet. Be the first to give your opinion.

Leave a comment

Build comparison tables or lists about everything !

It's free and fast to publish data into original tables

Create a table