How to Export Orders to a CSV

Export your DecoNetwork order data to CSV so you can bring it into accounting software, spreadsheets, or reporting and analysis tools. Configuring the export trigger point and column selection once means every future export gives you data at the right stage of the order lifecycle, with exactly the fields you need.

In This Article

• Prerequisites
• Why use this feature?
• Step 1: Open Export Orders
• Step 2: Configure Export Settings
• Step 3: Choose Which Columns to Export
• Step 4: Run an Export
• Best Practices
• Troubleshooting
• FAQs
• Additional Resources

Prerequisites

Why use this feature?

Exporting orders isn't just about getting data out of DecoNetwork, it's about getting the right data out at the right point in the order lifecycle. An order that's been ordered but not yet invoiced won't show up the same way in every export, depending on which trigger point you've configured, so getting this right protects the accuracy of your accounting and production reporting. Because columns are fully configurable, this is also your opportunity to capture everything you might need for deeper reporting, including feeding the export into another analysis tool.

• Sync order data with accounting software like Quicken, Shopworks, or MYOB
• Build accurate reports tied to the correct point in the order lifecycle
• Get itemized, per-product data for production or sales analysis
• Prepare clean data for spreadsheets or AI-based reporting tools

Step 1: Open Export Orders

1. Log in to your DecoNetwork website.
2. Browse to Admin → Reports.
3. Select Export Orders.

Step 2: Configure Export Settings

Export Orders → Settings

1. Click Settings.
2. Set Export Date to the event that should trigger an order's inclusion: Ordered, Invoiced, or Shipped.
3. Tick Include cancelled orders if you want cancelled orders included, or leave it unticked to exclude them.
4. Click Save.

Step 3: Choose Which Columns to Export

1. Click Select Order Summary Columns to choose the fields included in a summary export, such as Order Number, Order Type, Status, Production Status, billing and shipping details, taxes, and sales person assigned.
2. Click Select Order Line Items Columns to choose the fields included when exporting one row per product line, including optional extras like shipping fees, rush order fees, coupon codes, and final total adjustments.
3. Tick the checkboxes for everything you might plausibly need.
4. Click Save.

Step 4: Run an Export

1. Click the CSV icon. Quicken, Shopworks, and MYOB are also available if your accounting software uses one of those formats.
2. Click Create Export.
3. Choose an export method: Export new orders to get everything since your last export, or Export orders between a date range, entering a From and To date, for example June 1 through June 30.
4. Choose Order Summary for one row per order, or Order Line Items for one row per product line.
5. Click Save to create the export.

Once saved, DecoNetwork begins generating the export, and the file becomes available for download once processing completes.

Best Practices

• Set your Export Date trigger deliberately based on what the report is for, for example Invoiced for accounting reconciliation or Shipped for fulfillment reporting.
• Overexport columns rather than underexport. It's far easier to delete unused columns in a spreadsheet than to re-run an export.
• Use Order Line Items when you need granular per-product data, and Order Summary when one row per order is enough.
• Decide upfront whether cancelled orders belong in a given report before running it.

Troubleshooting

Problem: An order I expected doesn't appear in the export.
Cause: The order hasn't crossed the Export Date trigger point, Ordered, Invoiced, or Shipped, within the selected date range.
Solution: Check your Export Date setting and date range against when the order was actually ordered, invoiced, or shipped.

Problem: A column I need isn't in the exported CSV.
Cause: The column wasn't selected under Select Order Summary Columns or Select Order Line Item Columns.
Solution: Return to Settings, open the relevant column selector, tick the columns you need, and run the export again.

Problem: Cancelled orders are showing up in a report where they shouldn't.
Cause: "Include cancelled orders" is ticked in the export Settings.
Solution: Untick "Include cancelled orders" in Settings, then run the export again.

FAQs

What's the difference between a summary export and a line item export?
A summary export gives one row per order. A line item export gives one row per product line within every order, which is useful for itemized reporting or feeding the data into another tool.

Why does the Export date setting matter so much?
It determines which stage of the order lifecycle counts for inclusion in the export. An order can fall outside your selected date range under one trigger point, like Ordered, while falling inside it under another, like Invoiced, so choosing the wrong trigger can leave orders out of a report unexpectedly.

What export formats does DecoNetwork support besides CSV?
Quicken, Shopworks, and MYOB are also available. Choose the format that matches your accounting software, or use CSV as a safe default if your software isn't listed.

Should I export every column available?
It's generally safer to select more columns than you think you need. It's much easier to remove unused columns from a spreadsheet afterward than to discover a report is missing something and have to export again.

Additional Resources

• Export Orders
• Export Orders and Order Line Item Reports
• What data is included in Export Orders Reports?
• Get a Consolidated List of Products Ordered
• Export Purchase Orders