Feature Enhancement Request: AD Data Feed Refresh Error / Increase Attribute Value column length
As a CSM, I am submitting this enhancement request on behalf of Stellar Industrial and their systems integration partner, Apexon, who are integrating an external AD-based product data feed with Optimizely Commerce Connect.
Stellar Industrial's AD system supports attribute values up to 500 characters, but Commerce Connect currently limits the attributeValue table to nvarchar(255). When their data feed refresh job runs, any attribute value exceeding 255 characters causes the job to throw an error, resulting in incomplete and inaccurate product data in their catalog.
What we're trying to solve: Stellar Industrial needs their AD data feed refresh jobs to complete without errors, and for all product attribute values to be saved accurately in Commerce Connect regardless of length.
Desired outcome: Increasing the column size to nvarchar(500) would align Commerce Connect with the capacity of their source AD system, allowing data feed jobs to run reliably and ensuring product attribute data is fully and accurately reflected in Stellar Industrial's catalog.
This is currently a blocker for reliable product data synchronization and is impacting catalog accuracy at scale.