Abstract: Methods and systems for database query efficiency improvement are disclosed. In one embodiment, a method includes mirroring a primary database to a secondary database; creating a testing database comprising the schema; receiving a query; running the query on the testing database; and evaluating the query by: identifying predicates in the query; determining most common values for each column name by querying the secondary database; creating, for each column name, a list comprising at least one of the most common values; creating a test predicate comprising one of the column names and an entry for the list corresponding to the column name; creating a test query comprising one or more test predicates; determining a resource utilization of the query by running each of the test queries on the secondary database; and providing, to a user interface for display, an efficiency improvement recommendation when the resource utilization exceeds a threshold.

Abstract: A computer-implemented system for dynamic inventory balancing including at a processor and a memory device comprising instructions that when executed configure the processor to perform operations. The operations including receiving an inventory data feed from at least one fulfillment center, storing (in a database) a plurality of virtual bundles with associated grouping numbers and quantities—the plurality of virtual bundles having item bundles grouping two or more of a same item in the inventory data. The operations also include exposing the database to queries from a seller portal through at least one of RESTful service, a queue based system, an index, or an object table and receiving a client order, the client order comprising a bundle selection from the plurality of virtual bundles, and updating the plurality of virtual bundles by rebalancing the plurality of virtual bundles and corresponding associated quantities based on the bundle selection.

Abstract: A computer-implemented system and a method for automatic electronic order creation are disclosed. The system and method may be configured to: receive a digitized document comprising embedded metadata related to contents of the digitized document; analyze the embedded metadata to extract a boundary parameter; generate a unique reference identifier associated with the digitized document and the boundary parameter; receive a first input data setting one or more target measurements for one or more predefined periods of time, wherein a sum of the one or more target measurements is less than or equal to the boundary parameter; receive a second input data setting configuration data for achieving the one or more target measurements; and generate an electronic order based on the configuration data.

Abstract: The present disclosure provides systems and methods for automated bag packaging, comprising at least one processor; and memory storing comprising: receiving an order comprising at least one item; searching at least one data store to determine one or more properties associated with each item; for each group: performing an optimization process for packaging the at least one item into one or more bags, by: selecting a data structure representing a first bag, the data structure comprising a size of the first bag; iteratively simulating packaging of a largest item of the group into the first bag until all items are packaged in the selected bag; generating at least one set of instructions for packaging the items into the selected bag; and sending the generated instructions to a computer system for display, the instructions including at least one item identifier and one bag identifier.

Abstract: Methods and systems for arranging hyperlinks on a graphical user-interface (GUI) of a computerized system include receiving, via the GUI, a user selection to display a plurality of hyperlinks, the hyperlinks corresponding to one or more nodes of a first set. The methods and systems further include determining, by a processor, a rank of each hyperlink in the plurality of hyperlinks. Determining a rank includes constructing a first bipartite graph between the one or more nodes of the first set and one or more nodes of a second set, the first set and the second set being mutually exclusive, wherein edges of the first bipartite graph are weighted according to a first criterium and constructing a second bipartite graph between the one or more nodes of the first set and the one or more nodes of the second set, wherein edges of the second bipartite graph are weighted according to a second criterium, different from the first criterium.

Abstract: A computer-implemented system for correcting address information. The system may include a memory storing instructions and at least one processor configured to execute the instructions to perform operations. The operations may include requesting an address for normalization from at least one of a current address or a residential history of a user; receiving, from a user device, a user input including requested address information responsive to the request for normalization; searching, based on the user input, a cache to determine whether a refined version of the requested address is available; returning, based on a determination that a refined version of the requested address exists in the cache, a refined address as the normalized address to the user; and beginning to transport a package to the user at the normalized address, by providing instructions to a mobile device associated with a delivery worker, to transport the package to the normalized address.

