Automation of data processing and Excel files
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
-
8150 63 1 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!
-
3853 24 0 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
-
334 1 0 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.
-
1848 43 0 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.
-
964 17 0 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.
-
336 4 1 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.
-
2215 35 0 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.
-
2912 44 0 Good day.
I can automate your workflow.
"Perfect" and "Out of the ordinary" can also be implemented.
-
655 6 1 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".
-
866 26 4 1 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.
-
4302 215 0 1 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.
-
419 13 0 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.
-
2986 37 0 1 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 |