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
Mugs
We have built in volume & bulk discounts that will cover most scenarios; however, if the scope and size of the order is not listed when checking pricing, please contact us with the details of what you want to order and the time frame so that we can work out the fulfillment and pricing of the order.
Most people order online via our website’s Print Online Setup Tool. Using this method, you will upload your image file(s), select the product type, styles, and size of print you want, then add the item to your shopping cart.
Some businesses that use us may have their websites connected to us, either through our Order Fulfillment App or one of our legacy integrations, which allow for batch order submissions.
FinerWorks is unable to accept orders by phone or email.
Yes, they are; however, for the maximum life of the imaged product, we recommend hand washing.
We strive for excellent color accuracy, but some slight variation may occur due to the differences between screen and print, especially with sublimation. You can order a sample mug if you’re concerned about precise color matching, especially before you place any large bulk orders.
Nope! You can order just one or as many as you need. Whether you’re creating a custom gift, testing a new design, or fulfilling an order for your online store, we’ve got you covered.
However, you can likely save when ordering in bulk since many of our products have built in volume discounts.
Production typically takes 1–3 business days. This is just an average and may take longer during busy seasons, such as around the holidays or when inventory is being replenished. Shipping times vary by location, but we offer standard and expedited shipping options to meet your needs.
We take great care in packaging, but if your mug is damaged during shipping, we’ll replace it at no cost. Just contact us with a photo of the damage and your order number.
Dye-sublimated mugs are perfect for:
- Photographers offering personalized gifts
- Brands and businesses using logo mugs for promotion
- Gift givers looking for unique custom items
We use professional dye-sublimation equipment and blank mugs specifically coated for vibrant and lasting results. Unlike at-home kits or DIY options, our process ensures consistent quality, scalability, and fulfillment services—especially valuable if you’re selling online.
Giclee Printing at FinerWorks
One of the largest ranges of paper selections, while using the highest level of archival print technology allowing superior detail and color, you can create custom giclee prints of your artwork and photos.