Mixtable’s spreadsheet interface simplifies the process of choosing an image for a specific product variant. You can either select an existing image from the product the variant belongs to or upload a new one.
First, ensure you have a Products with Variants worksheet in your workbook for the Shopify store whose variants you’re modifying. With this worksheet in place, you’ll need to designate a column for the variant image. Right-click on the header of a column that isn’t yet mapped for syncing (these columns have a grey background, while columns set for data syncing have a light green background). When you right-click, a context menu will appear. Choose the Shopify Sync Settings option.
In the window that opens, select the Core Field field type, and then Variant Image from the dropdown menu. Click the Save button to save the new column mapping.
You’ll see the new column start populating almost immediately with thumbnails of any images currently assigned to your variants. Mixtable populates the cells in the column with the IMAGE function, holding the URL of the image as a parameter.
Leveraging the power of the Excel-style IMAGE function in Mixtable allows users to efficiently manage Shopify product variant images within the convenience of their spreadsheets. By using a URL as a parameter, the IMAGE function enables seamless display and updating of images within cells.
How to use the IMAGE function in Mixtable to set product variant images
https://example.com/image.jpg, the function appears as:
https://example.com/new-image.jpg, update the function accordingly:
The Change button visible in each variant image cell allows you to set the variant image to another image associated with the product or upload a new one. Clicking the button brings up the Set Variant Image widget. The widget allows you to set the image for a given variant from the set of images already belonging to the same product, or by uploading a file from your computer.