It should work. If it isn't inserting into the orders then I'd think it must be an issue with the database structure. Maybe a required field that doesn't have a value or something of that nature. A single merchant account for two sites is not a problem.