Exporting Orders

Your business may utilize third-party accounting software to manage financial data. DecoNetwork provides you with the flexibility to export your order data seamlessly to the application of your preference. You can choose from various export formats such as CSV, Quicken, Shopworks, or MYOB, ensuring compatibility with a wide range of accounting systems. This tutorial will guide you through the straightforward process of exporting your DecoNetwork order data, empowering you to integrate smoothly with your existing financial management tools.

To Export your Orders:

Log into DecoNetwork and browse to Admin > Reports > Export Orders.
Click the button to configure how the export will function.
- Export date lets you set the triggering event after which the order will be exported. For example, if the product was ordered on the 10th, and invoiced on the 12th, an export of invoiced products from the 11th onwards will pick up this order. If the Export date was set to Ordered (the 10th, which is before the export date), this would not be included in the export.
- Export Order Options lets you choose whether to include canceled orders in the export. Tick the Include cancelled orders checkbox to include canceled orders. Untick the checkbox to exclude canceled orders.
- Export Order Columns lets you select which columns (pieces of transaction data captured at order time) are exported when doing a CSV summary export.
  Click on the Select Order Summary Columns button to open the selection popup.
  
  Tick the checkboxes of the data you want to be exported.
  
  The following information can be included in the order summary export:
  - Order Number: the unique identifier of the order.
  - Order Type: identifies, where the order originated - Internet or Business Hub
  - Status: the stage that the order has reached within the order processing workflow.
  - Production Status: the stage that the order has reached within the production workflow, if applicable.
  - Priority Order: indicates if the order has priority status.
  - PO Number: the purchase order number provided by the customer, if specified.
  - Supplier PO Number: the purchase order number from the supplier, if specified.
  - Order Job Name: the name assigned to the order job.
  - Sales Staff Accoun: the name of the team member responsible for the sale.
  - Date Ordered: the date when the order was placed.
  - Date Invoiced: the date when the order was invoiced.
  - Date Shipped: the date when the order was shipped.
  - Date Due: the due date for the order.
  - Date Produced: the date when the order was produced.
  - Date Scheduled: the date when the order is scheduled for production or shipment.
  - Order Total: the total amount of the order including all items and charges.
  - Shipping Total: the total shipping cost for the order.
  - Tax Total: the total amount of taxes applied to the order.
  - Tax Exempt: indicates if the order is tax-exempt.
  - Rush Order Cost: additional cost for a rush order, if applicable.
  - Coupon Discount: the discount amount applied to the order through a coupon.
  - Coupon Discount including Tax: the tax-inclusive discount amount applied to the order through a coupon.
  - Coupon: the coupon code used for the discount.
  - Gift Certificate: the gift certificate code used for the order.
  - Gift Certificate Value: the value of the gift certificate applied.
  - Credits: any credits applied to the order.
  - Final Discount: the final discount applied to the order.
  - Amount Billed: the total amount billed for the order.
  - Order Credits: the monetary value applied to an order, either as store credits, discounts, or refunds.
  - Outstanding Balance: the amount of money still owed on the account.
  - Payment Due Date: the due date for payment.
  - Payment Date: the date when payment was made.
  - Payment Terms: the terms of payment for the order.
  - Payment Method: the method used for payment.
  - Affiliate Commission: the amount of commission paid to affiliates, if applicable.
  - Referral Commission: the amount of commission paid for referrals, if applicable.
  - Affiliate Transaction Fee: the transaction fee for affiliate sales, if applicable.
  - My Store: the store associated with the order.
  - Wholesale Price: the wholesale price for the order.
  - Base Cost: the base cost of the products ordered, from the supplier.
  - Site Id: the unique identifier for the site associated with the order.
  - Site Name: the name of the site associated with the order.
  - Site Address: the address of the site associated with the order.
  - Store Group: the group to which the store belongs.
  - Billing Id: the unique identifier for billing contact.
  - Billing Salutation: the salutation for billing contact.
  - Billing First Name: the first name of the billing contact.
  - Billing Last Name: the last name of the billing contact.
  - Billing Company: the company name for billing.
  - Billing Email Address: the email address for the billing contact.
  - Billing Address: the street address for billing.
  - Billing City: the city specified for the billing address.
  - Billing State: the state specified for the billing address.
  - Billing Country: the country specified for the billing address.
  - Billing Post Code: the post code specified for the billing address.
  - Billing Phone Number: the phone number specified for the billing contact.
  - Shipping Salutation: the salutation for shipping contact.
  - Shipping First Name: the first name of the shipping contact.
  - Shipping Last Name: the last name of the shipping contact.
  - Shipping Company: the company name specified for shipping.
  - Shipping Address: the street address for shipping.
  - Shipping City: the city specified for the shipping address.
  - Shipping State: the state specified for the shipping address.
  - Shipping Country: the country specified for the shipping address.
  - Shipping Post Code: the post code specified for the shipping address.
  - Shipping Phone Number: the phone number specified for the shipping contact.
  - Shipping Method: the method used for shipping.
  - Weight Total: the total weight of the shipment.
  - Tax Names (column per tax): the names of taxes applied to the order, with each tax having its own column.
  - Custom Customer Fields (column per field): the custom fields defined for the customer, with each field having its own column.
