[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Link external DB MySQL DB to OSCommerce

Posted on 2014-08-18
Medium Priority
Last Modified: 2014-09-12
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?
Question by:Bob Stone
  • 3
  • 2
LVL 27

Expert Comment

ID: 40270706
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.

Author Comment

by:Bob Stone
ID: 40270808
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?
LVL 27

Accepted Solution

lenamtl earned 2000 total points
ID: 40271476
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

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 ;)
LVL 27

Expert Comment

ID: 40319648
Have you finally reach them?
Have you check  Opencart if it's suit your needs?

Author Closing Comment

by:Bob Stone
ID: 40319696
Opencart is working well. Thanks

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Ranking ecommerce websites is a vital process. You need to have a strong SEO (Search Engine Optimization) strategy. If you don’t have one, you are losing out on brand impressions, clicks and sales. Check this guide on how to improve website traffic …
The viewer will learn how to count occurrences of each item in an array.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
Suggested Courses
Course of the Month19 days, 9 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question