Connector Improvement: CommerceTools - discount object being missing in the order table
Answered
Currently, we're unable to retrieve discount information linked to specific orders due to missing fields in the schema.
We need to establish a join between the orders and cart_discount tables, as the required mappings are not available. While the direct API call to CommerceTools reveals an includedDiscounts field containing the necessary data, this information is not being pulled by the Fivetran connector.
In addition, we also have trouble to link the information contained in product_discount table.
Please consider adding this feature so that we can effectively use discount data.
-
Official comment
Hi Faustine,
Thank you for bringing this to our attention. I am pleased to inform that your request to enhance the CommerceTools connector by including the discount object in the order table has been added to our backlog. We will prioritize it based on customer demand and feasibility. Rest assured, I will keep you updated on any progress or developments regarding this feature.
Best,
Sanjeevv Maniram
Please sign in to leave a comment.
Comments
1 comment