Magento for B2B Commerce, 2.2.x
Advanced Pricing Data

Advanced Price Import/Export allows you to quickly update pricing information for product groups and tier prices. The process to import and export advanced price data is the same as any other entity type. The sample CSVComma Separated Values: A type of file used to store data values which are separated from each other by commas. file contains tier and group prices for each product type that supports advanced pricing. Making changes to advanced pricing does not affect the rest of the product record.


Advanced Price Sample File
  • Advanced Pricing Attributes

    Attribute

    Description

    sku

    (Required) The Stock-Keeping Unit is a unique, alphanumeric identifier that is used to track inventory. A SKU can be up to 64 characters in length. For example: sku123

    A SKUStock Keeping Unit: A number or code assigned to a product to identify the product, options, price, and manufacturer. longer than 64 characters will cause import to fail.

    tier_price_website

    The website code identifies each website where tier pricing is available. For example:

    website1

    All Websites [USD]

    tier_price_customer

    Identifies the customers groups where tier pricing is available. For example:

    ALL GROUPS

    NOT LOGGED IN

    General

    Wholesale

    Retailer

    tier_price_customer_group

    Identifies the customers groups where tier pricing is available. For example:

    ALL GROUPS

    NOT LOGGED IN

    General

    Wholesale

    Retailer

    tier_price_qty

    The quantity of the product that must be ordered to receive the tier price discount.

    tier_price

    The discounted tier price of the product. For bundle products, tier price is calculated as a percentage.

    group_price_website

    The website code of each website where group pricing is available. If specifying multiple websites, separate each with a comma and without a space. For example:

    website1

    All Websites [USD]

    group_price_customer_group

    Identifies the customers groups where group pricing is available. For example:

    NOT LOGGED IN

    General

    Wholesale

    Retailer

    group_price

    The discounted group price of the product. For bundle products, group price is calculated as a percentage.