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
Technology
A giclée print is a way to classify a professionally produced print using inkjet technology; primarily printed on canvas or fine art paper with archival-grade inks. While the process is only several decades old, it has quickly become the method of choice for both artists and photographers. 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.
Resolution is a relative number dependent upon the size of the print you choose. The more your image is enlarged, the lower your resolution will be.
We recommend trying to keep your resolution between 200-300 for your selected print size for optimal results. Read more…
Yes. We run regular re-calibration cycles on our monitors and run regular cleaning and calibration cycles on our printers. This is to ensure consistent results with every print job. All machines are calibrated based on standards set by the International Color Consortium (www.color.org).
Our calibration print is a special 8×10 print you can order which allows you to adjust your monitor to try to match the print. Once you have done this and start working on your images on your computer you will be working on an image which is more closely aligned to industry color standards. Read 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…
Acrylic Glass Prints
Transform your space with our sophisticated Acrylic Glass Prints, featuring exceptional clarity and durability to showcase photography, art reproductions, or commercial applications with modern elegance.