Abstract: Disclosed are methods and systems for intelligent distribution of products. In one aspect, a system comprises a memory storing instructions and at least one processor configured to execute the instructions. The processor performs operations include receiving forecasting data comprising an expected demand of a stock keeping unit and determining a target inventory of the SKU to satisfy the expected demand. The operations further include determining a regional target inventory of the SKU of a region comprising a plurality of fulfillment centers. The operations further comprise receiving historical data comprising the inbound and outbound shipment history of a fulfillment center in the plurality of fulfillment centers and generating a profile for the fulfillment center. The operations further comprise assigning a portion of the regional target inventory to the fulfillment center and transmitting instructions to a device to stock a number of SKUs in the fulfillment center based on the portion.

Abstract: According to various example embodiment of the present disclosure, a method of sharing item information by an electronic apparatus includes acquiring a request for link information related to at least one item from a user, acquiring first selection information related to an attribute of the link information, and providing link information on a first page including information related to the at least one item based on the request for the link information and the first selection information, in which the link information may include information related to the attribute.

Abstract: A system for managing a client request is described herein, which may have at least one processor and a non-transitory computer-readable medium containing a set of instructions executable by the at least one processor. Execution of these instructions may cause the processor to perform steps of: validating a client request received from a remote client device, the client request including request data; transmitting, based on the validating, a response to the remote client device; based on the request data, determining a queue for the client request; asynchronously enqueuing the client request in the queue, the queue being configured to analyze the client request according to a model; analyzing the client request; and based on analyzing the client request, performing a responsive action.

Abstract: Disclosed embodiments provide systems and methods related to monitoring logistics. A method for monitoring logistics comprises capturing attendance data and timekeeping data for a first plurality of workers from a first management system, data identifying work performed by a second plurality of workers, the data comprising a location of performed work, an associated scan event, or clock-in information associated with each of a second plurality of workers, from a second management system, and work data related to a third plurality of workers from a third management system. The method further comprises consolidating the captured data on workers having corresponding data in one of the captured sets of data, receiving a request from a user device, for a visualization including analysis of the consolidated data, and providing a visualization to the user device, wherein the visualization is generated by analyzing the consolidated data.

Abstract: A computerized system for API migration. The system includes a memory storing instructions and a processor configured to execute the instructions to perform operations, which include segregating client accounts three groups, assigning a first API for communications with the first group and a second API for communications with the second group, and assigning the first API for communications with a first portion of the third group and the second API for communications with a second portion of the third group. The operations may also include collecting communications from the groups and generating metrics associated with each group, and generating a comparative report and a compatibility report. The operations may also include transmitting at least one of an alert or a recommendation based on the comparative report and the compatibility report.

Abstract: A computer-implemented system for dynamic inventory balancing including at a processor and a memory device comprising instructions that when executed configure the processor to perform operations. The operations including receiving an inventory data feed from at least one fulfillment center, storing (in a database) a plurality of virtual bundles with associated grouping numbers and quantities—the plurality of virtual bundles having item bundles grouping two or more of a same item in the inventory data. The operations also include exposing the database to queries from a seller portal through at least one of RESTful service, a queue based system, an index, or an object table and receiving a client order, the client order comprising a bundle selection from the plurality of virtual bundles, and updating the plurality of virtual bundles by rebalancing the plurality of virtual bundles and corresponding associated quantities based on the bundle selection.

Abstract: The package configuration optimization system includes at least one non-transitory storage medium comprising instructions and at least one processor executing the instructions for performing operations. The operations may include receiving historical order data associated with a fulfillment center, the order data including at least one of items ordered, package information, shipping costs, or fill rate, generating a forecast for order data based on the historical order data and performance data associated with the fulfillment center, the forecast comprising a plurality of dummy orders, receiving preferences for packaging cost reduction, determining a current packaging configuration associated with the fulfillment center, optimizing the current packaging configuration to generate at least one new packaging configuration using the received preferences and the generated forecast, and sending the at least one new packaging configuration to a remote system.

