Skip to main content

Old: Statistics

No new features planned for this module

The statistics module described on this page will not be developed further. This means that no new functionalities will be added in the future. To process your business data, you can already use the newly introduced dashboard. The dashboard is part of the plentyBI module and provides you with even more flexibility for evaluating your statistics.

The plentymarkets statistics module allows you to keep track of everything that is happening in your organisation and more importantly to analyse revenue based on your different sales channels. Use filters to adjust the analysis to your needs. You can show the data either as a chart or listed in tables.

Statistics are grouped in tabs. You can create up to 4 statistics per tab. These tabs help you to group and sort your statistics. The name of these tabs should reflect the statistics grouped in this section.

Do not close the statistics tab

When you click on the tab’s X, the tab is deleted, not closed.

1. Getting to know the statistic types

This chapter provides an overview and a short description of the statistics available in plentymarkets. The statistics are created based on the data available in your plentymarkets system. The filters allow you to create very specific individual statistics. For example, you can create statistics for individual markets by selecting the relevant order referrers.

Opening the Statistics menu

Go to plentymarkets logo (Start) » Statistics to open the Statistics menu. Alternatively, click on the Statistics button in the plentymarkets title bar.

1.1. General statistics: Revenue

Revenue statistics provide an overview of the most important key values of your online store and allow not only to run helpful default statistics but also to configure a number of individual statistics to show the specific revenue data you need to optimise your business.

Table 1. Types of Revenue statistics
Type of statistic Explanation

Total revenue development

Shows the number of orders and the revenue for the selected period.
Returns and credit notes are not included in the number of orders. The number of returned items from item bundles will be analysed. However, the corresponding revenue will not. This statistic shows when a few orders generated a large amount of revenue or many orders generated only a small amount of revenue.

Returns/credit notes/cancellations

Shows the monetary amounts of returns, credit notes and cancellations for the selected period. This analysis helps you to monitor returned items. Use the Reasons for return statistic to correlate reasons for return statistic e.g. to referrers.

Revenue by item group

Shows the revenue by item groups of orders for the selected period and order statuses. Different filters allow you analysing based on specific item groups, e.g. by filtering by flags.

Revenue by referrer per item

Shows the revenue by item groups of orders for the selected period and order statuses. The statistic shows which order referrers were profitable and which referrers generated little or no revenue.

Revenue by referrer per order

Shows the revenue by order referrer of orders for the selected period and order statuses. The statistic shows which order referrers were profitable and which referrers generated little or no revenue.

Revenue by sales representative

Shows the gross revenue and the number of orders per sales representative for the selected period.

Revenue by manufacturer

Shows the gross revenue and the number of items sold per manufacturer for the selected period. The statistic shows revenue by manufacturer and the ratio of item quantities to revenue.

Revenue by category

Shows the gross revenue and the number of items sold per category for the selected period. The statistic shows the revenue distribution according to categories and also the efficiency of categories when it comes to the revenue they generate.

Revenue by country of delivery

Shows the revenue per country of delivery for the selected period. The statistic shows the countries of delivery that generated the most revenue, i.e. the most lucrative countries of delivery.

Revenue by shipping region

Shows the revenue per shipping region for the selected period. The statistic allows you to analyse which shipping regions are particularly profitable.

Revenue by payment method

Shows the gross revenue and the number of orders per payment method for the selected period. The statistic shows the payment methods that generated the most revenue, i.e. the most popular payment methods.

Shipping costs generated per shipping service provider

Shows the shipping costs by shipping service provider for the selected period. The statistics is based on the date of outgoing items.

Shopping cart development

Shows the average shopping cart value and the average shipping costs for the selected period. The statistic provides an overview of shopping carts' development month by month. This allows you e.g. to check if high shipping costs often prevent customers from going through with buying the items they placed in the shopping cart.

1.2. General statistics: Processes

The process statistics provide data for order processing activities, e.g. processing times, status changes and dunning.

Table 2. Types of Processes statistics
Type of statistic Explanation

Order processing times

Shows whether the majority of the order processing time was used in reaching the status paid or the status shipped. You will also see the percentage of total processing time that was needed. In addition, it helps you to determine if there is any need for corrective measures due to disproportionately long processing times.

