Exporting products from Your Store
Product Export is another great tool for managing your store! It is a powerful tool to edit and/or update multiple products at once.
For example, you want to engage your customers in a Black Friday event. You can update the prices for this sale a week in advance using the product export, and import the products Thursday night just before the start of the sale.
Let's learn how it works.
To export your products, follow these steps:
Go to Your Store (1) in the site settings;
Click Export (2).
Next up, you will see a pop-up with the following options:
Export All products (1);
Export products from one or muplitple Categories (2);
Export Selected products (3). To choose this option you have to select the products before clicking Export.
After pressing the button (4), your .csv file will be downloaded.
Tip: We recommend using Google Sheets to edit the file.
Let's take a look at the file's structure:
Important: Do not edit columns marked with ❌. Those columns are read-only.
(1) ID - read-only column. ID refers to the URL slug of your product;
(2) Variant - read-only column. Refers to the number of the product's variant. Each product has at least one variant, event if you haven't added any options yet. The row without a value is the base product, where you can edit the following columns: (3), (4), (5), (11), (12), (13), (14), (15), (16), (18). All other options should be edited in rows where the variant column (2) has a value;
(3) Name - the name of your product;
(4) Description - you can set a short description of the product, which will then be displayed on the product page on the site;
(5) Visibility: hide the product from your store by typing "no" and make it visible by entering "yes";
(6) Availability status. Sets the availability status of your product;
(7) Track Inventory. Start tracking inventory for this product by typing "yes" and turn it off by entering "no". Lean more about inventory tracking in the following article: Inventory tracking;
(8) Inventory saldo: number of products in stock. Value cannot be negative;
(9) SKU. The SKU of this product or it's variant. SKU is set manually and is used only by the site owner in the store settings;
(10) Price. Price of the product or it's variant;
(11) Categories. The categories which this product belongs to;
(12) Tags. Product tags. Please use comma as a separator when you add more than one tag.
The next settings are related to the SEO of the product. Learn more on how to configure the product SEO.
(13) Keywords. SEO keywords of the product, which can be also used to find it in your store using the store search . Keywords are located in the SEO settings of the product. Please use comma as a separator when you add more than one keyword;
(14) SEO title. Title of the product allows you to set the title for the page of the selected product which will be displayed in the search engines;
(15) SEO description. You can create a more detailed description of your product that will be displayed in the search results under the title.
Lean more about product options in the following article: Product options
(18) Every option displays the product options set and enriches your product. All of the variants for this product are displayed and numbered in the Variant column (2). If you have a product with multiple variants you will see it as shown on the figure (19).
Tip: Visit our guide on Editing products in your store to learn more about product settings.
Once you are done with your file editing, you can import it back to your Weblium site. To do that in Google Sheets save it as .csv following the steps below:
Go back to Your Store and upload the file via the Import option as shown on the screenshot below.
Choose the Weblium store import type (1) and upload your file (2):
All done! Your updated products have been imported. You'll see an import report in case something goes wrong.
Note: The following restrictions apply: the file size should not exceed 10MB and the maximum number of products is 1000.
For example, you want to engage your customers in a Black Friday event. You can update the prices for this sale a week in advance using the product export, and import the products Thursday night just before the start of the sale.
Let's learn how it works.
Product export
Getting started
To export your products, follow these steps:
Go to Your Store (1) in the site settings;
Click Export (2).
Next up, you will see a pop-up with the following options:
Export All products (1);
Export products from one or muplitple Categories (2);
Export Selected products (3). To choose this option you have to select the products before clicking Export.
After pressing the button (4), your .csv file will be downloaded.
Editing the file
Tip: We recommend using Google Sheets to edit the file.
Let's take a look at the file's structure:
Important: Do not edit columns marked with ❌. Those columns are read-only.
General product settings
(1) ID - read-only column. ID refers to the URL slug of your product;
(2) Variant - read-only column. Refers to the number of the product's variant. Each product has at least one variant, event if you haven't added any options yet. The row without a value is the base product, where you can edit the following columns: (3), (4), (5), (11), (12), (13), (14), (15), (16), (18). All other options should be edited in rows where the variant column (2) has a value;
(3) Name - the name of your product;
(4) Description - you can set a short description of the product, which will then be displayed on the product page on the site;
(5) Visibility: hide the product from your store by typing "no" and make it visible by entering "yes";
(6) Availability status. Sets the availability status of your product;
(7) Track Inventory. Start tracking inventory for this product by typing "yes" and turn it off by entering "no". Lean more about inventory tracking in the following article: Inventory tracking;
(8) Inventory saldo: number of products in stock. Value cannot be negative;
(9) SKU. The SKU of this product or it's variant. SKU is set manually and is used only by the site owner in the store settings;
(10) Price. Price of the product or it's variant;
(11) Categories. The categories which this product belongs to;
(12) Tags. Product tags. Please use comma as a separator when you add more than one tag.
SEO settings.
The next settings are related to the SEO of the product. Learn more on how to configure the product SEO.
(13) Keywords. SEO keywords of the product, which can be also used to find it in your store using the store search . Keywords are located in the SEO settings of the product. Please use comma as a separator when you add more than one keyword;
(14) SEO title. Title of the product allows you to set the title for the page of the selected product which will be displayed in the search engines;
(15) SEO description. You can create a more detailed description of your product that will be displayed in the search results under the title.
Product options.
Lean more about product options in the following article: Product options
(18) Every option displays the product options set and enriches your product. All of the variants for this product are displayed and numbered in the Variant column (2). If you have a product with multiple variants you will see it as shown on the figure (19).
Tip: Visit our guide on Editing products in your store to learn more about product settings.
Importing the file back to Your Store
Once you are done with your file editing, you can import it back to your Weblium site. To do that in Google Sheets save it as .csv following the steps below:
Go back to Your Store and upload the file via the Import option as shown on the screenshot below.
Choose the Weblium store import type (1) and upload your file (2):
All done! Your updated products have been imported. You'll see an import report in case something goes wrong.
Note: The following restrictions apply: the file size should not exceed 10MB and the maximum number of products is 1000.
Updated on: 12/07/2023
Thank you!