Magento 1.x – Database Tables with Product Data

databasemagento-1producttable

Which tables are the ones in the database that have all the product data in a Magento 1.x system?

Main table for products in magento:

catalog_product_entity

Above table is an act as main table, for that child tables are staring with “catalog_product_entity_” prefix.

catalog_product_entity_datetime – Product – date attribute are stored here. Ex: New From, New To
catalog_product_entity_decimal – Product price related values.
catalog_product_entity_gallery
catalog_product_entity_int – Product Status, Visiblity etc..
catalog_product_entity_media_gallery – product images path, Thumb , small, etc
catalog_product_entity_media_gallery_value – Product image,product image position, title info & position of image info, etc
catalog_product_entity_tier_price – Product tier product
catalog_product_entity_varchar – Product name, URL, etc

Bundled product – information: Will get bundled product associated values from below table

Related to downloaded product information.

Product custom option information will get from below tables

Configurable product and Grouped product information will get it from below tables

Source: jutesenthil

Try the --cleanup-database in magento command line tool. Documentation

You have to just export non magento database in csv format and convert your csv to magento related format to fast import in magento.

You have to manage your csv related to magento specific, saves your time and energy.

For Magento specific product and customer csv, You just need to export csv for each product and customer from

System -> Data Transfer -> Export

To check magento specific csv.

If you want to create custom script for each customer and product import you need to give more time and energy to workout.

If possible make csv file and use default magento admin import functionality.