

类目表 product_category
id	bigint(20)	NO	PRI		auto_increment
parent_id	bigint(20)	NO			
name	varchar(255)	NO			
pic_url	varchar(255)	NO			
sort	int(11)	YES		0	
status	tinyint(4)	NO			
creator	varchar(64)	YES			
create_time	datetime	NO		CURRENT_TIMESTAMP	
updater	varchar(64)	YES			
update_time	datetime	NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP
deleted	bit(1)	NO		b'0'	
tenant_id	bigint(20)	NO		0	



spu表 shoplazza_product_spu 全部字段
"Field"	"Type"	"Null"	"Key"	"Default"	"Extra"
"id"	"bigint(20)"	"NO"	"PRI"		"auto_increment"
"shop_id"	"bigint(20)"	"NO"	"MUL"		""
"shoplazza_id"	"varchar(64)"	"NO"	""		""
"handle"	"varchar(255)"	"YES"	"MUL"		""
"title"	"varchar(500)"	"NO"	""		""
"brief"	"varchar(1000)"	"YES"	""		""
"description"	"text"	"YES"	""		""
"spu"	"varchar(100)"	"YES"	""		""
"vendor"	"varchar(255)"	"YES"	""		""
"vendor_url"	"varchar(500)"	"YES"	""		""
"seo_title"	"varchar(500)"	"YES"	""		""
"seo_description"	"text"	"YES"	""		""
"seo_keywords"	"text"	"YES"	""		""
"image_src"	"varchar(500)"	"YES"	""		""
"image_width"	"int(11)"	"YES"	""		""
"image_height"	"int(11)"	"YES"	""		""
"image_path"	"varchar(255)"	"YES"	""		""
"image_alt"	"varchar(500)"	"YES"	""		""
"inventory_policy"	"varchar(50)"	"YES"	""		""
"inventory_quantity"	"int(11)"	"YES"	""	"0"	""
"inventory_tracking"	"tinyint(1)"	"YES"	""	"0"	""
"published"	"tinyint(1)"	"YES"	""	"0"	""
"published_at"	"datetime"	"YES"	"MUL"		""
"requires_shipping"	"tinyint(1)"	"YES"	""	"1"	""
"taxable"	"tinyint(1)"	"YES"	""	"0"	""
"fake_sales"	"int(11)"	"YES"	""	"0"	""
"display_fake_sales"	"tinyint(1)"	"YES"	""	"0"	""
"mixed_wholesale"	"tinyint(1)"	"YES"	""	"0"	""
"need_variant_image"	"tinyint(1)"	"YES"	""	"0"	""
"has_only_default_variant"	"tinyint(1)"	"YES"	""	"0"	""
"tags"	"text"	"YES"	""		""
"note"	"text"	"YES"	""		""
"category"	"varchar(255)"	"YES"	""		""
"category_id"	"bigint(20)"	"YES"	""		""
"category_google_id"	"bigint(20)"	"YES"	""		""
"category_level"	"int(11)"	"YES"	""		""
"category_path"	"varchar(500)"	"YES"	""		""
"shoplazza_created_at"	"datetime"	"YES"	""		""
"shoplazza_updated_at"	"datetime"	"YES"	"MUL"		""
"tenant_id"	"bigint(20)"	"NO"	"MUL"		""
"creator"	"varchar(64)"	"YES"	""	""	""
"create_time"	"datetime"	"NO"	""	"CURRENT_TIMESTAMP"	""
"updater"	"varchar(64)"	"YES"	""	""	""
"update_time"	"datetime"	"NO"	""	"CURRENT_TIMESTAMP"	"on update CURRENT_TIMESTAMP"
"deleted"	"bit(1)"	"NO"	""	"b'0'"	""

shoplazza_product_sku 全部字段
"Field"	"Type"	"Null"	"Key"	"Default"	"Extra"
"id"	"bigint(20)"	"NO"	"PRI"		"auto_increment"
"spu_id"	"bigint(20)"	"NO"	"MUL"		""
"shop_id"	"bigint(20)"	"NO"	"MUL"		""
"shoplazza_id"	"varchar(64)"	"NO"	""		""
"shoplazza_product_id"	"varchar(64)"	"NO"	"MUL"		""
"shoplazza_image_id"	"varchar(64)"	"YES"	""		""
"title"	"varchar(500)"	"YES"	""		""
"sku"	"varchar(100)"	"YES"	"MUL"		""
"barcode"	"varchar(100)"	"YES"	""		""
"position"	"int(11)"	"YES"	""	"0"	""
"price"	"decimal(10,2)"	"YES"	""		""
"compare_at_price"	"decimal(10,2)"	"YES"	""		""
"cost_price"	"decimal(10,2)"	"YES"	""		""
"option1"	"varchar(255)"	"YES"	""		""
"option2"	"varchar(255)"	"YES"	""		""
"option3"	"varchar(255)"	"YES"	""		""
"inventory_quantity"	"int(11)"	"YES"	""	"0"	""
"weight"	"decimal(10,2)"	"YES"	""		""
"weight_unit"	"varchar(10)"	"YES"	""		""
"image_src"	"varchar(500)"	"YES"	""		""
"wholesale_price"	"json"	"YES"	""		""
"note"	"text"	"YES"	""		""
"extend"	"json"	"YES"	""		""
"shoplazza_created_at"	"datetime"	"YES"	""		""
"shoplazza_updated_at"	"datetime"	"YES"	""		""
"tenant_id"	"bigint(20)"	"NO"	"MUL"		""
"creator"	"varchar(64)"	"YES"	""	""	""
"create_time"	"datetime"	"NO"	""	"CURRENT_TIMESTAMP"	""
"updater"	"varchar(64)"	"YES"	""	""	""
"update_time"	"datetime"	"NO"	""	"CURRENT_TIMESTAMP"	"on update CURRENT_TIMESTAMP"
"deleted"	"bit(1)"	"NO"	""	"b'0'"	""
