Get a Consolidated List of Products Ordered

If you run a fulfillment center that has multiple stores, you may want an easy way to get a consolidated list of products required when the time comes to fulfill the production of orders put through the stores. There are a couple of options to achieve this. One option is to run an order summary report by exporting orders to a CSV file. The second option is to bulk-select multiple orders in the Production screen, filter by store, and bulk-download the worksheets for the selected orders.

Watch the following video for instructions on how to get a consolidated list of products that have been ordered across multiple stores to make it easier to manage production. See below for written instructions.

Prerequisites

• You must have administrator access to use this feature

In this article, you will learn how...

• To export orders
• To download production worksheets in bulk

To export orders:

1. Log into DecoNetwork and browse to Admin > Reports > Export Orders.
   
2. Click the button to configure how the export will function.

   Configure the following settings:

   • 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 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
     • Order Line Id
     • Date Ordered
     • Date Shipped
     • Date Due
     • Date Produced
     • Date Scheduled
     • Product Name
     • Product Code
     • Category
     • Size
     • Color
     • SKU
     • GTIN
     • SKU Qty
     • Options
     • Line Qty
     • Blank Product Price
     • Decoration Price
     • Decoration Process
     • Unit Price
     • Line Total
     • Discount
     • Tax
     • Tax Exempt
     • Order Total
     • Order Shipping Total
     • Order Coupon Discount
     • Order Coupon
     • PO Number
     • Supplier PO Number
     • Supplier
     • Supplier Base Cost
     • Production Team Member
     • Production Status
     • Order Job Name
     • Store Commission
     • Store Name
     • Store Url
     • Store Group
     • Company
     • Billing SalutationBilling First Name
     • Billing Last Name
     • Billing Email Address
     • Billing Address
     • Billing City
     • Billing State
     • Billing Postcode/zip
     • Billing Country
     • Billing Phone No.
     • Shipping Salutation
     • Shipping First Name
     • Shipping Last Name
     • Shipping Address
     • Shipping Address 2 (40 char limit)
     • Shipping City
     • Shipping State
     • Shipping Postcode/zip
     • Shipping Country
     • Shipping Phone No.
     • Shipping Company
     • Shipping Method
     • Weight Total
     • Design Name
     • Design Price
     • Thumbnail Image URL
     • Customer ID
3. Click Save.

   You are returned to the Export Orders page.

   
4. Select CSV as the export format.

   A CSV (comma-separated values) file is a file that stores 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.

5. Select Create Export
   

   You will then be asked to select an export method.

   
6. Choose 'Export orders between a date range' to create an ad hoc export of all the orders made between specific dates.

   From and To date fields and export options will become visible.

   
7. Click on the calendar icons to pick the From and To dates, then select the 'Order Line Items' option.

   The 'Order Line Items' option will include one row per product from every order in the spreadsheet, essentially giving you an itemized list of all of the products that were ordered during this date range. This will help you to build a report about how many quantities and colors of which products were ordered.

8. Click on the Save button.

   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.

   

To download production worksheets in bulk:

1. Log into your DecoNetwork website.
2. Browse to Business Hub > Production.
   
3. Tick the checkboxes of the jobs you want to download production worksheets for.
   

   You can click on the circle icon at the top of the checkbox column to display the bulk-selection options:

   
   The number in the circle indicates the number of jobs selected.

   • Click on select all x line items to select all line items (x is the total number of jobs).
   • Click on select all line items on this page to select all jobs displayed on the current page.
   • Click on deselect all to deselect all line items.
4. Click on Download selected orders.
   
5. Select a download option:
   
   • Download worksheets and graphics as individual files: will download each order as a separate pdf along with all associated graphics production files (all compressed into a zip file).
   • Download worksheets as one pdf: will consolidate all orders into a single worksheet pdf file. (Production graphics files will not be downloaded with this option).
6. Click okay.
7. Click on the download link in the Download Orders popup.
   

   Depending on your browser settings, the worksheets will be immediately downloaded to the default download location or you will be prompted to choose a download location.