Moving data from Magento to osCommerce

[Guest]

I'm looking for a solution to import product data and images from magento to oscommerce, all I can find is the reverse. I have phpmyadmin access to both database. Any help would be greatly appraciated.

Thanks

[♥toyicebear]

If you export out the data in csv format, you could possibly then manipulate the format so that you could import it with Easy Populate

[Guest]

@@izzyfox

 

The only thing I can suggest is to export the database in CSV format and use Easy Populate to map the fields and import it into the osCommerce database

 

 

 

Chris

 

edit: yep, what Nick Said....lol

[Guest]

I was afraid someone would say that :(

You guys know how osCommerce stores product data, descriptions, images, etc....

Somewhere I can find which tables, fields, etc.? Version 2.3.3

[Guest]

@@izzyfox

 

The tables are labelled accordingly. The products table is structured like this: (example only)

 

--

DROP TABLE IF EXISTS products;

CREATE TABLE products (

products_id int NOT NULL auto_increment,

products_quantity int(4) NOT NULL,

products_model varchar(12),

products_image varchar(64),

products_price decimal(15,4) NOT NULL,

products_date_added datetime NOT NULL,

products_last_modified datetime,

products_date_available datetime,

products_weight decimal(5,2) NOT NULL,

products_status tinyint(1) NOT NULL,

products_tax_class_id int NOT NULL,

manufacturers_id int NULL,

products_ordered int NOT NULL default '0',

PRIMARY KEY (products_id),

KEY idx_products_model (products_model),

KEY idx_products_date_added (products_date_added)

);

 

Which works in conjunction with this table:

 

DROP TABLE IF EXISTS products_description;

CREATE TABLE products_description (

products_id int NOT NULL auto_increment,

language_id int NOT NULL default '1',

products_name varchar(64) NOT NULL default '',

products_description text,

products_url varchar(255) default NULL,

products_viewed int(5) default '0',

PRIMARY KEY (products_id,language_id),

KEY products_name (products_name)

);

 

And, if you have multiple images, this:

 

DROP TABLE IF EXISTS products_images;

CREATE TABLE products_images (

id int NOT NULL auto_increment,

products_id int NOT NULL,

image varchar(64),

htmlcontent text,

sort_order int NOT NULL,

PRIMARY KEY (id),

KEY products_images_prodid (products_id)

);

 

There are others as well, depending on attributes. You can see the complete database structure by looking at the oscommerce.sql file in the /catalog/install/ folder of the v2.3.3 download

 

 

 

Chris

[Guest]

right on Chris, thanks much, don't suppose you know where the product image directories are?

I see me having to do uploads manually as the Magento directory and naming structure for product image files

is quite ridiculous.

[Guest]

@@izzyfox

 

 

All product images are loaded into the /images directory on your server.

 

 

 

Chris

[quetevendo]

If you do not know how I recommend you hire a professional to do it. In "Saint Google" using the following search criteria "magento to oscommerce ".

[Galya]

Hello izzyfox,

 

Have you seen cart2cart? It sounds like they do exactly what you need. Check this

for details

I moved virtuemart 1 store to osc and everything went ok. However, think twice before migrating. I had some problems with my SEO after migration since they do not move links and I had to do 301 redirects and many other stuff. It is actually not their fault it is a general issue when you move from one cart to another. But still you have to plan that beforehand to be ready to handle some seo consequences of store migration.

 

Good luck =)

[Atwoodz-eCommerce]

You would need to have someone write a custom script to get it right the first time. There are so many version of Magento and osC that you need a custom script to make sure the products go to the correct categories and sub-categories, plus you have product descriptions, attributes and meta data that you may want to bring over.

 

Will it hurt your SEO? I don't know...no one does. That has a lot to do with the structure of the new website. I have seen website lose some rankings initially, but recover many times better because the new site has all around better structure. I would always recommend using a development site and running on-page and other crawlers to insure a smooth transition and to make sure the optimization is dialed-in prior to launch.

 

There are some higher level techniques used for these website changes, that will all but guarantee that optimization is not lost, but it is far out of the budget for the general store owner. Atwoodz uses some of these techniques to transfer and keep the optimization, but there is quite a bit of "sticker shock" when people see the costs for such a custom fix.

 

As mentioned in the previous post, have a great plan and follow through with it.

 

Matt