Sendinblue Plugin

Hi-am using V4.5 with the most recent Sendinblue plugin and get the following error message in the plugin page.
Unfortunately, there’s been an error, feel free to reach our support team. Error calling CreateAttribute: {"code":"invalid_parameter","message":"Incorrect formula. Please refer https://resources.sendinblue.com/formulas/ to read the formula"}

Can anyone suggest a solution?

Thanks

Look at this topic if it helps.

I am also having this same issue. Same version of Nop 4.5, using the built in version of sendinblue.

From what I can find, when Category.Enum.Transactional is created for ORDER_PRICE
It's datatype is set to "Text"

src\Plugins\Nop.Plugin.Misc.Sendinblue\Services\SendinblueManager.cs
Line 1002

(CategoryEnum.Transactional, SendinblueDefaults.OrderTotalServiceAttribute, null, CreateAttribute.TypeEnum.Text),

In the newest version of Sendinblue, text is no longer allowed for SUM[ORDER_PRICE]

The Attribute type needs to be "Number" in their list (Or from what I can gather, float from the TypeEnum)


After changing the ORDER_PRICE to Number, the errors went away.

The workaround for now is,
Click below to get into your sendinblue account
https://my.sendinblue.com/lists/add-attributes#tab-attributs-tra

Remove ORDER_PRICE from Transaction Attributes in sendinblue
Then, re-add it back as
Attribute Name: ORDER_PRICE
Attribute Type: Number

Then in the Calculated Values tab in sendinblue,
Add the following (if they don't already exist)

Attribute Name: NOPCOMMERCE_CA_USER
Calculation formula: SUM[ORDER_PRICE]

Attribute Name: NOPCOMMERCE_LAST_30_DAYS_CA
Calculation formula: SUM[ORDER_PRICE, ORDER_DATE,>,NOW(-30)]

Attribute Name: NOPCOMMERCE_ORDER_TOTAL
Calculation formula: COUNT[ORDER_ID]]

Thanks for the info. We'll also fix this, here is a work item.

We have updated the plugin, implementation details in this commit.

Thanks very much for the updates.
Can I update the plugin without uninstalling,  or do I have to uninstall/reinstall?

@SGEDU
The way I read the response / commit, they only updated the code in GitHub.  If you need the fix for 4.50, then you need to have a developer make the same code change, and compile/build the plugin.
(Then you could just take the new .dll and overwrite the .dll in your Sendinblue Plugin folder)

ah Ok..thanks for that.

You are a legend, thanks so much. The final calculated attribute wouln't add for me, but after doing the rest the plugin appears to be working error free again.

[email protected] wrote: