Batch Order Submission Tool
Upload Your Excel Spreadsheet

The batch ordering app allows you to upload a spreadsheet or submit a JSON formatted text file containing multiple orders that need to be drop shipped to different customers.

How to Use

You can create a spreadsheet manually using most major spreadsheet programs that will allow you to save/export the data as a MS Excel file. You can also create a JSON formatted text file with any text editor.

If you are a web application developer/programmer, consider having either of these generated automatically to save time.

Spreadsheet Example

JSON Example

How Do I Submit Orders

Currently this tool is available by request and requires a minimum of 5 orders to be submitted at once. If you would like to start submitting orders via the batch uploader please let us know so that we can begin setting you up to do so.

Questions?
Contact us with general questions regarding the use of this feature

Send Message

Spread Sheet Fields

Below is a list of the both required and optional fields. These should be in the first row (header) of your spreadsheet.

Column HeaderTypeRequiredDescription
account_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_codedescription
ECEconomy
GDGround
3D3 Day
2D2 Day
1DNext Day
Subscribe to Our Newsletter

 

 

Reference ID: 20180919080045139
Copyright © 2018 FinerWorks Media, LLC. All rights reserved.