Import from OsCommerce

Open to all! Ask other shopowners for help.
Post Reply
AsTecModels
Member
Posts: 99
Joined: Wed Mar 18, 2026 6:20 pm
Phoenix Version: v1.1.0.6
Has thanked: 6 times
Been thanked: 3 times

Import from OsCommerce

Post by AsTecModels »

Hi All,

I currently have an OsCommerce website, and support is almost zero now.

Is it possible to import all the data? I currently have 1500 products and 5000 customers.

Any help would be appreciated with this.


Join The Code Co-op to get access to your library in the Code Co-op Forum
User avatar
burt
Core Team
Posts: 4546
Joined: Tue Oct 29, 2019 9:37 am
Phoenix Version: v1.1.0.8
Has thanked: 252 times
Been thanked: 412 times

Re: Import from OsCommerce

Post by burt »

Which version of osCommerce?
Is it the older v2.3 ? Or v4.

If 2.3 the process would be fairly straightforward.
If 4 the process might be slightly more difficult as the tables will likely be quite different.

I suppose .. give it a go ?

Your next step would be to access PHPMyAdmin and get the DB structure of these (from your oscommerce) to start with;

products
products_description

and compare to Phoenix's.

Same for other tables such as customers, customers_info, address_book and so on
Same for categories, manufacturers.
AsTecModels
Member
Posts: 99
Joined: Wed Mar 18, 2026 6:20 pm
Phoenix Version: v1.1.0.6
Has thanked: 6 times
Been thanked: 3 times

Re: Import from OsCommerce

Post by AsTecModels »

Hi Burt,
It is V4 that I have installed.
User avatar
burt
Core Team
Posts: 4546
Joined: Tue Oct 29, 2019 9:37 am
Phoenix Version: v1.1.0.8
Has thanked: 252 times
Been thanked: 412 times

Re: Import from OsCommerce

Post by burt »

osCommerce to Phoenix, is absolutely something you can do yourself with a bit of time and effort.
Your next step is to start comparing DB tables. Start with the easy one; customers

Otherwise contract a Dev to do it, there are a few.
One of which lives 20km away from you!
AsTecModels
Member
Posts: 99
Joined: Wed Mar 18, 2026 6:20 pm
Phoenix Version: v1.1.0.6
Has thanked: 6 times
Been thanked: 3 times

Re: Import from OsCommerce

Post by AsTecModels »

Thank you for your help so far.

Last question before I go play, which Dev do you mean to contact that is fairly local?


Join The Code Co-op to get access to your library in the Code Co-op Forum
Post Reply