has anyone ever figured out how to add products to...
# suitecommercec
Casey Rotach
05/15/2020, 5:32 PMhas anyone ever figured out how to add products to their commerce category at time of item creation as opposed to needing to drop the item name in the commerce category at Lists>Web Site
w
wbermudo
05/15/2020, 5:38 PMI think you need a user-event script deployed on item to automate that process.
c
Casey Rotach
05/15/2020, 5:40 PMok, thank you. any chance you know what sql table commerce category data lives? I found item_site_categories
w
wbermudo
05/15/2020, 6:05 PMyou need to use SuiteScript to do CRUD on this table, NetSuite tables are not exposed, but we they have an equivalent record type/id. Check SuiteScript and SuiteScript Records Browser documentation about this. Help guide is healthy with how-to’s.
wbermudo
05/15/2020, 7:04 PMoh, I remember - if SuiteScript is not an option yet at this time. You can also do a CSV import on the record.
6 Views