Systems and methods for computer memory optimization for the storage of delivery time information for a product sold online
In e-commerce, web content (such as a checkout page) may include delivery time information associated with a product. To obtain the delivery time information, the computer may send an application programming interface (API) request to the fulfillment network. However, a fulfillment network is often delayed in responding to an API request. Also, there may be data privacy concerns with this approach. Alternatively, precomputed delivery time information may be sent from the fulfillment network, but this may result in a large amount of data that must be stored. In some embodiments, a data structure may be generated that includes a product-to-schedule mapping and a set of delivery schedule tables. Each of the delivery schedule tables may be based on a respective different set of one or more categories to which multiple ones of a plurality of products map. Computer memory resources may be saved.
1. A computer-implemented method comprising:
storing, in a memory, a data structure comprising:
a plurality of delivery schedule tables, and
a mapping of each of a plurality of products sold on an e-commerce platform to a respective one of the plurality of delivery schedule tables,
wherein each of the plurality of delivery schedule tables corresponds to a respective category, of a plurality of categories, to which multiple ones of the plurality of products map, and wherein each entry of each of the plurality of delivery schedule tables stores pre-computed delivery schedule information, for the respective category, for each destination of a plurality of destinations;
receiving, from a user device over a network during an online interaction by a user with the e-commerce platform, a request for web content associated with a particular product of the plurality of products sold on the e-commerce platform; and
replying to the request during the online interaction in real time, the replying comprising:
obtaining, from the request for web content, information related to a delivery destination associated with the user device and an identifier that uniquely identifies the particular product;
identifying a particular delivery schedule table, of the plurality of delivery schedule tables in the memory, to which the particular product maps based on the identifier, wherein the particular delivery schedule table corresponds to a particular category of the particular product;
extracting delivery schedule information and from a particular entry of the particular delivery schedule table that corresponds to the delivery destination;
based on the delivery schedule information extracted from the particular entry, generating an indication including delivery time information relating to the particular product;
incorporating the indication into the web content; and
transmitting the web content over the network for display on the user device.
2. The computer-implemented method of claim 1 , wherein a total number of the plurality of delivery schedule tables is less than a total number of the plurality of products sold on the e-commerce platform.
3. The computer-implemented method of claim 1 , wherein the replying occurs within a timing constraint associated with providing the web content during a user's real-time online interaction with the e-commerce platform.
4. The computer-implemented method of claim 1 , wherein the information related to the delivery destination associated with the user device is an Internet Protocol address of the user device.
5. The computer-implemented method of claim 1 , wherein:
the extracting comprises: using the identifier to consult the mapping of each of the plurality of products to a respective one of the plurality of delivery schedule tables, to determine a delivery schedule table of the plurality of delivery schedule tables that corresponds with the particular product, and using the delivery destination to extract the delivery schedule information from the delivery schedule table.
6. The computer-implemented method of claim 1 , wherein different delivery schedule tables correspond to different product characteristic categories.
7. The computer-implemented method of claim 6 , wherein the different product characteristic categories include different weight categories, each of the weight categories defining a different weight range.
8. The computer-implemented method of claim 1 , wherein different delivery schedule tables correspond to different fulfillment center location categories.
9. The computer-implemented method of claim 1 , wherein the plurality of delivery schedule tables and the mapping are updated to reflect a current version of the plurality of delivery schedule tables and a current version of the mapping, and wherein the update of the delivery schedule tables occurs at a different frequency from the update of the mapping.
10. The computer-implemented method of claim 9 , wherein at least one of the plurality of delivery schedule tables is updated in response to expired delivery time information, and wherein the mapping is updated in response to a particular inventory change.
11. The computer-implemented method of claim 10 , wherein in response to inventory for a given product at a particular fulfillment center dropping to zero or dropping below a threshold, the mapping is updated to no longer map the given product to the respective delivery schedule table to which the given product was mapped.
12. The computer-implemented method of claim 11 , wherein the given product is instead mapped to a different delivery schedule table.
13. A system comprising:
at least one processor; and
a memory storing processor-executable instructions that, when executed, cause the at least one processor to:
store, in the memory, a data structure comprising:
a plurality of delivery schedule tables, and
a mapping of each of a plurality of products sold on an e-commerce platform to a respective one of the plurality of delivery schedule tables,
wherein each of the plurality of delivery schedule tables corresponds to a respective category, of a plurality of categories, to which multiple ones of a plurality of products map, and wherein each entry of each of the plurality of delivery schedule tables stores pre-computed delivery schedule information, for the respective category, for each destination of a plurality of destinations;
receive, from a user device over a network during an online interaction by a user with the e-commerce platform, a request for web content associated with a particular product of the plurality of products sold on the e-commerce platform; and
reply to the request during the online interaction in real time, wherein the step of replying comprises:
obtaining, from the request for web content, information related to a delivery destination associated with the user device and an identifier that uniquely identifies the particular product;
identifying a particular delivery schedule table, of the plurality of delivery schedule tables in the memory, to which the particular product maps based on the identifier, wherein the particular delivery schedule table corresponds to a particular category of the particular product;
extracting delivery schedule information from a particular entry of the particular delivery schedule table that corresponds to the delivery destination;
based on the delivery schedule information extracted from the particular entry, generate an indication including delivery time information relating to the particular product;
incorporating the indication into the web content; and
transmitting the web content over the network for display on the user device.
14. The system of claim 13 , wherein a total number of the plurality of delivery schedule tables is less than a total number of the plurality of products sold on the e-commerce platform.
15. The system of claim 13 , wherein the step of replying occurs within a timing constraint associated with providing the web content during a user's real-time online interaction with the e-commerce platform.
16. The system of claim 13 , wherein:
the step of extracting comprises: using the identifier to consult the mapping of each of the plurality of products to a respective one of the plurality of delivery schedule tables, to determine a delivery schedule table of the plurality of delivery schedule tables that corresponds with the particular product, and using the delivery destination to extract the delivery schedule information from the delivery schedule table.
17. The system of claim 13 , wherein different delivery schedule tables correspond to different product characteristic categories.
18. The system of claim 13 , wherein the plurality of delivery schedule tables and the mapping are updated to reflect a current version of the plurality of delivery schedule tables and a current version of the mapping, and wherein the update of the delivery schedule tables occurs at a different frequency from the update of the mapping.
19. The system of claim 13 , wherein the information related to the delivery destination associated with the user device is an Internet Protocol address of the user device.
20. The system of claim 13 , wherein different delivery schedule tables correspond to different fulfillment center location categories.
21. The system of claim 13 , wherein the plurality of delivery schedule tables and the mapping are updated to reflect a most current version of the plurality of delivery schedule tables and a most current version of the mapping, and wherein the update of the delivery schedule tables occurs at a different frequency from the update of the mapping.
22. The system of claim 21 , wherein at least one of the plurality of delivery schedule tables is updated in response to expired delivery time information, and wherein the mapping is updated in response to a particular inventory change.
23. A non-transitory computer readable medium having stored thereon computer-executable instructions that, when executed by a computer, cause the computer to perform operations comprising:
storing, in a memory, a data structure comprising:
a plurality of delivery schedule tables, and
a mapping of each of a plurality of products sold on an e-commerce platform to a respective one of the plurality of delivery schedule tables,
wherein each of the plurality of delivery schedule tables corresponds to a respective category, of a plurality of categories, to which multiple ones of a plurality of products map and wherein each entry of each of the plurality of delivery schedule tables stores pre-computed delivery schedule information, for the respective category, for each destination of a plurality of destinations;
receiving, from a user device over a network during an online interaction by a user with the e-commerce platform, a request for web content associated with a particular product of the plurality of products sold on the e-commerce platform; and
replying to the request during the online interaction in real time, the replying comprising:
obtaining, from the request for web content, information related to a delivery destination associated with the user device and an identifier that uniquely identifies the particular product;
identifying a particular delivery schedule table, of the plurality of delivery schedule tables in the memory, to which the particular product maps based on the identifier, wherein the particular delivery schedule table corresponds to a particular category of the particular product;
extracting delivery schedule information from a particular entry of the particular delivery schedule table that corresponds to the delivery destination;
based on the delivery schedule information extracted from the particular entry, generating an indication including delivery time information relating to the particular product;
incorporating the indication into the web content; and
transmitting the web content over the network for display on the user device.