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
Uploading Files
It will be up to you to select a print size that compliments your image’s current aspect ratio. If your image file does not quite match those dimensions, it will be cropped to accommodate the print size selected. This can result in part of your image file being cropped. Be sure you pay attention to the real-time preview when you setup your print. If any part of it looks cropped, then you may need to choose a different size print or adjust your image file to fit accordingly.
In most cases if you do not see any sort of upload tool it is because either Flash is not running in your browser and HTML 5 is not supported. This is usually fixed by updating your web browser. If you do see an uploading interface but nothing happens when clicking the “add files” or “upload” button, this is also usually fixed by updating your web browser. Read more…
Sometimes when you upload a very high resolution file, it’s possible the preview will come out blurry. This happens because we are using a smaller embedded thumbnail data within your image file rather than generating a preview from your high resolution file. It’s done as a fallback method if it appears generating the preview from the high resolution file will take too long.
Fortunately your high resolution file will remain intact since we need that to produce your print.
Best print quality is between 200-300 dpi.
Rasterized PNG, JPG or TIFF files are necessary. If you file is a PDF or vector file (such as Corel Draw or Adobe Illustrator), please convert it. You will need to make these changes before submitting these files for accurate color when printed due to different CMYK and RGB outputs. For instance, many programs like Adobe Illustrator will default to a CMYK color space. It’s relatively easy to change it to RGB, so make sure you do so before saving a jpg or tiff version of your file.
Because the file is so large, generating a thumbnail would be time consuming for our servers. To speed things up, we generate a thumbnail from the embedded thumbnail image. This won’t affect or be used for printing. We always print the original file that was uploaded. It’s just used as a preview.
Absolutely not. We prefer you upload your file before it is enlarged. Not to say you cannot do this but to do so might result in a poorer quality print than you would have wanted. This is because when you enlarge a digital image, you are adding pixels that were never there. Our software will try to guess what those pixels will look like and the more guessing it has to do, the more pixelated the image becomes. The reason we prefer you not to do this yourself is so we can warn you if we think the file is too small for the size you selected.
Your images should be in RGB mode. Images in CMYK color mode are more likely to experience noticeable color shifts which may result in a muted or washed out looking print.
Yes, if the image was saved in your Inventory Files. From there you will find under each image of the file you will find a “Create Download Link” for a small fee of $1.50 USD.
See Video
As an on-demand printer, we must adhere to the same regulations and standards that anyone else does. To learn more about protecting your intellectual property, take time to read over one of our recent blogs here.
Only lower resolution web versions of the images are shown. These contain a watermark which provides some protection. If you are too worried that people will copy your web viewable images, we recommend not participating in the gallery experience.
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.