Updating Variant Images in Shopify using CSV

Mittwoch, 27. Oktober 2021, 17:37 Uhr

Shopify has a possibility to update fields using a CSV file. This is useful if you want to update a lot of images.

Shopify will download these images from a remote server if necessary, so you can provide URLs of your choice.

You only need to provide the values you want to update, along with some core values.

These are the ones I found necessary to include for the Variant Image update:

(The Variant Inventory Qty is probably not necessary – I wanted to test adjusting the inventory quantities, too).

Here are the fields for copy & pasting for your convenience:

Handle Title Option1 Name Option1 Value Option2 Name Option2 Value Option3 Name Option3 Value Variant SKU Variant Inventory Qty Variant Image Workflow

First you export the product, you get rid of all unnecessary fields.

You edit the Variant Image field (note this is NOT the Image field).

I suggest to use LibreOffice Calc for this, and to name your files with <sku>.jpg, and upload them to a directory on your webserver.

This way you can quickly add the images using a LibreOffice Calc formula

=”https://your-url.com/path/to/images/”&I4&”.jpg”

then you drag the formula down, so that it will update to the cell rows.

Good luck.

You can hire us as consultants (2000 $ daily rate), if you need help.

Der Beitrag Updating Variant Images in Shopify using CSV erschien zuerst auf pi3g.com.


pi3g e.K.

Als approved Raspberry Pi Reseller in Deutschland arbeiten wir seit Anfang an (2012) besonders eng mit Raspberry Pi zusammen. Wir bieten ehrliche, tiefe technische Kompetenz rund um den Raspberry Pi. Wir vertreiben Raspberry Pi sowie Coral AI hardware, und entwickeln Hardware und Software für unsere Kunden.

Unsere Plattform picockpit.com ermöglicht Nutzern ihre Pis von überall aus ganz leicht per Webinterface zu nutzen. Unsere Apps lösen echte Probleme und machen Nutzer glücklich.