Pranesh Posted November 28, 2002 Posted November 28, 2002 Hi: I wonder whether the osCommerce shopping Cart supports all kind of reporting like Inventory Control, Product Order,Sales Report, Slow Moving items list, List of Highest selling Product etc. Thank you and appreciate for your reply. Regards, Pranesh
Ajeh Posted November 28, 2002 Posted November 28, 2002 There are a few reports under Tools ... and if you look in the contributions there are a few more that might be of interest.
zzfritz Posted November 28, 2002 Posted November 28, 2002 Some of us are working on additional reports, but first you have to figure out where in the database the necessary information is and then it bring some SQL expertise to the subject. I posted a request for assistance to create a simple monthly sales and tax report, but no one has come forward. This is an area that needs substantial improvement.
Jan0815 Posted November 28, 2002 Posted November 28, 2002 This is an area that needs substantial improvement. That depends on your expectations. When you start seeing osCommerce as the complete-all-in-one solution you are right. But osCommerce was always defined as a webshop frontend solution - not a complete backend system. You can't have everything. That's why trains have difficulty crossing oceans, and hippos did not adapt to fly. -- from the OpenBSD mailinglist.
zzfritz Posted November 28, 2002 Posted November 28, 2002 Why shouldn't osC be all that it can be? Raise your expectations, for I will not lower mine. Even if we don't add a whole suite of business reports, we at least need to conveniently export the valuable data to a "complete backend system."
Jan0815 Posted November 28, 2002 Posted November 28, 2002 Why shouldn't osC be all that it can be? Because we are not a big company, just a small team of people doing this mainly in unpaid spare time. And there are so many different legislations aout there that one must know and understand. A report that is perfectly legal in USA might be illegal in Europe or Nepal. Raise your expectations, for I will not lower mine. Then either start coding or start paying people like us that are actually doing the job ;-) Even if we don't add a whole suite of business reports, we at least need to conveniently export the valuable data to a "complete backend system." Right. When will we see your contribution? ;-) Jan Wildeboer You can't have everything. That's why trains have difficulty crossing oceans, and hippos did not adapt to fly. -- from the OpenBSD mailinglist.
Jan0815 Posted November 28, 2002 Posted November 28, 2002 This is not meant to lower your expectations though. We all share the vision that osCommerce will become the perfect solution in the future. We are always open for suggestions, though we prefer sourcecode ;-) With the current structure of osCommerce 2.2-CVS the ful-blown backend solution is something that requires a lot of work. But maybe we can collect suggestions for 3.0? You can't have everything. That's why trains have difficulty crossing oceans, and hippos did not adapt to fly. -- from the OpenBSD mailinglist.
Harald Ponce de Leon Posted November 28, 2002 Posted November 28, 2002 With the current structure of osCommerce 2.2-CVS the ful-blown backend solution is something that requires a lot of work. But maybe we can collect suggestions for 3.0? Simple reports will not be a problem as one of the tasks on the Current Tasks list for 2.2 is to make the Tools->Reports section modular. Who knows what sort of reports could be contributed once this feature is implemented :D , osCommerce
Harald Ponce de Leon Posted November 28, 2002 Posted November 28, 2002 Simple reports will not be a problem as one of the tasks on the Current Tasks list for 2.2 is to make the Tools->Reports section modular. Sorry! The Reports section is a section in itself, it's not in the Tools section :P , osCommerce
jon_l Posted November 28, 2002 Posted November 28, 2002 Making reporting functionality modular will be an excellent step. Though maybe some form of general reporting tool would be better - with the option of saving commonly used reports. I wouldn't of thought this would be too difficult, as I imagine most of the required code already exists. One big issue I still have is finding the time to write mods. When I do have spare time for OSC, most of it is spent applying the latest CVS to my shops and merging in the currently installed mods. I'm sure its the same for a lot of people. The sooner we can get more of the excellent mods merged in with the CVS the better. And I realise the devs are very busy (and doing an excellent job), this is a comment, not a complaint. Jon. PS, Jan - you may want to update your signature as technically Eurostar does actually 'cross' the English Channel. I realise it goes under it, but it still crosses the ocean. As far as I am aware, Hippos are still not flying though.
zzfritz Posted December 1, 2002 Posted December 1, 2002 Right. When will we see your contribution? ;-) Jan Wildeboer Right now: http://www.oscommerce.com/downloads.php/co...ions,746/type,3 This is the sales and tax report for which I sought help, but got none and had to learn on my own. All I got was a discouraging rant about how reports that are legal in the US might not be legal elsewhere (is that a reason not to write them?). So, if you fear my report is verboten in your jurisdiction, just look the other way.
Jan0815 Posted December 1, 2002 Posted December 1, 2002 I will :-) But at least my rant moved you from a user to a developer! Congrats and have fun with osCommerce ;-) You can't have everything. That's why trains have difficulty crossing oceans, and hippos did not adapt to fly. -- from the OpenBSD mailinglist.
zzfritz Posted December 1, 2002 Posted December 1, 2002 "But at least my rant moved you from a user to a developer!" It did not. I was determined to do it anyway. Your posts were not encouraging or helpful at all. I had been seeking some guidance, or any information at all, on the database queries. And when I stated improvement was needed, you took it as a personal affront to the core developers and not as it was intended: that we work for enhancement and extension of osC as a community. And note that this message is personal, not posted. Don't feel obliged to respond.
rseigel Posted December 1, 2002 Posted December 1, 2002 And note that this message is personal, not posted. Don't feel obliged to respond. Looks like that didn't work out as intended. :roll:
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.