Post by polarpos » Wed Jul 04, 2012 4:33 am

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?

pos


Newbie

Posts

Joined
Wed Jul 04, 2012 4:29 am


Post by voca » Wed Jul 04, 2012 8:07 pm

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

Active Member

Posts

Joined
Mon Aug 23, 2010 9:52 pm

Post by polarpos » Thu Jul 05, 2012 4:59 am

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.

pos


Newbie

Posts

Joined
Wed Jul 04, 2012 4:29 am


Post by celestial » Thu Jul 05, 2012 6:22 am

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??

Celestial - Martín Abel Rosales
Email: martinrosales2012@hotmail.com
Skype: martin.abel.rosales
San José , Costa Rica


User avatar
Expert Member

Posts

Joined
Sat Mar 20, 2010 4:19 am
Location - Costa Rica

Post by polarpos » Thu Jul 05, 2012 9:05 pm

Polar POS

pos


Newbie

Posts

Joined
Wed Jul 04, 2012 4:29 am


Post by Avvici » Sun Jul 08, 2012 3:12 pm

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

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by polarpos » Wed Aug 15, 2012 7:39 am

Is there any database schema available?

pos


Newbie

Posts

Joined
Wed Jul 04, 2012 4:29 am


Post by scanreg » Wed Oct 24, 2012 3:22 am

any further development of this?

thanks

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Post by whichone » Mon Apr 08, 2013 6:51 am

A POS for opencart is available here.
http://www.opencart.com/index.php?route ... n_id=11943
Last edited by whichone on Sat Jul 20, 2013 10:02 am, edited 1 time in total.

Opencart POS (Point of Sale, P.O.S.)


New member

Posts

Joined
Sun Apr 07, 2013 1:44 pm

Post by williamrichard » Mon Jul 08, 2013 7:52 pm

polarpos wrote:Is there any database schema available?
Yes, database schema is available.

MSAJAA | MSAJCE



Posts

Joined
Fri Jun 28, 2013 12:43 pm


Post by butte » Thu Aug 15, 2013 10:15 am

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.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by scanreg » Fri Aug 16, 2013 1:10 am


Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Post by butte » Fri Aug 16, 2013 7:45 am

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

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by scanreg » Fri Aug 16, 2013 11:13 pm

one concern is that the pos should be open source

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

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Post by butte » Fri Aug 16, 2013 11:44 pm

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.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by butte » Sun Aug 18, 2013 1:32 am

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

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by scanreg » Sun Aug 18, 2013 3:12 am

thanks :)

Active Member

Posts

Joined
Thu May 06, 2010 12:15 am

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by butte » Sat Oct 26, 2013 6:29 am

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

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am
Who is online

Users browsing this forum: No registered users and 4 guests