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
Geo Galleries Artists
Geo Galleries sets the retail price at 3x’s the cost as of July 2022. To see the retail price as your customers would; you must be logged out of your FinerWorks account.
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.
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.
Existing FinerWorks members are given an exclusive invitation to join at no charge. In the future there will be optional priced services relating to promotion and fulfillment that artist can take advantage of.
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.
Reporting of your sales is done through the Geo Galleries reporting interface. Sales are shown after an order is shipped.
The artist will receive the difference of the retail price they set and the seller fee.
An artist may also get 10% in shared revenue on the sale of any frames, matting or glazing when ordered as part of the finished item.
Geo Galleries retains a seller fee that is based on the sale of any print. This seller fee equals what the artist would pay for any unframed printed item, plus a 10% administrative fee which is based on the cost of the unframed print or product.
For example,
For example, if an artist sets their canvas print to be priced at $200 but the cost for them to order it at Finerworks is $50, Geo Galleries would receive $50 for the print and $20 as an admin fee. The artist would receive the remaining $130.
You must have a PayPal account. Your earnings will be paid out on a monthly basis for any sales 30 days or older.
We plan to integrate a new system that will allow payment direct to your financial institution which will allow weekly payments as the platform grows. When this will happen is not set but would be announced in the newsletter.
Geo Galleries will offer a set of default print products, however if you have a set of 3 or more print products in your virtual inventory for an image, then this will be used in place of the default products.
Geo Galleries will reserve the right to adjust based upon the advice of FinerWorks when it comes to optimizing the file for printing. This will be limited to any necessary sizing and cropping adjustments or color correction as FinerWorks deems is necessary. Artists recommended adjustments may be considered however are not guaranteed.
No. You retain full ownership of your images and you may remove them at any time.
Order HD Face Mounted Acrylic Prints
Printed on high-quality photo paper and face mounted to 1/4″ acrylic with polished edges. Choose between satin luster or metallic photo paper. Included is easy-to-install hanging hardware in the form of a French cleat.