insert items  ( itemcode,itemname,groupcode ,dunitid,unitstype ) 
select itemcode,itemname , groupcode,unitid,1   FROM  itemsxx ;


update items set compoundid=itemcode ;
update items set sales=1 ;


insert itemsunits  (unitcode, itemcode,unitid,price  ) 
select itemcode, itemcode ,unitid,price   FROM  itemsxx ;

 
insert itemsnetprice  (branchid, itemcode,netprice  ) 
select 1, itemcode , netprice/unitq   FROM  itemsxx ;
 
 
insert barcodes ( unitcode, barcode, expireid,main)
 SELECT itemcode , bar,  0 AS expireid, 1 AS main FROM itemsxx ;
 

insert compoundcompontents (compoundid,quantity,itemcode )
 SELECT itemcode , 1 , itemcode  FROM items ;

insert compoundsdata (itemcode,compoundid, rq,runitid ) 
  SELECT itemcode,  itemcode, 1 AS rq, 0 AS runitid FROM   items ;


  /// start value

insert purchases( inquantity,itemcode,unitid,price,stockid,netprice  ) 
select quantity, itemcode ,unitid,netprice,1 ,netprice  FROM  itemsxx where quantity >0;

 
// more untis 
insert itemsunits  (unitcode, itemcode,unitid,price  ) 
select itemcode+700, itemcode ,11 as unitid,round(price/12,2) as price   FROM  itemsunits where itemcode in (select itemcode from items where groupcode=1) 


insert barcodes ( unitcode, barcode, expireid,main)
 SELECT itemcode+700 , itemcode +1000000,  0 AS expireid, 1 AS main FROM items where groupcode=1 ;