The Google Table. The ERP program. Small production and several warehouses.
There is a small production, there is a small production, there is a small production. Dresses are what comes from hair.
These traps have different parameters - length, color, thickness, natural hair, experienced hair, different ends, quantity and so on.
You need to be able to make orders far away, as the sale is sitting elsewhere, in fact even the country. that is. The decision must be cloudy.
There are also different types of warehouses.
1 . warehouses in production. It consists of raw materials (different types of hair (length, color, etc.) and finished products. The consumption of raw materials is handmade, as it is very difficult to predict, too different is the source material.
2nd Storage of finished products in the sales department.
Three Commission warehouses in customers (they are now three, may be more), with which they, usually once a month, have to report on the sale of finished products, which they are then accounted for.
In addition, everything should be either in two languages Russian/Ukraine + English or only in English.
I will be pleased with the proposals.
-
2 days231 USD
226 2 1 2 days231 USDWelcome to Michael.
I have experience in creating analytical and accounting tables on the basis of Google Sheets, I have experience in creating tables to reflect the movement of goods by stock.
I will be able to realize all your wishes in 1-2 days, possible also with tracking the product on the box, and creating a sales analysis according to your wish.
-
5 days115 USD
421 13 0 5 days115 USDWelcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
10 days58 USD
647 11 1 10 days58 USDGood Morning Michael.
I specialize in automating work in Google tables, creating dashboards, scripts, and more.
As an option, you can divide it into several separate tables (so that certain users have access only to their composition), and the director (or owner) will have access to all.
Data between tables can be transmitted through the importtrange function and obtain the required data range.
1) Create a table for the production stock
2) Create a table for the composition of finished products
3) Create tables for commissions (for each client their own)
… 4) A table for the director, in which you will be able to see sales statistics from the commission stores and other indicators.
You can connect scripts to the table, contact with the email and send a message from the table if necessary. It is also possible to automatize the process of accounting for commission stores.
I can show in a private example of a mini-CRM based on Google tables
I will be glad to discuss the details and implement this project for you.
-
10 days577 USD
1880 29 0 10 days577 USDHello to you.
I can make you automated on the basis of Google tables.
There will be a CRM/ERP system.
The general advantages:
Availability and joint work
Easy integration with other Google services
Automation for scripts. Calculations, simplification of routine actions and
… - Automatic data update, sending notifications by email, and much more
Forms and reports.
For example, a order is formed by a button and sent to another order table.
Synchronization of data between tables, forms and so on.
I can do it in three languages.
A lot of interesting. Show your tables, we will discuss details and we can move forward.
-
10 days577 USD
2137 39 0 10 days577 USDI can do on the basis of an ERP system, in which there will be both accounting and orders and production
-
1 day23 USD
900 10 1 1 day23 USDGood day, you can organize on Google tables. Details can be discussed in Ls. See more in detail how it may be.
-
1 day23 USD
1115 109 0 1 day23 USDHello to you!
All the described functionality can be implemented on the basis of Google tables. Experience in solving similar tasks.
Write to LS to discuss the details of the project.
Current freelance projects in the category Databases & SQL
Development of the web service "Interactive Veterinary Dental Map"Project essence: a web application where doctors can maintain interactive dental charts for patients (cats and dogs) The interface design and all jaw elements are already fully prepared in Figma (vector SVG with separation by individual teeth) Required functionality:… Databases & SQL, Web Programming ∙ 3 hours 38 minutes back ∙ 35 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 5 hours 40 minutes back ∙ 11 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 2 days 9 hours back ∙ 54 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 2 days 10 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 2 days 22 hours back ∙ 10 proposals |