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: 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 price of the blank product before any decoration or customization.
     • 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.
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.