Pending amount by payment method

Shows the total pending amount and dunning level per payment method for the selected order statuses. The statistic shows the payment methods with the largest pending amounts and the highest dunning levels.

Status of the current orders

Shows the number of orders and the revenue for the order status. The status Shipped only includes orders from the current day. The statistic offers an overview of how orders are distributed across the different order statuses. For example, it allows you to see the number of unpaid orders at a glance.

Shipping orders by shipping service provider

Shows the number of shipping orders by shipping service provider for the selected period. The statistics is based on the date of outgoing items. The statistic shows how shipping orders are distributed across the different shipping service providers.

1.3. General statistics: Orders

Use the order statistics to analyse your order data. For example, you can gain insights into the most common reasons why customers return items.

Table 3. Types of Orders statistics
Type of statistic Explanation

Order items

The order parameters and a variety of information about the revenue will be shown in a data table for the selected period. The statistic shows how revenue data of orders is composed. Tables allow you to compare amounts directly.

Reasons for return

Shows the number of returns and the revenue from returns for the selected period. Returns are shown sorted by reason for return. The statistic shows the number of returns and how much revenue was lost due to returns in the selected period. Furthermore, you can determine how the number of returns and the corresponding amounts are distributed among the different reasons for returns. The statistic allows you to monitor refunds and returns. By filtering by referrer, you can spot recurring reasons for return for specific referrers.

Sent email templates

Shows the ID and name of the email templates and the number of emails sent for the selected period. The statistic shows which email templates were used in the selected period. This can help you to determine which processes are frequent and which do not occur very often.

1.4. General statistics: Items

The item statistics allow you to analyse item data as a whole or filter them based on specific criteria such as flags, categories or referrers.

Table 4. Types of Items statistics
Type of statistic Explanation

Sold quantities / returns

Shows the number of items sold and the number of returns and the revenue for the selected period. All items are shown, i.e. including those items without returns. The return rate shows you the relationship between how many times an item was sold and how many times it was returned.

Tops / Flops

Shows the top items, i.e. those sold most often, and/or the flops, i.e. the least sold variations for the selected period. The variations are shown in descending order. This list will end with whichever top variation was sold the least often. The list of flops begins with the variation that was sold the least often and progresses with variations that were sold more and more often.
You can only analyse and export data for a period of 6 months.
This statistic takes sold quantities into consideration when calculating basic items from item bundles. However, the purchase price and the revenue are not taken into consideration. The statistic shows which items are not lucrative. For example, you may notice that the warehouse and operating costs of an item are higher than the profit.

Sold item quantities

Shows items in sales ranges based on the number of items sold for the selected period. Furthermore, the total number of sold items and the percentage of total revenue is displayed for each sales range. The statistic shows how many items were sold in each sales range and what percentage of the revenue each sales range generated.

1.5. General statistics: Warehouse

The warehouse statistics not only provide data regarding sold quantities and associated revenue but also allow you to analyse the value of one or more warehouse based on different criteria.

Table 5. Types of Warehouse statistics
Type of statistic Explanation

Current stock

Shows the value of items per category and the stock by warehouse. The statistic shows the available and reserved stock and stock values in each or all warehouses.

Estimated stock turnover and reorder levels

Shows the stock turnover of items sorted into categories according to their stock turnover in days. It also shows how many items were sold in one category during the selected period. This data is used to calculate the stock turnover in days and group the data into categories. The statistic shows whether there are items that only have enough stock to last a few more days.

Stock

Shows the value of items per variation and the stock per warehouse. The statistic shows the available and reserved stock and stock values for variations in each or all warehouses.

Incoming items by date

Shows the number of items and the value of incoming items by date. The statistic shows the values of incoming items and the item quantity per supplier per warehouse for the selected period.

Incoming items by supplier

Shows the number of items and the net value of items by warehouse and supplier. The statistic shows all values of incoming items and the item quantity per supplier for the selected warehouses.

Item revenue

Shows an analysis of the value of items by warehouse, order referrer, payment method and shipping profile for the selected period. The statistic shows how revenue data is composed.

Value of items

Shows an analysis of the value of items by warehouse, price and supplier for the selected period. The statistic shows the value of items and the quantity by warehouse.

