Skip to main content

Managing 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 tabs

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 system data. 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 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 order status.
Returns and credit notes are not included in the number of orders. The number of returned items from item bundles will be analyzed. 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 refunds. 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 order referrer of items 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 order 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. It 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. Allows you to analyse which shipping regions are particularly profitable.

Revenue by payment method

Shows the 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. 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 processes, 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. The statistic shows how long it took for orders to get paid and shipped. 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 order status selected. This 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 Shipped status 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 Order 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 time span. 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. 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 Item 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. This 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. This 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. This 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 will be used to calculate the stock turnover in days and group the data into categories. This 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 by warehouse. This 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. 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. This 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. In other words, 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. 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. 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 refunds.

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. This 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. This 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. 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. This 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. This 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 System » Client » Settings » Statistics to access the visitor statistics.

Opening the visitor statistics:

  1. Go to System » Client » Settings » Statistics.
    → The menu opens.
    → The login details are shown. .Click on Open Webalizer statistics.
    → The Authentication Required window will open. .Enter the login details into the fields User Name and Password. .Click on Login.
    → The statistics will open in a new browser tab. .Click on a month to see a detailed analysis for the period.

2. Managing statistics

2.1. Creating a statistic

Statistics are grouped in tabs in the 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 merely 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 Start » Statistic.

  2. Select the tab.

  3. Click on the green plus icon of one of the four tab fields.
    → The New statistic window will open.

  4. Select a statistics type.

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

Table 10. Statistic layout
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.

Reload

Click to update the chart with the current data.

Pencil icon

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 Show all to end zooming and show the entire statistic.

Totals

In tables, 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: No data available?

Not all referrers are shown for all statistics by default. If no data is shown for a statistic, click on the pen icon and select a longer period or additional referrers.

Modifying statistics:

  1. Go to Start » Statistic.

  2. Select a Tab.

  3. Click on the pen of the statistic you want to adjust.
    → The statistic settings are shown.

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

  5. Save the settings.
    → The data is updated.

Table 11. Editing a statistic
Setting Explanation

Chart view

Type of chart

Select how the values should be shown. 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 email folder from the drop-down list. Select a default value or select Date selection and set a starting date and an ending 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 analyzing 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. As such, Status 8 and Status 8.1 are 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

Select to include paid orders only in the statistic.

Orders with outgoing items booked only

Select to include orders with outgoing items booked in the statistic.

Chart

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

  • 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

In this chapter, we will show you how to interpret and use the data you gain from the statistics. To interpret the statistics note the information provided in table 1. Also make sure you understand the pool of data shown in the statistic you are interested in. Depending on the statistic, the values shown may be total values or values per unit, e.g. per customer or per order.

3.1. Types of chart

The data is shown in different formats depending on the chart type selected. 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
Schema Explanation

Data table

Shows the 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 and not for the page currently visible.

Column chart

Shows the data in columns.

Line chart

Shows the data as lines.

Column line combination chart

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

Bar and line chart

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

Stacked column chart with percentages

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

Stacked double column chart

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

Stacked bar chart

Shows the data as different coloured bars.

Multi line chart

Shows the data as different coloured lines.

2D pie chart

Shows the 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

Shows the 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 respectively:

  • 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 Start » Statistic.

  2. Open the statistic’s tab.

  3. Click on the pen of the statistic you want to export.
    → An editing window will open.

  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 Start » Statistic.

  2. Open the statistic’s tab.

  3. Click on the pen of the statistic you want to export.
    → An editing window will open.

  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

The following table 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 the 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

Company

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

The customer’s 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 orders

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

Surname

Legend

Legend

Losses

Refunds

Client

Default store or client

MethodeOfPayment

Payment method

NetItemValue

Net value of items

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 item intakes

QuantityOfBundleItems

Items in item bundles

QuantityOfCreditNotes

Number of credit notes

QuantityOfCustomers

Number of customs

QuantityOfItems;
QuantityItem

Number of items

QuantityOfItemsBundle

Items in item bundles

QuantityOfMessagesSent

Number of sent messages

QuantityOfOrders

Number of orders

QuantityOfReturns

Number of returns

ReasonOfReturnID

Reason for return ID

ReasonOfReturnName

Name of reason for return

Referrer

Order referrer

ReferrerID

Referrer ID

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

Gross shipping costs

ShippingCostsGross

Gross shipping costs

ShippingCostsNet

Net shipping costs

ShippingProviderID

Shipping service provider ID

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 that the order was received

TimestampPaid

Date of incoming payment

TimestampShipped;
TimestampShipping

Items shipped on;
(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 be paid

ToPaidHoursPercentage

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

ToShippedPercentage

Percentage of total processing time needed for orders to be shipped

Total

Revenue including shipping costs

TradeRepresentativeCompany

Company of sales representative

TradeRepresentativeID

Sales representative ID

TradeRepresentativeLastName

Last name of sales representative

TradeRepresentativeName

Name of sales representative

TransportationCosts

Transportation costs

Type

Order type

UserID

User ID

UserName

User name

VariationPurchasePrice

The item variation’s purchase price

ValueOfNetStock

Value of available stock

ValueOfPhysicalStock

Value of stock

ValueOfReservedStock

Value of reserved stock

Variation

Attribute values of the variation

VariantID

Variation ID

VariantName;
VariationName

Name of the variation

VAT

VAT

WarehouseID

Warehouse ID

WarehouseName

Name of the warehouse

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 the CSV file shows incorrect values, you may need to adjust the Advanced settings in Excel:

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