Import prices

Before using the import prices interaction, ensure that Magento tax configuration is compatible.

The import prices interaction uses Brightpearl price lists to update Magento products across all of the following pricing features found in Magento:

  • Product attributes:
    • Price
    • Special price (including bundle %)
    • Cost price
    • Custom attributes

      product-attribute-price-mapping.png

  • Tiered pricing for handling:
    • Price per website
    • Prices for customer groups
    • Volume discounts

      tier-price-map.png

Import prices triggers

The Magento prices are updated at the following times:

Time Description Execution method
Cronjob Checks all orders modified in the past X number of minutes, hours, days, weeks, months or years and updates differences Scheduled
Manual: bulk Checks all orders modified in the past X number of minutes, hours, days, weeks, months or years and updates differences. Manual

Magento tax configuration

Before importing prices from Brightpearl it is important that Magento is configured in a compatible way. Magento catalog prices must be set as tax exclusive for all websites. If prices should be displayed to the online customer inclusive of tax, then set this using the price display settings.

Why Magento tax configuration is important

Brightpearl always sends prices to Magento exclusive of tax, regardless of whether the price list in Brightpearl is set as inclusive of tax. This means that the prices seen on the products in the Magento catalog will always be the price before tax, and therefore the Magento configuration must also be set to acknowledge this. If Magento is configured to read the price as inclusive of tax then Magento will always calculate tax out of the given value, instead of adding it on.

If the Magento tax configuration is not compatible with the way Brightpearl works the price import will give an error to ensure the configuration and effects of the price import are reviewed. This validation can be switched off in the Interaction: Import prices settings, this will allow prices to be imported from Brightpearl regardless of the incompatible tax configuration - this may result in incorrect pricing in Magento.

How to configure Magento catalog prices

  1. Log into the Magento admin panel and go to:

    Magento 1: System > Configuration > Sales > Tax

    Magento 2: Stores > Configuration > Sales > Tax

  2. In the calculation settings section set Catalog prices to 'Excluding'.
  3. Use the Store view dropdown at the top of the configuration to ensure this setting has been applied to all websites.

    catalog-price-excluding.png

  4. To display prices as inclusive of tax online, scroll down to the price display settings set the Display product prices in catalog option to either 'inclusive' or 'inclusive and exclusive'. Magento tax rates and rules will need to be correctly configured and applied to customer groups and products. To ensure prices display correctly.

    price-display-inclusive.png

  5. Save the Magento configuration.

Price

The price attribute is the main price field on a Magento product for a single item. To update this price using Brightpearl it should be mapped within the product price attribute mapping section.

If the Brightpearl price list includes price breaks then it must also be mapped within the tier price mapping section.

Cost price

The cost price is found in the advanced pricing section of the Magento product. To update this price using Brightpearl it should be mapped within the product price attribute mapping section.

Special price

This price is found under advanced Magento pricing and can be used to show a sale price on the Magento website. On a bundle this special price is a percentage, this can also be managed by Brightpearl.To update this field using the import, it must be mapped to a Brightpearl price list within the extension configuration.

Using special prices on bundles

Special prices on Magento bundles are given using a percentage discount. The percentage to be applied is calculated by comparing the price on the special price list against one chosen for this specific purpose - the bundle base price list. Choose which price list to use within the Shared: Price settings of the extension.

For example, if the bundle price on the special price list is 50.00 and the price on the bundle base price list is 200.00 then the discount percentage applied to the bundle in Magento is 25%.

Website level prices (tier prices)

To apply different pricing at a website level Magento must be configured to allow it. In the Magento configuration, go to Catalog > Catalog and set the catalog price scope to 'website'. If this is set as 'global' then tier pricing can only be applied to 'all websites'.

price-scope.png

Use the tier price mapping section in the extension configuration to use different Brightpearl price lists for managing the prices on each Magento website.

When the prices are imported they will be displayed within the advanced pricing > tier pricing section on the Magento product.

Customer group prices (tier prices)

Customer groups allow different prices to be applied, on the same website, depending on who the customer is.

Use the tier price mapping section in the extension configuration to use different Brightpearl price lists for managing the prices for different customer groups. When the prices are imported they will be displayed within the advanced pricing > tier pricing section on the Magento product.

Quantity discounts/price breaks (tier prices)

If the Brightpearl price lists used in the tier price mapping include price breaks these will be imported and displayed within the advanced pricing > tier pricing section on the Magento product.

Including/excluding break 1

If a tier price is added for a quantity of 1, it will overrule the main price on the product. For this reason there is the option of excluding break 1 within the tier price mapping. When no tier price for a single quantity exists, the main price is used.

Have more questions? Submit a request