Overview
While creating boxes for a shipment, you may encounter the following error:
null value in column "packing_option_id" of relation "box" violates not-null constraint
🔍 Why This Error Happens
This error occurs due to the following sequence:
Amazon does not return packaging options for the shipment plan.
The placement option has already been confirmed in Amazon.
Because packaging options are not available, the system cannot assign a valid
packing_option_id.Since
packing_option_idis a required (not-null) field, the box cannot be created.This results in the error shown above.
In short, once placement is confirmed and Amazon does not provide packaging data, boxes cannot be generated for that shipment plan.
🛠 Resolution
To resolve this issue, please follow the steps below:
Cancel the Shipment Plan for the batch.
Regenerate the Shipment Plan
Allow Amazon to generate packaging options during shipment creation.
Proceed to create boxes again.
Once a new shipment plan is generated and Amazon returns valid packaging options, the system will be able to assign a proper packing_option_id, and box creation should complete successfully.
Important Notes
This is not a system defect.
The issue occurs because Amazon does not return packaging information once placement is confirmed.
The only supported resolution is to cancel and regenerate the shipment plan.
Contact customer support if you see any issue.