Preventing Duplicates - CSV Import
I have two tables setup. one for my customers information and order number, and another for the items in the order.
I am importing two .csv files and have the customer information setup to match on the order number.
I have the order details setup to match on the order number, and the specific line number in the order.
I am getting duplicates upon import, and I'm very confused why this would be happening. The CSV file that I am importing from always contains the entire set of orders that have not shipped. I continue to over write the .csv file to capture any modifications to the order.
Does anyone have any ideas of why I might be receiving duplicates?