I am a small merchant and use JAC as my shopping cart but feel reporting is too limited and finding a particular order is a pain based on the shipping name or Item.
I am looking for a shopping cart but could not find anything that can export data in excel or access database.
I will be happy if online reporting of orders show at least following fields Ordernumber, date, Item, Qty, Amount paid etc.
I would also like something online where I can type some comments about orders for reference purpose like credit card declined etc. Having online search feature may be a bonus.
My current software is dumb and there is no reporting at all. With the increase in number of orders, finding a particular order is real pain. If an order needs follow up later, there is no way to type comments and their upgraded version does not import Item name but I need that feature if I am looking for a particualr order for that product.
I normally try to not post a specific but you did ask. I use StoreFront [storefront.net]. It comes in several flavors from Access DB to SQL. It is highly customizeable. It comes with a great support newsgroup. It has built in backend to work with Quickbooks. Reports give what you requested also.