Anyone have any clever ideas on how to do this- databases/csv export isn't my big thing but I'm trying to help out a local public school.
They're having a carnival fundraiser- and in past years PTA parents have spent probably 40-80 hours tracking food pre-order forms that were physically filled out and ported into excel.
All I'm trying to do is:
1) Online signup for first/last name and quantites of several items (carnival tickets, hamburgers, etc) each with a price associated with it (ie hamburger @ $3 - quantity entered = 4 = $12)
2) Porting of this into CSV where 1 row is the registered person and each column is the label of 'things' (ie hamburger) and the registered quantity. Right most row gives the SUM TOTAL of $monies owed.
3) Ideally allow editing of submitted orders - not requred
4) A way to run a report showing current number of registrants (even if this just runs/compiles the CSV export and they view in excel.
Can something like Magento work for this? Ideally I'd like to customize something similarly designed- never worked with any traditional DB powered cart stuff before.
Any points in the right direction would be appreciated (and no, I cannot code the mysql/csv portion by hand hence the post/question)
They're having a carnival fundraiser- and in past years PTA parents have spent probably 40-80 hours tracking food pre-order forms that were physically filled out and ported into excel.
All I'm trying to do is:
1) Online signup for first/last name and quantites of several items (carnival tickets, hamburgers, etc) each with a price associated with it (ie hamburger @ $3 - quantity entered = 4 = $12)
2) Porting of this into CSV where 1 row is the registered person and each column is the label of 'things' (ie hamburger) and the registered quantity. Right most row gives the SUM TOTAL of $monies owed.
3) Ideally allow editing of submitted orders - not requred
4) A way to run a report showing current number of registrants (even if this just runs/compiles the CSV export and they view in excel.
Can something like Magento work for this? Ideally I'd like to customize something similarly designed- never worked with any traditional DB powered cart stuff before.
Any points in the right direction would be appreciated (and no, I cannot code the mysql/csv portion by hand hence the post/question)
