OpenCart Community

I am not sure if this is the correct place to post this so I apologize if not but I was interested in getting opencart integrated with my point of sale software to provide online ordering for our customers. we have several individuals already interested in that and I wasn't sure where I could find the documentation regarding the database structure that opencart sets up. Whether it would be possible to just make changes to the database that opencart uses directly or would there have to be a script software written as well to pass any changes to the software through that method?

Hi Polarpos
You will need to post what the requirements of your POS software are in relation to getting information from an external source whether that be opencart or any other "sale gathering" application.
I have a strong interest in POS integration and look forward to seeing how you go with this.
Regards
Kym

We need UPC/Model #/Part #, Price (per product), Category/Fineline, Current Quantity, Description of Product, Vendor, All vendor contact information. We aren't sure how exactly all this is done within the opencart database.

polarpos wrote:We need UPC/Model #/Part #, Price (per product), Category/Fineline, Current Quantity, Description of Product, Vendor, All vendor contact information. We aren't sure how exactly all this is done within the opencart database.

Name of your POS??

Polar POS

This would take custom development because there is no extension that will suit any type of POS.

Is there any database schema available?

any further development of this?

thanks

A POS for opencart is available here.
http://www.opencart.com/index.php?route ... n_id=11943

polarpos wrote:Is there any database schema available?

Yes, database schema is available.

You can see the OC schema, tables, fields, records, layout, content, and whatnot else that you may or may not be aware of by the simple expedient of installing OC and via phpMyAdmin opening the database. There are additional ways, but that one is expediently pointy-clicky. That question leads me to guess that you don't have anyone there who is currently ready to grapple with databases independently of ready-to-run and running software, and you drew the short straw for going public to ask.

As for "POS", caveat emptor, there are two kinds, the real deal that goes varroom and zooms on the counter, and peddle-it-yourself bicycles. A "POS" that is not merely hand-entered by keyboard into boxes rather than onto scribblepaper will entail, as "POS" traditionally means, communication between a glorified cash register and a computer and a (shudder) database, as seen for 20-odd years, now, in restaurants, department stores, and other fine establishments. THAT, as avvici -arvixe- indicated above, is NOT available for OC; with the possible exception of http://www.kassanova.org/en/supported-w ... r-opencart if it yet exists (haven't been able to see it on-line).

In order to deal with an OC database and a POS database at once, you would need to open them both, see what the tables, fields, and typical records are, and begin to manipulate those as required for dual purposes. On the other hand, mere bean counters deserve to use pencils and paper, to take their time and attention off screwing everything up.

possibly Unicenta:

http://ehc.ac/p/unicentaopos/discussion ... /b54dc51e/

Kassanova at least knows and cares about OC and carts. Unicenta seems not to know or care about OC or carts.

one concern is that the pos should be open source

we'd need to assure our customers that no snooping is going on

Most normal pos software is not open source. Commercial versions from Stateside or similarly situated places (unlike hotbeds of wrongdoing here and there around the world) would not embed snooping, would not be worth the risks.

We've all wondered at one time or another just exactly what the 'ell MS, Adobe, or other outfits with severely bloated and convoluted code might be up to. Quite a while back, long after reverse-engineering was routinely considered foul play even as the huge companies could still do it and one suspects did do it, we could easily look inside compiled code and see chatter that did NOT need to be there and was NOT always properly escaped. (There was a free code viewer; published by one of the bigshots; no longer available; oddly enough.) Those of us who began writing code with limits of a few kb probably universally resent the bloat, it is not premium code. On the other hand, the bloat has fostered increasing need for faster chips, bigger ram, faster and bigger drives, etc., and prices have actually fallen through time relative to bang per buck. Early gigs of anything were dreadfully expensive, now a terawhatever is modestly priced. The industries' plowback rates have been remarkable. Had the automotive industry made computers, we would still be agreeing how wonderful these XT machines are, and the 286 would still be an eXperiMental wowEE. The XP and 286 would, of course, also be OSHA approved for safety and have smog devices, electronics, and fuel injection that wouldn't work.

Today we have a further one pending, "POS OpenCart" -- see both
http://forum.opencart.com/viewtopic.php ... 43#p429543 in Spanish
http://forum.opencart.com/viewtopic.php ... 44#p429544 in English

thanks

Now three (English just above included):
http://forum.opencart.com/viewtopic.php ... 44#p429544
http://www.opencart.com/index.php?route ... search=pos
http://www.opencart.com/index.php?route ... search=pos

We have a new one available, http://en.microinvest.net/EN/Software-i ... ehouse-Pro, with integration in http://en.microinvest.net/News/Open-Cart-Integration. Both are linked to from new Live thread http://forum.opencart.com/viewtopic.php?f=11&t=113036 for debut of his new live http://shop.dreams-bg.com/ . . .

New one: http://forum.opencart.com/viewtopic.php?f=123&t=114647