Generation and provision of directed sales incentives at locations remote from the point of sale
This invention is directed to a system and method for improving customer loyalty through direct sales incentive dissemination based on the customers past purchase history and items the store is offering at a reduced price. The additional services include providing the customer with a list of their preferred items, which are also on sale, without the customer needing to search for related coupons and the like.
1. A method performed by a processor which executes the method embodied as computer program code stored on a non-transitory computer useable medium, the method comprising:
receiving a dimensional database comprising a first plurality of tables comprising at least one first table comprising inventory items offered for sale at a reduced price, each of a second plurality of the first plurality of tables comprising a plurality of rows having at least one identifier attribute identifying the inventory items offered for sale at a reduced price, the second plurality comprising a third table comprising a plurality of rows, each of the plurality of rows of the third table comprising a reference to a row of at least one other table in the dimensional database;
following the receiving step:
fashioning at least one second table responsive to the at least one identifier attribute of at least one of the at least one first table of the dimensional database;
responsive to the identifier attribute of at least one row of the at least one second table, picking at least one row from the at least one first table of the dimensional database and a table produced responsive to at least a portion of the at least one first table of the dimensional database;
receiving an identifier of a first input table comprising at least a portion of one of the at least one first table, the first input table comprising a plurality of rows, at least one row of the first input table consisting of at least one selected from an item effective identifier and a user effective identifier; and
fashioning the third table comprising at least one row consisting of at least one selected from at least one identifier corresponding to the item effective identifier from at least one row of the first input table and at least one identifier corresponding to the user effective identifier from the at least one row of the first input table.
2. The method of claim 1 wherein the picking step comprises joining at least one row from the one selected from the at least one first table of the dimensional database with the table produced from the at least one first table of the dimensional database.
3. The method of claim 1 wherein the picking step comprises selecting at least one row from the one selected from the at least one first table of the dimensional database and the table produced from the at least one first table of the dimensional database.
4. The method of claim 1 comprising the additional step of picking, independently of the second table, at least one row from a table selected from at least one of the at least one first table of the dimensional database and the table produced responsive to the at least one first table of the dimensional database.
5. The method according to claim 4 additionally comprising the step of fashioning at least intermediate table from at least one of the at least one second table; and
wherein the picking step responsive to the portion of the at least one second table is additionally responsive to the at least one intermediate table.
6. A method performed by a processor which executes the method embodied as computer program code stored on a non-transitory computer useable medium, the method comprising:
receiving a dimensional database comprising a first plurality of tables comprising at least one first table comprising inventory items offered for sale, each of a second plurality of the first plurality of tables comprising a plurality of rows having at least one identifier attribute identifying the inventory items offered for sale at a reduced price, the second plurality comprising a third table comprising a plurality of rows, each of the plurality of rows of the third table comprising a reference to a row of at least one other table in the dimensional database;
following the receiving step:
fashioning at least one second table responsive to the at least one identifier attribute of the at least one first table of the dimensional database;
responsive to the identifier attribute of the at least one second table, picking at least one row from one selected from the at least one first table of the dimensional database and a table produced responsive to at least a portion of the at least one first table of the dimensional database;
receiving an identifier of a first input table comprising at least a portion of one of the at least one first table, the first input table comprising a plurality of rows, at least one row of the first input table consisting of at least one selected from an item effective identifier and a user effective identifier; and
fashioning the third table comprising at least one row consisting of at least one selected from at least one identifier corresponding to the item effective identifier from the at least one row of the first input table and at least one identifier corresponding to the user effective identifier from the at least one row of the first input table.
7. The method of claim 6 comprising the additional step of delivering the third table to a user corresponding to the user effective identifier.
8. The method of claim 6 wherein the delivery step comprises delivery of a computer-readable copy of the third table to the corresponding user.
9. The method of claim 6 wherein the delivery step comprises delivery of a printed copy of the third table to the corresponding user.
10. A method of improving customer relations performed by a processor which executes the method embodied as computer program code stored on a non-transitory computer useable medium, said method comprising:
receiving a dimensional database consisting essentially of at least one first table consisting of a plurality of rows having at least one inventory item attribute identifying an inventory item offered for sale and at least one customer identifier attribute comprising a customer identifier;
following the receiving step:
fashioning at least one second table responsive to the at least one inventory item attribute and the at least one customer identifier attribute of the at least one first table of the dimensional database;
receiving an inventory item identifier of a first input table consisting essentially of at least a portion of one of the at least one first table, the first input table comprising a plurality of rows, at least one row of the first input table comprising the inventory item identifier;
fashioning a third table comprising at least one row consisting of the inventory item identifier from the at least one row of the first input table, the at least one inventory item attribute from at least one row of the second table, and the at least one customer identifier attribute from the at least one row of the second table; and
informing the customer corresponding to the at least one customer identifier attribute of the third table of the data in said third table.
11. The method of claim 10 wherein the step of fashioning the at least one second table comprises an input of the at least one inventory item attribute and an input of the at least one customer identifier attribute corresponding therewith.