In case you have orders for products that are not created by PrintHub app, you can still import your orders to fulfill on the Print Hub app of the Apps section on your store admin. They can either be ShopBase orders or orders from any other platform.

On this page

A. CSV format to import your order

B. Make payment for your orders to fulfill

C. Export your orders with tracking number

D. Frequently asked questions


A. CSV format to import your orders

Before you import, you will need the information of your orders, which can be available in the order CSV file. Below is the short guide to prepare your file:

Steps:

Export your orders from your previous platforms.

Update your file's data according to the file template. You must fill in the necessary information in Required columns, while Optional columns can be left blank.
Name (required): Unique Identifier for the order, or Order name
Reference Id (optional): Reference Id of your order
Lineitem Quantity (required): The total number of variants ordered
Lineitem Sku (required): The SKU of your items
Product Name (optional): The name of your product
Product Id (required): The Product Id listed on our catalog here that you want to fulfill. For example, Unisex T-shirt is acceptable.
Color (required): The color of the Product Id that you want to fulfill. You can check the supported color values here on each product sheet. For example, the color list here for apparel (2D)
Size (required): The size of the Product Id that you want to fulfill
Shipping Name(required): Name of the customer
Shipping Address 1 (required): Shipping address of the customer
Shipping Address 2 (optional): Additional shipping address of the customer
Shipping City (required): City of the customer
Shipping Zip (required): Zip code of the customer
Shipping Province (required): Province of the customer
Shipping Country (required): 2-letter country code of the customer (Reference)
Shipping Phone (required): Phone number of the customer
Artwork Front Url (required for all products having one side): URL of the front artwork for your desired product (format: JPG/PNG and downloadable or Google Drive image url)
Artwork Back Url (required for all products having two sides): URL of the back artwork for your desired product (format: JPG/PNG and downloadable or Google Drive image url)
Mockup Front Url (required): URL of the front mockup for your desired product (format: JPG/PNG and downloadable)
Mockup Back Url (required): URL of the back mockup for your desired product (format: JPG/PNG and downloadable)

Please note that the first line/row of your order CSV file needs to include the field headers described above and you need to fill in all required fields. The sequence of headers can be rearranged.

From the store admin, go to Apps >> Print Hub >> Manage Orders >> Order import CSV. Click Import.



Click Choose file in the Import orders by CSV file window.

Locate and select your CSV file, then click to open.

Click Upload file.

After this, you will see a preview of your first order:



If everything is correct, click Upload File to confirm.

After your CSV file is uploaded, your order will be importing into Print Hub. It might take up to 30 minutes to import your orders depending on your file size.
If your orders are valid, they will go to Awaiting payment tab
If your orders are invalid, they will go to In review tab and show the errors so that you can check and fix them
If you want to update any unprocessed orders, you can select and delete them in Awaiting payment or In review tab then import the updated ones. Orders can only be deleted before you make payment.

Note: Your order names must be unique. All line items in a imported file with the same Name will be combined to an order and ship to a customer. In case there is an order on different CSV file has the same name of the available order, it will be removed or overridden data of invalid orders.

B. Make payment to fulfill your order

After all orders are validated and updated if necessary, you will see them in the Awaiting payment tab. You can select any orders to manually pay for or delete them anytime.

Paid orders will create a payment and be charged by your ShopBase Balance. If your orders are charged successfully, they will be updated status as Awaiting shipment.

You are done! Fulfillment team will process all Awaiting shipment orders.

C. Export your orders with tracking number

When your orders are shipped, they will be updated status as Fulfilled with tracking numbers.

You can download your order information with tracking numbers in the store admin, go to Apps >> Print Hub >> Manage Orders >> Order import CSV >> Export.

D. Frequently asked questions

1. What is CSV file format?
We only support Comma Separated Values - CSV file. You can check out our guide to understand the CSV file and how to create one.
After filling in all order information, please go to File > Save as > Select Save as Type: CSV (Comma delimited)

2. Why my orders are in review?
To be sure all orders are valid to fulfill, our system will automatically validate your orders as well as customer information. Here are some reasons why your orders may be moved to in review status. You can check the reasons in each order when hovering on the red warning icon. Please follow the corresponding solutions then fix them and import again.
Missing required column, for example "Product Id is required": You need to fill in all our required fields as the header explanation above
Invalid shipping country: Please fill in the 2-letter country code (Reference)
Product Id not found/Size not found/Color not found: Please check our catalog then carefully copy and paste the exact product id, color and size of the product that you would like to fulfill
Shipping phone only contains numbers and + - ( ) . /: Please fill in your buyer's phone number so that our shipping carriers could deliver orders fast and correctly. If you don't have a shipping phone, you can fill in country code (for example: United State country code is 1)
Artwork must be at least [dimensions]: Your artwork should be greater than or equal to the min dimensions of the base product so that they would be printed with the standard quality
The Artwork/Mockup URL doesn't refer to an image or the image is not publicly accessible: We support JPG/PNG and Google Drive image url with maximum file size 80MB
Total quantity requested for '{productid}, color, size' exceeds our amount in stock: Base product may be sold out at the moment, you should wait for a few days to let them restock or contact the buyers as soon as possible to update their orders.
Shipping information in all line items conflict: Currently, we don't support separate addresses for one order. We will ship an order to one shipping information. If you fill in the different shipping addresses for 2 line items in the same order, they won't be processed. You can divide them into 2 different order names
Could not save the URL image. Please try again: Our server could be down in a very short time that cannot save your artwork then. Please import orders again and the invalid orders will be replaced

Please note that the order name is unique so that do not import 2 different orders with the same name unless the imported order was in review.

3. How to create a mockup or artwork as an image url?
You can upload your artworks and mockups to a cloud storage service (such as Google Drive, Dropbox, Amazon Drive,...), an image sharing service (Pinterest, Imgur,...), or even Trello to get their image urls. Please be sure the image url is public so that we can access to get them. The followings are three popular and easy ways that you can use:
Google Drive: right-click the image on Drive >> Click Get shareable link >> Copy link. Make sure the urls are for anyone with the link.
Dropbox: Hover on the image line > Click Share > Click Create link > Click Copy link. Paste that link to your import csv file and edit the suffix from dl=0 to dl=1
Trello: Create a Card >> Add an attachment >> Click the icon on the right of the image name.

Google Drive
Trello
Was this article helpful?
Cancel
Thank you!