Any Celigo BigCommerce/NetSuite users out there? I'm trying to bring the option sets and chosen options into NetSuite. On this custom item, the customer can choose a range of options. I'm trying to pull all the things they chose (Header Style: Notice, Orientation: Landscape, etc. etc.) into the Sales Order in NetSuite. Anyone know if this is possible? I'm able to pull a single value (either the option name OR option value) using "products[*].product_options[0].display_value" but when I try to join multiple names or multiple values, it fails out

Hello @ericbirdsall! I'll reach out to you on a direct chat. There's a few ways to extract the data from BigCommerce through your Celigo integration and I'd be glad to share some advice!

Thanks @rico for connecting us 🙂

@Mannan I'd appreciate piggybacking on this - would love to hear your advice and would also be happy to share some workarounds we've used. I've mostly set things up with help from Celigo directly (create a ticket and explain what you need to do.) Here's an example of code that helps us lift the selected start date for a customized subscription bolt on (MiniBC) we have: {{#each products[*].product_options}}{{#compare display_name "==" "Select Start Date"}}{{{display_value}}}{{/compare}}{{/each}}

Hey @Brad Wentworth! That's my go to expression as well. @ericbirdsall was looking to push all the custom values into a single column field so suggested a few options

For anyone following along... I ended up using this mapping: {{#each products[*].product_options}} {{#compare display_name '!=' ''}} {{{display_name}}}: {{{display_value}}} {{else}}{{/compare}}{{/each}} This essentially checks if a product option exist for the SKU, and if it does- this adds a line of "Product Option Name: Product Option Value" Warning: this just provides 1 string with all of the options/values. As @Mannan has pointed out - it's likely a better practice to pull each option/value into a separate item column in NS, but our flow is somewhat unique.

@ericbirdsall thanks for posting. I'm starting our Celigo (BC to NS) configuration this week. Any tips and tricks help!