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
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.
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.