System and method for storing and displaying returned goods information
A system, a method, and computer readable medium for storing and displaying user-selected returned goods information for a retailer having a plurality of stores and a plurality of vendors. The system, method and computer readable medium includes a computer database of returned goods information for a retailer having a plurality of stores and a plurality of vendors. A user interface receives at least one condition for displaying user-selected returned goods information for one or more of the plurality of stores or one or more of the plurality of vendors. The system, method and computer readable medium determines whether the condition for displaying the returned goods information is satisfied for each of the plurality of stores and each of the plurality of vendors. The system, method and computer readable medium displays returned goods information for which the condition is met for each of the plurality of stores and each of the plurality of vendors.
1. A method of processing returned goods information for a plurality of retailers having a plurality of stores selling a plurality of goods purchased from a plurality of vendors, the method comprising:
creating a plurality of retailer computer databases, wherein each of the plurality of retailer computer databases includes returned goods information for each of the plurality of retailers;
aggregating each of the plurality of retailer computer databases into an aggregated computer database of returned goods information based upon an extract-transform-load process comprising
extracting, at each of a plurality of scheduled time periods, the returned goods information from each of the plurality of retailer computer databases,
transforming the returned goods information from each of the plurality of retailer computer databases to a common format,
processing, the extracted and transformed returned goods information in batches to a staging database, and
loading the processed extracted returned goods information from the staging database to the aggregated computer database by bulk inserting multiple processed rows from the staging database into the aggregated computer database,
the aggregated computer database comprising returned goods information, item master files, and vendor master files from at least two of the plurality of retailer computer databases;
associating the returned goods information for each of the plurality of retailers stored in the aggregated computer database with a predefined time period for each of the plurality of retailers and enabling displaying of returned goods information for each of the plurality of retailers for the predefined time period; and
permitting access to the associated returned goods information stored in the aggregated computer database by a corresponding one of the plurality of retailers for the displaying of the returned goods information.
2. The method of claim 1 , wherein the returned goods information comprises at least one of a store identifier, number of units of goods returned, cost of the goods, retail price of goods, total value of goods returned to store, total value of store credits, store department, store category, returned goods vendor identifier, return goods vendor name, goods identifier, goods description, goods disposition, and handling charges.
3. The method of claim 1 , wherein creating the plurality of retailer computer databases comprises creating a plurality of retailer databases each comprising store credit information, invoice information, item information, disposition information, and shipping information.
4. A non-transitory computer readable medium having stored thereon instructions for accessing and managing a plurality of remote computers which, when executed by a processor, cause the processor to:
create a plurality of retailer computer databases, wherein each of the plurality of retailer computer databases includes returned goods information for each of the plurality of retailers;
aggregate each of the plurality of retailer computer databases into an aggregated computer database of returned goods information based upon an extract-transform-load process comprising instructions for causing the processor to
extract, at each of a plurality of scheduled time periods, the returned goods information from each of the plurality of retailer computer databases,
transform the returned goods information from each of the plurality of retailer computer databases to a common format,
process, the extracted and transformed returned goods information in batches to a staging database, and
load the processed extracted returned goods information from the staging database to the aggregated computer database by bulk inserting multiple processed rows from the staging database into the aggregated computer database,
the aggregated computer database comprising returned goods information, item master files, and vendor master files from the plurality of retailer computer databases;
associate the returned goods information for each of the plurality of retailers stored in the aggregated computer database with a predefined time period enabling displaying of returned goods information for each of the plurality of retailers for the predefined time period; and
permit access to the associated returned goods information stored in the aggregated computer database by a corresponding one of the plurality of retailers for the displaying of the returned goods information.
5. The method of claim 1 wherein the plurality of scheduled time periods comprises hourly.
6. The non-transitory computer readable medium of claim 4 wherein the instructions cause the processor to create the plurality of retailer databases each comprising store credit information, invoice information, item information, disposition information, and shipping information.
7. The non-transitory computer readable medium of claim 4 wherein the plurality of scheduled time periods comprises hourly.
8. A method of processing returned goods information for a plurality of retailers having a plurality of stores selling a plurality of goods purchased from a plurality of vendors, the method comprising:
creating a plurality of retailer computer databases, wherein each of the plurality of retailer computer databases includes returned goods information for each of the plurality of retailers;
aggregating each of the plurality of retailer computer databases into an aggregated computer database of returned goods information based upon an extract-transform-load process comprising
extracting, at each of a plurality of scheduled time periods, the returned goods information from each of the plurality of retailer computer databases,
transforming the returned goods information from each of the plurality of retailer computer databases to a common format,
processing, the extracted and transformed returned goods information in batches to a staging database, and
loading the processed extracted returned goods information from the staging database to the aggregated computer database by inserting single rows and columns of returned goods information into the aggregated computer database,
the aggregated computer database comprising returned goods information, item master files, and vendor master files from at least two of the plurality of retailer computer databases;
associating the returned goods information for each of the plurality of retailers stored in the aggregated computer database with a predefined time period for each of the plurality of retailers and enabling displaying of returned goods information for each of the plurality of retailers for the predefined time period; and
permitting access to the associated returned goods information stored in the aggregated computer database by a corresponding one of the plurality of retailers for the displaying of the returned goods information.
9. The method of claim 8 , wherein the returned goods information comprises at least one of a store identifier, number of units of goods returned, cost of the goods, retail price of goods, total value of goods returned to store, total value of store credits, store department, store category, returned goods vendor identifier, return goods vendor name, goods identifier, goods description, goods disposition, and handling charges.
10. The method of claim 8 , wherein creating the plurality of retailer computer databases comprises creating a plurality of retailer databases each comprising store credit information, invoice information, item information, disposition information, and shipping information.
11. The method of claim 8 wherein the plurality of scheduled time periods comprises hourly.
12. A non-transitory computer readable medium having stored thereon instructions for accessing and managing a plurality of remote computers which, when executed by a processor, cause the processor to:
create a plurality of retailer computer databases, wherein each of the plurality of retailer computer databases includes returned goods information for each of the plurality of retailers;
aggregate each of the plurality of retailer computer databases into an aggregated computer database of returned goods information based upon an extract-transform-load process comprising instructions for causing the processor to
extract, at each of a plurality of scheduled time periods, the returned goods information from each of the plurality of retailer computer databases,
transform the returned goods information from each of the plurality of retailer computer databases to a common format,
process, the extracted and transformed returned goods information in batches to a staging database, and
load the processed extracted returned goods information from the staging database to the aggregated computer database by inserting single rows and columns of returned goods information into the aggregated computer database,
the aggregated computer database comprising returned goods information, item master files, and vendor master files from the plurality of retailer computer databases;
associate the returned goods information for each of the plurality of retailers stored in the aggregated computer database with a predefined time period enabling displaying of returned goods information for each of the plurality of retailers for the predefined time period; and
permit access to the associated returned goods information stored in the aggregated computer database by a corresponding one of the plurality of retailers for the displaying of the returned goods information.
13. The non-transitory computer readable medium of claim 12 wherein the instructions cause the processor to create the plurality of retailer databases each comprising store credit information, invoice information, item information, disposition information, and shipping information.
14. The non-transitory computer readable medium of claim 12 wherein the plurality of scheduled time periods comprises hourly.