Magento2: Unable to export advance pricing on Magento 2.2.3

[dinkeronline]

Preconditions

1. Magento 2.2.3
2. Upgraded from 2.1.5 to 2.2.3

Steps to reproduce

1. Go to system->export
2. Select Entity type Advance Pricing
3. Click on continue

Expected result

1. CSV file with tier pricing should be exported.

Actual result

1. Error pops up on screen - "There is no data for the export."
2. Exception log - main.CRITICAL: Notice: Undefined index: product_link_id in /var/www/html/vendor/magento/module-advanced-pricing-import-export/Model/Export/AdvancedPricing.php on line 358

Line 358 checks for an undefined array index-

$sku = $productLinkIdToSkuMap[$tierPriceData['product_link_id']];

this part is not needed as the tier price data already includes the SKU and the part of code is for adding the SKU to $tierPriceData array.

[ghost]

Hi @dinkeronline I cannot reproduce by your's scenarios steps. can you check the websites for your advicind pricing ?

[ghost]

@dinkeronline we are closing this issue due to inactivity. If you'd like to update it, please reopen the issue.

[macrodesignuk]

This is still an issue on v2.2.6 and v2.3.0. Can this be re-opened?

V2.2.6 clean install and migrated data from Magento1, cannot do Advanced Pricing Export.
V2.3.0 clean install, created several bundle products, cannot do Advanced Pricing Export.

Both sites result in "There is no data for the export."

[ghost]

@macrodesignuk Hi seems like this related to migration tool, you can open issue here -> https://github.com/magento/data-migration-tool repository.

[macrodesignuk]

@macrodesignuk Hi seems like this related to migration tool, you can open issue here -> https://github.com/magento/data-migration-tool repository.

@engcom-backlog-nazar My second scenario didn't use the migration tools, it was a clean install of version 2.3.0 and the simple products and bundles were created from scratch on the Magento 2 admin panel.

[ghost]

@macrodesignuk ok i'm will recheck

[macrodesignuk]

@macrodesignuk ok i'm will recheck

Any updates on this please?

[eharvest]

Same issue on 2.1.6, never used data migration tool.

[macrodesignuk]

Any feedback @engcom-backlog-nazar ?

[ghost]

@macrodesignuk Fixed in this commit https://github.com/magento/magento2/commit/461009ef7492cae1ca17183fac5b26d142b6e01f

[Ctucker9233]

@engcom-backlog-nazar That commit is for 2.3.1, so is there a backport?

[khasru]

I could fix this issue by checking store code as follow

if(isset($productData[Store::DEFAULT_STORE_ID])) {
$productLinkIdToSkuMap[$productData[Store::DEFAULT_STORE_ID][$this->getProductEntityLinkField()]]
= $productData[Store::DEFAULT_STORE_ID]['sku'];
}

In this file

vendor/magento/module-advanced-pricing-import-export/Model/Export/AdvancedPricing.php

So, for this i created a custom module

https://github.com/khasru/magento2AdvancedPricingImportExportbug

[sajidunnar]

I installed @khasru module but it dint work but it fixed the error but was getting message no data on export .

-- This issue is with migrated data
-- Once I saved Tier Pricing in Store mode then export worked properly as it should
-- Once Change Single-Store Mode to yes , it seems it helped but not sure but price export now

Thanks

[kerlama]

I have the same issue on clean 2.3.3 version with sample data.

[manju-Cue]

I am facing the same issue on fresh Magento2.3.3 :(