Features and Attributes

[PuzzleDecimalLda]

Hi there, i'm kind a new in prestashop, i'm developing a software to auto sync our product database with prestashop, i already done the part of sync the products, images, tags, categories. i have 2 questions, the first one is a bit dumb maybe... the software was developed in VB.NET and i'm stressing with the manufacturers, the code:

  Dim ManufacturerIDFinder As New MySqlCommand(String.Format("SELECT id_manufacturer FROM " & Perfix & "manufacturer WHERE name ='" & Manufacturer & "'"), Conn)
  ManufacturerID = CInt(ManufacturerIDFinder.ExecuteScalar)

sometimes returns the wrong ID, and when it does it gives a +1 index, example, if the ID would be 1000, it returns 1001. Any ideas?

the most important question, now is... 

What should be the queries to insert features and attributes to each product?

thanks in advance.

[PuzzleDecimalLda]

I'm going to finish this topic... i solved everything!

if anybody has the same problem, ask, and i will help

thanks anyway