>Your order only have a date as information? No customer name? No order details?
>

No, no other information. I was thinking adding back the ID since my colleague just told me it doesn't matter, only PK field really matters for sync, but I already re-did everyting, so even though we have VSS and I can go back easily I would have to make a change back in the table.

Let me figure out again if adding ID back is OK.

I do have details in the OrderDetails table (the items with the price).