Customized Cart for Login

We own eCart and are considering purchasing DataBridge, but want to make sure we can achieve the functionality we're looking for. We like to have our customers login and see products we've picked specifically for them to purchase. Can this be done? And what is the level of difficulty (I understand this question is matter of reference)? We are comfortable with eCart.

Yes, this can be done with the security assist porting of data bridge.


when a user logs in, the ID for that user is stored in a session variable, you can set a table in your database to assign products to the user based on productID and User ID, then use the Login Session variable to query that table and return products for that user.


the table to assign products to the user would be a linking table, with a column for productID and userID:


usersproducts:
userproductID - primary key
usersproductUserID - relates to users.userID
usersproductProductID - relates to products.productID

you could the use a join query to return the user products, for example, if the login session variable is named "UserID" the query may look like this:


SELECT products.*
FROM products
INNER JOIN usersproducts
ON products.productID = usersproducts.usersproductProductID
WHERE usersproducts.usersproductUserID = paramUserID


Variable:
name: paramUserID
type: integer
default value: -1
run time value: $_SESSION['UserID']