Value of items by supplier

Shows the number of items and the net value of items by supplier for the selected period and warehouse. The statistic shows the value of items and the quantity by supplier.

Customs list for outgoing items

Shows an analysis of your outgoing items based on when the orders were received and the selected order type for the selected period. The statistic provides you with a variety of information about your orders and customers, which you can use for customs forms or for other purposes.

1.6. General statistics: Customer

Customer statistics provide insights into the profitability and shopping habits of your customers.

Table 6. Types of Customer statistics
Type of statistic Explanation

Consumer behaviour

Shows how many customers (grouped by order quantity) generated a certain amount of revenue. For example, you can see which customers generate the most revenue: those who rarely purchase in your store or those who make purchases regularly. The order quantities apply per customer. As such, e.g. the quantity <3 means that the customers shown have generated less than 3 orders per customer.

Top / Flop customers

Shows the revenue data sorted by customers who generated the most revenue and those who generated the least revenue in the selected period. The customers will be listed in descending order. Thus, the list will begin with the customer who generated the most or least revenue. The statistic shows which customers generate a lot or very little revenue, which will help you to analyse their purchase behaviour and target your promotional activities.

Revenue by customer class / feedback

Shows revenues and orders by customer class for the selected period and the selected order status. The statistic shows which customer classes are particularly profitable.

1.7. General statistics: Tickets

The ticket statistics help you analyse tickets by status and system state.

Table 7. Types of Tickets statistics
Type of statistic Explanation

Tickets by current status

Analyses tickets by current status at the time when the statistic was created. The tickets are grouped by the types and statuses selected. A tooltip displays the number of tickets as a percentage of all the displayed tickets. The statistic shows the number of tickets of a type in a particular system state.

Tickets by status

Displays the tickets based on status and ticket type for the selected period. The statistic shows the number of tickets of a type in a particular system state.

Tickets by system state

Displays the tickets based on system state and ticket type for the selected period. The system state is assigned to a ticket automatically and cannot be changed.

1.8. Item statistics

To analyse individual items statistically, go to Item » Edit item » Open item and create a statistic in the Statistics tab of an item. Once you create and save a statistic in an item’s Statistics tab, this statistic is shown in the Statistics tab of all other items as well. In contrast to the general item statistics, the statistics of an item’s Statistics tab show data for individual items.

Table 8. Statistic types in the Statistics tab of an item
Type of statistic Explanation

Returns

Shows the monetary amounts of returns by reason for return for the selected period. The statistic shows the number of returns and the revenues affected by returns. Furthermore, you can determine how the number of returns and the corresponding amounts are distributed among the different reasons for returns. This helps you to monitor returns.

Revenue by date

Shows the item revenues (e.g. gross or net revenue) for the selected period.

Revenue by referrer

Shows the order revenues by the referrer shown for the selected period.

Revenue by country of delivery

Shows the order revenues by country of delivery for the selected period.

Revenue by client (store)

Shows the item revenues (e.g. gross or net revenue) by online store and/or client (store) for the selected period.

Revenue by item variation

Shows the revenue per variation of the item, e.g. gross revenue or contribution margin. The statistic shows which item variations are lucrative and which are not. For example, you may notice that the warehouse and operating costs of an item are too high and negatively influence the profit.

Stock

Shows the current stock by variation. Shows the value and the number of items of the available stock and of the reserved stock. It also shows several other stock parameters. The statistic shows the available and reserved stock and stock values per variation in each or all warehouses.

Incoming items by date

This statistic shows the incoming items by date within the selected time span. The data is displayed for the warehouse(s) and supplier(s) that were chosen. The statistic shows the value of items and the quantity by supplier. In addition, the value totals are shown by date in a line chart, e.g. the item quantity and the value of items per month.

Incoming items by supplier

Analysis of incoming items by warehouse and supplier in the selected period. The statistic shows the value and quantity of items per supplier for the entire period selected.

Value of items

Shows an analysis of the value of items by warehouse, price and supplier for the selected period. The statistic shows the value of items and the quantity by warehouse.

Value of items by supplier

Analysis of the value of items and the number of items by warehouse and supplier. Shows the number of items and the net value of items by supplier for the selected warehouses. The statistic shows the value of items and the quantity by supplier.

