HTML Code:
[HTML][HTML][QUOTE=mc12345678;1367176]There "is" though it depends on what setting you have for the primary id (assuming using a more recent version of EP4 that offers a selection). If you have the selection, then blank_new as the setting will create a new product when the products_id is left blank. If you choose products_model (the default/classic primary key) then a new product is made when there is a new products_model that hasn't existed. For products_id as a key, then a new product is created if a products_id is used that didn't previously exist noting that a row of data with a blank products_id will be ignored.

At any time if a primary key is used and that product already exists in the database and not specifically deleting data, then when that row is processed for adding/updating if the category is different than what already exists that row of data will be linked to the original product and the data of the original product will be updated to the row being read.[/QUOTE]

hmmm... I do have the primary key as model and entered the model as NEW PRODUCT! - Model: blank_new | | 1 | einsteins- | Colombian | Not just t | | | | | 55 | 6 | 0 | 25 | 1 | 1 | 0 | 1 | | | 0 | Coffee | Coffee^Pre | --none-- | 1 | | | | | | | | | 
No product yet that I can fine.  I will experiment some further.  Thank you!
[/HTML][/HTML]