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 (10 partners), including "IAB Europe Trusted Partners" (2 partners). Information about the purposes of personal data processing by our partners can be found in their privacy policies.
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.
With this option, you can select the marketplace — Poland (allegro.pl), Czechia (allegro.cz), Slovakia (allegro.sk) or Hungary (allegro.hu). With that, you can read articles about rules applicable to a foreign marketplace in your default language. If you want to browse articles in a different language, click here.
Listing offers 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.
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> |
Your file and the description it contains have been coded incorrectly. See how to save the file.
The offer details you provided are incomplete:
Go to the report and complete the data we indicate.
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.
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.
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.
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].
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.
How to list offers from your file
You can post up to 10,000 offers simultaneously from your own file. The correct file should include 3 obligatory columns with data — product ID, quantity, and price.
If you have your own file, you can use it to list up to 10,000 offers at the same time. Upload a CSV file with items. We will process it automatically and list your offers. This option is only available on business accounts.
How to list offers from your file
- Go to the List from file tab.
- Select I have my own file (non-Allegro).
- Upload your CSV file.
- A file size cannot exceed 5 MB.
- A file cannot contain more than 10,000 offers.
- If you cannot upload the file, check how to solve the most probable problems.
- Go to the Reports tab and download a report. Check which offers have been listed successfully and which need to be corrected.
You can only list from your file the offers with products that are already in the Allegro Product Catalog
Use our template to create new products when listing from the file. Thanks to it, you will be sure you have provided all the information about your new products we require in the Allegro Product Catalog.
- Quantity
- Standard Price.
While processing your file, we will try to automatically recognize the obligatory columns based on their names. If we fail to do it, we will ask you to change the column names to the ones we can recognize. Upload the file again after making those changes.
Select the sales terms for offers from the file
When listing offers from a file from outside Allegro, you have to provide the same sales terms for all offers. This is why before uploading a file you should complete the following information:
- delivery price list
- dispatch time
- dispatch origin – the Dispatch from section
- invoice options
- VAT rates
- returns terms
- complaint terms
- currency.
How we convert foreign currencies
After we have processed the file, select one currency for all the prices there. We accept the following currencies: PLN, EUR, GBP, USD.
If you provide prices in a foreign currency, decide how you want us to convert them to PLN:
- based on the average exchange rate downloaded from the National Bank of Poland – we update the exchange rate every business day between 12:00 P.M. and 1:00 P.M. or
- based on your own conversion.
You can round the prices to the whole Polish zloty, as follows:
- from 0.01 PLN to 0.49 PLN – we round it down
- from 0.5 PLN to 0.99 PLN – we round it up.
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.
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.
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.
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.
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.