Abstract: Systems and methods for correlating item data are disclosed. A system for correlating item data may include a memory storing instructions and at least one processor configured to execute instructions to perform operations including: receiving text and image data associated with a reference item from a remote device; converting, using a computer-modeled embedding layer, at least one image to an image embedding; comparing the image embedding to reference embeddings stored in a database; selecting a subset of the candidate item text as candidate text data based on the comparison; selecting a subset of the candidate item images as candidate image data based on the comparison; selecting a text correlation model; determining a first similarity score; selecting an image correlation model; determining a second similarity score; calculating a confidence score based on the first and second similarity scores; and performing a responsive action based on the calculated confidence score.

Abstract: According to the present disclosure, a method of processing data in a data processing system using a distributed messaging system may include acquiring, by a first server, event information associated with at least one item, transmitting, by the first server, a job creation request to a distributed message server based on the acquired event information, acquiring, by a second server, a job request message generated in the distributed message server based on the job creation request, processing, by the second server, event information using at least one processor based on the job request message, and transmitting, by the second server, the processed event information to a front-end-related server.

Abstract: The present disclosure relates to a method of providing product information, the method including identifying a product corresponding to a request from a user, verifying whether a category of the product is included in a first category for which brand information is additionally provided, identifying, when the product belongs to the first category, logo content mapped based on brand information of the product identified from information on or regarding the product, and providing, in response to the request, a page related to a product in which the brand information of the product including the identified logo content is displayed in a first area.

Abstract: One aspect of the present disclosure is directed to a computer-implemented system for streamlined product searching configured to receive a search query comprising at least one keyword; determine a product type; retrieve a first record of products associated with the product type; determine whether the search query meets a condition; and if the search query meets the condition: determine, a plurality of label values, and for each label value: generate a second record of products associated with the label value; determine whether each product in the second record meets a condition; deleting each product that meets the condition from the second record; ranking each remaining product in each second record; display the plurality of label values for selection; receive a selected label value; and display at least a portion of the remaining ranked products associated with the selected label value.

Abstract: The embodiments of the present disclosure provide systems and methods for managing inventory placement, comprising a memory storing instructions and at least one processor configured to execute the instructions. The processor may be configured to receive an identifier of a product for inventory placement, and determine, based on historical shipment data stored in a database, a region with the highest customer demand for the product. The processor may predict, using a machine learning algorithm, a product tag associated with the product based on at least a temperature associated with the region with the highest customer demand for the product. The processor may further modify the database to assign the product tag to the product identifier, and assign the product for placement in a fulfillment center. The fulfillment center may be associated with a fulfillment center tag corresponding to the product tag assigned to the product.

Abstract: Systems and methods are provided for updating product information on a webpage. One method comprises receiving, from a first seller, a first request to list at least one first product for sale on the webpage and receiving, from the first seller, product information associated with the at least one first product for sale. The method further comprises receiving, from the first seller, at least one image associated with the at least one first product for sale and providing the received product information associated with the at least one first product for sale to a workflow system, wherein the workflow system is configured to begin a first workflow to enter the product information into a database and configured to process multiple workflows substantially simultaneously. The first workflow may include listing the at least one first product for sale on the webpage.

Abstract: Provided is a packaging cooler box for delivery, comprising a bottom portion to form a lower surface upon conversion into a box mode, a plurality of sidewall portions configured to connect with the bottom portion, a lid portion configured to connect with one of the sidewall portions, and to face said bottom portion upon conversion into the box mode, a crease portion formed along the edge of the bottom portion so that the sidewall portions can stand upright, joint portions configured to join said sidewall portions, to be folded to face itself and to be in close contact with the sidewall portions, upon conversion into the box mode, and easy adhesive portions provided in said joint portions and sidewall portions to maintain the box shape upon conversion into the box mode from a single plane consisting of said bottom portion, sidewall portions, said lid portion and joint portions.