Link external DB MySQL DB to OSCommerce

I need to integrate the inventory section of PC Repair Tracker http://pcrepairtracker.com/page/?ap_id=pcrt
to an OSCommerce store front.

How do I do that?
LVL 9
Bob StoneIT GuruAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lenamtlCommented:
PC Repair Tracker is a premium application so it is hard to guide you how to integrate the data.

Are you using OScommerce for long time or it's new?
Beacaude I don't recommend to use Oscommerce, it is not well coded and it's really a pain to work with.

Opencart, Magento will be a better solution to my opinion.

Do you need just to import once the data or you need to have both application to get updated in realtime?
For one time data importation you will need to check both database and create a csv file that will merge the data to the oscommerce fields.

If it's real time updates you will need to find out if a bridge already exist or hire a freelance to make one.

Ask PC Repair Tracker for help they can provide you some guideline and maybe they have a solution ready for your needs.
0
Bob StoneIT GuruAuthor Commented:
PC Repair Tracker is fairly new and already has a bunch of data in it. OSCommerce is new too but nothing in it so far. I've signed up for PC Repair Tracker forum but haven't been approved or whatever by the admin and don't know how to contact them.

Which would be best for this, OpenCart or Magento? Which is easier to use on the backend?
0
lenamtlCommented:
Opencart is very easy to set, very easy to adapt I like the option to use Vqmod for my custom code this is not aftecting the core.
A lot of very nice template on themeforest for it.

You can instal it and try it
http://www.opencart.com

demo: http://www.opencart.com/index.php?route=demonstration/demonstration

vqmod: https://code.google.com/p/vqmod/

Magento can be a little harder to customize and usualy cost more to have extension or custom code.
Also requires high end servers.

it's always depending of your needs.

To contact PC repair check in the file usually you have the support email address or try their contact form ;)
http://pcrepairtracker.com/page/contact-us/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lenamtlCommented:
Have you finally reach them?
Have you check  Opencart if it's suit your needs?
0
Bob StoneIT GuruAuthor Commented:
Opencart is working well. Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.