Bulk product operations
Opening many products or updating price and stock via Excel template: template, upload, validation, preview, and partial sending.
The Bulk product operations screen allows you to open or update many products at once using an Excel file. The process proceeds in four steps: you download the template, upload the file, the screen validates and previews the file row by row, and finally you send the error-free rows. No product record changes until the upload is confirmed; you can filter out erroneous rows and send the rest.
Accessing the screen
- Select Vendor Panel › Items › Bulk product operations from the left menu.
- Press the Bulk operations button in the toolbar of the My Items list.
The screen opens only for accounts with product editing permission. If you do not see it in the menu, your account does not have permission for this screen.
The uploaded file, preview, and sending status are kept only on this page. If you leave or refresh the page, you need to upload the file again. Do not leave the page while sending: the sending record is written to the Uploads in this session card when sending finishes.
Screen sections
- Header: Bulk product operations and a short description; Back to my products on the right.
- Step indicator: Template, Upload, Preview & validate, Send. The current step is highlighted, completed steps appear green.
- Main area: cards for 1. Download the template, 2. Upload the file, 3. Preview & validation, and 4. Send. The preview and send cards appear after the file is validated without blocking issues; the template card hides after file validation.
- Side area: Update stock from Excel card and Uploads in this session card. On wide screens on the right, on narrow screens at the bottom.
Which path should I choose?
| Need | Path to use |
|---|---|
| Open new products or update product name, brand, description, color, and size structure | New products / product update template |
| Update price, VAT rate, and stock of existing products by SKU | Price & stock update template |
| Update only stock quantities | Update stock from Excel in the side area (file with Sku and Qty columns) |
| Edit a single product | Product creation and editing page |
1. Downloading the template
- In the 1. Download the template card, select the Template type:
- New products / product update: You must select a category; the template includes that category's attributes.
- Price & stock update: Updates price, VAT rate, and stock of existing products by SKU. This template does not open new products. No category selection.
- For New products / product update, find and select your category by typing in the Search category field. The search matches category name and full path. After selection, Selected category: … appears below. Up to 100 categories are listed at once; if more, N more categories; narrow your search. appears. If no match, No matching category; if list cannot be loaded, Categories could not be loaded.
- Press Download template. While preparing, the button shows Preparing…. The button is disabled without category selection; hovering shows Pick a category first.
Template structure
The first sheet in the Excel template is the data sheet. The Instructions sheet describes each column's name, whether it is mandatory, description, and allowed values. For attributes with allowed value lists, there is also a Values sheet.
Columns in the New products / product update template:
| Column | Mandatory | Description |
|---|---|---|
Model |
Yes | Model code. Same for all colors and sizes of the same product. |
Option |
Yes | Option (color) code. Same for all sizes of the same color. |
Sku |
Yes | SKU. Unique per variant. |
Barcode |
Yes | Barcode. Unique per variant. Cell is text format to preserve leading zeros. |
Name |
Yes | Product name (model level). |
SalePrice |
No | Sale price. Entered together with list price. |
ListPrice |
No | List (strikethrough) price. Entered together with sale price. |
VatRate |
No | VAT rate (%). Common rates: 0, 1, 10, 20. |
Brand |
Yes | Brand (model level). |
Description |
No | Product description (model level). Leave blank to keep existing description. |
Stock |
No | Stock quantity (integer). |
| Attribute columns | Per category | Category attributes (color, size, etc.). Mandatory ones come first. Header consists of attribute name and an ID after a dash; do not change these headers. |
The Price & stock update template contains only Sku (mandatory), SalePrice, ListPrice, VatRate, and Stock columns.
Mandatory columns have yellow headers; optional ones are gray. The template applies Excel validation: price and stock cannot be negative, stock must be an integer; dropdown lists appear for attributes with allowed values and VAT.
Rules to follow when filling the template (also in the Instructions sheet):
- Each row is a variant (e.g., one color and one size). Same
Modelmeans same product; sameOptionmeans same color. - Name, brand, and description must be the same in all rows of the same model. Option attributes like color must be the same in all rows with the same
Optioncode. - Sale and list prices must be entered together; if only one is filled, the row is rejected.
- Do not change column headers or the first sheet name: the category is read from the sheet name. Unknown columns are ignored.
- If you delete the
Optioncolumn, the file is processed as an update by SKU. - In price and stock update, only filled fields are updated; SKUs not found in the catalog are not sent.
2. Uploading the file
- In the 2. Upload the file card, drop your file into the Choose an Excel file or drop it here area.
- Only .xlsx files are accepted; file size max 10 MB and max 5,000 rows. For unsupported files, the card shows Only .xlsx files can be uploaded (old .xls not supported).; for large files, File exceeds 10 MB limit.
- While reading, the card shows Reading and validating the file…. No product record changes occur at this step.
If the file cannot be read, an error starting with The file could not be read appears; select the file again.
After validation, the card shows the file name and badges:
- Operation type: New / update (model tree) or Update by SKU. If the file has an
Optioncolumn, it is processed as new/update; otherwise as update by SKU. - N rows
- Category: … (if category determined)
To start over with another file, press Another file. This button is hidden while sending.
How the file is read
- Column headers are recognized case-insensitively. Stock column can be named
StockorQty. - In update by SKU, columns
Sku,Name,Brand,Description,SalePrice,ListPrice,VatRate, andStockare read.ModelandBarcodecannot be changed in this operation; these columns are marked Ignored: cannot be written in an update by SKU. - Attribute values are converted to the allowed list spelling; case differences are not errors.
- For decimals, comma or dot can be used. If both dot and comma appear, the last separator is decimal (
1.234,50). If a single separator appears once, it is decimal:12,500is twelve and a half, not twelve thousand five hundred. Avoid thousand separators for safety.
File-level issues
File-wide issues are listed under File-level issues on the card. Red issues block continuation; yellow ones are informational.
| Message | Action |
|---|---|
| Category not determined. No category marker in sheet name; select a category below. | Select a category in the Select category for this file field and press Validate with this category. |
| Category (…) in file not in your category tree. Select another category. | Similarly, select a category and revalidate the file. |
| The file has no Sku column | Prepare the file again without changing template column headers. |
| The file has no data rows | Add at least one product row to the file. |
| The file has N rows; max N rows can be uploaded. Split the file. | Split the file into parts of max 5,000 rows and upload separately. |
| Unknown columns ignored: N | Informational; these columns are not sent. |
| Attribute columns not in this category ignored: N | Informational; check that columns match the category. |
| Second column for the same field ignored: N | Only the first of two columns with the same info is read. |
| Template generated from another category tree (…) but category ID found in your tree. | Informational. |
If there is a blocking issue unrelated to category, the card shows Resolve the file-level error to continue.; fix the file and upload again with Another file.
3. Preview & validation
If there are no blocking issues, the 3. Preview & validation card opens.
Summary boxes
| Box | Meaning |
|---|---|
| Rows | Number of data rows in the file. |
| Model | Number of distinct models in the file (only for new product upload). |
| Option | Number of distinct colors/options in the file (only for new product upload). |
| Rows with errors | Rows that cannot be sent. |
| Rows with warnings | Rows that can be sent but should be checked. |
| Already in PIM | Rows with SKUs already in the catalog; these products are updated, not newly opened (only for new product upload). |
| To send | Error-free rows not excluded by you and with update info. |
Code check
As soon as the file is validated, SKUs (and barcodes for new product upload) are checked in the catalog. While checking, PIM code check: N/N appears; when finished, PIM code check completed. appears.
- In new product upload, you can skip the check with the Skip the check button. Then a warning appears: Code check skipped: products already in PIM are sent as new products (including sales opening fields). You can retry the check before sending with the Retry button.
- In update by SKU, the check cannot be skipped: Code check is mandatory in update by SKU: SKUs not in PIM are not sent. Sending is disabled until the check finishes; only SKUs verified in the catalog are sent.
- If the check is interrupted, Code check interrupted: … appears; retry with Retry.
Column mapping
Open the Column mapping section to see which file column maps to which field. The header shows … columns mapped · … columns ignored. The table shows Column in file and Mapped to; attribute columns show Attribute: …. Ignored columns show the reason in yellow, e.g. Ignored: unknown column, Ignored: second column for the same field, or Ignored: column without header.
Row table
In new product upload, rows are grouped by model and color; model and option codes appear only in the first row of each group, and each model is separated by a bold line. In update, rows appear in file order.
Table columns: Send (checkbox), Row (file row number), Model code and Option code (new product upload), SKU, Barcode (new product upload), Product name, Brand (new product upload or if brand present in file), Sale / list, VAT, Stock, attribute columns from the file, and Status.
- Problematic cells are color-coded: red for errors, yellow for warnings. Hover to see the issue.
- The Status column shows a green Predefined badge for error-free rows, or a list of issues for problematic rows.
- 100 rows are shown at once; use Show N more rows to load more.
Use the Show filter above the table to filter rows: All (N), Errors (N), Warnings (N), Excluded (N). If no rows in the selected view, No rows in this view appears.
Including and excluding rows from sending
- Uncheck the box in the Send column to exclude a row from sending. Excluded rows appear faded.
- Exclude rows with warnings removes all warning rows at once.
- Include all restores all excluded rows.
- The checkbox for error rows is disabled; hovering shows Rows with errors cannot be sent. Fix the file and upload again.
Selections cannot be changed after sending starts.
Error report
If there are error or warning rows, a Download error report button appears at the top right of the card. The downloaded Excel file lists each issue as a row: Row, SKU, Model code, Option code, Field, Level (Error / Warning), and Description. File-level issues appear at the top; informational notes are not included. You can fix your file based on this report and upload again.
Row issues
Error (row cannot be sent)
| Message | Meaning |
|---|---|
| … mandatory | A mandatory field or attribute is empty. |
| … not a number: "…" | A non-numeric value in price, VAT, or stock field. |
| … cannot be negative | Price, VAT, or stock is negative. |
| Stock must be a whole number | Stock is decimal. |
| Sale and list price must be entered together | Only one of the prices is filled. |
| VAT rate must be between 0 and 100 | VAT is greater than 100. |
| … invalid value: "…" | Attribute value not in the category's allowed list. |
| SKU repeated in file: … (row N) | Same SKU appears in multiple rows; all repeated rows are marked. |
| Barcode repeated in file: … (row N) | Same barcode appears in multiple rows (new product upload). |
| … … differs from other rows of model (first value: "…") | Name, brand, or description differs within the same model. |
| … … differs from other rows of option (first value: "…") | A color attribute differs within the same option. |
| … option code used in another model (…) | Same option code used in two different models. |
| … too many rows in model (max 500 variants, 100 options) | Limit exceeded for a single model. |
| SKU not found in PIM: the update is not sent | SKU not found in catalog during update by SKU. |
| … could not be checked in PIM | SKU could not be checked in update by SKU. |
Warning (row can be sent)
| Message | Meaning |
|---|---|
| Sale price is higher than list price | Sale price is higher than strikethrough price. |
| Unusual VAT rate: %… | Rate is not 0, 1, 10, or 20. |
| Barcode may be used by another product in PIM | SKU is new but barcode is registered in catalog. |
| … could not be checked in PIM | Code check failed in new product upload. |
| Nothing to update; the row is not sent | In update, no fields other than SKU are filled. This row is not counted in To send. |
Info
| Message | Meaning |
|---|---|
| Already in PIM: the existing product is updated | SKU is registered in catalog; product is updated, not newly opened. |
4. Sending
The 4. Send card shows a summary: N rows will be sent in N parts. If rows are registered in the catalog, below it says N rows are registered in PIM; sales opening fields are not written for these rows. If no rows to send, No rows to send. appears.
- Press Send N rows. The button is disabled if no rows to send or code check is pending; reasons appear above: in new product upload You can send once the code check finishes., in update by SKU Code check is mandatory in update by SKU: SKUs not in PIM are not sent.
- In the Confirm the upload box, it says N rows (…) will be sent to PIM in N parts. Records are queued and cannot be undone after sending.
- Press Send or Cancel to return.
Rows are sent in parts of 200 rows each, sequentially. In new product upload, a model is never split into two parts; a model larger than 200 rows is sent in its own part. While sending, Sending: part N/N and a progress bar appear; when done, …/N parts queued. appears.
If a part cannot be sent, a message like Part … (N rows) failed to send: … appears and the progress bar turns yellow. After sending finishes, you can resend only failed parts with the Resend failed parts button; successfully sent parts are not resent.
Results
If at least one part is sent, the Results section opens and polls the status every three seconds:
- While processing, PIM is processing… N operations pending. appears.
- When finished, Operation completed: N products successful, N products failed. appears.
- If not finished within about 10 minutes, PIM is taking long. You can refresh the result later from the history below. appears and polling stops.
- Operation codes: … line shows operation numbers; share these when opening support tickets.
- If no per-product results come despite completion, PIM returned no per-product results. appears.
The product-based results table includes Row, Product (SKU), Status (Successful / Failed), Description, and Operation columns. Failed products appear at the top. Download result report downloads these results as an Excel file with columns Row, SKU, Product ID, Status, Description, and Operation.
New upload clears the screen and returns to the first step. Sent operations remain in the Uploads in this session card.
Update stock from Excel
The Update stock from Excel card in the side area is for files with only Sku and Qty columns. The Upload stock file button opens the same stock upload box as in the My Items screen (.xlsx or .xls, max 10 MB). Rows are processed immediately; there is no preview step. The result shows total, successful, and failed row counts and a list of failed rows.
Uploads in this session
The Uploads in this session card in the side area lists your uploads in this browser tab, newest first (max 20). As the card says (Kept only in this tab; cleared when the tab closes.), the list is not visible in other tabs or devices. If no uploads yet, No uploads in this session yet. appears.
Each record shows file name, upload time, operation type, category, N rows · N parts info, status badge, and if known, Operation completed: N products successful, N products failed. line. Use Refresh status to update operation statuses.
| Status | Meaning |
|---|---|
| Processing | Sent operations are still being processed. |
| Completed | All products processed successfully. |
| Failed | A part failed to send, no parts queued, or some products failed. |
| Unknown | Operation status not yet retrieved. Press Refresh status. |
Common situations
- "Only .xlsx files can be uploaded" error. Save your file again in Excel as .xlsx; old .xls format is not readable here.
- My file was detected as update by SKU. Your file has no
Optioncolumn. To open new products, fill the template without deleting theOptioncolumn. - Send button is disabled. Code check may be running, or in update by SKU the check is not finished, or no error-free rows to send. Check the To send box and the check bar.
- Prices are smaller than expected. Amounts with thousand separators (e.g.
12,500) are read as decimals. Write amounts without separators or with decimal comma. - My existing products were sent as new products. If you skipped code check, products already in catalog are sent as new. It is recommended to send without skipping the check.
- Results have been pending for a long time. If sending finished, you can leave the screen; later check status with Refresh status in the Uploads in this session card in the same tab. Processed products appear in the My Items list.