Description

Metamap is an additional service provided to DataSource customers for mapping SKUs to distributor part numbers. DataSource customers may receive distributors’
part numbers from one or multiple distributors (depending on the contract terms) for the products delivered to the customer by 1WorldSync and
based on distributors’ catalog available at 1WorldSync.

Metamap is mostly useful to the customers with SupplierBase (Synchro) or CategoryBase or full market PUSH accounts. These types of accounts have DataSource SKUID as the primary key identifier (ProdID) as opposed to CatalogBase (PULL) accounts which have their own internal part number (Customer PN) as the primary key (ProdID).

Database Structure

The distributor part numbers are delivered in the tables Metamap and Distivoc.

Metamap table

This table provides the information on the distributor part numbers linked to DataSource SKUIDs.

Metamap example

The part numbers in the metamap table for HP Pro Slate 10 EE G1 tablet:

Distivoc table

This table is related to the table metamap and contains the distributors’ names.

Distivoc example

Here are the names for DistiIDs provided in Metamap Example above.

Sample Query

SELECT m.prodid,

m.distisku AS DistributorPN

FROMcds_metamap m

WHERE m.prodid = ‘PRODUCTID’

AND m.distiid = ‘Distributor ID’