my $results = $dbh->selectall_arrayref(
   "SELECT * FROM shop_items", { Slice => {} }
);
foreach my $hash_ref (@$results)
{
   # blah
}