test.items

gistfile1.txt

SELECT 
	'' as code,
	'' as sku,
	a.status, a.generic, a.brand, a.make, a.model, a.color, a.size_dim, a.gauge_thick, a.description, 
	CASE
		WHEN a.type = "Serialized" then 3
		WHEN a.type = "Inventoriable" then 2
	END as inventory_types_id,
	
	CASE 
		WHEN a.uom = "pcs" THEN 1
		WHEN a.uom = "rol" THEN 4
	END as uom_id,
	a.category,
	b.category_id as category_id,
	b.sub_category_id as subcategory_id,
	a.re_order as reorder_lvl, 
	a.unit_cost as item_cost,
	a.unit_cost as ave_cost,
	a.unit_cost as ave_value,
	a.min,
	a.std,
	a.max,
	NOW() as created_at,
	NOW() as updated_at
from items as a
LEFT JOIN category as b on a.category = b.orig_name