Exports available in Turis
Dashboard
Accumulated revenue
Shows the accumulated revenue for all currencies. With this dataset, you can choose to see the accumulated revenue in your preferred currency as well. When clicking Export as .csv, the data will be converted into a simple overview in a .csv file.
Example of .csv.
Top products
This dataset will show you the most significant data on how some of your top-performing products, such as Cases sold, units sold, and total revenue. With top products, you can also choose in which timeframe you would like to see data, along with how many products you want to see as default. The default amount of products is shown in the vertical 3 dots.
Top products can also be exported to a .csv file, in this, you will see the performance of the chosen default amount of products within the chosen timeframe;
Product export
All your products data can also be exported into a .csv file to give you a better overview of your products - This file can especially come in handy, if you are doing a lot of bulk edits to your products.
This export is found in Products > Products > Top right corner;
This export contains following data:
- Name
- Brand
- Supplier
- SKU
- Warehouse Location
- EAN
- Style Number
- HS Code
- Unit Cost
- Variant
- Variant Title
- Size/Volume
- Category
- Sub-Category
- Groups
- Color
- Material
- Dimensions
- Unit weight
- Unit volume
- Wholesale prices (all currencies on your account)
- RRP's (all currencies on your account)
- Special Pricelists
- Discount Tiers
- Stock
- Allow Backorders
- Purchase Requirements
- Case Quantity
- UOM
- Description
- New Product
- Images
- Units Ordered
- Orders Count
*Please note, the product export from Products page should not be used to bulk update products in the bulk uploader - Only the template found in the bulk uploader should be used to bulk update products.
Users
Within your user section, you'll be able to find 2 different exports; Retailers and Buyers.
Retailer export
Your retailer export contains the following data:
- Customer no
- Name
- Address
- Zip code
- City
- Country
- State
- Language
- Delivery term
- Vat number
- Vat exempted
- Select Agents
- Website
- Order confirmation email
- Phone number
- Currency
- Special Prices
- Free Shipping limit
- Minimum order amount
- Discount
- Payment days
- Allow users to sign-up using company email domain
- Is customer contractor
- Express ordering
- Read only' delivery address checkbox
This export can be found in Users > Retailers > All retailers;
Buyer export
Your buyer export contains the following data:
- Buyer no.
- First name
- Last name
- Company
- Language
- Discount
- Last login
This export can be found in Users > Retailers > Buyers;
* Please note that, the retailer export nor the buyer export should be used to bulk update retailer or buyers in the bulk uploader.
Order export
All orders with each of their order lines can too be exported into a .csv file.
Your order export contains the following data:
- Order no.
- PO No.
- Order Type
- Order Status
- Date of Order
- Time of Order
- Sales Agent
- Customer no.
- Company
- Buyer
- Delivery Terms
- Delivery Address
- Invoice Address
- Product SKU
- Warehouse Location
- EAN
- HS Code
- Product Name
- Supplier
- Cases
- Units
- UOM (Unit of measure)
- Unit Weight
- Unit Volume
- Discounts Pct.
- Unit Cost
- Total cost
- Default currency
- Price per unit
- Sub-total
- Shipping cost
- Grand total
- Currency
- Payment Terms
- Paid
- Comments
- Internal order comments
- Tags
The order export can be exported in Orders;
To export a single or only a few orders, you can use Bulk action > Mark the orders you want to be exported > Click Export as .csv;
