Automation of data processing and Excel files
223 USD 
Hello!
I will describe the real situation and what is desired!
1. The client sends an order in an Excel file.
2. The data, specifically the quantity of boxes and the price, is manually transferred to the specification file.
3. Then an invoice file is created based on the specification.
It is desired that upon receiving the order file, it is somehow uploaded or read, and only the items that are ordered (the blue column) are selected, and a Specification and Invoice file is created automatically, filling in the quantity of ordered boxes and the price from the order file.
Features:
All three files have different data content for the corresponding items.
When ordering, the client can order a different assortment each time.
We can create one file as a database where everything will be recorded, and only what is needed will be entered into the Specification and Invoice.
There are 20+ clients, and new ones are being added.
Each has its own prices.
In the Invoice, a different bank for payment is set for each client.
Ready to consider any possible implementation, offline or online. It is preferable to have the ability to expand and modify data. Adding items. Adding clients.
Ideally, it would be great if the client had their own login and could access a web page to place orders, and we would receive a notification about the order. If we approve it, the Specification and Invoice would be immediately generated and sent to the client for signing and payment, and to us for production.
From the realm of fantasy:
It would be good for the client to see their previous orders.
Based on the previous one, they could create a new order, changing only the quantity of boxes ordered.
The budget can be reviewed depending on the quality and capabilities of your execution, but it is not limitless.)
Applications 3
-
1 day445 USD
8150 63 1 1 day445 USD
Good day!
I am ready to automate the ordering process and generate files for the client. I am waiting for the opportunity to discuss the details and start working!
-
1 day356 USD
3853 24 0 1 day356 USD
Hello!
I am ready to automate the process of processing customer orders. The main functions include receiving orders in the form of an Excel file, creating an invoice file based on the specifications, and automatic distribution of items according to the orders.
Possible implementations are offline and online, with the possibility of expanding and modifying the data. Additionally, it is possible to create a web page for customers with the ability to place and view orders.
I am ready to consider your additional wishes and proposals. My rate is $16 per hour.
Best regards,
… Maxim
-
10 days223 USD
334 1 0 10 days223 USD
Good day!
All your wishes can be realized. Here are a few options. For this, we need to discuss everything and choose the best one for your needs.
I have worked on similar tasks. I am also the owner of online stores, where the work with incoming and outgoing price lists and invoices in Excel format is implemented.
Feel free to reach out, we will discuss, and I will show you possible options.
-
10 days223 USD
1848 43 0 10 days223 USD
I have done somewhat similar projects:
In this project, it was enough to write a macro
https://freelancehunt.com/project/formuvannya-tablitsi-excel-zadanimi-parametrami/1396672.html
For you, it might be possible to create some interface through which the client would upload their files somewhere on hosting, from there, using a script via API, integrate into Google Sheets
I need to talk to you to make the appropriate decision on how to proceed.
-
10 days223 USD
964 17 0 10 days223 USD
Good day, Alexander!
I can offer the following option: each client has their own Google Sheet, where they mark the required number of products. All data is sent to your master sheet. If everything is okay - you press a button and the required invoice is created.
Advantages include the simplicity of adding new clients, and it will be convenient for them to work in their own sheet each time, essentially just changing the previous order.
I will set everything up, explain how to work, and will provide service support if needed)
* I can offer a test implementation with two sheets so you can see how it will work.
-
1 day223 USD
336 4 1 1 day223 USD
Good day.
A possible implementation option based on Google Script and Google Sheets.
There is a main table where you keep a list of clients.
There is a table with products and prices.
Also, each client has separate tables where they can select the relevant products from the lists, after sorting the order, an Excel invoice file can be automatically generated and sent to them via email, along with the specifications file.
I can create an example of such a model, and we will discuss it.
-
7 days223 USD
2215 35 0 7 days223 USD
Good day, I will help solve the task both online (in Google Sheets) and in Excel. Each case has its own advantages and disadvantages. More important than the technical part is to determine the accounting policy, so that it does not need to be redone later. I will help find the optimal solution. Feel free to reach out.
-
10 days223 USD
2912 44 0 10 days223 USD
Good day.
I can automate your workflow.
"Perfect" and "Out of the ordinary" can also be implemented.
-
10 days223 USD
655 6 1 10 days223 USD
Good day! I am ready to develop automation for creating Specification and Invoice files from the order file. I also have suggestions regarding the points of your task "Ideal" and "Out of the ordinary".
-
10 days223 USD
866 26 4 1 10 days223 USD
Here it is not about website building, but regular coding. The page, of course, should be there for authorization. Reading and analysis. With subsequent processing. Database as needed.
-
10 days223 USD
4302 215 0 1 10 days223 USD
Good afternoon, we can basically create a B2B service where the client can log in, see the full range of products, and place an order. Please message me for a more detailed discussion of the details.
-
2 days223 USD
419 13 0 2 days223 USD
Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
-
20 days890 USD
2986 37 0 1 20 days890 USD
Hello. I can develop a system for your clients and you if you need it. The price is indicated below. Feel free to contact me, we can think everything through.
Current freelance projects in the category Databases & SQL
Integration of Viber into 1C 8.3
223 USD
Project Meta Implement Viber integration without using third-party CRM systems. All work with messages should be done directly in our internal CRM based on BAS / 1C 8.3.Current System BAS / 1C 8.3 Custom configuration "Customer Service" Database of over 40,000… Databases & SQL, Web Programming ∙ 1 hour 37 minutes back ∙ 12 proposals |
A Senior Flutter + Backend developer is required to create an MVP for a startup (similar to Uber for household services).
223 USD
Looking for an experienced developer (or a small team) to create an MVP mobile application — a service for urgent calls to specialists similar to Uber, Uklon. Development needed: • mobile application for iOS and Android (Flutter); • server part (REST API); • admin panel; •… Databases & SQL, Hybrid Mobile Apps ∙ 17 hours 28 minutes back ∙ 35 proposals |
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 5 days 2 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 5 days 19 hours back ∙ 10 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 6 days 13 hours back ∙ 93 proposals |
Rovno