Tier Price Unknown column 'cpetp.entity_id'

[JacoOppermanZA]

Hi,

Firstly thanks for creating this extension.

The default Akeneo Connector does not cater for Adobe Commerce with B2B features enabled: Products are created but due to them not being linked to the default shared catalogue they do not display on the front end.

We have a price attribute in Akeneo called Retail Price, code "Retail_Price". I have enabled the Tier price setting and configured Customer group pricing as follows:

Akeneo Price Attribute Code: Retail_Price-ZAR
Magento Customer Group: Default (General)

When I run the products job I get the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cpetp.entity_id' in 'on clause', query was: DELETE cpetp FROM catalog_product_entity_tier_price AS cpetp INNER JOIN tmp_akeneo_connector_entities_product AS tacep ON cpetp.entity_id = tacep._entity_id

Not sure if this is relevant but even though I do have products manually linked to the Default Shared Catalogue I do not see any records in that table.

Hoping you can assist? Thanks in advance!

[pimruiter]

Create a price attribute in Akeneo, the best practise is to use <code>-<customergroup>. Then within the mapping in the Magento Akeneo connector use: <code>-<customergroup>-<currency> and map it to the right customer group. Does this solve your error?