The Excel module for the Order Fulfillment App does not require any special connection. Download the template, populate the fields, and upload it through the Excel Module within the app.
Table of Contents
Get the Excel Template
Column Descriptions
Column Name | Type | Required | Description | Example |
---|---|---|---|---|
order_po | number | yes | A unique order identifier | 12345 |
ship_first_name | text | yes | Recipient’s first name | John |
ship_last_name | text | yes | Recipient’s last name | Doe |
ship_company_name | text | no | Recipient’s company name | ABC Company |
ship_address_1 | text | yes | Recipient’s street address | 123 Somewhere |
ship_address_2 | text | no | Additional address information | Suite 12 |
ship_city | text | yes | Recipient’s city or town | Sunshine City |
ship_state_code | text | see description | The recipient’s official two-digit state code. Required if shipping within the United States | CA |
ship_province | text | see description | The recipient’s province if outside the United States | |
ship_zip | text | yes | Recipient’s zip or postal code | 12345 |
ship_phone | text | yes | Phone number of the 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 someone about a shipment. | 123456789 |
ship_country_code | text | yes | Recipient’s official two-digit country code | us |
product_qty | number | yes | Number of copies | 1 |
product_sku | text | yes | Product code found when setting up a print in P.O.S.T., our print ordering app, or the SKU from virtual inventory. | AP1234P1234 |
shipping_code | text | yes | See shipping codes below | EC |
product_image_file_url | text | see description | URL to high-resolution downloadable image file to be printed. Required if not using product code rather than a SKU from virtual inventory. | |
product_thumb_url | text | see description | URL to preview what will be printed on the invoice. Required if not using product code rather than a SKU from virtual inventory. | |
product_cropping | text | see description | Leave blank or use the word “crop” if you want the image to be cropped if it does not fit the size. Use “fit” to not crop. |
Shipping Codes
To be used in the shipping_code column.
shipping_code | description | Transit Time Avg | Notes |
---|---|---|---|
EC | Economy | 3-7 days | Goes the least expensive method |
SD | Standard | 2-5 days | Usually goes via UPS ground or USPS Priority |
EX | Express | 2-3 days | Usually goes via Fedex/UPS 2-day or Priority Mail (whichever is estimated faster) |
ON | Overnight | 1-2 days | Usually goes via Next Day Air or Express Mail. It may not be available for some orders, in which case the fastest method will be selected. |
FAQs
Shipping
You can see what shipping options and costs are available to you when you have items in your shopping cart.
Please note that some shipping options may not be available where print sizes exceed the measurements the packaging can hold. In cases of oversized packages (usually when they contain multiple mounted canvas prints measuring 30×40 or larger), additional shipping charges may be required. The customer will be notified in advance prior to processing the order.
More information on shipping rates can be found here.
Some product types will give you the option for “Priority Processing,” in which case we attempt to have the order completed within 24 to 48 hours.
Rush or priority processing may not be available for all product types; however, you can contact customer service to see if this is possible.
Yes. When checking out, you would enter your friend or family’s address information as the “Ship To” destination. You can also request drop shipping on the final review page. With the drop ship option selected, a generic packing slip is included, which does not reflect the price. In addition, we will print your billing address on the return address label and not include any mention of FinerWorks.
You will need to place a separate order for each shipping destination since only one shipping destination can be entered per order.
Use our Order Status and Tracking page or refer to your shipment confirmation. If you were logged in at the time the order was placed, you can also check your Order History.
When an order is shipped, we will send you an email indicating your order has been successfully processed and is on its way. There will also be a link to view your order status and get the tracking number for your order.
Paper prints will many times be grouped and placed in a single clear plastic sleeve. Prints are not individually sleeved each print unless it is ordered as an add-on.
These print sleeves are intended solely to add protection during transport. If you wish to obtain additional print sleeves for your inventory, you can order print sleeves here.
They are ideal for protecting your work from fingerprints, smudging, dust, and scratches as a result of casual handling or storage while also increasing the perceived value of the print.
Depending on the product type, they may be boxed, rolled in a shipping tube, or in some cases, placed on a pallet (huge orders). We use multiple carriers and multiple shipping methods, broken down as either Economy, Standard, or Express shipping. The primary carriers we use are UPS, FedEx, and USPS.
Orders shipped overseas that are sent via USPS will ultimately be turned over to the destination country’s shipping carrier.
International orders tracking sometimes relies on the destination country and shipping method. In many cases, for small orders, tracking might end once it reaches its last stop before leaving the U.S.
Depending on the product type, production can vary based on the product you are ordering, the time of year, as well as current inventory levels.
Please note that production times and shipping times are two different time spans. So, if two-day shipping is selected, this does not mean you will receive your print in two days. View our turnaround page and shipping page for details.
Finerworks offers some retail-ready packaging options for primarily paper prints. These are available within P.O.S.T., our online ordering tool.
Our average for most frames is about 5 to 7 days in production; however, there may be exceptions dependent on current inventory levels and how quickly the supplier can send us the required stock.
You can also see our turnaround time page for time frame details.
If you are based outside of the U.S. and want your order drop-shipped, we recommend configuring your business profile with a U.S.-based address. This prevents confusion and potential problems that can occur with the shipping service or even customs.
You can access your business profile in your account business profile or the Order Fulfillment App.
Prints being lost or damaged during shipping is rare; however, it does happen on occasion (less than 1% of orders are ever reported), and we will do everything possible to provide a replacement as soon as possible. For more information, please visit our returns and replacement page.
Order HD Chromaluxe® Metal Prints
Print your artwork or photography as custom-size metal prints. Using the dye-sublimation process, your image is fused to the surface of rigid aluminum panels. These provide a modern look when decorating your home or office. Choose from multiple metal surface options. Order it framed, with a float wall mounting or even with a tabletop easel back.