import2

    def insert_products
      ActiveRecord::Base.connection.execute <<-SQL
        INSERT INTO spree_variants(sku, code_1c, description)(
          SELECT
            trim(coalesce(tp.title, '')),
            tp.external_code,
            tp.short_description
          FROM #{table_name} AS tp
          LEFT JOIN spree_variants AS p
            ON p.code_1c = tp.external_code
          WHERE p.id IS NULL
        )
      SQL
    end

==========================================================================


    def insert_products
      ActiveRecord::Base.connection.execute <<-SQL
        INSERT INTO products(title, url, external_code, short_description, product_group_id, product_category_id, disabled, has_sorted_images, total_stock, has_priority_vendor, model_name, is_exported_to_aggregators, name_for_google, name_for_yandex, created_at, updated_at)(
          SELECT
            trim(coalesce(tp.title, '')),
            url_translit(trim(coalesce(tp.title, '')) || '-' || tp.external_code),
            tp.external_code,
            tp.short_description,
            pg.id,
            pg.product_category_id,
            'f',
            'f',
            tp.total_stock,
            tp.has_priority_vendor,
            tp.model_name,
            tp.is_exported_to_aggregators,
            tp.name_for_google,
            tp.name_for_yandex,
            '#{DateTime.now.to_s(:db)}',
            '#{DateTime.now.to_s(:db)}'
          FROM #{table_name} AS tp
          INNER JOIN product_groups AS pg
            ON pg.external_code = tp.group_external_code
          LEFT JOIN products AS p
            ON p.external_code = tp.external_code
          WHERE p.id IS NULL
        )
      SQL
    end