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.
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.
