Dupe Hash field
Submitted by exsolo on Mon, 2008-05-05 22:42.Price Tapestry
please someone explain me why do I need this field in a product category?
"dupe_hash"
Price Tapestry Home
Purchase & Download
Manual
Support Forum
Links
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.
--
Developer, Price Tapestry
For unrelated PHP, MySQL or Affiliate Marketing tech help please post your questions on my personal forum