Skip to content

Import Tier Prices to Magento V2

This task will create or update tier prices for products in Magento. See below for a sample input file.

The task uses the <sku>, <customer_group_name>, and <qty> elements to check if the tier price already exists. If a match is found the existing tier price will be updated, otherwise a new tier price will be created.

POST products/{sku}/group-prices/{customerGroupId}/tiers/{qty}/price/{price}

{sku} The task will find a matching product sku based on the data you provide. This should be the product you want to update prices for.
{groupId} The task will find a matching customer group id based on the data you provide. This should be the customer group you want to update the product prices for.
{qty} This value will default to 1 if you do not provide a value.

Settings

Connection

Required
The Magento V2 connection to use. See the Connecting to Magento v2 article if you require more information on how to create/manage connections.

Fail File

Required
The XML file to save failed tier price imports to. The data will be written in the same format as the input file.

Input File

Required
The XML file containing the tier prices to import in Magento.

Success File

Required
The XML file to save successful tier price imports to. The data will be written in the same format as the input file.

Store View Code

Required
The magento store view code to perform the API calls against. Default value of 'all'.

Zynk Settings

See Common Task Settings.

Examples

A sample input file is shown below.

<?xml version="1.0" encoding="utf-8"?>
<ArrayOfTierPrice xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <TierPrice>
    <sku>24-MB01</sku>
    <customer_group_name>Wholesale</customer_group_name>
    <qty>3</qty>
    <value>29.99</value>
  </TierPrice>
  <TierPrice>
    <sku>24-MB01</sku>
    <customer_group_name>Wholesale</customer_group_name>
    <qty>10</qty>
    <value>25.99</value>
  </TierPrice>
  <TierPrice>
    <sku>24-MB01</sku>
    <customer_group_name>ALL GROUPS</customer_group_name>
    <qty>3</qty>
    <value>49.99</value>
  </TierPrice>
</ArrayOfTierPrice>