We have a bunch of custom columns on the Sales Order Item Lines that pull from various fields on the Item/Customer Record when a Sales Order is created, but these columns are not being populated when an order from our SuiteCommerce website is created, they work perfectly when an order comes in via EDI or is manually entered. Any idea on why or how to fix this, these columns are used in Workflows and used to populate Order Ack and Picking tickets.

If you're populating those values via workflow. The context for webstore needs to be selected. (image below) If you're using a script check that webstore is selected in the execution context of the script deployment.

They automatically populate when an item is added when done manually, not sure how they are done when order is created by EDI. The custom fields are linked to the respective field when they were created and added to the SO record item line

Are those custom columns part of a bundle? My guess is that they are updated via a script or a workflow. If this is part of a bundle, then the fields might be protected, in which case, you either contact the developers of the bundle and request them to enable the filling of that data to the webstore, or you can create a script to fill those values upon creation for webstore context.

Not part of bundles, custom fields I created and set to pull data from the item or customer record, what is confusing is they work with EDI orders but not Website orders

oh ok so you're sourcing the values in the definition of the field itself?, if not how are you filling those values for EDI and NS?

I will give that a try

👍 Let me know if it works for you.

@Gonzalo Martinez - checking that box looks like it resolved the issue, would never have thought that box would have affected those. Thank you for your help.

That's great news. Glad I could help!