Abstract: Provided are methods and systems for automatic creation of a catalog map for reconciliation of a merchant catalog, as used in a merchant point-of-sale system and a third-party reseller catalog configured to receive an order from a consumer for one or more items from the merchant. The disclosed invention provides for extraction of a merchant catalog and at least one reseller catalog for the merchant from a third-party reseller service. Subsequently, terms are compared between the extracted catalog using an automatic three-tiered approach consisting of pattern (or string) based mapping, structure based mapping into a hierarchical model, and semantic based matching. From this, a hierarchical catalog map is generated for equivalent terms between the two extracted catalog. The catalog map can then be used to create a new Master Catalog.