Link external DB MySQL DB to OSCommerce

Posted on 2014-08-18
Last Modified: 2014-09-12
I need to integrate the inventory section of PC Repair Tracker
to an OSCommerce store front.

How do I do that?
Question by:Bob Stone
    LVL 24

    Expert Comment

    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.
    LVL 12

    Author Comment

    by:Bob Stone
    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 24

    Accepted Solution

    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



    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 24

    Expert Comment

    Have you finally reach them?
    Have you check  Opencart if it's suit your needs?
    LVL 12

    Author Closing Comment

    by:Bob Stone
    Opencart is working well. Thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit ( and similar technologies have enjoyed wide adoption, making it possib…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now