In the file you will find the following fields with details:

• OrderId – order ID
• SellerId – seller’s ID
• SellerLogin – seller’s username
• SellerStatus – order status set by the seller: new, processing, ready_for_shipment, canceled, or sent
• OrderDate – order date (UTC)
• BuyerId – buyer’s ID
• BuyerLogin – buyer’s username
• BuyerEmail – buyer’s email address
• BuyerCompany – buyer’s company name
• BuyerName – buyer’s first and last name
• BuyerPhone – buyer’s contact number
• BuyerAddress – buyer’s address
• BuyerZip – buyer’s postal code
• BuyerCity – buyer’s city
• BuyerCountryCode – buyer’s country code
• PaymentId – payment ID
• PaymentStatus – payment status
• PaymentProvider – payment service provider
• PaymentAmount – payment amount
• PaymentCurrency – payment currency
• DeliveryMethod – delivery option
• DeliveryAmount – delivery cost
• DeliveryCurrency – delivery payment currency
• DeliveryAddressCompanyName – company name from delivery address
• DeliveryAddressName – delivery address
• DeliveryAddressPhone – contact number from the delivery and payment form
• DeliveryAddressStreet – delivery street name
• DeliveryAddressZipCode – delivery postal code
• DeliveryAddressCity – delivery city
• DeliveryAddressCountry – delivery country
• DeliveryPickupPointId – pick-up point ID
• DeliveryPickupPointName – pick-up point name
• DeliveryPickupPointStreet – pick-up point street name
• DeliveryPickupPointZipCode – pick-up point postal code
• DeliveryPickupPointCity – pick-up point city
• InvoiceName – first and last name on the invoice
• InvoiceCompanyName – company name on the invoice
• InvoiceStreet – street name on the invoice
• InvoiceZipCode – postal code on the invoice
• InvoiceCity – city on the invoice
• InvoiceCountry – country on the invoice
• InvoiceTaxId – NIP (Tax Identification Number)
• TotalToPayAmount – total payment amount
• TotalToPayCurrency – payment amount currency
• TotalPaidAmount – total amount paid
• TotalPaidCurrency – payment currency
• SellerNotes – seller’s comments
• BuyerNotes – buyer’s comments, message to the buyer
• Smart – information whether the order is settled within Allegro Smart!
• TrackingNumbers – name of the carrier and the tracking number.

For the offer from the order:

• OrderId – order ID
• LineItemId – offer ID in the order
• OfferId – offer ID
• OfferExternalId – your own offer ID
• Name – offer title
• Quantity – the number of purchased items/units/sets
• Price – price
• Currency – currency.

If the offer was listed for charity, you will see an additional column:

• FundraisingCampaign – information about the fundraiser to which the money has been donated.

For additional services from the order:

• LineItemId – offer ID in the order
• DefinitionId – additional service ID
• Name – additional service name
• Quantity – the number of additional services
• UnitPrice – additional service price
• UnitPriceCurrency – currency
• additionalService – name of additional service.

In the summary, you will first see order details (order):

Next, the offer details in this order (lineItem):

At the end, you will find additional services for a given offer (additionalService):

If you filter the file by OrderId, you will see all the order details – including offer details and additional services, grouped by orders.

Microsoft Excel is the most popular spreadsheet ― this is why we show how to open a sales summary CSV file in this program. The process may be different for different programs.

If you have Microsoft Excel on your device, a CSV file should open in this program by default. All you have to do is download the file from your email and double-click on it. If it does not work or there are errors in the file (for example, lack of Polish characters), import the file.

How to import a CSV file

1. Download a CSV file and save it on your device.
2. Open an empty Excel spreadsheet.
3. Click Data, and next, click From text in the Get External Data section.

4. Select the file with the sales summary you want to import and click Import.

5. This opens the Text Import Wizard. In order to import the text, follow these 3 steps:

6. Step 1: select the file type Delimited. Next, determine the file origin — select 1250 : Central European (Windows). Also check the My data has headers box. Click Next.

• Step 2: select the delimiters. In the sales summary, the text is separated with commas, so select Comma, and click Next.

• Step 3: select General as a column data format. Click Finish.

6. In the Import Data window, determine where to place the date. Select Existing worksheet and click OK. Done!