Skip to main content
All CollectionsIntegrationsWooCommerceStore management
How Can I Move My WooCommerce Products To Gelato In Bulk?
How Can I Move My WooCommerce Products To Gelato In Bulk?

Learn how to bulk migrate WooCommerce products to Gelato by preparing a CSV with Product UID and File URL

Updated today

This article provides a streamlined process for efficiently migrating a large catalog of WooCommerce products to Gelato. It outlines the steps involved, focusing on a bulk upload method to simplify the transition for merchants with numerous products.


Initiating Your Migration from WooCommerce to Gelato

To begin the bulk migration of your WooCommerce products to Gelato, follow these simple steps:

  1. Log in to your Gelato Dashboard and navigate to the Store tab.

  2. Click on Bulk Operation, then select Connect Products Using Files.

  3. In the top-right corner, click Export CSV to download the file.

Depending on your store size, the process may take a few minutes to a few hours. Once completed, you will receive an email with the CSV file attached.


Preparing Your CSV File for Upload

The provided CSV file will have two key columns that need to be populated with specific information for each product variant:

Product UID

This column requires the Gelato product/variant SKU that corresponds to the specific product you want to be printed and fulfilled when an order is placed.

To find the correct Product UID:

  1. Navigate to the Gelato product catalog and locate the desired product.

  2. Select the appropriate size, color, and any other relevant variant options.

  3. Scroll down to find the blue copy icon (as shown in the image below) and click it to copy the Product UID.

Paste this copied Product UID into the corresponding cell within the 'Product_UID' column for that specific variant. Repeat this process for all product variants.

File URL

In this column, you'll provide a direct, downloadable link to the print file associated with each product variant. Ensure that this link is publicly accessible and doesn't require any login credentials to download.

For Dropbox users, follow these instructions to create a shareable link that allows direct downloads.

Accepted file formats for your print files are PNG, JPEG, and PDF. If your products involve personalized designs, a blank image can be used for the File URL.

Please note, that we suggest using files no larger than 100mb in size to ensure a smooth upload.

Once you have filled in both columns for all variants, your CSV file is ready for the final step.


Finalizing Your Product Migration

Once you have meticulously filled in the CSV file with the necessary information, go back to Bulk Operation and select Connect Products Using Files again.

From there you can initiate the migration process, ensuring all your variants are connected and configured for automatic fulfillment by Gelato.

Please note that while we handle the technical migration, we cannot edit the designs within the provided print-ready files. Therefore, it's crucial that your files are finalized and print-ready.

Did this answer your question?