ALTER TABLE packinglist_products 
ALTER COLUMN batchno TYPE INTEGER USING batchno::INTEGER;

ALTER TABLE qcp4_products 
ADD COLUMN noofboxes INTEGER;
