$insertValues = '';

                foreach ($data->sheets[0]['cells'] as $row)
                {
                  $name = isset($row[$cols['name']]) ? $row[$cols['name']] : '';
                  $producer = isset($row[$cols['producer']]) ? $row[$cols['producer']] : '';
                  $employment = isset($row[$cols['employment']]) ? $row[$cols['employment']] : '';
                  $price = isset($row[$cols['price']]) ? ceil($row[$cols['price']]) : '';
                  $supplier_price = isset($row[$cols['supplier_price']]) ? ceil($row[$cols['supplier_price']]) : '';

                  $pat = '#(?! +[\pL\pN])[/;,\pZ]+#su';
                  $vars = array('code', 'replacement', 'original_code');

                  foreach ($vars as $var)
                  {
                    if (isset($row[$cols[$var]]))
                    {
                      $$var = trim($row[$cols[$var]]);
                      $$var = !empty($$var) ? '|' . preg_replace($pat, '|', $$var) . '|' : '';
                    }
                    else
                      $$var = '';
                  }

                  $insertValues .= '(' . (int)$pid . ",'" . mysql_real_escape_string($name) . "','" . mysql_real_escape_string($producer) . "','" . mysql_real_escape_string($code) . "','" . mysql_real_escape_string($replacement) . "','" .  mysql_real_escape_string($original_code) . "','" . mysql_real_escape_string($employment) . "','" . mysql_real_escape_string($price) . "','" . mysql_real_escape_string($supplier_price) . "'),";
                
                  // хак, чтоб мускул не падал от большого пакета
                  if (strlen($insertValues) > 990000)
                  {
                    mysqlQuery(
                      'INSERT INTO `' . IN_DBPREFIX . 'search_data`
                         (`pricelist_id`,`name`,`producer`,`code`,`replacement`,`original_code`,`employment`,`price`,`supplier _price`) VALUES ' . substr($insertValues, 0, -1));
                    
                    $insertValues = '';
                  }
                }

                // дописываем остатки
                if ($insertValues != '')
                  mysqlQuery(
                    'INSERT INTO `' . IN_DBPREFIX . 'search_data`
                       (`pricelist_id`,`name`,`producer`,`code`,`replacement`,`original_code`,`employment`,`price`,`supplier _price`) VALUES ' . substr($insertValues, 0, -1));

                header('Location: ' . IN_HOST . 'admin/' . $thispage);
                exit();