You can export all your products to an Excel/CSV file, and import a file you have prepared by mapping its columns and previewing first. Import can both…

Where to find: Left menu → Catalog → Products — the Export and Import buttons at the top right of the Product List Who it's for: Anyone who wants to download products in bulk as an Excel/CSV file, or upload/update them in bulk from a file In short: You can export all your products to an Excel/CSV file, and import a file you have prepared by mapping its columns and previewing first. Import can both add new products and update existing ones.

What is this feature for?

It's a two-way transfer. Think of an Excel table: each row is a product, each column is a piece of information about it (name, price, stock...).

Export: Downloads the products in your store to your computer as a file. Useful for backups, reviewing products in bulk in Excel, or using them elsewhere.
Import: Bulk-uploads the products in a file into the panel. Instead of adding hundreds of products one by one, you can add them with a single file, and you can also update information like price/stock in bulk.

Tip — The easiest way: First download a few products with Export. You now have a sample file with the correct column headers. Edit it in Excel and upload it back with Import; the columns map themselves automatically.

Where are the buttons?

At the top right of the Product List, between Customize Columns and Add Product, there are two buttons:

Button	Icon	What does it do?
Export	(download arrow)	Opens the window for downloading products to a file.
Import	(upload arrow)	Opens the window for uploading products from a file.

On a narrow screen the button labels are hidden; only the arrow icons appear. Hover over them to see what they do.

Also, when you select one or more products from the table, the Bulk Actions (N) menu in the top bar includes an Export option too (for selecting products, see the Product List page).

Part 1 — Export (downloading products to a file)

Clicking the Export button opens the Export Products window. You make three settings: Format, Scope, Columns.

1. Format (file type)

Option	When?
Excel (XLSX)	Opens cleanly in programs like Excel and Google Sheets. Recommended for most people. (Default)
CSV	A plain-text table. Handy for transferring to other systems.

2. Scope (which products)

Option	What does it do?
All products	Exports every product in your store.
Selected (N)	Exports only the products you checked in the table. (N = the number of products you selected.)

If you open the window without selecting products, the Selected option is disabled and All products is chosen. If you select products first and then open it, Selected comes ready.

3. Columns (which information to include)

You choose which information is written to the file using checkboxes. The columns are organized into six groups. A column whose box you uncheck is not included in the file.

Group	Columns inside
Basic	Product Name (always on), Type, Status, SKU, Barcode, Combination
Price	Sale Price, List Price, Cost Price
Classification	Categories, Brand, Tags, Supplier
Stock & Size	Stock, Weight, Volumetric Weight, Width (cm), Length (cm), Height (cm), HS Code
Images	Image URL, Thumbnail URL
System	Created Date, Updated Date

A few details:

Product Name is locked; its box looks faded and cannot be turned off. Since it's hard to tell which row is which product without the name, it is always exported.
Thumbnail URL, Created Date and Updated Date start off. Check them if you need them.
Image URL and Thumbnail URL are the internet address of the product image (a CDN link). So the file contains the link to the photo, not the photo itself.

At least one column must be checked; if you turn them all off, the Export button won't work.

How do products with variants look in the file?

If a product has variants (e.g. Red-S, Blue-M), each variant becomes a separate row. On those rows:

The Type column says Variant,
The Combination column shows that variant's options (e.g. "Red - M"),
SKU, Barcode, prices and Stock show that variant's own values.

For products without variants (basic), the Type column says Basic and Combination stays empty.

Downloading the file

After making your settings, press the Export button at the bottom right.
The message "Exporting..." appears while the file is prepared.
When it's ready, the "Export ready" message and a Download file button appear. Press the button and save the file to your computer.

If you have many products, preparation may take a few seconds; wait without closing the window.

Part 2 — Import (uploading/updating products from a file)

Clicking the Import button opens the Import Products window. The process runs in four steps: Upload a file → Map the columns → Preview → Import.

Know this first: Import doesn't only add new products; depending on the settings it can also overwrite existing products. See the "Overwriting" section below. If you're not sure, first download a backup with Export.

Step 1 — Upload the file

Click the large dashed area in the window (it says "Click to select a file").
Choose a CSV or Excel (XLSX) file from your computer.
A loading icon spins briefly while the file is read, then it moves to the mapping step.

The accepted formats are shown in the window: CSV, XLSX (up to 10,000 rows). If you have more rows, split the file and import it a few times.

Step 2 — Map the columns (the most important step)

The system can't know which of the columns in your file correspond to which Treyza field. In this step you match each column to the right field. You see a table on screen:

Column	What does it show?
Source Column	The column header in your file (e.g. "Price", "Name", "Stock").
Example Value	An actual value from that column. It helps you pick the right field (e.g. which column is really the sale price).
Target Field	A dropdown where you choose which Treyza field the column is imported into.

The system auto-maps columns it recognizes. A small badge appears next to the Target Field:

Badge	Meaning
Auto (green)	The system recognized the column for certain and mapped it itself.
A percentage like 75%	The system made a guess but isn't fully sure. Check the example value and confirm.
Manual	The system couldn't recognize it; you must choose the target field.
As attribute	The column will be imported as a product attribute.

In the dropdown there are three kinds of options for each column:

