The grand vision
see what is the master plan and what's in the future
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