Batch Order Submissions
Upload a Spreadsheet

The batch ordering or api allows you to submit your orders without the need to place orders through our normal ordering interface. Either upload an Excel document (see Excel tab) or submit a api request (see api tab) that contains the necessary order information.

Orders are recorded in your order history just like the would be if you placed them normally. It a great solution when you have multiple orders that need to be drop shipped to different customer.

How to Use

The Excel option is one of the more understandable however if you are a web application developer/programmer, consider having either of these generated automatically or using the Api submission process.

Sending Personalized or One of a Kind Print Orders

Many users require us to print one of a kind orders or personalized print orders. With these tools you can designate the sku (product id) and a location to download the image (i.e., DropBox). Simply include that in your order submission in the appropriate fields.

Sending Orders for Prints inside My Virtual Inventory

For those, all we will need is the Sku for that item. Since your file and print details have already been provide there is no need to do more to tell us what you want printed.

Spreadsheet / Excel Submissions

Many shopping carts and services where you receive your order allow you to download your order data into an Excel format. Change the column names to match the appropriate fields and you have an Excel doccument ready to submit.

Download the Template

Download the template if you have not already done so. Provide in all the required fields as indicated in the example / field descriptions.

Contact us for the appropriate submission url where you can uload your spreadsheet.

Multiple Items in an Order

You can submit multiple items in the same order by simply including the same PO for that item.


Below is a list of the both required and optional fields. If submitting via a spreadsheet, the field name should be in the first row (header) of your spreadsheet. See the JSON example if submitting via JSON.

Field NameTypeRequiredDescription
web_api_keytextyesWeb Api Key found within your account
order_ponumberyesA unique order identifier
ship_first_nametextyesRecipient's first name
ship_last_nametextyesRecipient's last name
ship_company_nametextnoRecipient's company name
ship_address_1textyesRecipient's street address
ship_address_2textnoAdditional address information
ship_citytextyesRecipient's city or town
ship_state_codetextsee descriptionRecipient's official two digit state code. Required if shipping within the United States
ship_provincetextsee descriptionRepcient's province if ourside the United States
ship_ziptextyesRecipient's zip or postal code
ship_country_codetextyesRecipient's official two digit country code
ship_phonetextyesPhone number of recipient or sender. This is required by USPS and UPS. Use your business phone number if not comfortable in supplying this. This will be the number UPS or USPS will use in the rare occasion they need to call somone about a shipment.
shipping_codetextyesSee shipping codes below
product_qtynumberyesNumber of copies
product_skutextyesSku for the product be ordered or sku from virtual inventory (starts with "AP"). You will need to supply one or the other otherwise you will be prompted to create a print using our Print App before the order can be submitted.
product_image_idnumbersee descriptionNumeric id number of image to be printed uploaded to your "Ready to Print" bin
product_image_file_urltextsee descriptionUrl to the downloadable image file to be printed
product_thumb_urltextsee descriptionUrl to preview what will be printed on invoice. Required if not using sku from virtual inventory.
product_croppingtextsee descriptionLeave blank of use the word "crop" if you want the image to be cropped if it does not fit the size. Use "fit" to not crop.
packing_slip_urltextnoUrl to download a custom 8 1/2 x 11 packing slip document to include. If present, will be included in place of the normal packing slip.
user_fedex_accounttextnoReserved for future use
user_ups_accounttextnoReserved for future use

Shipping Codes

shipping_codedescriptionTransit Time AvgNotes
ECEconomy3-7 daysGoes the least expensive method
SDStandard2-5 daysUsually goes via UPS ground or USPS Priority
EXExpress2-3 daysUsually goes via UPS 2 day or Pruirity Mail (which ever is estimated faster)
ONOvernight1-2 daysUsually goes via Next Day Air or Express Mail. May not be available for some orders in which case the fastest method will be selected.

My Web Api Key

Your web api key (account_api_key) is required to validate your submission.

Click here to access

Subscribe to Our Newsletter



Reference ID: 20190323174655780
Copyright © 2019 FinerWorks Media, LLC. All rights reserved.