1.9. Customer statistics

To statistically analyse individual customers, use the CRM » Contacts » Open contact menu. The tabs and statistics types correspond to those the statistics menu. Once you create and save a statistic in an customer’s Statistics tab, this statistic is shown in the Statistics tab of all other customers as well. In contrast to the general customer statistics, these statistics show data for individual customers.

Table 9. Statistic types in the Statistics tab of a customer
Type of statistic Explanation

Total revenue

Shows the number of orders and the revenue for a specific customer and the selected period.

Revenue by referrer

Shows how much revenue was generated by each order referrer. Furthermore, it shows which percentage of the total revenue each referrer generated. The statistic shows how much revenue the customer generated with each referrer.

Revenue by category

Shows revenue per category and the number of items purchased by the customer by date. The statistic shows how much revenue the customer generated in each of the different categories. If you change the time span, then you can also see how much revenue the customer generated in the different categories during a specific period of time.

1.10. Visitor statistics/Webalizer

In addition to the statistics for analysing your business data, plentymarkets also offers a tool for analysing visitor numbers for your online store. The different areas of the Webalizer provide you with information about visits to your online store, e.g. the number or percentage of total hits and the number of hits within a specific category. Go to Setup » Client » Settings » Statistics to access the visitor statistics.

Opening the visitor statistics:

  1. Go to Setup » Client » Settings » Statistics.
    → The login details are shown.

  2. Click on Open Webalizer statistics.
    → The Authentication Required window opens.

  3. Enter the login details into the fields User Name and Password.

  4. Click on Login.
    The statistics opens in a new browser tab.

  5. Click on the desired month to see a detailed analysis for this period.

2. Managing statistics

2.1. Creating a statistic

Statistics are grouped in tabs in the plentymarkets logo (Start) » Statistics menu. You can create up to 4 statistics per tab. Note that clicking on the tab’s X deletes the tab instead of just closing it.

Proceed as described below to create a statistic. Table 10 shows the available options in the tab view.

Creating a statistic:

  1. Go to plentymarkets logo (Start) » Statistics.

  2. Create a new tab or make sure that you have opened the correct tab that has been created before.

  3. Click on Add () on one of the four tab fields.
    → The New statistic window opens.

  4. Select a statistics type.

  5. Save () the settings.
    → The statistic is created using the default settings.
    Tip: Table 10 explains the statistics views.

Table 10. Statistics view
Option Explanation

Name

The statistic’s display name is shown in the top left corner of the title bar.

Period

The period considered in the statistic is shown in the statistic’s title bar.

Click to update the chart with the current data.

Click to edit the statistic.

Zoom

Opens the statistic in a new window. Enlarge the window by dragging the bottom right corner. The window’s size is saved.
Tip: Left-click on the mouse and drag along a section of the column line combination chart to zoom in. Click on Show all to end zooming and show the entire statistic.

Totals

In table views, totals are displayed underneath the rows. There, you will see the column’s total value as well as the column’s average value.
Note: If the data table spans several pages, the totals are calculated for the entire table and not for the page currently visible.

Mouseover info

Click on an area to show additional information.

2.2. Modifying statistics

Default values are preset when a statistic is created. Modify the default values for the analysis to reflect your specific needs.

Tip: Error message “No data avaiable”?

Not all order referrers are shown for all statistics by default. If no data is shown for a statistic, click on Edit () and select a longer period or additional referrers.

Modifying statistics:

  1. Go to plentymarkets logo (Start) » Statistics.

  2. Select a Tab.

  3. Click on Edit () for the statistic that you want to modify.
    → The statistic settings are shown.

  4. Carry out the settings. Table 11 explains the most important settings.

  5. Save () the settings.
    → The statistic data is updated.

Table 11. Modifying a statistic
Setting Explanation

Chart view

Type of chart

Select how the values should be displayed. Values can be grouped in tables or in different types of charts.

Export

Click to export the statistic data to a CSV file. The statistics export only contains the values shown in the chart type Data table.

Raw data export

Click to export the raw data to a CSV file. The raw data export contains the data pool on which the values shown in the statistic are based.

Settings

Name

Display name of the statistic. The name can be changed at any time.

Period

