The grand vision

It will take some time to actually create a complete solution:

Phase 1: Data access

in the first phase I concentrate mainly on data retrieval

• lists - tool to retrieve flat tables with any data. Ability to join different data together
• summary lists - tool to summarize lists - group list data together, for example sales by category
• xml - tool to retrieve data in hierarchical / xml structure. Ideal format for integration with third-party services
• cross-tabulation - tool to create reports, such as sales by category by week

Phase 2: Data extension

In the second phase I will provide ability to enrich your data. This will allow you to track additional informations on your products, categories, customers,…

• custom fields - easily add new fields to any record in the system. For example associate your products with Amazon SKU identifier
• custom relations - create new relations between records. For example link together products that sells together
• custom records - ability to create whole new records. For example, you can create a secondary category tree for reporting purpose only

Phase 3: Data modification

In phase three it will be the time to add support for data modification

• inline editing - you will be able to change field values directly from the list. For example rename product name, increate price,…
• mass editing - change multiple values at once. For example, increase price of selected products by 20%
• custom forms - create a special input form for you records, to speed up data entry.

Phase 4: Import

The last phase will revolve around data entry and import from external sources

• xml and csv data import - map data in xml and csv files to records
• scheduled import - import data on regular basis

additional supporting functionality

• scheduling - run export / import / data modification on regular basis
• url endpoints - expose data via custom url, for integration purposes
• amazing UI