- Export Order Item Columns lets you select which data points are exported during a CSV line item export.
  Click on the Select Order Line Items Columns button to open the selection popup.
  
  Tick the checkboxes of the data you want to be exported.
  
  The following information can be included in the order item export:
  - Order Number: the unique identifier of the order.
  - Order Line Id: the unique identifier assigned to the order line item.
  - Date Ordered: the date when the order was placed.
  - Date Shipped: the date when the order line item was shipped.
  - Date Due : the due date for the order line item.
  - Date Produced: the date when the order line item was produced.
  - Date Scheduled: the date when the order line item is scheduled for production or shipment.
  - Product Name: the name of the product in the order line item.
  - Product Code: the code of the product in the order line item.
  - Category: the category of product to which the order line item belongs.
  - Size: the size of the product in the order line item.
  - Color the color of the product in the order line item.
  - SKU: Stock Keeping Unit, the unique identifier for the product.
  - GTIN: Global Trade Item Number, the unique identifier for the line item.
  - SKU Qty: the quantity of the product associated with the SKU.
  - Options: any additional options or customizations chosen for the line item.
  - Line Qty: the quantity of the specific product ordered in the line item.
  - Blank Product Price: the final price of the blank product with decoration/order markups applied in Business Hub.
  - Original Blank Price: the price set for the blank product in the Admin before any decoration or customization markups are applied in Business Hub.
  - Decoration Price: the price of decoration applied to the product.
  - Decoration Process: the process used for decorating the product.
  - Unit Price: the price per unit of the product, including any decorations or customizations.
  - Line Total: the total cost for the line item, considering quantity, decoration, and any discounts.
  - Discount: any discount applied to the line item.
  - Tax : the total amount of taxes applied to the order line item.
  - Tax Exempt : indicates if the order line item is tax-exempt.
  - Order Total: the total cost of the entire order, including all line items and fees.
  - Order Shipping Total: the total shipping cost for the entire order.
  - Order Coupon Discount: the discount amount applied to the order through a coupon.
  - Order Coupon: the coupon code used for the discount.
  - PO Number : the purchase order number provided by the customer, if specified.
  - Supplier PO Number : the purchase order number from the supplier, if specified.
  - Supplier: the supplier associated with the product.
  - Supplier Base Cost: the base cost of the product from the supplier.
  - Production Staff Account: the member of the production team responsible for the line item.
  - Production Status : the stage that the order has reached within the production workflow, if applicable.
  - Order Job Name : the name assigned to the order job.
  - Store Commission: commission earned by the store for selling the item, if applicable.
  - Store Name : the store associated with the order.
  - Store Url: the URL of the store associated with the order.
  - Store Group : the group to which the store belongs.
  - Company: the company of the customer who placed the order, if applicable.
  - Billing Salutation: the salutation for billing contact.
  - Billing First Name : the first name of the billing contact.
  - Billing Last Name : the last name of the billing contact.
  - Billing Email Address: the email address for the billing contact.
  - Billing Address : the company name for billing.
  - Billing City: the city specified for the billing address.
  - Billing State: the state specified for the billing address.
  - Billing Postcode/zip: the post code specified for the billing address.
  - Billing Country: the country specified for the billing address.
  - Billing Phone No. : the phone number specified for the billing contact.
  - Shipping Salutation: the salutation for shipping contact.
  - Shipping First Name: the first name of the shipping contact.
  - Shipping Last Name: the last name of the shipping contact.
  - Shipping Address: the street address for shipping.
  - Shipping Address 2 (40 char limit): the additional details specified for the street address with a limit of 40 characters, if applicable.
  - Shipping City: the city specified for the shipping address.
  - Shipping State: the state specified for the shipping address.
  - Shipping Postcode/zip: the post code specified for the shipping address.
  - Shipping Country: the country specified for the shipping address.
  - Shipping Phone No.: the phone number specified for the shipping contact.
  - Shipping Company: the company name specified for shipping.
  - Shipping Method: the method used for shipping.
  - Weight Total: the total weight of the shipment.
  - Design Name: the name of the design applied to the product.
  - Design Price: the price of the design applied to the product, if applicable.
  - Thumbnail Image URL: the URL of a thumbnail image representing the line item.
  - Customer ID: the identifier of the customer associated with the order.
- Export Order Item Generic Line Items lets you set which generic items are exported during a CSV line item export, for example, shipping fees, rush order fees, and so on.
- MYOB Order Export Options lets you make configuration options if making a MYOB export. You can set the customer name to export orders against (as MYOB exports must be made against a single customer), the account number for that customer, tax code, tax-free code, and tax-free export code.
Click Save to save the settings.
Choose between CSV, Quicken, Shopworks, or MYOB

CSV (comma-separated values) files store tabular data such as spreadsheets, lists, or databases. The format is widely used as a fallback format by most applications as it is always in plain text, using basic characters with simple formatting. If your finance package is not listed as one of the other alternative export formats, choose CSV.

Quicken is a personal finance management tool developed by Intuit, Inc. that is linked with DecoNetwork software. You can export your orders from DecoNetwork right into your Quicken account.

Shopworks is a business management software that is also linked with DecoNetwork and can be used to export your orders.

MYOB, which stands for Mind Your Own Business, is a corporation that provides tax, accounting, and other services to businesses. You can export orders from DecoNetwork into your MYOB account as well.

None of these methods create an automatic synchronization of DecoNetwork and the accounting software. If you wish to integrate your accounting software, go to Admin > Reports > Accounting Software Integration
Select Create Export

You will then be asked to select an export method.
Choose the export method:
- Choose 'Export New Orders' to create an export history of all the new orders made since your last export.
- Choose 'Export orders between a date range' to create an ad hoc export of all the orders made between specific dates.
Click Save to save the changes.
The server will then process your request and download the file to your system. The report will also be available to download or view via the Order Summary button.