Select the period from the drop-down list. Select a default value or user the option Date selection and set a start date and an end date.

Starting date;
End date

Enter a starting and ending date instead of selecting a Time span (optional). Only available if the option Date selection is selected.

Date based on

Select which event should be used for analysing the data: Order received, Incoming payment or Outgoing items.

From status / To status

Depending on the type of statistic there are different options available to narrow down the status. Default values are preset.
Note: All types of orders are included in the statistical analysis except for cancellations. Status 8 and Status 8.1 are thus excluded from the statistic.

Client (store)

Select the stores that you would like to include into the statistic.

Order referrer

Select the order referrers that you would like to include in the statistic.
The order referrers correspond to individual orders and not to order items.

Country

Select the country that you would like to include in the statistic. Select all to include all countries.

Payment method

Select the payment method that you would like to include in the statistic. Select all to include all payment methods.

Shipping profile

Select the shipping profile that you would like to include in the statistic. Select all to include all shipping profiles.

Paid orders only

Activate this option to only include paid orders in the statistic.

Orders with outgoing items booked only

Activate this option to only include orders with booked outgoing items in the statistic.

Chart

Select which revenue should be calculated for the statistic.
Net revenue = Revenue minus VAT
Gross revenue = Revenue including VAT
Contribution margin II = Revenue minus taxes, purchase price and the additional costs that were selected.
The following costs can be deducted separately:

  • Payment commission

  • Manufacturer commission

  • Transportation costs

  • Storage costs

  • Operating costs

  • Customs

The contribution margin II is reduced by any costs activated with a check mark.
Tip: Transportation costs, storage costs, operating costs and customs are saved in the Settings tab of the variation. Note: Item bundles are not taken into consideration. Fees for markets are added to the gross price (sales price).

Amazon account

Select the Amazon account that you would like to include in the statistic.

eBay account

Select the eBay account that you would like to include in the statistic.

3. Analysing a statistic

This chapter explains how to interpret and use the data gained from the statistics. To interpret statistics, note the information provided in Table 12. Also, make sure you understand the pool of data shown in the statistic you are interested in.

3.1. Types of charts

Depending on the chart type selected, statistic data is shown in different formats. To compare statistics, select identical chart types and periods for the statistics you want to compare. The following chart types are available:

Tip: Use the tool tips

The graphical charts provide additional values in tool tips. Move the cursor over a chart to show this information.

Table 12. Available chart types
Display Explanation

Data table

Displays data as a table.
Tip: Tables offer very detailed values at a glance. However, they do not show developments over time as clearly as line, column or bar charts.
Note: If the data table spans several pages, the totals are calculated for the entire table, not only for the page currently visible.

Column chart

Displays data in columns.

Line chart

Displays data as lines.

Column line combination chart

Displays one value as a column, i.e. vertically, and another value as a line, i.e. horizontally.

Bar and line chart

Displays one value as a bar, i.e. horizontally, and another value as a line, i.e. vertically.

Stacked column chart with percentages

Displays data in columns. The percentage data is stacked and shown in different colours.

Stacked double column chart

Displays data in columns. The data is stacked and distinguished by different colours.

Stacked bar chart

Displays data as different coloured bars.

Multi line chart

Displays data as different coloured lines.

2D pie chart

Displays data as two-dimensional pie chart.
Tip: Click on a pie piece to move it out of the pie. Click on each of the pie pieces to move all pie pieces out of the pie chart. Click on the pie piece again to move it back to its original position.

3D pie chart

Displays data as three-dimensional pie chart.
Tip: Click on a pie piece to move it out of the pie. Click on each of the pie pieces to move all pie pieces out of the pie chart. Click on the pie piece again to move it back to its original position.

3.2. Amounts and costs

The following amounts are used for the statistics. The amounts do not take into consideration item bundles. Fees for markets are added to the gross price (sales price).

Table 13. Amounts
Amount Explanation

Net

Amounts minus VAT

Gross

Amounts including VAT

Total

Revenue including shipping costs

Adjusted gross revenue

Gross revenue minus credit notes

Adjusted net revenue

Net revenue minus credit notes

Contribution margin I

Revenue minus purchase price, VAT and shipping costs

Contribution margin II

