Introduction
Artelo’s bulk order upload functionality streamlines the process of creating and managing large numbers of orders at once. By downloading and editing a pre-validated Excel template, you can quickly enter customer shipping details, select product specifications, and upload multiple order items in one go. Each row represents a unique order item, and rows sharing the same Order ID are grouped under a single order. The template’s built-in validation rules reduce errors and save time, ensuring that critical information—such as product configurations, images, and shipping addresses—is entered accurately and consistently. This makes it easier to handle high-volume workflows, giving you more time to focus on delivering exceptional prints to your customers.
Artelo offers two template versions:
An Excel template
A Google Sheet template
Regardless of the template you use, the rules are essentially the same. If you're using Google Sheets, please read the Google Sheets Section below for several additional rules.
Step 1. Downloading A Template
Go to the orders page and click on the “Upload Orders” button. On the modal that opens, click on the “Download Excel Template” button or the "View Google Sheet Template" button.
The Download Excel Template button should immediately download the Excel template titled “Artelo Order Upload Template.xlsx”
The View Google Sheet Template button opens up a read-only template, where you must make a copy first.
Note: The Excel template should be edited in Microsoft Excel. This would enable the validation of all fields, simplifying the data-entering process with embedded validation rules.
Note: The Google Sheet template can be edited in Google Sheets but must be exported as an Excel file before you can upload it to Artelo.
Step 2. Configuring Data
Regardless of your template, the first tab is considered the "Order" sheet, where every row represents a unique order item, and the order items are grouped by their order Id. This means orders with a single order item will have a single row, whereas orders with multiple order items will have multiple rows.
There are three key column sections to each row on the table: Order Id, Customer and Shipping Columns, and Order Item Configuration columns.
Let's review some of the key columns:
Order Id: This is a unique identifier for the order. This can be chosen by you or from your sales channel. If it is the same in multiple rows, it’s assumed that those rows belong to the same order (i.e. they are order items belonging to the same order). This field is required.
Customer and Shipping Columns:
These columns are only required for the first item of an order(i.e., the first row where an order ID is specified). They can be skipped in subsequent rows/order items of a given order. If they aren’t provided in the first row/order item of an order, we will prompt errors.
Customer Name: The full name of the customer that owns the order. This is for the shipping address.
Address Line 1: The first line of the shipping address.
Address Line 2: Second line of the shipping address.
City/Town: The city or town of the shipping address.
State/Province/Region: The state, province, or region of the shipping address.
Zip/Postal Code: The zip or postal code of the shipping address.
Country: The country of the shipping address.
Order Item Configuration columns
These columns are used to configure the order item itself. These fields configure the specific product and image that would be delivered to the customer.
The product configurations are sensitive, which is why we recommend opening templates in Excel to benefit from the validation rules. We recommend creating a product set (or at least tinkering with the flow) in Artelo to get an idea of how our product configuration works. Remember that, unlike a product set, this is just a single that is not saved anywhere for use at a later date.
Quantity: The number of units for this given order Item.
Product Catalog Type: The type of product to be printed.
Individual Art Print
Set of 2 Art Prints
Set of 3 Art Prints
Set of 4 Art Prints
Set of 6 Art Prints
Set of 8 Art Prints
Set of 12 Art Prints
Gallery Art: Brighton, Bristol, Camden, Hudson, Kent, Warwick, Windsor, York
Picture Frame
More details about each can be found on the catalog page on the Artelo app. Each of these has a different design count(number of designs/images required), so we have up to 12 image slots in the order upload template.
Orientation: There are two orientation options, Portrait and Landscape. Portrait here corresponds with Vertical orientation in Artelo, while Landscape corresponds with Horizontal orientation in Artelo. Unless you want to have a horizontal print 90% of the time, you’ll want to select Portrait orientation.
Note: For 1:1 prints, the orientation can be portrait or landscape
Paper Type: This refers to the type of paper for this print. It is formatted as
`Paper Style - Paper Type`.Note: This field is disabled for Picture Frames.
Framing: This refers to the type of frame to apply to your print. These frames span oak, metal, premium frames, etc. If you’d prefer to have no framing, you can select unframed.
Size: This refers to the size of the print. Some sizes are only available for unframed prints, so you’ll only see them when selected.
Include Framing Service: If set to true, Artelo places prints inside frames so the products are ready to hang. If false, Artelo packages the print and frame separately and places both into a single box.
Include Hanging Pins: This includes pins to hang the print in the package. This is only supported for valid framing options(i.e., not unframed). This field is optional.
Include Mats: This refers to whether the product should be matted. Mats are only supported for premium frames and specific sizes. Visit the Artelo product creation flow for more information.
Design Fit Style: This refers to how the design image should be positioned on the canvas. It has two values: Inside and Outside. Inside means the design should fit inside the canvas. Outside means the design should cover the entire canvas, even if it means being outside(a bit). This is optional.
This field is relevant when you use a file that does not have a 100% aspect ratio match to the art you're printing.
See the demo video above for more details.
Note: Outside is almost always preferred.
Design Fit Canvas: This is only relevant for matted products. It has two values: Mat Opening and Paper. Mat Opening means the design should be placed on the mat opening, while paper means the design should be placed on the entire canvas. For non-matted products, this is always paper.
See the demo video above for more details.
Note: Inside is almost always preferred.
Image URL 1 - 7: This is the image to be placed on this product. Depending on the product catalog type, the required images could be 1-12. The image URL fields that are not disabled are required. Currently, only JPG, PNG, PDFs, and TIFFs are supported.
See the demo video above for more details.
See the Image URL section below for more details.
Step 3: Uploading Your Sheet
Once you complete your sheet, you can upload it back to Artelo.
Artelo processes each row to ensure they are valid. A successful order will result in an order being added in the "Design Pending" state.
The Design Pending state usually lasts 10 seconds to a few minutes, depending on the size of the file Artelo must download.
Once the files for an order are downloaded, the order is moved to production automatically. No other work is required on your end.
If your file upload leads to errors then you'll see them displayed in the upload modal.
Carefully review each error and reupload your Excel file.
Note: All errors must be fixed before any of the orders from the Excel file can be uploaded.
Where to upload images and find Image URLs
Artelo requires direct, publicly accessible URLs for all images in the bulk upload sheet. This means each Image URL cell should point to an actual image file (JPG, PNG, PDF, or TIFF) hosted online. Here are a few popular hosting options:
Your Own Website or Server
Upload the image to your own site or server and copy the direct URL (e.g.,
https://example.com/images/myphoto.jpg).
Image Hosting Platforms (e.g., Imgur, Postimages)
Upload images and use the provided direct link. Check that the link ends with a valid file extension (e.g.,
.jpg,.png).
File-Sharing Services (Dropbox, Google Drive, etc.)
Make sure to generate a direct download/view link rather than a link to a folder or preview page.
For Google Drive, for example, replace
/file/d/FILE_ID/viewwith/uc?export=view&id=FILE_IDin the URL, and ensure sharing is set to “Anyone with the link.”The Google Sheet template contains a helper column for converting public Google Drive URLs to compatible Artelo URLs.
Select the file you've uploaded to Google Drive and click the link icon button. Then paste that URL in column A of the helper sheet. Finally, copy the URL in column B and use that value in your Order sheet.
When pasting these URLs into the Image URL columns, confirm that they are public (no login required) and meet Artelo’s file size and format requirements:
Supported file types: JPG, PNG, PDF, TIFF
Maximum file size: 10 MB
Image URLs: Up to 500 characters
Other Restrictions:
The file must be at most 10 MB in size
You must have at most 1000 rows in the sheet
Only the first sheet is processed for any upload.
Other Tips:
You can download the desktop app or visit it at https://excel.cloud.microsoft
FAQ
Can I use images already uploaded to Artelo as source images on my Excel sheet?
No, not currently. We will support this option in the near term.
For Bulk uploaded orders containing art print sets, does the order of my files matter?
No, you can upload your files in any order you'd like. Note: for gallery art, the order of files does matter and further instructions will be added here shortly.
Do I need to fill out the customer shipping columns for every single row?
No. Shipping columns (Customer Name, Address Line 1, etc.) are only required on the first row for each unique Order ID. For subsequent items in the same order, you can leave these columns blank.
Can I update or change an existing order after uploading it?
Once the orders are successfully uploaded, changes cannot be made via bulk upload. Once the order is no longer in the "Design Pending" state, you'll have 3 hours to cancel the order before it is moved to production.
What happens if my file exceeds 1000 rows or 10 MB?
Artelo will reject the upload. Split large datasets into multiple files, ensuring each meets the row and size limits. For file size, consider compressing images or hosting them on a more efficient server if direct embedding is causing large file sizes.
How do I fix errors after uploading my sheet?
Artelo will show an error message detailing which rows or fields have invalid data. Correct those errors in your Excel file and re-upload the entire file. All errors must be fixed before any orders in that file can be processed successfully.
Does orientation matter for 1:1 (square) prints?
For square prints, the orientation can be either Portrait or Landscape in the sheet, as Artelo treats them the same. However, to avoid confusion, we recommend consistently choosing Portrait for square prints unless you have a specific need for horizontal orientation.