• Resolved kslrweb

    (@kslrweb)


    We sell rather technical products and are trying to important a bunch of product metadata from NetSuite (mapped through Celigo) into ACF. This process is working well for all but multi-select items in NetSuite. We’ve mirrored those NetSuite fields in ACF with the same selection options. We know from the JSON that Celigo is importing this information, but it’s not showing up in ACF. I’m wondering if anyone else has run into this issue and is familiar with a workaround.

    • This topic was modified 1 year, 9 months ago by kslrweb.
Viewing 1 replies (of 1 total)
  • Hi @kslrweb

    ACF Support Team here, Thanks for reaching out with your query we would be happy to assist.

    I am afraid ACF as it is out of the box doesn’t have a feature to import data and this is not something we can be able to assist from our end due to clarification.

    However, for basic fields such as text, the ACF plugin uses the field name as the meta_key in the wp_postmeta table(For fields in posts) to save the field value and the field reference key. That is field_name will be used to store the value of the field and _field_name will be used to store the field key as shown in the image at https://drive.google.com/file/d/1N9LoJ3WIFRVb5awF1tZ1oEkmsC22DD8f/view?usp=sharing.


    For the select field, the data is stored similarly to that of the basic fields, however, when multi-select is enabled, the value is stored as a serialized array in order to accommodate all the choices selected as illustrated at https://drive.google.com/file/d/1xyhajG-jVjC7zGh2LMGN7RosMz7ffdbp/view?usp=sharing.

    That said, you should ensure the data is stored in the right format for ACF to understand it. You can also check with Celigo Support if they have a way to execute custom code during import so that you can use update_field() to update the field.

    If you need further clarification, please create a ticket using our ?support form and we can look into it further.

Viewing 1 replies (of 1 total)
  • The topic ‘Multi-select options not showing up when importing data from NetSuite’ is closed to new replies.