Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How Reporting is done in OS Shopping Cart?


Pranesh

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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."

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

:heart:, osCommerce

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

 

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.

Link to comment
Share on other sites

"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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...