Ignore: Do not import this column at all. Leave unneeded columns like this.
A Treyza field (Product Name, Sale Price, SKU, Stock, Categories...): Imports the column into that field. Required fields have a * next to them.
As attribute: Adds the column as a product attribute.

Don't assign the same field to two columns. If you map one field (e.g. SKU) to more than one column, a yellow **** warning appears next to those rows ("This field is assigned to multiple columns"). Map each field to only one column.

Import options (below the mapping table)

Below the mapping table there are a few settings. They control how the import behaves:

Setting	What is it for?	Options
Match key	Treyza uses this to tell whether a row is a new product or an existing one.	SKU (default) / Barcode / Slug
Mode	Determines what happens to products that are found and not found.	Create and update / Create only / Update only
Default status	What status should newly created products have?	Active / Inactive / Draft
Download images	Downloads the photos at the image addresses in the file and adds them to the product.	On / Off (default on)
Create missing category/brand/supplier	Automatically creates any category/brand/supplier that appears in the file but doesn't exist yet in your store.	On / Off (default on)

What does the Mode setting do?

Mode	What does it do?
Create and update	If a product from the file exists in your store it is updated; if not, it is added as new. (Default)
Create only	Only adds new products. It leaves already existing (matched) products alone and skips them.
Update only	Only updates existing products. It does not add new products from the file.

How to choose the "Match key"? If you fill in SKU on your products, leave it as is (the safest). If you track by barcode, choose Barcode. You must map the column you choose as the key (e.g. SKU); otherwise the warning "Mapping the SKU column is recommended for matching" appears at the top.

Product Name is required in most cases. In every mode except Update only, you cannot continue without mapping the Product Name column; the warning "Map the Product Name column to continue" appears at the top and the Preview button stays disabled.

After making your settings, press the Preview button at the bottom right. (At any time you can return to file selection with Back at the bottom left.)

Step 3 — Preview (nothing is saved yet)

The preview shows what will happen when your file is processed in advance — but nothing is saved to your store in this step. You see four numbers:

Box	Meaning
To create	The number of rows that will be added as new products.
To update	The number of existing products that will be overwritten.
To skip	The number of rows that won't be processed (e.g. not matching the mode).
Errors	The number of rows that can't be imported due to a problem.

If there are error rows, the first errors are listed in a red box below, in the form "Row 5: ..." (the row number is the actual row in your file). This way you can fix your file and try again.
If your file exceeds 10,000 rows, the warning "Row limit exceeded, only the first 10,000 rows will be processed" appears.

Preview first, then import. This step is your safety net: make sure the numbers are what you expect. If they're wrong, go Back to mapping and fix them.

Step 4 — Import and see the result

If the numbers in the preview look right, press the Import button at the bottom right.
A progress bar and an "Importing %..." percentage appear. The window won't close during this; wait until it finishes.
When it's done a result screen appears with four numbers:

Result	Meaning
Created	The number of newly added products.
Updated	The number of products updated (overwritten).
Skipped	The number of rows not imported.
Errors	The number of rows that couldn't be imported.

If there are errors, a Download error report button appears. This report says which row couldn't be imported and why; you can fix it and try again.
If the process fails, the message "Import failed" appears.
Close the window with the Close button; your product list refreshes automatically.

How do products with variants behave on import?

Just as in export, each variant is its own row and has its own SKU (or barcode). On import, Treyza finds each row by the Match key you chose (default SKU). So:

If a variant row's SKU already exists in your store, that variant is updated (overwritten).
If the SKU doesn't exist in your store, it is added as new depending on the mode.

That's why filling in the SKU/Barcode column correctly and completely is very important for variants; a wrong SKU can cause the wrong variant to be overwritten.

Overwriting — the thing to watch most

Import can change the information of existing products. If a row matches a product in your store via the Match key (and the mode is Create and update or Update only), that product's relevant fields are replaced with the values in the file. This cannot be undone one by one.

To stay safe:

Back up first: Before importing, download your current products with Export.
Trust the preview: If the To update number is larger than you expect, stop and review your file.
If unsure, start with "Create only": That way existing products are never touched, only new ones are added.
Choose the Match key correctly: A wrong key (e.g. repeated SKUs) can cause the wrong product to be updated.

Frequently asked questions

Which file type should I use? It doesn't matter; both CSV and Excel (XLSX) work for both import and export. If you're comfortable in Excel, XLSX is the most practical.

Can I prepare my own file from scratch? Yes, but the easiest way is to first download a sample with Export and work on top of it; the column headers map themselves.

Does import delete my existing products? No, it does not delete. It only adds or overwrites/updates (matched ones). Deleting is a separate action (see Product List).

How are images imported? The file contains the internet address (URL) of the image. During import, if Download images is on, the system downloads the photo at that address and adds it to the product.

My file has a category/brand that isn't in my store — what happens? If Create missing category/brand/supplier is on, it is created automatically. If it's off, that information may be skipped.

How many products can I import? Up to 10,000 rows per file. For more, split the file. (Note: adding new products is also subject to your plan's product quota.)

What do "error" rows mean? Those rows can't be imported due to a problem (e.g. missing required information). Using the preview and the Download error report in the result, you can see which row is wrong and why, and fix it.

Can I stop the process midway? Once the import starts, the window stays open until it finishes; wait for it to complete. If you made a wrong import, you can restore the old values from the Export backup you took beforehand.

Importing and Exporting Products