Inventory management in Google Sheets.

Good day!

Google Sheets is a good option for small and medium businesses, with free service, online information storage, and unlimited user access with an internet connection available.

Using scripts (Apps Script), you can perform more complex tasks to automate the spreadsheet and create CRM systems, databases, and integration with messengers (Telegram Bot) based on the spreadsheets.

I see that you understand the desired outcome, but are unsure if it can be achieved using Google Sheets. We can start with what you have in mind and develop from there.

What I can offer:
… 1. Separate spreadsheets for salons with a unified structure and restricted access for data entry.
2. A main spreadsheet with consolidated data from all salon spreadsheets.
3. Data collection in the structure you need for statistics/analytics.
4. Ability to link spreadsheets together (a comment on a specific product/service entered in the main consolidated spreadsheet will be pulled into the corresponding spreadsheet for further processing).
5. Calculation of salaries, inventory, profits, and other indicators based on the data entered in separate spreadsheets.
6. New ideas will emerge during the project execution, which I will share.

If interested, feel free to reach out. I am ready for long-term collaboration.

Show original

Translate

Good day,
I am ready to help you with this project.
Looking forward to discussing the details and starting the work!
I will be happy to continue cooperation in the future.
Waiting for your response.

Show original

Translate

Good day,

I am ready to take on your project on inventory management for a beauty salon based on Google Sheets. I have experience in developing platforms and bots using data import, calculations, and automatic email sending through triggers.

To scale the system to 10-30 beauty salons, I am considering the following possible solutions: creating a master file for data copying, moving the backend to a database for centralized management, and other options that will efficiently solve the task. I am willing to cooperate in the future and complete the project within the specified deadline.

My rate is $16 per hour. I am ready to discuss the budget and project details.

Sincerely,
… Maxim

Show original

Translate

Good day, Mykola.
Can you record a video to show in what format your file with user-entered data is, the json file (where it is stored) and how the exchange process takes place.

It is possible to create one main file for the director, and by clicking a button, a template file for filling in by the beauty salon employee will be created on Google Drive.

The data can be sent either by script or imported via importrange from the relevant range.
But all files must be on your Google Drive so that you are the owner.

Show original

Translate

Hello. I am an experienced .net programmer with 10+ years of commercial development experience.

I propose to implement your task based on the .net stack in the form of a web application and database.

Let's discuss the details.

Prices and deadlines are approximate.

Show original

Translate