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
Getting a Bad Print
Generally, unless professionally calibrated, computer monitors are going to be very bright. Tablets and mobile devices display images with elevated brightness and contrast. These settings mislead people into believing their images are brighter than they usually are. Read more…
Since we do not print with “white” inks, the white areas in your print will reflect the tone of your chosen paper in its natural state. Some papers have a slightly warm cast, while others do not. Being informed about the paper you are printing on will help you avoid any surprises. Learn More…
This could stem from a number of factors but the first thing to check is your white balance/white points. Another thing that might result in color shifting is submitting your images for print in CMYK mode instead of RGB mode. Find out more about accuracy in print color…
If your print arrives damaged, contact us immediately. Once we have received photo snapshots of the damage, we will arrange to either reprint your damaged print or provide a full refund.
Please contact us within 30 days of placing your order if you are unhappy with your print. Our first goal will be to help you get a satisfactory replacement. If that is not an option, we offer a 30 day money back guarantee.
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.
We require returns to be processed within 30 days of the delivery date to receive a full refund or credit with FinerWorks. Credits with FinerWorks are non-refundable and do not expire.
Order Giclee Printing on Canvas
Printed using some of the highest archival standards in the industry, your photos or artwork will last for decades to come.