Product Attribute Tier Price Error

[tranductrong92]

Preconditions

1. Magento 2.1.3
2. PHP Version 7.0.15

Steps to reproduce

1. Create simple product
2. At Price, click Advanced Pricing and "Add" Tier Price
3. Save Product

Expected result

1. Tier Price added to Product

Actual result

1. Warning: Illegal string offset 'price_qty' in /var/www/abc/vendor/magento/module-catalog/Model/Product/Attribute/Backend/Tierprice.php on line 74

[tranductrong92]

......

[apurv-anand]

We have the same problem: Warning: Illegal string offset 'price_qty' in /opt/bitnami/apps/magento/htdocs/vendor/magento/module-catalog/Model/Product/Attribute/Backend/Tierprice.php on line 74

Please provide a solution and provide a workaround meanwhile.

[tranductrong92]

@apurv-anand you can try this code:

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$_productTierPrice = $objectManager->create('Magento\Catalog\Api\ProductTierPriceManagementInterface');
$sku = "product";
$_productTierPrice->add($sku, 1, 100, 1);

OR:

$tierPrices = array(array(
  'cust_group' => 1,
  'price_qty' => 1,
  'price' => 100,
  'website_id' => 1
));

Notes:

$tierPrices = array(array(
......
));

[lisaaugustine]

Just check if you have entries for tier prices in catalog_product_entity_int table, as there is an eav attribute 'tier_price ' with attribute_id 92. For us deleting those entries resolved the issue.

[Blevin1]

This bug is crippling our website launch. We have tried everything and nothing is working.
Please fix this right away!

[mzenner1]

I'm having the same bug. My client imported about 2000 products with tier pricing. While the tier pricing is reflected accurately on the store front and in the cart, I can no longer save products.

Warning: Illegal string offset 'price_qty' in /var/www/vhosts/tlcelectronics.com/httpdocs/vendor/magento/module-catalog/Model/Product/Attribute/Backend/Tierprice.php on line 74

Solutions?

[lucacarafoli]

We have the same bug of @mzenner1. Imported products with tier pricing. Editing on backend, error.
Someone found a solution?

[sduif]

We had the same issue. Our client imported products through the backend, after which certain products would not save (Warning: Illegal string offset 'price_qty').

Solution for us was similar to what @lisaaugustine pointed out. A single attribute value was saved in one of the product entity tables. Steps to resolve:

1. Backup your database
2. Locate your "tier_price" attribute ID (Stores -> Attributes -> Product -> Search for "tier_price")
3. Search catalog_product_entity_decimal, catalog_product_entity_int, catalog_product_entity_text, and catalog_product_entity_varchar for any records with the attribute_id of your tier_price attribute
4. Delete these rows
5. Clear cache and try to resave the affected products. The problem should be gone

[lucacarafoli]

Thank you @sduif, we resolved the problem in the same way.

[magento-engcom-team]

@tranductrong92, thank you for your report.
We were not able to reproduce this issue by following the steps you provided. If you'd like to update it, please reopen the issue.
We tested the issue on 2.3.0, 2.2.0, 2.1.9