The sql query should be written to return a list of products. The results of the sql query must have a unique identifier that will match products in SellerCloud. There is an option on the Options tab that can be set so that SellerCloud will create any product that isn't matched from the sql query. The map button maps the query columns to the corresponding SellerCloud columns.
A sample query could look like:
SELECT ID, Name, QTY FROM PRODUCTS
See attached script (general-sql-2-3-2011.txt) used to access product information from ACctivate
There is an updated version of this ACctivate sql, June 6 , 2011, that takes into account carriage return characters in the product description.