lotus labs
Reinventing the workflow of grocery giant
C&S Wholesale Grocers, LLC is a leading player in the U.S. grocery supply chain industry, providing wholesale grocery distribution services. Founded in 1918, the company supplies over 7,500 independent supermarkets, chain stores, military bases, and institutions with more than 100,000 different products. C&S operates on a large scale, servicing various retail formats, including corporate grocery stores and independent franchisees across the Midwest, South, and Northeast.
C&S's operations are extensive and multifaceted. The company focuses on wholesale procurement, category management, pricing, private brands, marketing, advertising, merchandising, business and accounting, and store design and engineering. This comprehensive approach allows C&S to support a wide range of retail partners and ensure efficient supply chain solutions.
Lotus Labs partnered with C&S Wholesale Grocers (CSWG) to develop innovative products that streamline and enhance operational efficiency. The resulting products, CS Connect and GS Connect, have significantly transformed how CSWG manages orders, deliveries, returns, and reporting, boosting productivity and user satisfaction across various levels of the company.
The Challenge
Due to the scale of operations CSWG were sitting on a goldmine of data. However this data needed to be managed and streamlined to be useful. The existing tools and methods were traditional and a lot of effort was required in managing the extensive communication and operational processes required to fulfil orders, manage deliveries and returns, and generate accurate reports. CSWG approached LotusLabs to come up with solutions to streamline the entire process.
Understanding the Problem
Understanding the core issues were cardinal to providing feasible solutions and therefore the process started with analysing the issues that were being faced. Lotus Labs started with laying out the entire map of the operations and looked into various verticals and their specific issues. Research was conducted by interviewing users across different hierarchies and use cases. The insights received from the initial research formed the foundation of designing the solution scenarios.
Some of the core insights can be highlighted as,
Solution
To address these challenges, Lotus Labs developed two tailored products: CS Connect and GS Connect. These products were designed to integrate seamlessly with CSWG’s existing infrastructure, providing a comprehensive solution to streamline operations.
CS and GS Connect
CS Connect's dashboard offers an exceptional vantage point for users, providing immediate access to upcoming events and company advancements. It features vital statistics such as delivery status, open orders, recent invoices, billing data, and quick links to various reports, offers, and services.
Key Features:
Dashboard : Central hub for real-time updates, important stats, billing data, and report access, enhancing user productivity and awareness.
Financials : Provides detailed insights into invoices, payments, returns, credits, billing information, and statements, streamlining financial processes with dynamic lists.
Orders : Dedicated section for creating and tracking orders, managing payments, deliveries, returns, and mishaps, facilitating efficient order management.
Retail Section : Enables CSWG to visualize product pricing, make informed business decisions, and manage millions of products regarding retail prices, profits, offers, and discounts.
Reports : Generates detailed charts and reports, crucial for documenting and streamlining the logistics process.
Additional Features : Includes product search, tools, food shows, bulletins, and trade shows, tailored for both CS and GS Connect to boost productivity and promote offers.
CS Connect Home Page
GS Connect Homepage
Technical Insights and Upgrades
Database migration to improve efficiency:
CS Connect and GS Connect systems leverage an Oracle database and involve data integration from Excel production. To manage data more efficiently, the team migrated to PostGreSQL, which offers faster database activities.This switch facilitated better synchronization between the mainframe and PostGres databases, which are reflected to the user in the front-end
Advanced Analytical Solutions:
Analytical Solutions offer comprehensive insights into inventory management, sales trends, and customer behavior. By leveraging data analytics, we optimize stock levels, reduce excess inventory, and enhance demand forecasting accuracy. Additionally, our solutions enable personalized marketing strategies, improving customer engagement and driving higher sales conversion rates. With real-time reporting and predictive analytics, the client can make informed decisions, streamline operations, and achieve significant cost savings.Our Computer Vision and NLP capabilities provide solutions for future use cases to automate data entry,customized automated stock counting and customized Chatbots.
Product Usage and Technology Transition:
Both CS Connect and GS Connect use the same backend service but have distinct front-end features. There are plans to merge these into a unified system in the future, further simplifying the technology landscape for users. This transition from "My Store" to the customer portal has been pivotal in enhancing user experience.
Report Generation Improvements:
Transitioning the reporting system to the Customer Portal for GS Connect addressed previous issues with the outdated technology, which was slow and lacked filtering capabilities. The new system supports more efficient report generation, with enhanced filters and customizable report dates, significantly improving accessibility and productivity.
Microservices and AI Integration:
Utilizing microservices has prevented system interference and issues that typically arise with monolithic systems. Although AI and machine learning have not yet been integrated, there are plans to explore these technologies to further enhance functionality and user interface.
User Interface and Database Upgrades:
Recent upgrades to the database and user interface have improved speed and visual appeal, simplifying the process of updating product prices and details. The new price association groups feature allows simultaneous updates to products within the same group, greatly improving efficiency.
Impact
Since the deployment of CS Connect and GS Connect, CSWG has experienced remarkable improvements in operational efficiency and user satisfaction:
Increased Productivity: Automation of routine tasks and streamlined processes have significantly reduced manual effort, allowing employees to focus on higher-value activities.
Improved Accuracy: Enhanced tracking and reporting capabilities have reduced errors and discrepancies in orders and deliveries.
User Satisfaction: The intuitive interfaces and comprehensive training provided by Lotus Labs have led to high user adoption and satisfaction rates across all levels of the organisation.
Contribution of Lotus Labs
The success of CS Connect and GS Connect is a testament to the expertise and dedication of the Lotus Labs team. Developing a customised product that meets the specific needs of CSWG, ensuring seamless integration and optimal performance. Also providing continuous support and updates to ensure the software remains effective and up-to-date with evolving business needs. And finally working closely with CSWG to understand their challenges and goals, resulting in solutions that deliver tangible benefits.
lotus labs
© 2026 LOTUSLABS All rights reserved.
Reinventing the workflow of grocery giant
C&S Wholesale Grocers, LLC is a leading player in the U.S. grocery supply chain industry, providing wholesale grocery distribution services. Founded in 1918, the company supplies over 7,500 independent supermarkets, chain stores, military bases, and institutions with more than 100,000 different products. C&S operates on a large scale, servicing various retail formats, including corporate grocery stores and independent franchisees across the Midwest, South, and Northeast.
C&S's operations are extensive and multifaceted. The company focuses on wholesale procurement, category management, pricing, private brands, marketing, advertising, merchandising, business and accounting, and store design and engineering. This comprehensive approach allows C&S to support a wide range of retail partners and ensure efficient supply chain solutions.
Lotus Labs partnered with C&S Wholesale Grocers (CSWG) to develop innovative products that streamline and enhance operational efficiency. The resulting products, CS Connect and GS Connect, have significantly transformed how CSWG manages orders, deliveries, returns, and reporting, boosting productivity and user satisfaction across various levels of the company.
The Challenge
Due to the scale of operations CSWG were sitting on a goldmine of data. However this data needed to be managed and streamlined to be useful. The existing tools and methods were traditional and a lot of effort was required in managing the extensive communication and operational processes required to fulfil orders, manage deliveries and returns, and generate accurate reports. CSWG approached LotusLabs to come up with solutions to streamline the entire process.
Understanding the Problem
Understanding the core issues were cardinal to providing feasible solutions and therefore the process started with analysing the issues that were being faced. Lotus Labs started with laying out the entire map of the operations and looked into various verticals and their specific issues. Research was conducted by interviewing users across different hierarchies and use cases. The insights received from the initial research formed the foundation of designing the solution scenarios.
Some of the core insights can be highlighted as,
Solution
To address these challenges, Lotus Labs developed two tailored products: CS Connect and GS Connect. These products were designed to integrate seamlessly with CSWG’s existing infrastructure, providing a comprehensive solution to streamline operations.
CS and GS Connect
CS Connect's dashboard offers an exceptional vantage point for users, providing immediate access to upcoming events and company advancements. It features vital statistics such as delivery status, open orders, recent invoices, billing data, and quick links to various reports, offers, and services.
Key Features:
Dashboard : Central hub for real-time updates, important stats, billing data, and report access, enhancing user productivity and awareness.
Financials : Provides detailed insights into invoices, payments, returns, credits, billing information, and statements, streamlining financial processes with dynamic lists.
Orders : Dedicated section for creating and tracking orders, managing payments, deliveries, returns, and mishaps, facilitating efficient order management.
Retail Section : Enables CSWG to visualize product pricing, make informed business decisions, and manage millions of products regarding retail prices, profits, offers, and discounts.
Reports : Generates detailed charts and reports, crucial for documenting and streamlining the logistics process.
Additional Features : Includes product search, tools, food shows, bulletins, and trade shows, tailored for both CS and GS Connect to boost productivity and promote offers.
CS Connect Home Page
GS Connect Homepage
Technical Insights and Upgrades
Database migration to improve efficiency:
CS Connect and GS Connect systems leverage an Oracle database and involve data integration from Excel production. To manage data more efficiently, the team migrated to PostGreSQL, which offers faster database activities.This switch facilitated better synchronization between the mainframe and PostGres databases, which are reflected to the user in the front-end
Advanced Analytical Solutions:
Analytical Solutions offer comprehensive insights into inventory management, sales trends, and customer behavior. By leveraging data analytics, we optimize stock levels, reduce excess inventory, and enhance demand forecasting accuracy. Additionally, our solutions enable personalized marketing strategies, improving customer engagement and driving higher sales conversion rates. With real-time reporting and predictive analytics, the client can make informed decisions, streamline operations, and achieve significant cost savings.Our Computer Vision and NLP capabilities provide solutions for future use cases to automate data entry,customized automated stock counting and customized Chatbots.
Product Usage and Technology Transition:
Both CS Connect and GS Connect use the same backend service but have distinct front-end features. There are plans to merge these into a unified system in the future, further simplifying the technology landscape for users. This transition from "My Store" to the customer portal has been pivotal in enhancing user experience.
Report Generation Improvements:
Transitioning the reporting system to the Customer Portal for GS Connect addressed previous issues with the outdated technology, which was slow and lacked filtering capabilities. The new system supports more efficient report generation, with enhanced filters and customizable report dates, significantly improving accessibility and productivity.
Microservices and AI Integration:
Utilizing microservices has prevented system interference and issues that typically arise with monolithic systems. Although AI and machine learning have not yet been integrated, there are plans to explore these technologies to further enhance functionality and user interface.
User Interface and Database Upgrades:
Recent upgrades to the database and user interface have improved speed and visual appeal, simplifying the process of updating product prices and details. The new price association groups feature allows simultaneous updates to products within the same group, greatly improving efficiency.
Impact
Since the deployment of CS Connect and GS Connect, CSWG has experienced remarkable improvements in operational efficiency and user satisfaction:
Increased Productivity: Automation of routine tasks and streamlined processes have significantly reduced manual effort, allowing employees to focus on higher-value activities.
Improved Accuracy: Enhanced tracking and reporting capabilities have reduced errors and discrepancies in orders and deliveries.
User Satisfaction: The intuitive interfaces and comprehensive training provided by Lotus Labs have led to high user adoption and satisfaction rates across all levels of the organisation.
Contribution of Lotus Labs
The success of CS Connect and GS Connect is a testament to the expertise and dedication of the Lotus Labs team. Developing a customised product that meets the specific needs of CSWG, ensuring seamless integration and optimal performance. Also providing continuous support and updates to ensure the software remains effective and up-to-date with evolving business needs. And finally working closely with CSWG to understand their challenges and goals, resulting in solutions that deliver tangible benefits.
lotus labs
© 2026 LOTUSLABS All rights reserved.
lotus labs
TALK TO US
Automating Data Entry with LLM: A Game Changer
Automating Data Entry with LLM: A Game Changer
Developments in the field of Language models has resulted in some tremendously useful API’s by OpenAI and other companies to provide users their models to build LLM applications. Lang Chain is a framework that helps to use these models in an organised and hygienic manner. In this article we talk about how data from documents can be extracted in structured format , this helps in automating the tasks of data entry and can help in making data validation faster.
Why Automate Data Entry?
Manually entering data from various documents is time-consuming and prone to errors. Automating this process not only saves time but also ensures that the data is accurate and consistent. This can be incredibly beneficial for teams in customer service, marketing, and other departments that rely heavily on data to make informed decisions.This also helps in improving quality of real time data analysis.
Extracting Data from Documents
The process of extracting data from documents involves a few key steps:
- Input Document: Start with a document, which could be a PDF, a web page, or any other text file.
- Define Schema: Specify the required fields, their data types, and descriptions to outline what data needs to be extracted.
- Initialise the Model: Use a language model like GPT-4 to create an extraction workflow.
- Data Processing: Break down the document into manageable chunks for easier processing by the model.
- Extracted Data: The model then extracts the data according to the defined schema and stores it in a structured format.
By transforming unstructured documents into structured data, teams can quickly access the information they need to make better decisions and communicate more effectively.
Validating Data with QA (Question-Answering)
To ensure the extracted data is accurate, we use a method called Question-Answering with Retrieval Augmented Generation (QA with RAG). Here’s how it works:
- Generate Questions: Create a set of questions to validate the extracted data.
- Embed Text: Convert the document content into embeddings and store them in a vector database.
- Answering Chain: Use the model to answer the questions based on the document content.
- Validation: Compare the extracted data with the answers generated by the QA process.
This step ensures that any missing or unclear information from the initial extraction can be verified and corrected.
Combining Results
To further refine the data, we compare the outputs from both the structured extraction and the QA process. We create a table with the following columns:
- Key: The attribute we want to extract.
- LLM1: Values from the structured data extraction.
- LLM2: Values from the QA process.
- Mixed: Fill in any gaps from the structured extraction with data from the QA process.
Summarizing Documents
Additionally, we generate a summary of the document using the LangChain framework, which helps quickly understand the content of the documents. This summary provides a concise overview, making it easier to digest large amounts of information and also for a quick understanding by any user of the document.
Automating data entry and validation using LLM not only enhances efficiency but also ensures data accuracy. By leveraging advanced language models and frameworks, businesses can streamline their processes, reduce manual labor, and make more informed decisions. This change can be observed in almost every sector where manual data entry is required.
Business Impact of Automating Data Entry:
A Zapier survey found that 76% of employees spend up to 3 hours daily on data entry. Organisations using automated data entry software report a 95% reduction in this time. According to a 2020 McKinsey survey, automation cuts costs by 10-15%. Financial data errors alone can cost over $800,000 annually in rework, as per Gartner. However, businesses that automate have seen a 90% reduction in manual invoice processing time, showcasing significant returns on investment.
Embrace the power of automation and transform how your organisation handles data entry and validation today!