Hi All,
I am using the Amazon NetSuite connector, and I am facing a limitation when sending product data to Amazon. We have a set of custom fields that store bullet point data, but in the mapper, I am unable to map more than 1 bullet point to this.
Anyone else facing the same issue? Kind of defeats the purpose of using a connector as we now manually upload this data to Amazon via a CSV upload.
Hi Ovina,
Thank you for reaching out. To address this, you’ll need to include the bullet_point in the saved search using the format below, depending on how many bullet_points are available for the item:
attributes.bullet_point.0.value
attributes.bullet_point.1.value
attributes.bullet_point.2.value
attributes.bullet_point.3.value
attributes.bullet_point.4.value
Then, you’ll need to map the fields accordingly, as suggested on this page:
Please see the sample screenshot below for further guidance. On the left side of the screenshot, you’ll see the saved search results tab displaying the bullet_points labeled in this format: “attributes.bullet_point.0.value“. On the right side of the screenshot, you’ll find the corresponding mapping and the input and output when previewed.
Thank you, Richel! you are a hero(ine)! I was trying to find a solution was this, and i was told (by celigo support team even) that there is no fix and there is a limitation.
One moe question. I have 5 bullet points, and sometimes the 5th bullet points can be empty/null. How to handle that?
Hi Ovina,
Thank you for reaching out. I’m really glad to hear Richel’s solution helped.
Regarding your follow-up question about handling cases where the 5th bullet point might be empty or null:
You can manage this directly in the field settings of your bullet point mapping. Under the Settings icon (gear icon) for the bullet point field, you'll find an option labeled "Action to take if source field has no value." Please set this option to "Do nothing."
This setting ensures that if the 5th bullet point is null or blank, it will simply be skipped and won’t cause any issues in the output.
Based on the above output from NetSuite I get the below
I have the same setup as you mentioned.
However, I get the error below:
Hi Ovina,
It appears that a more in-depth investigation is required to determine the root cause of the error. To proceed, I will create a support ticket on your behalf. You should receive an email shortly.
