Product Import - CSV

Product Import / Export feature is very useful:

1. To batch import new products
   
2. 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 (Microsoft Excel, Numbers, GoogleSheet, Libre office etc.)

You must be through when dealing with this process.

WARNING:

- Once the Import is done, it will modify the products of your shopping app, and their visibility

- Once done, those modification can't be cancelled

- We strongly advise to create a full export of your catalog before doing any import. This export will be your backup copy if needed.

1. Product Import

1. Add the Product Import / Export extension

2. Go to your product list, you'll see a new button at the top of your list

3. Click "Import" to import your .csv file. The status of your import will be mentioned in your back office. The import can take up to few minutes, you'll be notified by email if the import is successful.

2. General Rules

The import can only be done via a .csv file format.

Delimiters in the .csv file must be set as follow:

1. Data delimiters is the comma: [data1,data2]
   
2. Text qualifier is the quotation marks: ["text"]
   
3. Field names must respect the exact spelling. Otherwise the import will fail.
   
4. All mandatory fields must be filled in (see reference table below).

Reminder:

1. the product is the object or service that is sold
   
2. the variant is a combination of options for the product. For instance it can be different sizes or colours available for your product. 

Note: data regarding description text, images, or videos can't be imported.

3. Import without Variant and Unlimited Stock

1. Leave the product_id and variant_options empty, they will be created automatically.

2. The variant_sku corresponds to your product reference, it must be unique.

Example : Importation of 3 product without variant:

product_id;product_title;variant_options;variant_stock;variant_sku;variant_price
;BRITAIN AVRIL GAU;;Unlimited;AVR-BRI;199.00
;SOLEIL AVRIL GAU;;Unlimited;AVR-SOL;179.00
;JUMP AVRIL GAU;;Unlimited;AVR-JUM;139.00

4. Import with1 Variant with Stock Management

1. Leave the product_id and variant_id empty, they will be created automatically.

2. Fill in the product_url_slug and use the same for all options of a same product.

3. Encapsulate in double brackets your options.

Example : importation of 2 products with a variant (the size), you notice that the product_url_slug is the same for 2 products.

product_id;variant_id;product_title;variant_options;variant_stock;variant_sku;variant_price
;;BRITAIN AVRIL GAU ;britain-avril-gau;[[size:36]];2;AVR-BRI-36-B;199.00
;;BRITAIN AVRIL GAU;britain-avril-gau;[[size:37]];3;AVR-BRI-37-B;199.00
;;SOLEIL AVRIL GAU;soleil-avril-gau;[[size:36]];8;AVR-SOL-36;139.00
;;SOLEIL AVRIL GAU;soleil-avril-gau;[[size:37]];5;AVR-SOL-37;139.00

5. Import with Several Variants and Stock Management

1. Leave the product_id and variant_id empty, they will be created automatically.

2. Fill in the product_url_slug and use the same for all options of a same product.

3. Encapsulate in double brackets your options:  [[size:36]][[color:black]]

product_id;variant_id;product_title;product_url_slug;variant_options;variant_stock;variant_sku;variant_price
;;BRITAIN AVRIL GAU ;britain-avril-gau;[[size:36]][[color:black]];2;AVR-BRI-36-B;199.00
;;BRITAIN AVRIL GAU;britain-avril-gau;[[size:37]][[color:black]];3;AVR-BRI-37-B;199.00
;;BRITAIN AVRIL GAU;britain-avril-gau;[[size:36]][[color:grey]];2;AVR-BRI-36-G;199.00
;;BRITAIN AVRIL GAU;britain-avril-gau;[[size:37]][[color:grey]];3;AVR-BRI-37-G;199.00

6. Import with a Collection

Once your collection are created, use one of those 3 combination above, simply add a column named product_collection.
Make sure to respect its spelling.

7. Import of an Existing Shopping Project

1. 1. Create a CSV export of your existing shopping project, edit it to follow format.
   2. Leave the product_id and variant_id empty, they will be created automatically.
   3. Fill in the product_url_slug and use the same for all options of a same product.
   4. Fill in the product_pict_url by using your pictures URL
   Find below our reference table regarding the fields you can import

8. Importable Fields Reference Table

9. Get an Example of CSV File

To get a first example of CSV file you can use the export.

To make it easier and more understandable for you, add a first product in the back office with its variants, prices, etc ... that way you will have a concrete example.

When exporting, remember to select the fields you use.

Tip: a CSV file can be worked on in a spreadsheet and viewed very simply in a simple text editor such as Notepad.

• Related Articles

• 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 ...

• 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, ...

• 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 ...

• 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 ...