Packing list to CSV.
A reliable CSV keeps each line item, unit, and shipment reference tied to the source packing list.
1. Start with the destination columns
Start with the import specification or spreadsheet your receiving team already uses. List the required columns and value types. A basic export might include product_sku, description, quantity, quantity_unit, carton_count, and gross_weight_kg.
Add shipment fields such as purchase_order and packing_list_number to each row when your destination requires them. Confirm the file format before preparing a full batch.
2. Keep one source line item per row
Preserve separate SKUs, variants, and units. If the supplier groups products by carton, check whether your destination needs one row per product or one row per carton.
Store product codes as text. Spreadsheet software can remove leading zeros or turn a code into a date.
3. Make units explicit
A quantity of 12 could mean pieces, packs, or cartons. Keep the source unit and confirm conversions against supplier or product data. Apply the same care to weights and dimensions.
4. Check totals against the source
Compare line-item quantities with the packing list total when the units match. A mixed carton can contain several product lines, so summing every row may count the same carton more than once.
Keep an empty weight field empty until you can resolve it. Entering zero can make missing information look like a measured value.
5. Review, then test the import
Check references, product codes, quantities, and exceptions against the PDF. Test a small sample before importing the full file.
Keep the source packing list and record corrections. Treat automated extraction as a draft until someone reviews it.
Where CartonField fits
CartonField extracts the fields, keeps the PDF beside the result, and exports your chosen columns. Contact us to discuss your workflow.
Next: packing list fields.