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
Cards
You are not. After formatting the front of the card, you may add it directly to your cart. The back of the card will arrive blank.
Yes, your flat cards may have images or graphics on both sides.
Your set of cards will arrive in its own card box with a clear top for easy viewing. Keep in mind that multiple sets will not always have their own boxes as these boxes are utilized for packaging and shipping purposes. We do not currently offer card storage boxes for purchase.
We do not offer direct card mailing services.
All folded cards, both standard and giclee cards, come with envelopes. For flat cards and postcards, envelopes can be ordered as an add-on.
You may include a logo or graphics to the back of your folded card. Just choose one of your uploaded images to add imagery to the back. Keep in mind that the print area may be limited so it will be important to format your image file to fit the dimensions of the print area (for more info watch this).
At this time we do not offer the option to print imagery inside the folded cards.
The front of the cards will have a bleed of approximately 1/8 inch, so we recommend allowing for this bleed when formatting your image file. Subject matter on or close to the edges may be partially cropped or appear off-centered.
No, bulk rates are only applicable when it is duplicate copies of the same card.
Yes, cards can be ordered in bulk. Pricing depends on card type and style.
We now offer digitally printed cards on various card stock and giclee printed cards on fine art paper. Standard cards are available as postcards, flat cards, or folded cards. Giclee cards are available as folded cards.
Explore both card options and pricing via our products page.
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.
Giclee cards are printed using the same pigmented inks we use on Fine Art Papers, giving them an exceptionally wide color gamut, which leads to a much nicer looking print and potentially more accurate.
Standard cards are a more economical option because they are printed using toner-based printing, on commodity card stock. This may be fine for most people, but keep in mind that they will not be able to achieve the accuracy and consistency of a giclee card. Also, slight variations are common with color tone from batch to batch due to the nature of the printing.
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.
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.