The easiest way to import a CSV file with a list of your products is to first create a product in your store, and then use that as the basis for the CSV file you would like to upload. Here's how to do this:
- Log into the Sitebuilder.
- Click Menu > Store.
- Go to Catalog > Products.
- Click +Add New product.
- Add a new product (ensure that you fill in all the relevant information such as price, weight etc).
- Click Save.
The product you have created becomes a template for your CSV file. All you need to do now is export this product to your spreadsheet editor, add your products and upload the CSV file to your online store. Here's how:
- Click on the check box next to the product you have just created.
- Scroll down to the bottom of the page and click Export All.
- Select Semicolon as the delimiter.
- Click to select or deselect columns as needed.
- Click Download CSV file.
- Open the downloaded CSV file in your spreadsheet editor.
- Use this file as an example and template for creating a CSV file with all of your products.
- Please note: If your example product name or any other text field contains special characters (é, ñ, ã, etc.), they may be incorrectly displayed in your spreadsheet editor. You will need to correct them manually (using your keyboard).
- Manually add the rest of your products to your spreadsheet. If you have additional products with special characters, you can type them as usual.
- When you've created your product list, save it. If you receive a message regarding the formatting of your spreadsheet (usually something like: "Do you want to save your sheet in this format"), click Yes.
- Go back to Catalog > Products.
- Click Import products.
- Select the file you would like to upload.
- Select Semicolon as the delimiter.
- You can drag and drop the column order as desired.
- To view special characters correctly, select the "ISO-8859-1" option from the "Character Encoding" drop down menu. If you don't use special characters, you can leave the default setting.
- Scroll down and select Import.
- Your products will be displayed in the product list.
Once you've created this file, editing it is really easy, and you don't need to create a new file every time you add products. Simply edit the CSV file on your computer and follow the steps to import the file. Your product list will be updated accordingly.