From the order export csv, I can find the column of POS location(column BB) and payment status only.
How can I export the order with store location and fulfillment status?
Topic summary
-
Issue: The built-in order export CSV only shows POS location (column BB; POS = point of sale) and payment status. The requester needs exports that include store location and fulfillment status.
-
Limitation: Natively, this cannot be done. The exportable columns are fixed, and only filters can be modified.
-
Workarounds: Use third-party apps that allow custom report fields and data blending/joining. Suggested options: Advanced Reports for reporting-focused exports; Mipler Data Flow for automation or exporting to other systems.
-
Outcome: No native solution; external apps are required to include fulfillment status alongside store location. The discussion concludes with app recommendations rather than a built-in fix.
Short answer: you can’t.
The list of columns that you can export is fixed, and you can only adjust filters. If you need to blend or join data in some way, you need an external app with these capabilities.
If you need to export orders for some kind of reporting, look at reporting apps (you can select what data to display and export) such as Advanced Reports.
If you need to export orders for other purposes (e.g., importing to other systems) or for automation, look at Mipler Data Flow, which can also export and blend data.