Revenue minus purchase price, VAT, shipping costs and the selected additional cost
The following costs can be deducted separately:

  • Payment commission

  • Manufacturer commission

  • Transportation costs

  • Storage costs

  • Operating costs

  • Customs

The contribution margin II is reduced by any costs activated with a check mark.
Tip: Transportation costs, storage costs, operating costs and customs are saved in the Settings tab of the variation.

4. Exporting statistics data

You can export to a CSV file either the data shown or the raw data that the statistic is based on:

  • The statistics export only contains the values shown in the chart type Data table.

  • The raw data export contains the data pool on which the values shown in the statistic are based.

4.1. Exporting statistics data

Proceed as described below to export the data of a statistic to a CSV file. The export contains the data shown in the chart type Data table.

Exporting basic statistics data:

  1. Go to plentymarkets logo (Start) » Statistics.

  2. Open the statistic’s tab.

  3. Click on Edit () for the statistic that you want to export.
    → The editing window opens.

  4. Click on the green arrow Export above the chart view.

  5. Select a storage location and confirm your selection.
    → The CSV file is saved.
    Tip: You can export up to 10,000 rows of data. If this amount is exceed, only the first 10,000 rows will be exported. If you want to export a full set of data, limit the data volume by applying filter options.

  6. Open the file with a spreadsheet program, e.g. Microsoft Excel.
    The data fields contained in the CSV file depend on which statistic is exported. Table 14 explains the available data fields.

4.2. Exporting raw data

The raw data export contains the data pool on which the values shown in the statistic are based. Proceed as described below to export the raw data of a statistic to a CSV file.

Exporting raw data:

  1. Go to plentymarkets logo (Start) » Statistics.

  2. Open the statistic’s tab.

  3. Click on Edit () for the statistic that you want to export.
    → The editing window opens.

  4. Click on Raw data export, i.e. the document with the green arrow above the chart view.

  5. Select a storage location and confirm your selection.
    → The CSV file is saved.
    Tip: You can export up to 10,000 rows of data. If this amount is exceed, only the first 10,000 rows will be exported. If you want to export a full set of data, limit the data volume by applying filter options.

  6. Open the file with a spreadsheet program, e.g. Microsoft Excel.
    The data fields contained in the CSV file depend on which statistic is exported. Table 14 explains the available data fields.

4.3. Export data fields

Table 14 explains the data fields of the export files. The data fields contained in the CSV file depend on which statistic is exported.

Table 14. Data fields of CSV exports
Data field Explanation

AdjustedItems

Adjusted items

AdjustedSales

Adjusted revenue

AdjustedSalesNet

Adjusted net revenue

AttributeValueSetID

ID of the item variation

AveragePurchasePrice

Average purchase price

AverageSales

Average revenues

AverageShipping

Average shipping costs

CategoryID

Category ID

CategoryName

Category name

City

Town

Claim

Pending amount

Company

Account

CountryID

Country ID

Country

Country

CountryOfDelivery

Country of delivery

CreditNotes

Credit note amounts

CreditNotesNet

Net credit note amounts

CustomerID

Customer ID

CustomerGroupID

Customer class ID

CustomerName

Customer name

CustomerRating

Feedback by customer

Customs

Customs

Date

Date

DatePaid

Incoming payment

DateShipped

Items shipped on

DistributionMarginOne

Contribution margin I

DistributionMarginTwo

Contribution margin II

Division

Partition number

DivisionDefinition

Order range, e.g. stock turnover

DunningLevel

Dunning level

EmailTemplateID

ID of email template

EmailTemplateName

Name of email template

EntryDate

Incoming order

ExternalItemID

External item ID

FirstName

First name

GrossPrice

Gross price

HouseNumber

House number

InvoiceNumber

Invoice number

InvoiceTotalGross

Gross invoice amount

InvoiceTotalNet

Net invoice amount

ItemID

Item ID

ItemMarking1

Flag 1

ItemMarking2

Flag 2

ItemName

Item name

ItemNo

Item number

ItemNumber

Item number

ItemPriceTotal

The item’s gross total price

ItemPriceTotalNet

The item’s net total price

ItemPriceUnit

Unit price

ItemPriceUnitNet

Net unit price

ItemPurchasePrice

