A method and system to automatically categorize a merchant listing in an electronic marketplace are provided. The method includes parsing the category information submitted by a seller to derive a first category identifier. A first search is performed to locate the first category identifier in a first database containing a listing of category identifiers. If no match is found, the first category identifier is identified as expired or invalid. A second search is performed on a second database that includes mapping information of an expired category identifier to a new category identifier. If a match is found, the first category identifier is assigned as the new category identifier, thereby enabling the listing to be listed in the updated category automatically.