You are here:  » Dupe Hash field

Support Forum



Dupe Hash field

Submitted by exsolo on Mon, 2008-05-05 22:42 in

please someone explain me why do I need this field in a product category?
"dupe_hash"

Submitted by support on Tue, 2008-05-06 07:59

Hi,

The dupe_hash field is the method by which duplicate products from the same merchant are preventing from being imported.

Just before importing a new product record; $dupe_hash is calculated by taking the MD5 hash value of the merchant name + the product name. An MD5 hash is a 32 character sequence that is never the same for any 2 different input strings. The dupe_hash field in the database then has a unique index applied to; meaning that any subsequent import with the same dupe_hash value (and therefore a duplicate product for that merchant) would not be imported because MySQL would reject the record for breaking the unique index.

You don't need to worry about this field anywhere else, it is only relevant during the import process!

Cheers,
David.