made helper function for generate_qr, removed link field from items table
merging