Go to Dashboard

How can we help?

Popular articles Welcome to Gelato! Getting Started with Manual Orders Getting Started with Shopify Integration Getting Started with Etsy Integration Getting Started with WooCommerce Integration What print products do you offer? What is the design editor? How does the integration with Shutterstock work? Frames & Hangers - Stock Status How does the sign-up promotion work? Why do I get charged VAT/tax on some orders and not others? Where do you print locally? How quickly do you deliver? How do I estimate the price for shipping? Where can I find the flat rates for shipping? How do I see where a specific product is being printed? I receive an error message when I try to place an order. What should I do? Email Notification from Gelato: Order [123] is on hold - Action required How do I contact Gelato? Do you offer 24/7 customer support? What is you return policy and quality guarantee? How do I report a problem with my order? How do I place a manual order via the Gelato Dashboard? How do I check the order status in the Gelato Dashboard? How do I check estimated delivery date and tracking in the Gelato Dashboard? How can I check your product price?

How can I move my Etsy products to Gelato in bulk?

Are you looking to move to Gelato and have hundreds or thousands of products in your store? Then this article is for you. In the dashboard, you are able to connect variants one by one. This is a great way when you have a couple of products and variants that you want to connect. When you have hundreds or more than another approach is needed. 

This guide is for customers who want to have their Etsy products fulfilled via Gelato. 

To bulk migrate the products and variants we will leverage the Bulk Import Products functionality. There is no limit to how many products and variants that can be imported and connected with it in one go. 

What you will need: 

  • Contact your account manager or Gelato representative to confirm your interest, they will provide you the export file
  • A link to the print file for each variant

We are going to make a spreadsheet with several columns: 

  1. Etsy product title
  2. Etsy product id
  3. Etsy variant title (The number of variant columns depends on how many variant dimensions you have)
  4. Etsy variant option name 
  5. Etsy variant option value
  6. product UID (i.e. the Gelato product that should be printed)
  7. print file link (i.e. the link to the print file you want to have printed on the product)

 

Adding the print file

Use a spreadsheet software to modify the file we provided you in the previous step. Fill column to the sheet:

  • product_uid
  • file_url

Picking the right product_uid

The product_uid represents the product that should be fulfilled when the variant is ordered. To get the product_uid find the product in the catalog that you want to use. Select the right size, color, orientation (or any other dimension) needed. Then scroll down and click on the blue copy icon highlighted in the below screenshot. 

Screenshot_2020-10-11_at_15.50.13.png

 

Adding a link to the print file

In the column for file_url add a link to your print file even if you are connecting a product without design, e.g. a frame or a hanger.

Important: It is important that the link can be accessed without any login or credentials. 

Paste the link into the cell of the spreadsheet. The print file can be in PNG, JPEG, or PDF format. Repeat until all variants are done. 

Note: We can't process links from Google Drive (Google Cloud storage is ok). 

 

Finalizing the import file

Now you are done with adding all data. 

Make a copy of your file before you do this so you can easily go back and make further updates.  

 

Example final structure

Product title

Product ID

Variant Title #1

Variant Option #1 Name

Variant Option #1 Value

product_uid

file_url

Sunset Poster

5307198341280

50x70 cm

Size

50x70

flat_product_pf_500x700-mm_pt_200-gsm-uncoated_cl_4-0_ct_none_prt_none_sft_none_set_none_ver

https://www.dropbox.com/s/a1b2c3d4ef5gh6/example.png?dl=1

Aurora

5314279080096

30x40 cm

Size

30x40

flat_product_pf_300x400-mm_pt_200-gsm-uncoated_cl_4-0_ct_none_prt_none_sft_none_set_none_ver

https://www.dropbox.com/s/a1b2c3d4ef5gh6/example-2.png?dl=1

 

Importing the file

Currently, the import is run by Gelato on request. After you fill the product_uid and the file_url share the file with your account manager or Gelato representative. We will check that the file looks structurally ok but we will not make any specific verifications on that you have mapped each product and file correctly. 

The import will then be run and all the variants in the sheet will be connected and start to be automatically fulfilled by Gelato. 

 

Was this article helpful?
0 out of 0 found this helpful