Product Catalog and Price Management

Product Catalog and Price Management

PRODUCT DATABASE

Product Catalog is stored in Postgres SQL database. Product data is categorized on three levels: Supplier product – this is equivalent of a supplier pricelist entry for any given supplier SKU. Inventory product – this is equivalent of a unique manufacturer product and can be sourced from multiple suppliers (supplier products). Catalog product – external product catalog for each marketplace or website. Each marketplace catalog may include a subset of inventory products, e.g. website catalog, Amazon catalog, GSA catalog, etc. Each catalog may use different pricing and categorization. B2B Online performs mapping of supplier products to inventory products based on sophisticated mapping algorithm that includes available data (UPC, MPN, Brand, etc.). Products are organized in a multi-level category tree. Every product may be assigned to one of more categories.

Product Catalog and Price Management

Product Details

Detailed product information contains: Product name. Brand and category. Images. Text description (html). Technical specification (attributes, features). Price. Availability/ inventory. Supplier sourcing. Product codes (UPC, MFN, COO).

CATALOG IMPORT

Product information can be imported from several sources: External product catalogs (e.g. Etilize Spec Plus). XML catalogs – custom XML catalogs can be imported. XLSX importer – B2B spreadsheet format for catalog import.

PRICE AND INVENTORY

price and inventory can be imported from the following sources: ftp download of csv price flat files. xml import via rest api. xlsx importer – b2b spreadsheet format for price file import. optional prices for government discount price.

CATALOG EXPORT

there catalog information can be exported to the following formats: xml export in google shopping format. b2b online export in xlsx flat file. csv flat file.

pexels-brett-sayles-3803517
pexels-lukas-590016
pexels-nataliya-vaitkevich-8062362

Categorization and presentation of products

The structure of categories is unlimited, a catalog can include any number of categories and sub-categories. Categories can be visible or hidden. Categories can have assigned pictures. One product may belong to many categories. Products may have other variants, each variant having its own price, availability and photos. There is a possibility of specifying attributes to every category: Fixing the parameters using the list available in a panel, fitting to product group (e.g. for IT hardware it will be a kind of a processor or operating system). Facility is useful in comparing, filtering or searching products by categories by their parameters.

Products highlighting and presentation

Fixing a discount, a sale or a new product. Administrator can manage discounts, sales and recently added products in a very easy way, which means he can choose products he wants to highlight in this way. Highlighted products have special graphic labels. Administrator can create bestselling products rankings. Every product can be chosen and given level of priority at the administrator’s panel.

Price Spider

Product catalog can utilize custom price comparison against competition by the use of spider price checker. Competitive price is retrieved to product database and available for comparison. Competitive price can be used for price decision algorithm. Price spiders can use web based price check against selected set of products. Product groups can be defined as watch lists and filtered by brand, category and price.<br /> Each product group can be compared against competition at specified times returning 3 best competitive prices and sellers. Additional rules can be used to target competitive sellers

Price Calculator

Custom price rules can be used for calculating sale prices: Margin/ markup based rules are used based on the cost. Cost is determined based on the supplier mapped products. You can use the best cost rule if the currently available products should only be considered. Once you establish the best cost you can add margin and markup to calculate target sale price, e.g. cost + 10% + $10. Combined calculated and competitive price: If the competitive price is available, you can use both base sale price and competitive price to increase or decrease the final sale price.

X