First of all the tables are the same. The only thing what was changes is the name and ofcourse some contributions which was installed.
For an example we use the manufacturers table: ( We just export the table in phpMyAdmin)
This is the MarvikShop table
CREATE TABLE IF NOT EXISTS `#__osc_manufacturers` (
`manufacturers_id` int(11) NOT NULL auto_increment,
`manufacturers_name` varchar(32) NOT NULL,
`manufacturers_image` varchar(64) default NULL,
`date_added` datetime default NULL,
`last_modified` datetime default NULL,
PRIMARY KEY (`manufacturers_id`),
KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=87 ;
And this is the Oscommerce table
CREATE TABLE IF NOT EXISTS `#__manufacturers` (
`manufacturers_id` int(11) NOT NULL auto_increment,
`manufacturers_name` varchar(32) NOT NULL,
`manufacturers_image` varchar(64) default NULL,
`date_added` datetime default NULL,
`last_modified` datetime default NULL,
PRIMARY KEY (`manufacturers_id`),
KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
As you can see the only thing is jos_osc_manufacturers and manufacturers.
It's very easy to copy your tables from OSCommerce to MarvikShop
Just rename the table and import your data in the MarvikShop tables.
dont forget to BACKUP FIRST!!
Go to the admin menu.
configuration-> mystore -> look for: This is the flag for the categories block on the home page.
Set it off and update the page.
No categories block on the homepage anymore.
We did not test it. But with some database changes in the program it should be no problem.
Joomla tables start with jos_
For the table product from Marvikshop ( oscommerce) it start with
jos_osc_products.
jos_osc_product_description
etc.
Marvikshop tables are the same as Oscommerce. Ofcourse they are very modified because of all the constributions.