Example : Import with Photos - CSV
During a first import, you'd like to integrate images to your products.
It is possible, but your photos must be online, it means having a URL.
The import is made with a CSV file, you can see all possible solutions in the online help about the CSV products import.
It is possible, but your photos must be online, it means having a URL.
The import is made with a CSV file, you can see all possible solutions in the online help about the CSV products import.
1. New products import without variant and with 1 or several images
1. Leave the product_id and variant_options empty, they will be created automatically,2. variant_sku corresponds to your product reference, it must be unique,
3. Use the product_pict_url to fill in the Photo URL associated to your product.
product_id; product_title; variant_options; variant_sku; variant_price; product_pict_url;
;BRITAIN AVRIL GAU;;AVR-BRI;199.00; https://example.com/photo1.png;
;SOLEIL AVRIL GAU;;AVR-SOL;179.00; https://example.com/photo2.png;
;JUMP AVRIL GAU;;AVR-JUM;139.00; https://example.com/photo3.png;
You can add up to 5 images per products, in this case you can specify each image position in the field product_pict_position.
If you don't do it, images will be placed in order of arrival, you'll be able to order them later on from the back office.
;BRITAIN AVRIL GAU;;AVR-BRI;199.00; https://example.com/photo1.png;
;SOLEIL AVRIL GAU;;AVR-SOL;179.00; https://example.com/photo2.png;
;JUMP AVRIL GAU;;AVR-JUM;139.00; https://example.com/photo3.png;
You can add up to 5 images per products, in this case you can specify each image position in the field product_pict_position.
If you don't do it, images will be placed in order of arrival, you'll be able to order them later on from the back office.
2. New Products Import with Variant and Associated Images
1. Leave the product_id and variant_options empty, they will be created automatically,
2. Fill in the product_url_slug and use the same for all variants of a same product.
3. Embed your option in between double brackets
4. Use the variant_pict_url to fill in the Photo URL associated to each of your variants product.
2. Fill in the product_url_slug and use the same for all variants of a same product.
3. Embed your option in between double brackets
4. Use the variant_pict_url to fill in the Photo URL associated to each of your variants product.
product_id; variant_id; product_title; product_url_slug; variant_options; variant_sku; variant_price; variant_pict_url;
;;BRITAIN AVRIL GAU ;britain-avril-gau;[[size:36]];AVR-BRI-36-B;199.00; https://example.com/photo1.png;
;;BRITAIN AVRIL GAU;britain-avril-gau;[[size:37]];AVR-BRI-37-B;199.00; https://example.com/photo2.png;
;;BRITAIN AVRIL GAU ;britain-avril-gau;[[size:36]];AVR-BRI-36-B;199.00; https://example.com/photo1.png;
;;BRITAIN AVRIL GAU;britain-avril-gau;[[size:37]];AVR-BRI-37-B;199.00; https://example.com/photo2.png;
3. Photo Import for Existing Products
Make an export, edit the photos URL and import again your file once you've added your new images URLs.
Don't forget the most important, fill in the new URL of the image you want to replace.
In the example below, you modify the photos of a product variant.
In the example below, you modify the photos of a product variant.
product_id; variant_id; variant_pict_url;
2872947; 11831975; https://example.com/new-photo1.png;
2872947; 11851884; https://example.com/new-photo1.png;
To edit photos of a product without variant
2872947; 11831975; https://example.com/new-photo1.png;
2872947; 11851884; https://example.com/new-photo1.png;
To edit photos of a product without variant
product_id; variant_id; product_pict_url; product_pict_position;
2872947; 11831975; https://example.com/new-photo1.png; 1;
2872947;; https://example.com/new-photo2.png; 2;
2872947; 11831975; https://example.com/new-photo1.png; 1;
2872947;; https://example.com/new-photo2.png; 2;
Related Articles
Product Import - CSV
Product Import / Export feature is very useful: To batch import new products To import data from another eCommerce platform to a Muse mBaaS app Product Import / Export is managed only via .csv files. Those files can be managed using a spreadsheet ...Example of Slashed Prices update - CSV
When the sales are finished, you might have lots of product with 5 or 6 variants to update, this makes a lot of manipulations and can create errors. With the export / import feature, you can cancel all your slashed prices in a few minutes. 1. For ...Export and update of the Catalogue - CSV
The product Export / Import feature is very useful to update quickly your catalogue (product characteristics, price, stock) Product Export / Re-import is managed only via .csv files. Those files can be managed using a spreadsheet (Microsoft Excel, ...Remove Products to a Collection
To remove one or more products from a collection, follow the procedure below. 1. In your Product menu, click on "Collections ". 2. Select the collection in which the product to be deleted is located The page of the collection in question opens. ...Add or Edit Tags on your Products
It is possible to add tags to your products. Tags allow for easy access to your products. They will be used in: Your back office: the search engine of the menu Products > All products Front side: in the Search section of your app They also allow you ...