/*
/*
*Weicot 兔子自定义付款系统
*付款链接发送模块
*作者 ajiang-兔子
*20150921
*1050653098@qq.com
*v0.1
*/
*/
truncate table export_magento;
insert into export_magento
select 'admin' as store
,'base' as websites
,'Common' as attribute_set
,'simple' as type
,p.products_model as sku
,pd.products_name as name
,pd.products_name as product_name
,'' as market_price
,p.products_price as price
,p.products_price
,p.products_weight as weight
,'Brand new, never refurbished, 100% compatible' as short_description
,pd.products_description as description
,pd.products_name as meta_title
,'' as meta_keyword
,pd.products_name as meta_description
,substring_index(p.products_image, ',', 1) as image
,substring_index(p.products_image, ',', 1) as small_image
,substring_index(p.products_image, ',', 1) as thumbnail
,replace(p.products_image, ',', ';') as gallery
,'Enabled' as status
,'None' as tax_class_id
,p.products_quantity as qty
,p.master_categories_id as category_ids
,1 as is_in_stock
,'Catalog, Search' as visibility
,date_format(now(),'%Y/%d/%c') as adddate
from products p
inner join products_description pd
on p.products_id = pd.products_id
where pd.language_id = 1
and p.master_categories_id in (10);
mysql> desc products;
+----------------------------------+---------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------------------+---------------+------+-----+---------------------+----------------+
| products_id | int(11) | NO | PRI | NULL | auto_increment |
| products_type | int(11) | NO | | 1 | |
| products_quantity | float | NO | | 0 | |
| products_model | varchar(256) | YES | MUL | NULL | |
| products_image | varchar(255) | YES | | NULL | |
| products_price | decimal(15,4) | NO | | 0.0000 | |
| products_virtual | tinyint(1) | NO | | 0 | |
| products_date_added | datetime | NO | MUL | 0001-01-01 00:00:00 | |
| products_last_modified | datetime | YES | | NULL | |
| products_date_available | datetime | YES | MUL | NULL | |
| products_weight | float | NO | | 0 | |
| products_status | tinyint(1) | NO | MUL | 0 | |
| products_tax_class_id | int(11) | NO | | 0 | |
| manufacturers_id | int(11) | YES | MUL | NULL | |
| products_ordered | float | NO | MUL | 0 | |
| products_quantity_order_min | float | NO | | 1 | |
| products_quantity_order_units | float | NO | | 1 | |
| products_priced_by_attribute | tinyint(1) | NO | | 0 | |
| product_is_free | tinyint(1) | NO | | 0 | |
| product_is_call | tinyint(1) | NO | | 0 | |
| products_quantity_mixed | tinyint(1) | NO | | 0 | |
| product_is_always_free_shipping | tinyint(1) | NO | | 0 | |
| products_qty_box_status | tinyint(1) | NO | | 1 | |
| products_quantity_order_max | float | NO | | 0 | |
| products_sort_order | int(11) | NO | MUL | 0 | |
| products_discount_type | tinyint(1) | NO | | 0 | |
| products_discount_type_from | tinyint(1) | NO | | 0 | |
| products_price_sorter | decimal(15,4) | NO | MUL | 0.0000 | |
| master_categories_id | int(11) | NO | MUL | 0 | |
| products_mixed_discount_quantity | tinyint(1) | NO | | 1 | |
| metatags_title_status | tinyint(1) | NO | | 0 | |
| metatags_products_name_status | tinyint(1) | NO | | 0 | |
| metatags_model_status | tinyint(1) | NO | | 0 | |
| metatags_price_status | tinyint(1) | NO | | 0 | |
| metatags_title_tagline_status | tinyint(1) | NO | | 0 | |
+----------------------------------+---------------+------+-----+---------------------+----------------+
35 rows in set (0.16 sec)
*************************** 6. row ***************************
store: admin
websites: base
attribute_set: Common
type: simple
sku: DVD-DHWV
name: Die Hard With A Vengeance Linked
product_name: Die Hard With A Vengeance Linked
market_price: 0.00
price: 39.99
special_price: 39.99
weight: 7
short_description: Brand new, never refurbished, 100% compatible
description: Regional Code: 2 (Japan, Europe, Middle East, South Africa).
meta_title: Die Hard With A Vengeance Linked
meta_keyword:
meta_description: Die Hard With A Vengeance Linked
image: dvd/die_hard_3.gif
small_image: dvd/die_hard_3.gif
thumbnail: dvd/die_hard_3.gif
gallery: dvd/die_hard_3.gif
status: Enabled
tax_class_id: None
qty: 9
category_ids: 10
is_in_stock: 1
visibility: Catalog, Search
adddate: 2015/24/9
转载请注明：(●--●) Hello.My Weicot » zencart 产品转 magento sql