Development of an Excel spreadsheet
16 USD Technical task for automating the deduction of product stock when creating a deferred receipt
The task concerns the proper setup of an Excel table. There is a tab with products and their stock and a tab with customer orders for these product groups. The following task needs to be implemented:
⦁ In the table with customers, it is necessary to implement a column where, when creating a receipt, the manager can select a product, and upon selecting this product, it will be deducted in the tab or table with stock.
⦁ If all stock of the product is deducted and if the stock is equal to zero, it is necessary that when selecting this product, an error message is displayed stating that the product cannot be selected.
⦁ Additionally, it is necessary that a shipping document from Nova Poshta can be attached to the selected product. At the moment of selecting the product and the shipping document, the product will be automatically deducted, and if the parcel is not picked up, the product will be returned to stock in the warehouse.
⦁ It is desirable to automate all processes related to deduction and selection of the shipping document from Nova Poshta as much as possible. For example, so that the shipping document can be pulled up by the customer's phone number or last name.
-
1 day56 USD
3278 10 0 1 day56 USD
Here is your ready option, a brief overview of the principle of operation - https://youtu.be/0suuokPfk9g
I can perform it on any system, with 10 years of experience.
-
2 days67 USD
1449 24 3 2 days67 USD
Hello.
I have experience in completing similar tasks, so I am confident that I can deliver everything with quality and within the agreed deadlines. I am ready to start soon. Let's discuss the details in private messages.
-
3 days67 USD
986 12 1 3 days67 USD
Hello! I am ready to implement full automation of product deduction in Excel, taking into account the logic of deferred receipts, stock levels, and integration with Nova Poshta's shipping documents.
I will create a table where the manager can select a product from a dynamic list, and the stock level will be automatically deducted.
I will implement a check: if the product is not available — there will be an error message.
I will add the ability to attach shipping documents, which will be retrieved by the phone number or the client's full name.
I will foresee the return of the product to the warehouse if the package was not received.
The entire process will be maximally automated — without unnecessary manual actions.
I have experience in building such systems: interactive tables, stock control, order processing logic, integration with Nova Poshta's API (if needed). I work quickly, with explanations and documentation for the team.
…
I am ready to discuss the details and offer a demo solution.
-
5 days45 USD
2257 35 0 5 days45 USD
Good day. I am ready to help with the implementation. I have extensive experience in similar solutions. Maximum automation will affect the cost of the work. I will suggest the optimal option. Feel free to reach out.
-
1 day67 USD
567 28 2 1 day67 USD
I have completed several similar projects and can demonstrate them. Write to me, we will communicate.
-
1 day67 USD
4461 102 0 1 day67 USD
Good evening. I will be happy to help. I will complete everything quickly and efficiently!
-
2 days67 USD
973 17 0 2 days67 USD
Good day!
I would like to clarify regarding the last point. In general - I am ready to implement, a specialist in Excel / Google Sheets.
-
2 days22 USD
2991 73 4 2 2 days22 USD
Hello! I will do it quickly and efficiently!!! Experience in working with Excel for over 20 years!!!!!!!!!!!!
-
2 days45 USD
2578 57 1 1 2 days45 USD
I work as a financial analyst in a large international company. I will do
Current freelance projects in the category Databases & SQL
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 15 hours 50 minutes back ∙ 5 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 1 day 6 hours back ∙ 7 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 6 days 6 hours back ∙ 12 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 6 days 17 hours back ∙ 6 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 ∙ 10 days back ∙ 16 proposals |
Ukraine