Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Here I have exported my Magento Advanced Import Dataflow Empty SQL Database. I wrote a PHP application to take values from various sources to create this master sheet. I then exported as csv and imported with no problems using the System->Import->Advanced Dataflows inside Magento
CREATE TABLE `master` (
`mst_id` int(100) NOT NULL AUTO_INCREMENT,
`store` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`websites` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`attribute_set` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
`type` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
`category_ids` int(50) NOT NULL,
`sku` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`has_options` int(50) NOT NULL,
`name` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
`meta_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta_description` text COLLATE utf8_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`small_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`thumbnail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`url_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`url_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`config_attributes` text COLLATE utf8_unicode_ci NOT NULL,
`custom_design` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`page_layout` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`options_container` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`image_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`small_image_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`thumbnail_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`country_of_manufacture` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`msrp_enabled` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`msrp_display_actual_price_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`gift_message_available` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`price` decimal(12,4) NOT NULL,
`special_price` decimal(12,4) NOT NULL,
`msrp` decimal(12,4) NOT NULL,
`color` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`visibility` text COLLATE utf8_unicode_ci NOT NULL,
`enable_googlecheckout` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`tax_class_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`cjm_useimages` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`size` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`short_description` text COLLATE utf8_unicode_ci NOT NULL,
`meta_keyword` text COLLATE utf8_unicode_ci NOT NULL,
`custom_layout_update` text COLLATE utf8_unicode_ci NOT NULL,
`cjm_imageswitcher` text COLLATE utf8_unicode_ci NOT NULL,
`cjm_moreviews` text COLLATE utf8_unicode_ci NOT NULL,
`special_from_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`special_to_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`news_from_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`news_to_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`custom_design_from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`custom_design_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`qty` int(50) NOT NULL DEFAULT '1',
`min_qty` int(50) NOT NULL DEFAULT '1',
`use_config_min_qty` smallint(5) NOT NULL DEFAULT '0',
`is_qty_decimal` smallint(5) NOT NULL DEFAULT '0',
`backorders` smallint(5) NOT NULL DEFAULT '1',
`use_config_backorders` smallint(5) NOT NULL DEFAULT '1',
`min_sale_qty` decimal(12,4) NOT NULL DEFAULT '1.0000',
`use_config_min_sale_qty` smallint(5) NOT NULL DEFAULT '1',
`max_sale_qty` decimal(12,4) NOT NULL DEFAULT '1.0000',
`use_config_max_sale_qty` smallint(5) NOT NULL DEFAULT '1',
`is_in_stock` smallint(5) NOT NULL DEFAULT '1',
`low_stock_date` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`notify_stock_qty` smallint(5) NOT NULL DEFAULT '5',
`use_config_notify_stock_qty` smallint(5) NOT NULL DEFAULT '1',
`manage_stock` smallint(5) NOT NULL DEFAULT '1',
`use_config_manage_stock` smallint(5) NOT NULL DEFAULT '1',
`stock_status_changed_auto` smallint(5) NOT NULL DEFAULT '1',
`use_config_qty_increments` smallint(5) NOT NULL DEFAULT '0',
`qty_increments` decimal(12,4) NOT NULL DEFAULT '1.0000',
`use_config_enable_qty_inc` smallint(5) NOT NULL DEFAULT '0',
`enable_qty_increments` smallint(5) NOT NULL DEFAULT '0',
`is_decimal_divided` smallint(5) NOT NULL DEFAULT '0',
`stock_status_changed_automatically` smallint(5) NOT NULL DEFAULT '1',
`use_config_enable_qty_increments` smallint(5) NOT NULL DEFAULT '0',
`product_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`store_id` smallint(5) NOT NULL DEFAULT '0',
`product_type_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`product_status_changed` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`gallery` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`related` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`upsell` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`crosssell` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`tier_prices` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`associated` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`bundle_options` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`grouped` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`group_price_price` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`downloadable_options` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`super_attribute_pricing` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`product_tags` text COLLATE utf8_unicode_ci NOT NULL,
`weight` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_recurring` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`recurring_profile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`mst_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.