Efficient Inventory & Client DB
$250-750 AUD
Kiszállításkor fizetve
I'm looking to develop a robust database system that will serve two primary functions - managing our customer information and our product inventory for our artwork subscription service. The objective is to streamline our operational processes, ensuring accurate tracking, and efficient handling of our core business data.
We currently have a Google Sheet with many variations, and have made a Loom video explaining how we currently process which we will share with the freelancer we go with.
Key Requirements:
- The database should be designed to store and manage customer information and product inventory details.
- It's expected to comprise between 5 to 10 tables to accommodate the different data facets, including but not limited to, customer details, product specifications, stock levels, and inventory movement.
- The key factor in our process so far is that each customer receives a different artwork, every single time. As we process each order, we record the exact artwork they receive, and our promise is that they will never receive the same artwork twice. Currently in our google sheet there is validations set up and an inventory of artworks that is assigned to each person.
- We also ship monthly and quarterly, and the database should easily show us which customers are to be packed for that month.
- The system should be capable of generating reports that provide insights into inventory levels, product movement, and customer interactions.
- While the database isn't required to support online transactions or payment processing, it must be scalable enough to potentially integrate these features in the future.
Ideal Skills and Experience:
- Proficiency in database design and development, with a strong understanding of relational database management systems (RDBMS) such as MySQL, PostgreSQL, or equivalent.
- Experience in creating scalable database architectures, preferably with a portfolio demonstrating past work on inventory and customer management systems.
- Strong analytical skills to understand our data requirements and translate them into an efficient database structure.
- Knowledge of data privacy regulations and best practices in securing customer information.
We also would like to look into more Zapier integrations between thrivecart and Airtable to streamline the customer process.
By undertaking this project, you'll be playing a crucial role in optimizing our business operations. Your expertise will not just contribute to the structuring of our data but will also lay down the foundation for incorporating advanced features in the future.
Projektazonosító: #37741850
A projektről
26 szabadúszó tett átlagosan 492$ összegű árajánlatot erre a munkára
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Továbbiak
Hi There, Thank you for considering me for your project. I have carefully reviewed the project details and I am confident that I can develop a robust database system to meet your requirements. The database system wil Továbbiak
Hi there! As I have read, I see you need help to develop a solid database system I could help you develop this project and meet your requirements. I'm a professional Database Administrator and Analytics Engineer with Továbbiak
Hello there, Can you share the specific data points you currently track for customers and artwork? Do you have any preferences for specific database technologies or platforms? What level of data security and access c Továbbiak
Hello, I am excited about the opportunity to develop a robust database system for managing customer information and product inventory for your artwork subscription service. With proficiency in database design and deve Továbbiak
I can help you to create a system within the Google sheets by app script to make your inventory efficient and easy customer interaction. I can also create a database of your Google sheets into SQL and create data mod Továbbiak
Hi, How are you doing? As a professional developer with expertise in database system development based on MySQL and PostgreSQL, I eagerly anticipate the opportunity to complete this project for you. Please drop me a me Továbbiak
As the founder and CEO of Techfusion, I am thrilled to present you with our team's capabilities which align perfectly with your project's objectives. Boasting a strong background in full-stack development and data anal Továbbiak
Hi, I have experience in :- # inventory and customer information management systems # MySQL and SQL # PHP and other web application development # has rich experience and 7 years in web development # Integration with C Továbbiak
Hello , Good evening I have some queries in relation to the specs of the project. Could we please have a word? My Skills: Excel, Google Sheets, Airtable, PHP and Zapier
Dear, This project is nothing to me because I have rich experiences with skills including PHP, Google Sheets, Zapier, Airtable and Excel. Specially I've worked with other clients in similar projects and I can work on Továbbiak
Hi, ! I have worked with similar projects so that I can provide you with a satisfied result. Having confirmed the job posting "Efficient Inventory & Client DB", I truly feel that you're looking for ambitious, creati Továbbiak
susannaapril, The project "Efficient Inventory & Client DB" seems great and I want to work with you. I am an expert who has many years of experience on PHP, Excel, Airtable, Google Sheets, Zapier so I am sure tha Továbbiak
Good day, How are you? I went through your description and would like to grab this opportunity to make sure you are 100% satisfied with my work. With 6 years of professional experience in software development and a p Továbbiak