Ingredient Tracking and Sales Database System

Closed
Auntie Enterprises Inc.
Vancouver, British Columbia, Canada
RM
President
(7)
3
Preferred learners
  • Anywhere
  • Academic experience
Categories
Cloud technologies Data modelling Operations Software development Databases
Skills
data synchronization sales database remote access systems inventory management operational efficiency ibm system p scalability database systems sales dataflow
Project scope
What is the main goal for this project?

Auntie Enterprises Inc. requires a robust database system to efficiently track ingredients purchased from various suppliers. The system should record purchase dates, quantities by weight, and the specific recipes in which these ingredients are used. Additionally, it should track where the finished items are sold. The project aims to integrate this data with popular e-commerce platforms like Square and Shopify, ensuring seamless data flow and accessibility. The database will be cloud-based, providing scalability and remote access. This project will enable Auntie Enterprises Inc. to streamline their inventory management and sales tracking processes, ultimately improving operational efficiency.



Key points:


- Track ingredients from various suppliers.


- Record purchase dates, quantities, and usage in recipes.


- Track sales of finished items.


- Integrate with Square and Shopify.


- Cloud-based storage for scalability and remote access.

What tasks will learners need to complete to achieve the project goal?

The project deliverables include a fully functional cloud-based database system that tracks ingredient purchases, usage in recipes, and sales of finished products. The system will also feature integration with Square and Shopify for seamless data synchronization. Additionally, comprehensive documentation and a user manual will be provided to ensure ease of use and maintenance.



Key deliverables:


- Cloud-based database system.


- Integration with Square and Shopify.


- Comprehensive documentation.


- User manual for ease of use and maintenance.

About the company

Auntie Enterprises Inc. is a company focused on developing new brands in new verticals. Based in Vancouver, the company specializes in ecommerce, marketing, design, new product development, supply chain and logistics. We source products both locally and internationally with a view toward sustainability.