Уменшить количество запросов и нагрузку на БД

We are looking for a specialist or a team with experience in refining 1C/BAS for warehouse accounting automation. We already have an active 1C:Enterprise 8.3, but we need to analyze the current database and propose an optimal solution: refine the existing 1C; or deploy a new one that will implement the necessary functionality. The main task is to set up full-fledged warehouse operations using barcode scanners, data collection terminals, labels, address storage, and inventory control.What needs to be implemented management of product nomenclature; inventory accounting; receiving goods into the warehouse; sales and shipments to customers; reserving goods for orders; order picking through a scanner or data collection terminal; working with barcodes of products, packs, boxes, and pallets; printing internal labels; serial accounting for inverters, batteries, and expensive equipment; written-off goods; inventory through a scanner; returns of goods; management reporting; logging user actions; the possibility of further scaling of the system.Warehouse logic The manager creates a customer order in 1C. After that, the order should automatically be sent to the warehouse as a picking task. The warehouse employee opens the order on the data collection terminal or another device, sees the list of products, quantity, and storage location of the product: sector, row, shelf, or cell. It is necessary to implement address storage so that the warehouse employee can see exactly where the product is located. If there are many items in the order, it is preferable for the system to sort the products in a convenient picking sequence throughout the warehouse. The employee scans the product, pack, or pallet. The system must check whether this product is in the order, whether the quantity is correct, whether there is sufficient stock, and whether an extra item has been scanned. If the product is correct, the system confirms the item. If the product is incorrect, the system must show an error and not allow closing the order until it is corrected.Working with packs, boxes, and pallets It is necessary to implement accounting for goods not only by individual items but also by packs, boxes, and pallets. For example, if one pallet contains 30 units of product, when scanning the pallet label, the system should automatically add 30 units to the document. Partial picking logic is also needed. For example, if there were 36 pcs on the pallet, and the order requires picking 10 pcs, the system should write off 10 pcs, leave 26 pcs, and suggest printing a new label for the remaining pallet.Labels and equipment It is necessary to set up label printing for: product unit; pack; box; pallet; products with serial numbers. The label should contain the product name, article, model, barcode, quantity in the package, or serial number if it is a serialized product. The system must work with a barcode scanner, label printer, and data collection terminal.Reports and control Reports are needed on stock levels, product movement, sales, reservations, write-offs, inventory, serial numbers, surpluses, and shortages. User action logging is also needed: who created the document, who changed the quantity, who conducted the write-off, who conducted the inventory, date, and time of the action.Expectations from the performer A specialist is needed who: has experience working with 1C/BAS; understands warehouse accounting; has worked with data collection terminals or barcode scanners; has experience setting up label printing; can propose a ready-made module or optimal architecture of the solution; can assess what is better: refining the current 1C/BAS or creating a new database; after analysis, can provide work stages, timelines, and estimated costs.

About the Company Trading company. We work with a product group of more than 2000 items across different categories.Current Situation Currently, the nomenclature is maintained in Google Sheets — data is consolidated by tabs (categories). Tab Structure: Product name Price groups: cost price, wholesale, retail Characteristics: weight, quantity per package, etc. Important: the number of columns varies for different product categories, as they have different characteristics.Why the Current Solution is Inadequate Google Sheets does not allow setting access rights at the level of individual columns. We need to: Grant users rights to view certain columns (for example, only cost prices) Grant rights to edit certain columns (for example, retail prices) While restricting access to other columns in the same tabWhat Needs to Be DoneMain Requirements Flexible Rights Management System Access at the level of individual columns (read/write) Assignment of rights by roles or users Management of rights without the involvement of programmers Support for Different Data Structures Different product categories have different sets of characteristics Adding new columns/characteristics without programming Independence from Developers Administration by internal staff Adding categories, columns, users — through the interface Integration with ERP Exporting current prices to our ERP system Export or automatic integration via API Data Analysis Using AI (preferably) Ability to analyze the entire nomenclature list Enrichment, verification, recommendations — if you have ideas, please describeExpected Result A working solution in which: The nomenclature is structured by categories with different sets of characteristics Column rights are flexibly configured (view/edit) Data is exported to ERP The team can manage the system independentlyWhat We Need from You When Responding Describe in general terms how you envision the solution: What tool/platform do you propose

A deep technical verification of three PDF files for authenticity and possible signs of editing or forgery is required. Not only a visual assessment of the documents is needed. The performer must have a good understanding of the internal structure of PDF files and be able to analyze: file metadata; PDF structure and individual objects; creation history and possible editing; software used; embedded fonts, images, layers, and other elements; possible signs of re-saving, conversion, modifications, or backdating of the document; any technical discrepancies that may indicate manipulation of the files. Based on the verification results, a clear written conclusion regarding each file must be provided, indicating the identified signs, risks, and limitations of the verification. We are considering specialists who have practical experience in digital forensics, PDF document analysis, metadata, or verifying electronic files for authenticity. In your response, please briefly describe your experience, methods, and tools that you use for such verification.

General information It is necessary to develop a simple minimalist web system, the main purpose of which is to maintain a client database, create appointments for visits, and automate the process of confirming visits via SMS, sending one-time links through the API from the service itself. The project is being developed in stages. In the first stage, it is necessary to implement only the basic functionality (MVP) so that the system can be used in real work. After launch and testing, it will gradually be expanded with new modules.Main functionality of the first stage User authorization; Client database; Creating and editing appointments; List of appointments (or a simple calendar); Switching between points of sale; Integration with the SMS operator via API; Sending SMS with any text or link for visit confirmation; Confirmation or cancellation of the visit by the client via a one-time link; Displaying the confirmation status directly next to the client's appointment. At the initial stage, instead of a full calendar, the use of a simple list of appointments by days is allowed. Each day should contain a chronological list of bookings indicating the time, client's name, service, employee, and confirmation status. Later, this list can be replaced with a full calendar without changing the system structure. The system must have the ability to switch between points of sale. Each point of sale has its own list of appointments (or calendar), but they all use a common client database.

Copying the database and front for the database (Currently, the front is partially copied and some characteristics are incorrect. The parser filled the database with its own characteristics) Synchronizing the parser with the database and the characteristics of the database Fixing the bug in the parser agent Cropping photos proportionally to the watermark that comes from the parser Working with the buffer with the new database and tools with the objects of this database Fixing minor bugs: for example, text in pop-ups, or small issues on the front, bugs that appear during task execution Connecting a new storage for media storage Logs have stopped writing to the financial operations table, which affects the balance and tariff plan pages (payment of the tariff, account replenishment (successful/not)) Check the payment functionality again and then replace the test billing API from Monobank with the real one Refine access rights for the database administrator user There are currently hanging processes that load the server; this needs to be checked The logic of comments and notes is currently working incorrectly; it needs to be such that for the same object in 2 databases - comments are tied to each database, not to the object, the source of which is the object of this database (I can explain in more detail in private) Fix the sorting in the databases correctly (Currently from the first added to the last. It needs to be the opposite; the sorting functionality is created) Check and correct the accuracy of filters in the databases, possibly add restrictions on filtering with large data volumes