Statistics (old function)
Important: No new features planned for this function
The function in the PlentyONE logo (Start) » Statistics will not be developed further. You can still see and use the function. However, no new features or extensions will be implemented. We recommend that you use the dashboard. For further information, refer to the Dashboard page and the plentyBI section of the manual. |
The PlentyONE 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 PlentyONE. The statistics are created based on the data available in your PlentyONE 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 PlentyONE logo (Start) » Statistics to open the Statistics menu. Alternatively, click on the Statistics button in the PlentyONE 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.
Type of statistic | Explanation |
---|---|
Total revenue development |
Shows the number of orders and the revenue for the selected period. |
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.
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.
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.
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. |
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.
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.
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.
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.
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.
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, PlentyONE 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:
-
Go to Setup » Client » Settings » Statistics.
→ The login details are shown. -
Click on Open Webalizer statistics.
→ The Authentication Required window opens. -
Enter the login details into the fields User Name and Password.
-
Click on Register.
The statistics opens in a new browser tab. -
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 PlentyONE 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:
-
Go to PlentyONE logo (Start) » Statistics.
-
Create a new tab or make sure that you have opened the correct tab that has been created before.
-
Click on Add () on one of the four tab fields.
→ The New statistic window opens. -
Select a statistics type.
-
Save () the settings.
→ The statistic is created using the default settings.
Tip: Table 10 explains the 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. |
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. |
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:
-
Go to PlentyONE logo (Start) » Statistics.
-
Select a Tab.
-
Click on Edit () for the statistic that you want to modify.
→ The statistic settings are shown. -
Carry out the settings. Table 11 explains the most important settings.
-
Save () the settings.
→ The statistic data is updated.
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; |
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. |
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. |
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.
The contribution margin II is reduced by any costs activated with a check mark. |
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. |
Display | Explanation |
---|---|
Data table |
Displays data as a table. |
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. |
3D pie chart |
Displays data as three-dimensional pie chart. |
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).
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 contribution margin II is reduced by any costs activated with a check mark. |
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.
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:
-
Go to PlentyONE logo (Start) » Statistics.
-
Open the statistic’s tab.
-
Click on Edit () for the statistic that you want to export.
→ The editing window opens. -
Click on the green arrow Export above the chart view.
-
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. -
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.1. 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:
-
Go to PlentyONE logo (Start) » Statistics.
-
Open the statistic’s tab.
-
Click on Edit () for the statistic that you want to export.
→ The editing window opens. -
Click on Raw data export, i.e. the document with the green arrow above the chart view.
-
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. -
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. 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.
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 |
Contact ID |
CustomerGroupID |
Customer class ID |
CustomerName |
Customer name |
CustomerRating |
Feedback by customer |
Customs |
Customs |
Date |
Date |
DatePaid |
Incoming payment |
DateShipped |
Outgoing items booked 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; |
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 |
Gross shipping costs |
ShippingCostsGross |
Gross shipping costs |
ShippingCostsNet |
Net shipping costs |
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 |
Paid on |
TimestampShipped; |
Date of outgoing items; |
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; |
Name of the variation |
VAT |
VAT |
WarehouseID |
Warehouse ID |
WarehouseName |
Warehouse name |
ZIPCode |
Postcode |
4.3. 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:
-
Open Microsoft Excel.
-
Open the menu File > Options > Advanced.
-
Deactivate the option Use system separators.
-
Enter a period as the decimal separator.
-
Click on OK.
-
Reopen the CSV file in Excel.
→ The values are shown correctly.