Purchase price

ItemQuantity

Item quantity

Items

Number of items

ItemSellingPrice

Sales price

ItemWeight

Item weight

LastName

Last name

Legend

Legend

Losses

Refunds

Client

Default store or client

MethodeOfPayment

Payment method

NetItemValue

Value of items (net)

NetPrice

Net price

NetStock

Available stock

OperatingCosts

Operating costs

OrderID

Order ID

OrderRowID

Order item ID

OrderType

Order type

PaidAmount

Amount paid

PaymentCommission

Commission of payment method

PaymentMethodID

Payment method ID

PaymentMethodName

Payment method name

Percentage

Percentage

PhysicalStock

Total stock

Price

Price

ProducerCommission

Manufacturer commission

ProducerID

Manufacturer ID

ProducerName

Manufacturer

PurchasePrice

Purchase price

Quantity

Number of incoming items

QuantityOfBundleItems

Items in item bundles

QuantityOfCreditNotes

Number of credit notes

QuantityOfCustomers

Number of customers

QuantityOfItems;
QuantityItem

Number of items

QuantityOfItemsBundle

Items in item bundles

QuantityOfMessagesSent

Number of sent messages

QuantityOfOrders

Number of orders

QuantityOfReturns

Number of returns

ReasonOfReturnID

ID of return reason

ReasonOfReturnName

Name of return reason

Referrer

Order referrer

ReferrerID

ID of the referrer

ReservedStock

Reserved stock

ReturnedItems

Number of returned items

ReturnRate

Return rate

Returns

Gross amount returns

ReturnsNet

Net amount returns

Sales

Gross revenue

SalesAdjusted

Adjusted revenue

SalesAdjustedNet

Adjusted net revenue

SalesGross

Gross revenue

SalesNet

Net revenue

SalesPercentage

Percentage of revenue

SalesWithoutShippingCosts

Revenue minus shipping costs

ShippingCosts

Shipping costs (gross)

ShippingCostsGross

Shipping costs (gross)

ShippingCostsNet

Shipping costs (net)

ShippingProviderID

ID of the shipping service provider

ShippingProviderName

Name of the shipping service provider

ShippingRegion

Shipping region

SoldItems

Sold items

Status

Order status

StockCosts

Storage costs

StoreID

ID of the online store

Street

Street

Store

Default store or client

SupplierID

Supplier ID

SupplierName

Supplier name

Timestamp

Date at which the order was received

TimestampPaid

Date of incoming payment

TimestampShipped;
TimestampShipping

Date of outgoing items;
(Processing times)

ToPaidHoursAverage

Average number of hours needed for the order status to reach Paid

ToPaidPercentage

Percentage of total processing time needed for orders to reach Paid

ToPaidHoursPercentage

Average number of hours needed for the order status to reach Shipped

ToShippedPercentage

Percentage of total processing time needed for orders to reach Shipped

Total

Revenue including shipping costs

TradeRepresentativeCompany

Company of the sales representative

TradeRepresentativeID

Sales representative ID

TradeRepresentativeLastName

Last name of the sales representative

TradeRepresentativeName

Name of the sales representative

TransportationCosts

Transportation costs

Type

Order type

UserID

User ID

UserName

User name

VariationPurchasePrice

Purchase price of the item variation

ValueOfNetStock

Value of available stock

ValueOfPhysicalStock

Value of stock

ValueOfReservedStock

Value of reserved stock

Variation

Attribute values of the variation

VariantID

ID of the variation

VariantName;
VariationName

Name of the variation

VAT

VAT

WarehouseID

Warehouse ID

WarehouseName

Warehouse name

ZIPCode

Postcode

4.4. Troubleshooting: Correcting incorrect values in CSV file

In the spreadsheet program Microsoft Excel, values may be shown incorrectly depending on the separator configuration. If your CSV file shows incorrect values, you may need to adjust the advanced settings in Excel as follows:

Adjusting separator settings in Excel 2007:

  1. Open Microsoft Excel.

  2. Open the menu File > Options > Advanced.

  3. Deactivate the option Use system separators.

  4. Enter a period as the decimal separator.

  5. Click on OK.

  6. Reopen the CSV file in Excel.
    → The values are shown correctly.

To top