Especially if you offer an extensive and frequently changing assortment, the product import can be a good solution to create and revise products as efficiently as possible.
You can use the import via Imports & Exports - Products in the shop backend.
Please proceed as follows for the product import:
Step 1: Please read the instructions and the column documentation carefully (attached below the article). All columns are explained in detail. Since the product import is quite error-prone, this step should not be skipped under any circumstances.
Step 2: Optional: Export existing products. This way you get the CSV file filled with perfect example products, if they were created manually in advance. Then you can add new products to the list. The old products can be removed from the list, as they are only for orientation for filling – unless you want to revise the already created products.
If you have not added any products to our list so far, please create an article manually and export it after activation. This will then serve as an example to help you create the new products via the CSV file.
Step 3: Check your file. Please wait for the result file that you will receive via email and only perform step 4 if no errors are displayed. Keep in mind that products that were created incorrectly and without a handle cannot be deleted afterwards. See also: What is a "handle"?
Step 4: Upload your file to our system. Please perform this step only when you are sure that the file is error-free. Products that have already been created cannot be deleted afterwards.
In the appendix you can also find a sample file for the product import.
See also: The product import is not shown to me as an option