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
Ceramic Tile
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.
Unfortunately, we do not offer a matte option for the ceramic tiles at this time.
It is possible the colors could fade over time if exposed to direct sunlight or if placed in a high traffic area.
The bulk discount will only apply if you are ordering the same tile with the same image within the same order.
The ceramic tiles are dye-sublimated and are not UV
Our ceramic tiles should be suitable for your needs based on feedback from our customers. While we used to offer metal trivet holders for the tiles, we regretfully no longer provide this option.
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.
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.
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.