We care about your privacy
By using cookies and related technologies (e.g. pixels, SDK), as well as by processing your personal data (including unique identifiers, browser data), we can better adapt the displayed content to your needs.By giving your consent to the storage of information on your terminal equipment, and to the access and processing of data, including in the sphere of profiling as well as market and statistical analysis, you will easily find exactly what you are searching for and what you need on Allegro. The controller of your personal data will be Allegro or, in certain cases, our partners (17 partners), including "IAB Europe Trusted Partners" (9 partners). Information about the purposes of personal data processing by our partners can be found in their privacy policies.
We and our partners may process personal data for the following purposes:
Store and/or access information on a device. Personalised advertising and content, advertising and content measurement, audience research and services development. Ensure security, prevent and detect fraud, and fix errors. Deliver and present advertising and content. Save and communicate privacy choices. Match and combine data from other data sources. Link different devices. Identify devices based on information transmitted automatically.
Your personal data are also processed to make it easier for you to use our web pagesThe purposes of processing are described in detail in the settings under "CHANGE MY CONSENTS" and in the Cookie Policy.Your consent is voluntary and is valid for 12 months. You may withdraw it at any time or renew it in the Cookie settings on the home page. Withdrawal of your consent does not affect the lawfulness of processing performed before the withdrawal.
Listing offers in bulk
How to list offers using the Import and List tab
Our tool allows to list your assortment for sale quickly and easily. This option is only available on business accounts. See how to use it.
If you share with us your own file with products, we will automatically search for matching products in our Catalog. It will help you list new offers or prepare draft offers easily and quickly. You can manage them in the My Assortment tab.
How to correctly prepare a CSV file containing products
Sample CSV file
Download the template to fill in your data (CSV, 5.9 KB)
You can also use the shortened, basic format if your products are already in our Catalog:
GTIN,NAME,PRICE,STOCK,EXTERNAL_ID
1234567890123, "Sample Product ABC", 129.99,10,ABC-5432How to correctly prepare the basic CSV file with products
Technical requirements and formatting
- Format: save the updated file as CSV.
- Size: the maximum file size is 50 MB.
- Coding: make sure that the file is saved in UTF-8 encoding (it is necessary for processing Polish characters).
- Separator: use the comma (,) as a separator between the fields.
- Special characters: if a field contains a comma or a newline character, you must enclose the entire content of that field in double quotes ("). If the content of the field itself contains a quotation mark, it must be doubled ("").
- Mandatory column: GTIN.
- Optional columns: NAME, PRICE, STOCK, EXTERNAL_ID.
How to correctly prepare the extended CSV file with products
Technical requirements and formatting
- Format: save the updated file as CSV.
- Size: the maximum file size is 50 MB.
- Coding: make sure that the file is saved in UTF-8 encoding (it is necessary for processing Polish characters).
- Separator: use the comma (,) as a separator between the fields.
- Special characters: if a field contains a comma or a newline character, you must enclose the entire content of that field in double quotes ("). If the content of the field itself contains a quotation mark, it must be doubled ("").
- Column names must match the names from the table below.
According to the EU regulations specified in the AI Act, if you publish a photo generated or modified with artificial intelligence — you must inform about that. You can do that with the new column in the file: AI_COCREATED. Learn more about labeling AI-generated or modified photos.
Column description in CSV file
Column names must be placed in the first row of the file.
| Column name | Description and instruction | |
|---|---|---|
| GTIN | Description and instruction GTIN (EAN code) is a unique product number. See how to get it. |
|
| MPN | Description and instruction Manufacturer Part Number, which means the catalog number of the part. Alphanumeric code, unique to a specific manufacturer, frequently used in the automotive industry. |
|
| NAME | Description and instruction Product name displayed in the offer. Note: If the name is too long (over 75 characters), too short (under 12 characters), or contains fewer than 3 words, we will attempt to use the official name from the Allegro Catalog instead of yours. |
|
| PRICE | Description and instruction Gross price. Provide only the number (for example, 129.99 — do not provide symbols or currency abbreviations). The currency is set by default to the currency of your registration marketplace on Allegro. |
|
| STOCK | Description and instruction Number of items available (e.g., 5). Enter 0 if the product is unavailable. If this field is left blank, the system will automatically set the value to 1. |
|
| EXTERNAL_ID | Description and instruction The external product ID code that you use in your system. Providing it will make it easier to manage the offer in the future. |
|
| CATEGORY | Description and instruction The name or path of the category that you use (for example, "Clothes, men's hoodies"). This is a required element to find a matching category on Allegro. |
|
| BRAND | Description and instruction Manufacturer's name or product brand. |
|
| DESCRIPTION | Description and instruction Product description visible in the offer. You can use regular text or simple HTML. HTML requirements: Tags must be properly closed. Use simple elements (bulleted lists, paragraphs, bold text). Complex code increases the risk of errors. |
|
| IMAGES | Description and instruction A group or URLs to images separated with a vertical bar |
|
| IMAGE1 ... IMAGE16 | Description and instruction An alternative way of adding images. Each image in a separate column. IMAGE1 is the main image. Next headings are IMAGE2, IMAGE3 etc. (up to IMAGE16). |
|
| AI_COCREATED | Description and instruction List of links (URLs) to photos or graphics generated or modified using artificial intelligence, separated by a vertical bar |
|
| Other (e.g. COLOR, MEMORY) | Description and instruction Every other column in the file is treated as a product parameter. The column header is treated as the attribute name (e.g., COLOR, WEIGHT, MEMORY), and the values in the rows — as the attributes of a specific product. |
How to use column mapping
You can also use column mapping and list offers from a CSV file with custom formatting. You do not need to change column names and values according to our guidelines.
When you upload a CSV file with custom formatting:
- you will see all the columns from your file on the left-hand side
- our system will show you how these columns match our structure on the right-hand side.
If your column name:
- is consistent with ours — the system will automatically suggest you the column match
- is not consistent with ours — you can manually configure how the columns should be matched.
How to upload a file with products and list offers
- Go to the Import and List tab.
- Choose a Link or a File as the data source.
- Add a link to the file or upload the file in CSV format. See how to correctly prepare a file with products.
- Click [start import].
- We will automatically validate your file and use it to extract all available information about your products.
- After importing the file, we will display the list of imported products together with their status. You will learn which products:
- are still being checked
- can be listed immediately — they will have the to list status. If a product has the to improve status, it means that we have not yet found its equivalent in the Allegro Product Catalog.
- Here, we will show you how we completed the data in your products and offers — for example, based on the file you provided, based on the data from the Catalog, or provided by AI.
- Select chosen products from the list and click [create an offer].
- Decide whether you want to:
- list a new offer — click [list X offers]
- create a draft offer — click [create X drafts].
Drafts are working versions of your offers — they are not visible to buyers. You can find them in the My Assortment tab where you can work on them and list them once they are ready. Learn more.
- If you list an offer or create a draft, go directly to the My Assortment tab or return to the Import and List tab. Read about how to manage your offers in the My Assortment tab here.
What if we do not find your product in the Catalog
In that case, we will try to create a proposal of such a product — we will use the data from the file you provided and AI tools. You will not have to create it on your own. You can find more details in the How completing categories and parameters based on AI works section.
What product statuses mean
In the product list, you can see product statuses and use them for filtering. See what each of them means:
- changes in progress: we are updating the product, listing an offer, or creating the draft. Before you start introducing new changes, you need to wait until we finish processing the current ones.
- to list: the product is complete and you can list the offer right away.
- to add: some product information is missing. You can add it now, or create an offer draft and add is later. You can find the draft in the My Assortment tab, where you can edit and list it.
- to improve: there has been an error in the product information, and that is why you cannot list the offer or create the draft. If it is possible, correct the product.
- offer or draft offer exists: such an offer or draft already exists. You can check its status in the My Assortment tab (draft, active offer, or finished offer).
You can check the listed offers and drafts on the list, together with ID numbers. There, you can also find historic data (from the moment of creating an offer or a draft). You can check the current offer status in the My Assortment tab.
What the category mapping is and how it works
Before you start selling products on Allegro, we need to assign them a correct category. We use mapping to change your categories to ones that apply on Allegro. This is how each of your products is assigned to the right category.
When we use mapping
We use mapping only for products we have not managed to find in the Catalog. If you do not set your own mapping for them, we will try to find the right category for them using AI. Keep reading to see how you can enable mapping on your own.
You can manage your mapping in the Import settings tab — there, you can also enable and disable it for selected categories.
How category mapping works
- When you import products from your source, such as a CSV file, we will display all categories detected in your file in the Import settings tab.
- Adjust your categories to the Allegro categories and enable mapping.
We will only change categories for products without listed offers. If a given product already has an active offer or a draft, we will not change its category.
- Complete the parameters — changing the product category may require completing other parameters that are specific for that category. First, we will try to complete them automatically. However, if that is not possible, we will change the product status to: changes in progress. In that case, complete the product parameters on your own — you can do it in the listing form — for example, when creating an offer draft.
You can stop mapping for the subsequent products at any time. Products imported before the mapping stopped will remain unchanged (according to the mapping set before).
How to change the category manually
If you think that the categories assigned automatically are not correct, you can reject our suggestion and select the category yourself. To do that:
- for a single product — click the menu icon (three dots) next to a given product and select: Set category
- for multiple products (in bulk) — select products on the list. Click [set category] on the lower bar.
When you can change the product category
You cannot always change the assigned category for each product. It depends on the product's current status. Keep reading to learn when you can change the category.
| Product status (color) | Category change possible (yes/no) | Notes |
|---|---|---|
| changes in progress (grey) | Category change possible (yes/no) In certain cases |
Notes You can change the category if the product has been imported. |
| to improve (red) | Category change possible (yes/no) Yes |
Notes You can select a new category. |
| to add (yellow) | Category change possible (yes/no) Yes |
Notes It is possible, as long as the product does not have an assigned product from the Allegro Product Catalog. |
| to list (green) | Category change possible (yes/no) Yes |
Notes It is possible, as long as the product does not have an assigned product from the Allegro Product Catalog. |
| offer or draft offer exists (blue) | Category change possible (yes/no) No |
Notes You cannot edit categories or add changes in the Import and list tab. Go to the My Assortment tab to check the offer created based on this product. |
We will display all information about the ongoing and completed changes in categories over the list of products — in the Actions on products section.
How to add the GPSR data to multiple products at the same time
If you want to bulk edit the GPSR data, check the selected products on the list. Next, go to the lower bar and click [set GPSR].
With this option, you can:
- select a manufacturer from the list or add a new one via link
- enter safety information as plain text.
How completing categories and parameters based on AI works
In the Import and list tab, we use AI mostly to suggest categories and parameter values.
How we suggest data
- Category matching: if we cannot find matches for your products in the Catalog after they have been imported, our AI-based tools will try to suggest and assign the appropriate category to them. This is essential for us to add the product to the Catalog.
- Parameter completion: if a category is found for your imported products, our AI-powered tools will then try to match the appropriate parameters based on the source data, such as the description.
- GPSR data: we will complete the manufacturer's and security data, as long as we find them for a particular product category and brand.
As a result, your product can be ready for listing faster, despite any previously missing information in the source data.
While our systems are searching for suggestions, the product will have the status: changes in progress. All fields filled in by our AI-powered tools will be marked with a special three-star icon.
As a seller, you are responsible for the accuracy of your data. Therefore, always verify information filled in by artificial intelligence. You can edit that data in the My Assortment tab. Allegro is not responsible for the accuracy or use of this data.
What to do if a product does not have complete data, but you want to list it
In that case, we will create an offer draft out of it.
Drafts are temporary versions of your offers — they are not visible to buyers. You can find them in the My Assortment tab, where you can work on them and list only when they are ready. Learn more.
How to manage offers in the My Assortment tab
You can continue working on created offers or drafts in the My Assortment tab. There, you can see a message informing that we are displaying offers created from a file uploaded in the Import and List tab.
Before we list the offers, we make sure they are complete and error-free. If everything looks good, we will activate the offers, so that buyers can make purchases in them.
If there is something missing or an error appears in the offers, we will create drafts. They will not be visible to the buyers until you correct them and activate them by yourself.
The offers which we list will have the active status. They will be visible to buyers. To check how your active offer looks to the buyers, click on its title.
The offers, which we have not listed yet, will have the draft status. Next to the status you will see the Fill in the gaps option. Select it and we will display Offer status details — information about the conditions which have to be completed before you attempt to list the offer again.
How to complete the missing information in the offers in bulk
- Use filters in the My Assortment tab — for example, Price missing.
- Select the desired offers and choose Sales Policy on the green bar.
- Go to the option you are interested in — for example, Price.
- Provide the appropriate value and click [save]. Done!
If there are other values missing in the offer, you can check them in the Offer status details.
How to update offers in bulk
- Go to the My Assortment tab.
- Select the offers you want to activate.
- On the bulk offer management bar, select Availability, then List or relist, and confirm changes. Done!
Now, you can manage your offers in the My Assortment tab. Use it to check and edit your products. It offers many options that make selling on Allegro easier. Check what else you can do in the My Assortment tab.
Share your opinion
We want to know what you think about this solution. In the Import and List tab we display a short questionnaire. Let us know what you enjoy and what we should improve. It will help us to better adapt the tool to the sellers' needs and further develop it.
How to list offers from a CSV file in bulk with the Allegro template
With the CSV file, you can list up to 10,000 offers simultaneously. It will be easier with our template — you only need to fill it in with the necessary details.
Check how to do it step by step
How to download the template file
- Open the List from file tab.
- Choose the option Create Allegro file.
- Use the search engine — enter the product name or code and we will show you the categories you can list your offers in. Select one or more categories and click [download template].
How to complete the template file
You will see 2 tabs with spreadsheets in the downloaded file. They are displayed at the bottom of your file:
- How to use this file — in that spreadsheet, we have provided detailed instructions on how to complete the template.
- Template — there, you complete all the details of the offers you want to list. Each offer is one separate row.
- Go to the tab with the Template spreadsheet.
- First, complete the Main category and the Subcategory in each row with a product. On that basis, we will determine:
- obligatory cells (outlined in red) — you have to complete them to list an offer
- optional cells (outlined in grey) — you do not need to complete them, although it is recommended. This way you may help the buyers decide about the purchase.
- cells to be skipped (with grey background) — leave them empty.
- Complete the remaining details, except for:
- Offer title
- Images
- Product parameters (do not complete any column under that header).
If the product exists in our Product Catalog, we will automatically complete those details while listing the offer. If the product does not exist in our Product Catalog, we will ask you to provide additional details in the final report.
- Make sure you are in the Template spreadsheet and save the file as CSV. Check how to do that.
What you should know before saving the file
Value lists
In some cells, you can select values from a drop-down list. Additionally, if at the bottom of the list, there is the Type own value option, you can enter the value from outside the list.
Multiple values for one parameter
If you want to type more than one value for a given parameter, separate the values with | without spaces.
Product ID (EAN/UPC/ISBN/ISSN/Allegro Product ID)
The product ID is any Global Trade Item Number (for example EAN, UPC, ISBN, ISSN) or Allegro product ID.
Offer description
You can add your own offer description — unformatted or formatted in JSON or HTML. If you do so, we will display your description in your offer instead of our default description from the Allegro Product Catalog. Learn how to create an offer description formatted in HTML or JSON. Sections are available only in JSON.
Additional images
You can add your own item images (for example, showing a replacement packaging) in the Images column.
- You have to provide the URL of each image. In order to do so, upload images onto a server or a website.
- You can add up to 16 images if you hold a business account, and up to 10 images if you hold a regular account. Separate URLs with | without spaces.
- The URL you add first will be your main image of your offer. The buyers will see it in an offer list.
- Additional images will be visible along with images from our Product Catalog.
Check how to complete other required offer details
Signature (seller’s SKU) — your own ID (for example, a product code). We display signatures in the My assortment tab.
Number of units — the number of items available for sale.
Market — divided into the Pricing Rule and Price columns. There, you can enter the offer price in the currency of your registration marketplace and in foreign currencies. Thanks to that, it will be easier for you to share your offers in foreign marketplaces — for example, with the price in CZK on allegro.cz or HUF on allegro.hu — if they meet the other conditions.
The price in the currency of the registration marketplace is obligatory. That is why, if allegro.pl is your registration marketplace, complete the PL price field.
In the Pricing Rule field, select one of the following options:
- manual or
- automatic.
If you select the manual option — you will enter the price in a given currency in the adjacent field.
Example: You list an offer in the Czech marketplace. You additionally complete the details in the Allegro.cz market (CZK) column. In the Pricing rule (CZ) field, you select manual. In the CZ price field, you enter the price in CZK: 5,000.
If you select the automatic option — we will recalculate the price using the Price converter. pricing rule. In that case, you do not enter the price yourself. The field in the Price column will be grayed out.
If you have a Professional or Expert Subscription, we can recalculate the prices automatically after exchange rate fluctuations. Check how the Automatic Price Converter works.
In the column with your registration marketplace, you can decide to enter the price manually — that means, if your registration marketplace is allegro.pl, in the Pricing Rule (PL) field, you select the manual option and enter the price yourself.
Offer title — a name of an item you sell, visible to the buyers. Note: if a product already exists in our Product Catalog, we will download the details from there.
Shipping price list — you can find your price lists in the Delivery settings tab. If you add a new price list after generating this file, provide the name of a new price list or generate the file again.
Dispatch time — time between a purchase and handing the parcel over to a carrier. Do not count in the time needed to deliver a parcel.
Country — a country from which you dispatch parcels to buyers.
Voivodeship — a voivodeship from which you dispatch parcels to buyers.
Postal code — a postal code of a place from which you dispatch parcels to buyers. For Polish locations, provide the code in the XX-XXX format.
Invoice options — inform buyers whether you can issue an invoice for a given offer. If yes, select an invoice type.
Tax parameters — complete the Offer Subject field if your offer is subject to the VAT e-Commerce Package, so that we can properly classify your transactions for the VAT purposes. Choose a VAT rate if your delivery can be subject to the VAT e-Commerce Package. Complete the Base of VAT exemption if the item you sell in your offer is exempt from the VAT e-Commerce Package.
Returns terms — a list of returns terms set in the Returns terms tab. If you add new returns terms after generating this file, provide their names or generate the file again.
Complaints terms — a list of complaints terms set in the Complaints terms tab. If you add new complaints terms after generating this file, provide their names or generate the file again.
Warranty information — a list of warranty information set in the Warranty Information tab. If you add new warranty information after generating this file, provide its name or generate the file again.
Offer duration
The offer you list from a file will be available until you sell all the units. You cannot list it for a specified period (for example, for 3 days). What is more, in the file you cannot set the offer to relist automatically when the products are sold out. However, after you list an offer, you can enable its automatic relisting in the My Assortment tab.
How to upload the file and check the listing report
- Go back to the List from file tab and select I have the Allegro file.
- Place the completed CSV file in the Load your file section.
- The file cannot exceed 5 MB.
- The file cannot contain more than 10,000 offers.
- If you cannot upload the file, check how to solve the most probable problems.
- Select whether you want to:
- list only the offers for which we find a matching product in the Allegro Product Catalog — you can check the remaining offers and correct them in the report. You will get the report once we process the file.
- list all the offers and automatically create new products in the Allegro Product Catalog — to link with the offers for which we do not find an existing product. That way, you can create several products at once — it may affect your monthly limit of 20,000 new products.
- When you upload the completed file, go to the Reports tab at the top of the website.
- You will find the latest report at the top of the list. In the status column, you will check if the report needs any corrections.
- Download the report and check which offers were not listed and why. Read the hints and correct the errors directly in the report. You can save it as a CSV file and send it again the same way.
Check the most probable errors in listing offers from a file and how to correct them in the report.
You can use the report to edit the listed offers
To do it, in the row with the offer you want to edit, select the Edit option in the Action column, and enter new details. Learn more about editing offers from a file in bulk.
I have a problem with listing offers from a file. What should I do?
When listing offers in bulk, you can come across errors during file uploading and processing. Check the most frequently occurring error messages and how to tackle them.
When you list an offer from a file, you may see error messages during its uploading and processing. See what the most frequent errors mean and how to correct your file.
Errors during the file uploading
| Error message | What you can do |
|---|---|
| Wrong file format. Upload the template in CSV format (Comma Separated Values). | What you can do |
| Invalid file encoding. Save the file in UTF-8 or Windows-1250 format. | What you can do To correct the file coding, follow those instructions. |
| All rows in the file contain "No Action" in the "Action" column. Select at least one "Edit" or "Add" action to process the file. | What you can do When you edit the offer listing report, you can decide whether you want to list, edit, or skip each of your offers. Selecting No Action produces the same results as deleting a row with the offer. In your file, all the offers have been skipped. Go back to your report file and check which offers you want to list or edit. Then, change their status from No Action to List or Edit. |
| We did not find any products in the Allegro Product Catalog. Use the Allegro template to list offers. | What you can do Open the List from file tab and click Create Allegro file. With our template, you can list your offers even if we do not find them in the Allegro Product Catalog. |
Errors during the file processing
Click the error message to see the suggested solution.
Invalid HTML subset / Invalid tag: [..], allowed tags: [..]
You are trying to list the offer with description in HTML format that is wrong or not supported by us.
In the description, you can only use the following HTML tags:
- <h1>…</h1>
- <h2>…</h2>
- <p>…</p>
- <ul>…</ul>
- <ol>…</ol>
- <li>…</li>
- <b>…</b>
If you want to use two or more tags for the same description part:
- use only the permitted tags sequences
- close tags in reverse order of opening them.
Example
| Valid | Invalid |
|---|---|
| </b></h1> | Invalid <h1><b> |
File contains invalid characters in the offer description.
Your file and the description it contains have been coded incorrectly. See how to save the file.
Product not found for the given ID. The data necessary to create the offer and new product was not provided.
The offer details you provided are incomplete:
Go to the report and complete the data we indicate.
The indicated category `{0}` ({1}) does not match the product category: `{2}` ({3}).
The category in which you want to list your offer and the product category have to be the same. You can check the product category in the report.
Multiple Products Found Exception
Sometimes the EAN matches more than one product. Then, we do not know which product you want to list. In that case, enter the unique Allegro ID instead of the EAN:
- Go to the product search engine.
- Enter the EAN in the search field and click [search].
- Select the proper product and copy its ID.
- Download report. Paste the ID instead of the EAN.
Missing mandatory parameters:[...]
When processing your file, we aim to catalog all the offers you have provided — to link them to a product you sell. That error means we cannot do it with at least one of your offers, because their details are incomplete.
Download report and complete the details we indicate.
The given value for parameter {0} ({1}) is not in the dictionary.
Some of the parameters, like brand or material, contain a list of allowed values — you can select one or several of them. If you enter a value different from the ones provided, we do not list your offer.
Download report and click the cell with the parameter you want to correct. We will display a new window with the list of all the allowed values. Select one or several of them and click [ok].
Enter the correct product data or use the ID of the matching product from the Allegro Products Catalog.
It means that:
- based on the offer details you have provided, we could not find the matching product in the Catalog and
- you selected the recommended List only those offers for which we find a matching product in the Allegro Catalog option when uploading the file.
Check if the details you have entered are complete. If all the details are correct, let us know that you want to create a new product.
To do that, upload the file again and mark List all offers from the file. We will then create new products and link them to the offers for which we cannot find an existing product. That way, you can create several products at once — it may affect your monthly limit of 20,000 new products.
What spreadsheet software to use and how to save CSV files when listing and editing offers from a file in bulk
Check which spreadsheets are the best to use to list and edit up to 10,000 offers from a file.
What spreadsheet software to use
If you want to fully use all spreadsheet's functions, select Microsoft Excel while listing and editing offers from a file — make sure that you are using MS Excel 2010 or newer.
Other programs you can use to process spreadsheets are, for example:
- LibreOffice Calc
- WPS Office Spreadsheets.
How to save files as CSV
Choose a spreadsheet software you use and check how to save files as CSV correctly. This way you will be able to list and edit up to 10,000 offers from a file.
Microsoft Excel for Windows
While saving a file, select the type CSV (Comma delimited).
To make sure that your document will be saved correctly, while saving, click Tools and then, Web Options.
Go to the Encoding tab. From the drop down menu select Unicode (UTF-8). Click [ok] to save the changes.
If you use Polish characters in the file name and do not use the Polish version of Windows – change the language settings first. This is how to do it:
- Go to Settings, select Language, and next Administrative language settings.
- In the Administrative tab click [Change system locale].
- Select Polish from the list. Click [ok].
How to edit offers in bulk with a CSV file
The Edit offers tab allows you to edit up to 10,000 offers at once. To do that, download the report with the details of offers and edit the file.
If you want to edit multiple offers at once, you can download the file that you will easily edit with our template. You can use the template if you have a business account. That way, you can edit, for example, price, description, images, delivery price list, or number of units. You can also enter the offer price in foreign currencies — for example, in CZK on allegro.cz or HUF on allegro.hu.
You cannot edit:
- the product ID
- the category or subcategory
- some of the product parameters.
How to edit offers from a file in bulk
- Open the Edit offers tab in the List from file section.
- Download one of the following files:
- file with your offers — if you want to edit all your offers or the ones from a specific category
- offer listing report — if you want to edit offers that were listed from a file.
Learn more about the file with offers
When you download the file with offers, you can decide which offers you want to include there. For example, you can decide to download only the details of active offers or the ones from specific categories.
In the file, you will not find auctions, classifieds, or offers only for business customers. You will not download the file with offers if you:
- select more than 10,000 offers
- select filters with no matching offers.
On allegro.pl, you can also download the file with offers directly from the My Assortment tab. You just need to click Download a file with offers at the bottom of the page, under your list of offers.
- Open the downloaded file and go to the Template spreadsheet. There, you will see two extra columns:
- Action — you will decide how we should change the offer from the given row
- Offer status — you will check if the offer is active or expired.
- Edit the details you want to change in the rows with proper offers.
- In the
- Action column — select one of the following options next to each offer
- list
- edit all — select this option if you want us to update all the details from the offer in the given row
- edit without changing the quantity — select this option when you do not want to change the number of units in the offer from the given row
- skip — select this option if you do not want to edit the offer from the given row.
- Offer status column — click Ended next to the offers you want to end.
Next, follow the same steps as when listing offers from a file in bulk:
- Check if you have completed the file correctly.
- Save the Template spreadsheet in CSV format.
- Go back to the Edit offers tab in the List from file section and upload the file.
- Click [send file]. Done!
In the Reports tab, you can check how many offers we have updated, and how many require correction. Download the report and check which offers were not edited and why. Read the hints and correct the errors directly in the report. You can save it as a CSV file and send it again the same way.
What to remember when editing the offer
- The fields you cannot edit are grayed out in the file.
- We have split the parameters in the template into two extra columns:
- Basic details — the offer details you can edit, for example, price, description, number of units, price list, or returns and warranty terms
- Product parameters — the parameters used to describe a product, for instance, the EAN. You cannot edit them.
- If you list product sets, in the report you will only see the main product details. You will not change the Number of products in the set parameter. In the file, we do not distinguish the offers that constitute product sets.
Check the most frequent errors and how to correct them in the report.
appearance: light theme
