You need to quote the string for the type field, or use placeholders. So:

my $sql_fmt = "INSERT INTO sales VALUES(%d, %d, '%s', %d, %d, %d)";
[download]

might be a minimal fix to get it to work.

Please read up on strings, quoting and placeholders in the DBI docs.

Michael