# Import / export # Export / orders list # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) Getting started In this article, you can learn about **export / orders list** functionality, which will allow you to export created e-commerce orders with their basic information. In order to access this module you have to have **BOK supervisors**, **MC business admin,** **Administrator**, **Super administrator**, or **Root** group.
![POWERPNT_h6wEpFGvDv.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/7287921788956.png)
*Visualization of the exported orders list*
To open the Featured products / list view, in the admin panel, navigate to: ***Import / export > Export / orders list*** All possible operations to perform on the **Export / orders list** view can be done in the **Filters **and **Export / orders list** tabs.
[![Screenshot 2025-02-13 at 14-44-29 Export _ orders list - Admin module.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/screenshot-2025-02-13-at-14-44-29-export-orders-list-admin-module.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/screenshot-2025-02-13-at-14-44-29-export-orders-list-admin-module.png)
*Visualization of the export / orders list module in the administrator panel*
Table of contents: 1. [ Filters section](#bkmrk-filters-section) 2. [ Export / orders list section](#bkmrk-export-%2F-orders-list) 3. [ Exporting orders to the xlsx](#bkmrk-exporting-orders-to-) --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) Filters section The **Filters** section allows the sorting of the orders in the **export / orders list** module, based on the available filters. Orders are not visible by default and it is required to apply any filter first in order to see them. Below you will find a description of each filter.
[![POWERPNT_ypOgCIY8Rl.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/Yw2powerpnt-ypogciy8rl.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/Yw2powerpnt-ypogciy8rl.png)
*Visualization of the filters tab*
- **Order ID** - Orders internal ID. - **Processed on** - A range of dates when the order was processed. - **Order value** - A range of total order values. - **Alt shop** - Altshop name where the order was placed on. - **Status** - Current status of the order. - **Delivery method** - Selected orders delivery method. - **Payment method** - Selected orders payment method. - **Deffered payment status** - Current status of the deffered payment. - **Check status** - Current internal check status of the order. - **Paid?** - Order payment status. - **Customer ID** - ID of the customer. - **Phone number** - Customer's phone number. - **Package number** - Number of the delivery package. - **Only with vouchers** - A tickbox that allows seeing only orders with vouchers. - **Status (Balikobot)** - Order status acquired from Balikobot. After defining the above filters, select the **Apply Filters** button to get a list of sites according to the applied filters. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) Export / orders list section The **Export / orders list** section allows to further narrow down the list of orders. Below you will find a description of possible actions.
[![POWERPNT_6OEtvkRjD2.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/powerpnt-6oetvkrjd2.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/powerpnt-6oetvkrjd2.png)
*Visualization of the export / orders list section*
- Select the **Show X entries** **(1)** field to set the number of orders, displayed on one page (min 10 / max 100). - The names of the columns **(2)** that contain information about a given order. Each column is susceptible to sorting. To sort the records, click on the title of the column in question. - **Order ID** - Orders internal ID. By clicking on the order ID you will be redirected to the detailed order information located in the **Orders > Orders / list.** - **Processed on** - A range of dates when the order was processed. - **Value** - A range of total order values. - **First name** - Customer's first name. - **Last name** - Customer's last name. - **E-mail** - Customer's e-mail address. - **Paid?** - Order payment status. - **DP status** - Current status of the deffered payment. - **Status** - Current status of the order. - **Phone number** - Customer's phone number. - **Package number** - Number of the delivery package (Carrier Barcode). - Select the **Export to xlsx (3)** button to export all filtered orders to the xlsx file. You can learn more about exported xlsx file in the [ Exporting orders to the xlsx](#bkmrk-exporting-orders-to-) section - **Search box** **(4)** where you can search for desired orders by their ID, first name, last name, e-mail address, status, phone number, and package number. - **Page buttons** **(5)**, which allow users to change the page of currently viewed orders. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) Exporting orders to the xlsx By pressing the Export to xlsx button shown in the [ Export / orders list section](#bkmrk-export-%2F-orders-list) chapter you are able to export all the filtered orders to the xlsx file and download it.
![POWERPNT_h6wEpFGvDv.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/7287921788956.png)
*Visualization of the exported orders=s*
Xlsx file contains the exactly same information as **export / orders list** tab: - **ID** - Orders internal ID. - **Processed on** - A range of dates when the order was processed. - **Value** - A range of total order values. - **First name** - Customer's first name. - **Last name** - Customer's last name. - **E-mail** - Customer's e-mail address. - **Paid?** - Order payment status. - **DP status** - Current status of the deffered payment. - **Status** - Current status of the order. - **Phone number** - Customer's phone number. - **Package number** - Number of the delivery package (Carrier Barcode). # Export customers # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/10027086064156.png) Getting started In this article, you can find information about e-commerce customer export with various filter options to a .csv file, that will help to export the exact type of customers that have an account on the e-commerce platform. ![info2.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/10027294665628.png) **Remember**You can find information regarding the Beauty Advisor customer export in the **\[UNDER CONSTRUCTION\]** article.
[![POWERPNT_xyjEabGTRm.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/powerpnt-xyjeabgtrm.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/powerpnt-xyjeabgtrm.png)
*Visualization of the export customers tab location*
Table of contents: 1. [ Exporting the e-commerce customers](#bkmrk-exporting-the-e-comm-1) 2. [ Exported file overview ](#bkmrk-exported-file-overvi) --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/10027086064156.png) Exporting the e-commerce customers E-commerce customer export can be found in ***Import / Export > Export / customers*** Below you can find all filter options to customize your export to your needs.
[![POWERPNT_ypOgCIY8Rl.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/powerpnt-ypogciy8rl.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/powerpnt-ypogciy8rl.png)
*Visualization of the all available export filters*
- **Registration time** - A range of dates when customers registered on an e-commerce platform. - **Update time** - A range of dates whenever customer information has been updated. - **Birthday** - A range of dates of customer birthdays. - **Active status** - Customers current status. Available statuses are: **Inactive**, **Active**, **Waiting for activation**, **One-time** - **Gender** - Customers gender. Available options are **Man**, **Woman**, **Not specified**. - **Export specific customers - filter** - A filter which allows to specify customers by their: - **E-mail** - **ID** - **JOY ID** - A field where you should put specific customer data with a "**;**" separator, data will be filtered according to the selected filter. This field is only visible whenever the **Export specific customers - filter** is selected. Example (with email filter selected): example@example.com;example2@example.com;example3@example.com - **Allowed to make test orders** - A **Yes** / **No** selection if customers are able to make test orders. This is defined by the "**Allowed to make test orders**" tickbox in the customers profile. - i**s MC customer?** - A **Yes** / **No** selection if a customer has a member club rank. All countries that use Member club functionality for various customer ranks (i.e. on Poland Default / Silver / Gold) are MC customers. - **Active status** - Customers member club current status. This field only filters the member club customers - **MC title** - Member club title assigned to the customers (in the case of Poland it can be T0 / TS / TG). This field only filters the member club customers. - **Orders count** - A range of numbers of created orders on the website. - **Orders placement dates** - A range of dates when customers have placed new orders using the e-commerce platform. Using this filter requires a non-zero "**orders count: from**" value. - **Show MD5 e-mail hash column** - Shows customers MD5 e-mail hash column in the report. - **Export opt-out\_mobile** - Shows customers current mobile communication subscription status. - **Export opt\_out\_email** - Shows customers current e-mail communication subscription status. - **Export agreements** -Exports all available agreements as columns and defines which customers have agreed to the selected agreements. - **Export FIDEN2 cards** -Exports customers FIDEN2 card information. The exported fields are: - **cards\_active** - A list of customers active FIDEN2 cards - **cards\_waiting** - The number of points waiting to be assigned to the selected customer FIDEN2 cards. - **cards\_balance** - Current FIDEN2 balance - **cards\_balance\_time** - A date of last balance change for the selected customer. - **Only customers which manually assigned retail card** - A tickbox which defines if only customers with manually assigned retail cards should be exported. With selected filters you can export customers using the **Export** button or clear all filters by using the **Clear filters** button.
[![POWERPNT_WK2pZwiiqi.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/powerpnt-wk2pzwiiqi.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/powerpnt-wk2pzwiiqi.png)
*Visualization of the prepared export file*
With exported file you are able to download it to your device using the **Download file** button. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/10027086064156.png) Exported file overview The exported file will be in a **.csv** format with an export date and hour in it's file name (i.e. **customers\_2023\_08\_16\_131359**)
![POWERPNT_53Kap3zLv3.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/10043712384668.png)
*Visualization of the exported csv file*
By default in the exported customers file you can find the following columns: - **id** - Customers internal ID. Example: **123456** - **first\_name** - Customers name. Example: **Jan** - **last\_name** - Customers surname. Example: **Kowalski** - **street** - Main street name. Example: **Uliczna** - **building** - Main building number. Example: **123** - **flat** - Main flat number. Example: **2** - **city** - Main city name. Example: **Warsaw** - **postal\_code** - Main postal code. Example: **12-345** - **email** - Customers e-mail address. Example: **test@example.com** - **mobile** - Customers mobile number with a country code. Example: **48123123123** - **birthday** - Customers birthday date. Example: **01-01-1990** - **gender** - Customers gender (if selected). Example: **Man** With additional fields dependent on selected options: - **md5\_email** - Customers MD5 email value. Example: **26h2cb31af663cdccaa2779c9d165a0b** - **opt out mobile** - Customers mobile communication current status. If the customer is opted in this value will be **empty**. If the customer is opted out the value will be set to **Opted out**. - **opt out email** - Customers e-mail communication current status. If the customer is opted in this value will be **empty**. If the customer is opted out the value will be set to **Opted out**. - **Customers agreement status to the selected agreements** - These fields will have different column names depending on the country and selected agreements (i.e. **terms\_of\_service\_vpi**, **data\_processing\_mc**). Whenever the customer has agreed to the selected agreement there will be a "**Selected**" value in the column. If the customer has not agreed to the agreement the field will be empty. - **cards\_active** - A list of customers active FIDEN2 cards. Example: **123456789, 987654321**. - **cards\_waiting** - The number of points waiting to be assigned to the selected customer cards. Example: **123** - **cards\_balance** - Current FIDEN2 balance Example: **5333** - **cards\_balance\_time** - A date of last balance change for the selected customer. Example: **05-08-2023** # Product catalog export and import # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Getting started In this article, you will learn how to extract a product catalog in the form of CSV files and how to import it back. The overview for each product catalog file is here. Export can be found in ***Import / Export > Export / catalog (1)*** Import can be found in ***Import / Export > Import > Type > Catalog mass import (2)***
[![POWERPNT_hv9c1tmzEd.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/powerpnt-hv9c1tmzed.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/powerpnt-hv9c1tmzed.png)
*Visualization of the product catalog options in the Import / export module*
Table of contents: 1. [Export catalog](#h_01GCH0X17BDKRC07GCXTQDSF97) 2. [Catalog files](#h_01GCH0X17BDKRC07GCXTQDSF91) 3. [Catalog import](#h_01GCH0X17BDKRC07GCXTQDSF92) 4. [How to make mass import](#imp0) 5. [Overview - catalog\_product.csv](#imp1) 6. [Overview - catalog\_product\_description.csv](#bkmrk-%C2%A0-10) 7. [Overview - catalog\_product\_attribute.csv](#bkmrk-%C2%A0-12) 8. [Overview - catalog\_product\_stock.csv](#bkmrk-%C2%A0-15) 9. [Overview - dict\_tag\_catalog\_product.csv](#bkmrk-%C2%A0-17) 10. [Overview - dict\_property.csv](#bkmrk-%C2%A0%C2%A0-2) 11. [Overview - dict\_tag.csv](#bkmrk-%C2%A0-20) 12. [ Overview - catalog\_product\_category.csv](#h_01H0T23XV4R0NE6N0TMR8EKG8B) 13. [Overview - alt\_shop\_catalog\_product.csv](#bkmrk-%C2%A0-28) 14. [ Overview - catalog\_product\_category.csv](#bkmrk-overview---catalog_p-3) 15. [ Overview - dict\_tag\_catalog\_product\_remove.csv](#bkmrk-overview---dict_tag_-1) 16. [ Order of processing files](#bkmrk-order-of-processing-) --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Export catalog Catalog export has some filtering options for thinning out the results of extracted data.
[![POWERPNT_VQRk4QGAv5.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/powerpnt-vqrk4qgav5.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/powerpnt-vqrk4qgav5.png)
*Visualization of the Catalog export*
- **Alt shop** - Chooses for which alt shop the catalog should be exported. If left empty, products from all alt shops will be exported. You can learn more about altshops in the [Alt shops - Introduction](https://tauceti.zendesk.com/hc/en-us/articles/360017301600) article. - **Product status** - Chooses between **Active** and **Inactive** products. If left empty, all products will be exported. - **Is altshop active?** - Choose if the product exported are active on chosen altshop or inactive. - **Product SKU** - A list of product SKUs. A list of multiple SKUs needs to be separated by commas (i.e. 123456,654321,55555). - **Two buttons**: - **Apply filters** - A button, which will apply selected filters and automatically start the download of the filtered products. - **Clear filters** - A button, which clears all already chosen filters. Exported files described in [ Catalog files](#h_01GCH0X17BDKRC07GCXTQDSF91) section are packed in a .zip file, which needs to be unpacked. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Catalog files The downloaded archive will contain the following files: - **alt\_shop\_catalog\_product.csv** - Contains data for **Alt shops > Products / list** (You can find more information about this module in [Products / list - browsing and managing products in altshop module](https://tauceti.zendesk.com/hc/en-us/articles/5591686579228) article) - **catalog\_product.csv** - Contains data for **Catalog > Products / list** (More information about this module in **\[UNDER CONSTRUCTION\]**) - **catalog\_product\_attribute.csv** - Contains data for **Catalog > Products / list > View product > Add color** (More information about this module in **\[UNDER CONSTRUCTION\]**) - **catalog\_product\_description.csv** - Contains data for **Catalog > Products / list > View product, Description tab** (More information about this module in **\[UNDER CONSTRUCTION\]**) - **catalog\_product\_meta.csv** - Contains data for - **Catalog > Products / list > View product, Metadata tab** (More information about this module in **\[UNDER CONSTRUCTION\]**) - **catalog\_product\_stock.csv** - Contains data for **Catalog > Products / list > View product, Stock tab** (More information about this module in **\[UNDER CONSTRUCTION\]**) - **dict\_property.csv** - Contains data for **Catalog > Properties / list** (More information about this module in **\[UNDER CONSTRUCTION\]**) - **dict\_tag.csv** - Contains data for **Catalog > Tags / list** (More information about this module in **\[UNDER CONSTRUCTION\]**) - **dict\_tag\_catalog\_product.csv** - Contains data for **Catalog > Products / list > View product, Tags tab** (More information about this module in **\[UNDER CONSTRUCTION\]**) - **catalog\_product\_category.csv** - Contains data for Catalog > Products / list > View product, **edit product tab**. You can find more information about the category module in [Catalog categorization](https://knowledge.tauceti-digital.com/books/e-commerce/page/catalog-categorization) article. - **dict\_tag\_catalog\_product\_remove.csv** - Contains exact same data structure as **dict\_tag\_catalog\_product.csv**, but it removes the assigned tags from the selected products. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Catalog import All the exported files can be edited and imported back to the administration panel to update catalog data. Files can be imported separately or in groups but their import must always be consolidated in a .zip file. The file names must be exactly the same as defined in this article and they cannot be changed. There are no mandatory files, so it is possible to import only **catalog\_product\_description.csv** without any other files as long as it is in the .zip file. Packed .csv files can be in any folder structure as long as file names are not duplicated. Other file formats than .zip will be rejected and won't be uploaded. ## Files specification Since the imported files directly correspond with the database some rules must be followed while creating and editing import files, here is a general specification for these: - Field type **BOOLEAN:** - 0 - NO - **1** - YES - Field type **DATE** must be in the following format "**YYYY-MM-DD**" - **EOL (End Of Line)** column must contain EOL in every row with a product. This column shows our system, that for a selected product its info ends with this column, and the system can move to another row. Here is an example of **EOL** use: - ``` column1;column2;EOL ``` - ``` “abc”;”abc”;EOL ``` - ``` “cde”;”cde”;EOL ``` - The decimal separator must be a dot "**.**" for example: "**199.99**" - While editing files in text editors (not spreadsheets) all columns have to be separated by **semicolon** "**;**" - **STRING** field type can be filled with any text and/or number. The only exception to this exists in every field with **URL** value, these must be strings without any special/regional characters besides "**/**" as a start to the URL and "**\_**" as a separator for word f.x. "**/new\_product\_sku\_123**" --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) How to make mass import Mass import is a product import of a ZIP file that contains prepared .csv files. This operation changes the product data based on their SKU or creates a new product if the selected SKU doesn't exist in the catalog database. You don't need to put every .csv file in the .zip, only the ones that you have modified can be put in the .zip file and then imported. In order to import catalog files, they have to be in CSV format, coded in UTF-8. Go to ***Import/Export > Import*** and choose ***Catalog mass import** in the* **Type***.*
[![POWERPNT_PN7j1CAtyh.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/powerpnt-pn7j1catyh.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/powerpnt-pn7j1catyh.png)
*Visualization of Import / Export, Import*
- ** File \* ** - **Choose a file,** and find your zip archive with CSV files. - **Type\* **- Click and choose **Catalog mass import** in order to perform the change in the catalog database. - **Options** - **Test import** allows for virtual database calculation after importing a chosen archive. You'll be able to check the results of this import by receiving a report for each imported file. Test import won't perform any actual changes in the environment. - **Import file** - Click to perform an import. The file will start processing right after clicking. ![info2.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915161244.png) **Remember**Product descriptions can be enriched by HTML and CSS codes. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - catalog\_product.csv File ***catalog\_product.csv*** contain mainly data regarding imported products. Mass import of this file allows to: - Adding new records - Updating records (on a base of unique SKU)
**\#****Column name****Value type****Max length****Can be empty?****Description****What, if empty**
1SKUSTRING7NoProduct code-
2is\_activeBOOLEAN (0/1)1NoIs the product visible?-
3nameSTRING255NoProduct name-
4titleSTRING255YesTitle for productEmpty product title
5short\_descriptionSTRING255YesShort descriptionEmpty description
6capacitySTRING125YesCapacity/size of the productCapacity undefined
7sort\_orderINTEGER1YesSort Order0
8priceDECIMAL10,2NoCatalog price-
9f\_green\_pointBOOLEAN (0/1)1YesFlag: green point 0
10f\_bestsellerBOOLEAN (0/1)1Yes Flag: bestseller0
11f\_limited\_editionBOOLEAN (0/1)1Yes Flag: limited edition0
12 f\_setBOOLEAN (0/1)1Yes Flag: set0
13 f\_giftBOOLEAN (0/1)1Yes Flag: gift0
14 f\_gift\_choiceBOOLEAN (0/1)1Yes Flag: gift of choice 0
15f\_outlet BOOLEAN (0/1)1Yes Flag: outlet 00
16is\_new\_untilDATE10Yes Date till the product is marked as "new". Should be in a DD-MM-YYY format. The product won't be marked as "new"
17friendly\_urlSTRING255Yes URL for the product-
18 eanSTRING 13 Yes EAN code. Multiple EANs can be separated by a comma (,). The system verifies in the import process if the typed EAN is in correct EAN-8 or EAN-13 format. -
19 EOLSTRING 3 No Always must be “EOL” -
--- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - catalog\_product\_description.csv File ***catalog\_product\_description.csv*** contains descriptions for the products. Mass import allows to: - Adding new records - Updating records (on a base of unique SKU) ![caution.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915165212.png) **Warning** There must be a product in the database with SKU matching the value of the SKU column in order to apply any changes.
**\#****Column name****Value type****Max length****Can be empty?****Description****What, if empty**
1SKUSTRING7NoProduct code-
2description\_mainSTRINGundefinedYesMain descriptionempty description
3description\_effectSTRINGundefinedYesEffects descriptionempty description
4description\_usageSTRING5YesUsage descriptionempty description
5description\_ingredientSTRINGundefinedYesIngredientsempty description
6description\_capacitySTRINGundefinedYesType of package and capacityempty description
7description\_additional\_infoSTRINGundefinedYesAdditional informationempty description
8description\_notesSTRINGundefinedYesResultsempty description
9 EOLSTRING 3 No Always must be “EOL” -
![info2.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359840869148.png) **Remember**New lines in descriptions fields will be changed to <br> HTML can be used to customize the text. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - catalog\_product\_attribute.csv File ***catalog\_product\_attribute.csv*** contains data about color variants of imported products. Mass import allows to: - Adding new records - Updating records (on a base of unique SKU) ![caution.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915165212.png) **Warning** There must be a product in the database with SKU matching the value of the SKU column in order to apply any changes. If there is no color from the color column in the database then a new color will be created and assigned to the new attribute.
**\#****Column name****Value type****Max length****Can be empty?****Description****What, if empty**
1SKU\_parentSTRING7NoCode of the parent product-
2SKUSTRING7NoCode of the color variant -
3colorSTRING255NoColor name -
4is\_activeBOOLEAN (0/1)1NoFlag: is active? -
5 EOLSTRING 3 No Always must be “EOL” -
--- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - catalog\_product\_stock.csv File ***catalog\_product\_stock.csv*** contains information about the stock resources of the imported products. Mass import allows to: - Updating records (on a base of unique SKU) ![caution.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915165212.png) **Warning** There must be a product in the database with SKU matching the value of the SKU column in order to apply any changes.
**\#****Column name****Value type****Max length** **Can be empty?****Description****What, if empty**
1SKUSTRING7NoProduct code-
2stock\_valueINTEGER5NoAmount of stock value -
3always\_in\_stockBOOLEAN(0/1)1YesFlag: product is always in stock 0
4min\_stock\_valueINTEGER5YesMinimal stock valueDefault value from the database
5warn\_stock\_valueINTEGER 5 YesStock limit at which administrator will receive a warning about low stock valueDefault value from the database
6 EOLSTRING 3 No Always must be “EOL” -
--- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - dict\_tag\_catalog\_product.csv File ***dict\_tag\_catalog\_product.csv*** contains information about tags of imported products. Mass import allows to: - Adding new assignments - Updating already existing assignments ![caution.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915165212.png) **Warning** There must be a product in the database with SKU matching the value of the SKU column in order to apply any changes. The same applies to tags columns and properties.
**\#****Column name****Value type****Max length****Can be empty?****Description****What, if empty**
1SKUSTRING7NoProduct code, if color variant then uses parent code. -
2propertySTRING45NoProperty name -
3tag1STRING150NoTag name -
4tag2STRING150YesTag name -
5tag3STRING150YesTag name -
6tag4STRING150YesTag name -
7tag5STRING150YesTag name -
9 EOLSTRING 3 No Always must be “EOL” -
In order to assign more than 5 tags to one product, use another row, here is an example of how to assign 6 tags to SKU1 in property "część ciała": - ``` SKU1;”część ciała”;”twarz”;”włosy”;”dłoNo”;”nogi”;”ramiona”;EOL ``` - ``` SKU1;”część ciała”;”uda”;;;;;EOL ``` In order to delete a tag from a product add “<delete>” before it. Here is an example of deleting the tag "40+": - ``` “40+”

``` --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - dict\_property.csv File **dict\_property.csv** contains information about properties. Mass import allows: - Adding new properties
**\#****Column name****Value type****Max length****Can be empty?****Description****What, if empty**
1nameSTRING 45 NoProperty name -
2url\_nameSTRING 45 YesFriendly URL Will be generated automatically from the property name
3sort\_orderINTEGER5NoSort Order-
4is\_activeBOOLEAN(0/1)1NoFlag: Is this property active?-
5 EOLSTRING 3 No Always must be “EOL” -
--- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - dict\_tag.csv File ***dict\_tag.csv*** contains information about tags. Mass import allows to: - Adding new tags ![caution.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915165212.png) **Warning** There must be a property in the database in order to add new tags.
**\#****Column name****Value type****Max length****Can be empty?****Description****What, if empty**
1property\_nameSTRING 45 NoNazwa cechy, do której jest przypisany tag -
2nameSTRING 150 NoNazwa tagu (wartość cechy) -
3url\_nameSTRING 150 Yesfriendly URL for the tagWill be generated automatically from the tag name
4 EOLSTRING 3 No Always must be “EOL” -
--- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - alt\_shop\_catalog\_product.csv File ***alt\_show\_catalog\_product.csv*** contains information about availability in altshops and discounts counted from catalog prices. Mass import allows to: - Adding new altshop assignments and promotions - Editing existing altshop assignments and promotions ![caution.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915165212.png) **Warning** Adding values to promotion\_price, price\_discount and percentage\_discount won't be updated if the product is\_active=0. Rows is\_active=0 serves as a forced deactivation in altshop. It is a good practice to add only alt\_shops that products should be active.
**\#****Column name****Value type****Max length****Can be empty?****Description****What, if empty**
1alt\_shopSTRINGundefinedNoAltshop system name-
2SKUSTRING 7NoProduct code -
3is\_activeBOOLEAN(0/1) 1NoIs the product active in altshop-
4promotion\_priceDECIMAL undefinedYesPromotion priceNo promotion price or set-by-price/percentage discounts
5price\_discountDECIMAL undefinedYesPrice discount subtracts value from the catalog priceNo discount or discounted by promotion price/percentage discount
6percentage\_discountDECIMAL2YesPercentage discount counted from catalog price.No promotion or discounted by promotion price/ price discount
7promotion\_start\_dateDATEundefinedYes**Information:** date of promotion start No date of promotion start
8promotion\_end\_dateDATE undefined Yes**Information:** date of promotion end No date of promotion end
9promotion\_valid\_textSTRING undefined YesText informing about promotion validationLack of text even, if promotion start and end dates are present.
10EOLSTRING 3 No Always must be “EOL” EOL
--- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - catalog\_product\_category.csv File **catalog\_product\_category.csv** contains information about categories assigned to the products. Mass import allows to: ![info2.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915161244.png) **Remember**You can find more information about catalog categories in the [Catalog categorization](https://knowledge.tauceti-digital.com/books/e-commerce/page/catalog-categorization) article. - Adding currently present categories to the selected products - Editing categories of the selected products.
**\#****Column name****Value type****Max length****Can be empty?****Description****What, if empty**
**1** SKU** **STRING 7 No Product code**-**
**2** category\_pathSTRING undefinedNo Category path. Path steps need to be separated by a Guillemet ("»") i.e. E-commerce » Włosy » Szampony. The category path should always start with E-commerce. **-**
**3** is\_main** **BOOLEAN(0/1)1 No A flag that shows if a selected category path for a selected SKU is marked as a main one **-**
**4** EOLSTRING 3 No Always must be “EOL” EOL
![caution.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915165212.png) **Warning** Please note that this process overwrites product categories for products that are being edited. In case the user has the following record already in the database on the website:
SKUcategory\_pathis\_mainEOL
32611E-commerce » Vůně1EOL
and there is a need to add a new category **the already existing record also needs to be included in the import**. ### Example of an incorrect import file that overwrites the product categories:
SKUcategory\_pathis\_mainEOL
32611E-commerce » Vlasy0EOL
When the file looks like that the **E-commerce » Vůně** will be removed from the product, and only **E-commerce » Vlasy** will be available after the import. ### Example of a correct import file that doesn't overwrite the product categories:
SKUcategory\_pathis\_mainEOL
32611E-commerce » Vůně1EOL
32611E-commerce » Vlasy0EOL
In this case both **E-commerce » Vůně** and **E-commerce » Vlasy** will be included in the product 32611 after the import. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Overview - dict\_tag\_catalog\_product\_remove.csv File **dict\_tag\_catalog\_product\_remove.csv** contains a list of SKUs with tags, that should be removed from the product. The content of this file is exactly the same as **dict\_tag\_catalog\_product.csv.** This file is not automatically created when exporting the product catalog. Mass import allows to: - Removal of tags from the selected SKUs
**\#****Column name****Value type****Max length****Can be empty?****Description****What, if empty**
1SKUSTRING7NoProduct code, if color variant then uses parent code. -
2propertySTRING45NoProperty name -
3tag1STRING150NoTag name -
4tag2STRING150YesTag name -
5tag3STRING150YesTag name -
6tag4STRING150YesTag name -
7tag5STRING150YesTag name -
9 EOLSTRING 3 No Always must be “EOL” -
Tag removal doesn't remove properties by itself. Whenever a product has all of it's tags removed, the property is removed automatically. For example, if the product has the following propety with a tags:
**SKU****property****tag1****tag2****tag3****tag4****tag5****EOL**
69726Péče o těloTělové olejeTělové peelingy EOL
And the **dict\_tag\_catalog\_product\_remove.csv** contains the following data:
**SKU****property****tag1****tag2****tag3****tag4****tag5****EOL**
69726Péče o těloTělové peelingy EOL
**Tělové peelingy** will be removed from the product tags list, but **Tělové oleje** will remain, which would result with the following record:
**SKU****property****tag1****tag2****tag3****tag4****tag5****EOL**
69726Péče o těloTělové oleje EOL
If both tags were removed, then the **Péče o tělo** property would also be removed from the product, as this product doesn't contain any tags from this property. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9359915156764.png) Order of processing files The system while importing the files is processing them in a selected order, to make sure there will be no mistakes while importing, like changing the price of a product that doesn't exist in the database. You can find an order of processing below:
**Order****File name**
1dict\_property.csv
2dict\_tag.csv
3catalog\_product.csv
4catalog\_product\_description.csv
5 catalog\_product\_category.csv
6catalog\_product\_attribute.csv
7catalog\_product\_meta.csv
8catalog\_product\_stock.csv
9dict\_tag\_catalog\_product.csv
10alt\_shop\_catalog\_product.csv
11 dict\_tag\_catalog\_product\_remove.csv
# Import / export introduction # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9575171443356.png) Getting started In this article, you will learn about **Import / export** module, and possible import or export options. **Import / export** module allows importing or exporting of desired data to or from the admin panel. By exporting the data you receive an xlsx, txt, or csv file with selected data within the selected scope. By importing the data you import previously prepared zip, xlsx, txt, or csv file and apply it to the data in the admin panel. ![info2.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9575171447068.png) **Remember**Exporting is an action that allows downloading of certain data from the e-commerce database to the user's device. Importing is the opposite action of exporting, which allows uploading selected files with selected content and extension from the user's device to the e-commerce database. **Import / export** module contains of: - Import sections **(1)** allow users to import external data in zip, xlsx, txt or csv format to the admin panel database. Import sections are described in [ Import options](#bkmrk-import-options) section. - Personal codes generator **(2)** allows for creating unique codes in bulk amounts, which later can be imported to the personal code database and assigned to the main code. You can find more information about promotional codes and how to generate and import them in the [Discount codes](https://knowledge.tauceti-digital.com/books/e-commerce/page/discount-codes) article. - Various export options, which will allow you to export e-commerce data to your computer.
[![POWERPNT_3jmqoXuPey.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/powerpnt-3jmqoxupey.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/powerpnt-3jmqoxupey.png)
*Visualization of the import module in import/export*
![caution.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9575194355868.png) **Warning** Most of the exported data is highly confidential. It contains the personal data of the customers. Thus, all downloaded files should be treated with care and security processes. Table of Contents: 1. [Import options](#bkmrk-import-options) 2. [Export options](#bkmrk-export-options) - [Extracting files](#bkmrk-extracting-data) --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9575171443356.png) Import options Import serves as a tool to update databases, following data can be uploaded: From the main section ***Import / export > Import*** - **Catalog mass import** - Allows to import a .zip file with product configuration (***Catalog > Products***, ***Colors***, ***Properties*** and ***Tags***; ***Alt shops > Products / list***). You can learn more about products and files used in this import in the [Product catalog export and import](https://knowledge.tauceti-digital.com/books/e-commerce/page/product-catalog-export-and-import) article. - **Newsletter subscribers CSV** - A CSV file with a subscribers list with an assignment to selected subscriber groups. (***Customers > Subscribers / list***). - **Address dictionary CSV (complete replace)** - Address database, which is used in a zip-code / city / street name recommendations while filling up a customer address on e-commerce platform. (***Customers > Address Dictionary***). This CSV import completely replaces the old database, so by uploading only one, new address it will replace all of the addresses in the database, and only this one address will be available. Please make changes to the entire address database first, and then import it to the admin panel instead of importing singular addresses. - **Translations XLSX** - List of phrases and translations. (***System > Translations / list***) - **Ingredients** - List of ingredients for the lexicon functionality. (***Herbarium > Plants***, ***Plant families***, ***Regions***) - **Vouchers - modification dates (XLSX/CSV)** - List with expiration dates for fiden2 codes. (***Promotions > Vouchers / list***) - **Customer private offers** - Custom private offers for customers. (***Customers > Customer Private Offers***). You can find more about private offers in [Customer private offers](https://knowledge.tauceti-digital.com/books/e-commerce/page/customer-private-offers) article. - **Customer contact database for Consultants - imports XLSX** - New contact data for Beauty Advisors. (***Beauty Advisors > Contacts***). This import is only available for **root** users. - **Admin user import XLSX** - Import new Administrator users (***System > Admin / list***). This import is only available for **root** users. - **Customer contact database for Consultants update** - Updating contact data for Beauty Advisors (***Beauty Advisors > Contacts***) - **Customer contact database for Consultants update (lite version)** - Updating contact data for Beauty Advisors in a simpler, faster version that contains less updateable information regarding customers (***Beauty Advisors > Contacts***). - **POS Users** - An xlsx file with Beauty Advisor data, which can be used to update their data. (***System > Admin / list***). This import is only available for **root** users. The other two import options in ***Import / export*** module require providing additional data (besides the file itself) - **Import / FIDEN2 points** - Equivalent of ***Customers > FIDEN2 / Change card balance*** but additionally allows for multiple balance changes. - **Import / discount codes** - Unique personal codes for ***Promotions > Discount codes / list***. You can learn more about this module in the [Discount codes](https://knowledge.tauceti-digital.com/books/e-commerce/page/discount-codes) article. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9575171443356.png) Export options Export options allow you to export data from e-commerce platform to your computer. They usually allow exporting of certain types of data or data in a certain date range. In **Import / Export** module there are the following exports: - **Export / SALESmanago tags** - - **Export / catalog** - Option to extract product catalog which contains the following files: - alt\_shop\_catalog\_product.csv - catalog\_product.csv - catalog\_product\_attribute.csv - catalog\_product\_description.csv - catalog\_product\_meta.csv - catalog\_product\_stock.csv - dict\_property.csv - dict\_tag.csv - dict\_tag\_catalog\_product.csv You can learn about product catalog import/export in the [Product catalog export and import](https://knowledge.tauceti-digital.com/books/e-commerce/page/product-catalog-export-and-import) article. - **Export / customers** - Exports customers data in a file: - Customers\_date\_time.csv - **Export / subscribers** - Exports customers signed to a newsletter in a file: - newsletter\_subscribers\_date\_time.csv - **Export POS users** - Exports all Points of Sale users in a file: - pos\_users\_date\_time.xlsx - **Export / Jumia** - Exports pairs (SKU and links) for Jumia (3rd party sales channel) in a file: - jumia\_links\_date\_time.csv - **Export / sales** - Exports sales in a range of chosen dates in a file: - sales\_date\_time.xlsx - **Export / FIDEN2 cards** - Exports cards for the FIDEN2 points system in a file: - fiden2\_cards\_date\_time.csv - **Export / Invoices** - Exports invoices in a range of chosen dates in a file: - invoice\_report\_date\_time.xlsx - **Export / contacts** - Exports contacts for Beauty Advisors in files: - ba\_contacts\_lite\_file\_date\_time.xlsx - ba\_contacts\_file\_date\_time.xlsx - **Export / orders** - Exports orders made by Beauty Advisors in a file: - ba\_orders\_lite\_file\_date\_time.xlsx - **Export / gift cards payment** - Exports orders made with gift cards in a file: - gift\_cards\_payments\_date\_time.xlsx ![info2.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9575171447068.png) **Remember**Part of the name in all of the files **"date\_time"** is written in the same format (f.x. Customers\_**2022\_09\_23\_133700**.csv). This date is always referring to the time of creation. --- ## Extracting data Most Export options will have additional filters to thin the results, if none of the filters is used then the whole database from this subject will be extracted. After applying filters small green window will show up with information about the file. Successful export will be reported with the title "File has been exported". The file name will be present **(1)** and the button to download the file **(2)**.
[![POWERPNT_rE6gLHIpvm.png](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/scaled-1680-/powerpnt-re6glhipvm.png)](https://ecomm-docs.tauceti-digital.com/uploads/images/gallery/2025-02/powerpnt-re6glhipvm.png)
*Visualization of the exporting file status, Import / Export module*
In case of a failed import or export user will receive an error message explaining why the error has happened. If the error message says so, or you are not sure about it please contact the Tau Ceti helpdesk regarding this error providing the error message content. In the case of catalog product import user will receive a report, which can be downloaded. In this report, there will be detailed information regarding every product that has failed to import allowing users to fix the affected .csv files and import them again in a .zip file. ![info2.svg](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/9575171447068.png) **Remember**Be advised that some reports due to a large number of records may take up to several minutes to complete extraction. Do not change the tab during the exporting process.