You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Clearing Existing Data Element in Bulk Import

Accepted answer
edited Feb 3, 2023 8:16PM in Commerce 12 comments


We need to know what value needs to be sent in the bulk load to clear a value that was sent in a previous load. This can occur in many cases where there was a value for an element and then in the ERP the value was cleared for one reason or another and need to clear this in OCC.

What value needs to be sent to clear an element that has existing data. Is there a null value syntax or passing in blank?

In the bulk import has been done several times since the load with incorrect was done and published. The value in the CSV file is/has been "". The bulk import process is not clearing the value it is leaving it with the previously uploaded and published value. Thus I am wondering if we need to pass a particular value in this case to truly clear a value. In some applications I have seen where you need to pass nul in as a value.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!