Hi everyone, I’m currently working on a web develo...
# general
w
Hi everyone, I’m currently working on a web development project for a NetSuite client who wants to sync their inventory with Shopify. I have written a middleware application and I am using SuiteQL to query the data from NetSuite to push onto Shopify. So far, everything’s running smoothly except for the item images. The client has a tab in the NetSuite Item edit page called "Custom" to upload these images—each product can have up to 10 images. I need to access the values stored there for each inventory item using SuiteQL. I’ve attached a screenshot of the custom tab in NetSuite for reference. Does anyone have experience with retrieving values from a custom tab in NetSuite using SuiteQL? Specifically, how can I query these custom fields for each inventory item? Any help or pointers would be greatly appreciated! Thanks in advance!
I have used the Netsuite fields browser plugin and can see the field I need - however it doesn't get returned when I make a SuiteQL query just select * from item
e
You should be able to find the custom item fields in the item table
Are the custom item fields set to store value or are those values being sourced dynamically from some other source
b
i will give the opposite advice, suiteql does not support image fields. you need to get your images using a different method
r
I would suggest asking your client to host images elsewhere and just store those image paths in Netsuite, specifically if they have a big SKU.