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
My Account
If you are unable to locate a recent order in your order history, it is likely you may not have been logged into your accounbt prior to placing your order. To fix this, simply contact us and we will be happy to add the unassigned order to your account for you.
When someone completes the purchase of one of your offered prints, PayPal will send you a notification of the order details as well as your customer information. It is your responsibility to fulfill this order in a timely fashion by either having us fulfill the order or you ship it out yourself.
If you plan on using Finerworks to fulfill your order, you should check the shipping page for shipping rates to determine the shipping cost and then charge accordingly. Also consider reviewing our blog post titled What to Charge Your Customers for Shipping.
No. Buyers can only purchase printed works.
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.
This can be done using your gallery’s URL. The link will look something like this
https://geogalleries.com/my_username
Make sure you replace “my_username” with your actual name.
Note: If you used to use FinerWorks old gallery, your FinerWorks gallery url now automatically redirects people to your Geo Galleries link.
We do offer COAs as an option at checkout. You will see an option to order a COA once you add a print to your shopping cart
We will not notify sellers when a sale is made. FinerWorks is not involved in your sales and has no knowledge of transactions relating to gallery sales. Read more…
When someone buys one of your printed products, the order is automatically forwarded to FinerWorks for fulfillment and shipped to the buyer. Within 30 days, once the order ships, details of the order (including the buyer) will be available to you.
Currently, we do not offer custom URLs.
Aside from having artistic value, the image must be a suitable print quality/resolution. It must also be properly titled, include a well written description, and be submitted to the appropriate category and assigned to a collection.
Virtual Inventory gives you the ability to store “virtual” prints. Create and store as many prints as you wish, and when you are ready for us to print one, its only a matter of checking out. Use this quick video tutorial for a walk through the entire process.
Virtual Inventory gives you the ability to store “virtual” prints. Create and store as many prints as you wish, and when you are ready for us to print one, its only a matter of checking out. Read more…
We no longer differentiate between the two. A basic account is now the same as a gallery account.
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.
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
Each registered account is intended for those who wish to print on demand, have the option to store their images with FinerWorks, and maintain a gallery. Users may opt to create personal galleries, sell prints from FinerWorks via their PayPal account, as well as sell from the Main FinerWorks Gallery.
No, you can create as many items as you’d like.
Occasionally, print products we have offered in the past have changed or have been discontinued. If those items can no longer be offered with the options selected then the item might automatically be removed.
Only images that are stored in your virtual inventory / my images can be used. Files you upload to temporary storage cannot be used.
Posting and Selling Prints
Currently, we do not offer custom URLs.
When someone buys one of your printed products, the order is automatically forwarded to FinerWorks for fulfillment and shipped to the buyer. Within 30 days, once the order ships, details of the order (including the buyer) will be available to you.
We will not notify sellers when a sale is made. FinerWorks is not involved in your sales and has no knowledge of transactions relating to gallery sales. Read more…
We do offer COAs as an option at checkout. You will see an option to order a COA once you add a print to your shopping cart
This can be done using your gallery’s URL. The link will look something like this
https://geogalleries.com/my_username
Make sure you replace “my_username” with your actual name.
Note: If you used to use FinerWorks old gallery, your FinerWorks gallery url now automatically redirects people to your Geo Galleries link.
Virtual Inventory gives you the ability to store “virtual” prints. Create and store as many prints as you wish, and when you are ready for us to print one, its only a matter of checking out. Read more…
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.
Aside from having artistic value, the image must be a suitable print quality/resolution. It must also be properly titled, include a well written description, and be submitted to the appropriate category and assigned to a collection.
No. Buyers can only purchase printed works.
If you plan on using Finerworks to fulfill your order, you should check the shipping page for shipping rates to determine the shipping cost and then charge accordingly. Also consider reviewing our blog post titled What to Charge Your Customers for Shipping.
When someone completes the purchase of one of your offered prints, PayPal will send you a notification of the order details as well as your customer information. It is your responsibility to fulfill this order in a timely fashion by either having us fulfill the order or you ship it out yourself.
Virtual Inventory
No, you can create as many items as you’d like.
Occasionally, print products we have offered in the past have changed or have been discontinued. If those items can no longer be offered with the options selected then the item might automatically be removed.
Only images that are stored in your virtual inventory / my images can be used. Files you upload to temporary storage cannot be used.
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.