Import and export of goods in OkayCMS

Managing an online store with a large number of products is not an easy task, especially when it comes to adding products, as well as drawing up a price list. In order not to waste time adding one product after another, a convenient functionality for importing and exporting goods in CSV format is provided in the administrative panel of the modern system for managing OkayCMS online stores. We will give detailed instructions on how to import and export goods below.

Import of goods

To import goods, you need to go to the "Import / Export" section of the admin panel menu, the "Import" item.

The download file must be in CSV format. Remember that this format only supports one sheet, so if you have multiple sheets in a table, only the current one will be saved.

The maximum file size that can be uploaded is 50 MB.

The import-export job has been redone. Now the presence of all the columns in the file is optional, as well as the observance of the ordering of the columns. In this case, the Article column must be present in the import file, since as this is the key parameter by which the product is linked.

The first line in the price list is the name of the column, for example, product category, price, brand.

One row in the table is one product. After your table with goods for import is ready and saved on your computer in a convenient place, click on the "Select file" button and use the opened explorer to find your import file.

After the file is selected, press the "Load" button.

The following information will appear:

In this window, you can select which heading fields should be updated or added. The "Skip All" button removes all fields from the import, that is, no product field will be changed. The Add All New button adds new fields, if any in the file. For example, these can be new properties (characteristics) of a product that were created in a csv file.

In addition, by clicking on the value in the "System Fields" column, you can specify a name for the corresponding column.

The result of the import of goods can be viewed in the menu item "Import log".

Before starting the import procedure, we advise you to create a backup, with which, if necessary, you can return the previous version of the product catalog.

Export of goods

To export the list of all products that are presented in the online store, go to the "Export" menu in the "Import / Export" section. The functionality of this tab is extremely simple and is represented by one button "Export".

For example, exporting products from the Home Furniture category.

When you click on the "Export" button, a CSV file is generated, which will contain the entire list of products. Depending on the number of trade items in the catalog, the process may take several minutes. The status of the unloading process is shown by a filling bar.

The result will be presented in the form of a table in which all products are displayed, with their properties, as well as a text description from the site.

It is worth noting that this functionality will help you manage your online store and maintain accounting documentation more efficiently, without spending a lot of time manually filling out numerous forms.