Files format

Overview of the import and export files format

The entire format is represented as an .zip archive containing the following .csv files.

Only zip-archived files are processed properly in case of an import - a simple .csv file upload won't work.

Files within the archive must be named accordingly, as in the documentation below.

The maximum archive size is 350 MB.

The maximum single file size within the archive is 1000 MB.

Columns are separated using ","(comma) or ";"(semicolon) separator depending on the configuration.

Files have to be UTF-8 formatted.

Cell values need to be escaped with the " sign if they contain a column separator. "sku1,sku2" - forcomma separator

"the ; sign is called semicolon" - for the semicolon

The files are placed in the zip archive as top-level entities. Those should not be placed in a subdirectory within the archive - an often-made mistake for MacOS users - when using the right-click menu on a directory containing files and using the option Compress "directory" which does just that.

Below you can find an example of importing data.

default_data_model_with_media_and_products.zip

archive · 5KB

Open

Please refer to a specific file description for more details.

• products.csv - the product data

• multimedia.csv - the multimedia resources

• multimedia_attributes.csv - the multimedia allowed attributes configuration

• categories.csv - the categories

• category_attributes.csv - the category allowed attributes configuration

• category_trees.csv - the category trees

• category_trees_elements.csv - the category trees configuration

• completeness_sets.csv - the completeness sets

• multimedia_folders.csv - the multimedia folders

• attributes.csv - the attributes

• attribute_groups.csv - the attribute groups

• custom_fields.csv - the custom fields

• options.csv - the collection attributes options

• units.csv - the units

• templates.csv - the templates

• templates_elements.csv - the templates configuration

• section_templates.csv - the section templates

• section_templates_elements.csv - the section templates configuration

• roles.csv - the roles

• roles_feature_privileges.csv - the role privileges

• automations.csv - the automations

• automations_actions.csv - the automation actions

• workflows_statuses.csv - the workflow statuses

• workflows.csv - the workflows

• workflows_transitions.csv - the workflow transitions