Skip to content
Avetti Support
Avetti Support

Getting Started

  • Getting Started Create a new Container store
  • Getting Started eShop
  • Getting Started Marketplace
  • Getting Started Multi Store Ecommerce
  • Getting Started With Accessibility
  • Getting Started With Website Performance
  • Getting Started With Google Analytics
  • Getting Started With Microsoft Clarity

Admin Pages

  • Create a New Supplier Store
  • Setup the Template/Default stores
  • Log in to a Supplier store
Dashboard
  • Dashboard
Catalog and Order Management
    Catalog
    • Product Dimensions
    • Sync Ecommerce
    • Find Products to Sell
    • Inventory
    • Prices
    • Manage Products
      • Products
      • Create Product
      • Edit Product
      • Edit Product Variations
    Orders
    • Quote Request
    • Chat
    • Return and Refunds
    • Click & Collect Orders
    • Manage Orders
About Me
  • General Information
  • Pickup Locations
  • Payment Information
Marketplace
  • Login Access Codes
  • Manage Standard Entities
  • Marketplace Category Mapping
  • Rebuild Marketplace
  • Category Profit Margin
  • Manage Supplier
  • Approve Supplier Data
  • Auction
Appendix
    Documentation Slides
    • About Me
    • Add Items – Suppliers
    • Create a Merchant Store
    • Customers
    • Manage Orders – Supplier
    • Prices – React Admin

System Admin Pages

  • Avetti Commerce Features
  • Ship Station Integration
B2C -Overview
    Templates
    • Catalog Personalization
    • Reset CDTO Cache
    • Template Skins
    People
    • Allowances
    • Customer Activity
    • Customer Properties
    • Customers
    • Member Types
    Marketing
    • A/B Split Tests
    • Add-ons
    • Basket Additions
    • Bundles
    • Coupons
    • Customer Discounts
    • Customer Segments
    • Customer Segment Prices
    • Customer Segment Ads
    • Gift Cards
    • Gift Certificates
    • Promotions
    • Sales Area Geolocation
    • Upsell/Cross-sell
    • Viral Promotions
    Settings
    • Basket Preferences
    • Image Scaling
    • Item Properties
    • Languages
    • Tax Rates
    • Order Preferences
    • Page Parameters
    • Payment Gateways
    • Retail Location
    • Search Dictionary
    • Shipping Countries
    • Shipping Packages
    • Shipping Rates
    • Sitemaps
    • Store Currencies
    • Shipping Exceptions
    • Store Preferences
    • Store Properties
    Audit Logs
    • Audit Log Views
    Catalog
    • Categories
    • Downloadable Items
    • Inventory
    • Item Reviews
    • Item Size/Weight
    • How to attach products to a category in the MCW
    • Manage Facets
    • Manage FAQs
    • Manage Galleries/PDFs
    • Manage Products
    • Multilingual Content
    • Prices
    • Validate Catalog Data
    • View Store
    • Variations
    Advanced
    • CDTO Editor
    • Change Password
    • Password Security Rules
    • Reports Configuration
    • Shopper Pwd Security
    • Site Admin Preferences
    • Solr Categories
    • Solr Items
    Media
    • Manage Media
    Orders
    • Abandon Cart
    • Customer Messages
    • Email State
    • Manage Orders
    • Manage Refunds
    • Reports
B2B - Overview
    Marketplace
      Advanced
      • Solr Items
      • Solr Categories
      • Site Admin Preferences
      • Shopper Pwd Security
      • Reports Configuration
      • Password Security Rules
      • Change Password
      • CDTO Editor
      Catalog
      • Item Status Settings
      • Item Options
      • Prices
      • Manage Facets
      • Item Size/Weight
      • Item Reviews
      • Inventory
      • Categories
      Marketing
      • Viral Promotions
      • Upsell/Cross-sell
      • Shipping Exceptions
      • Sales Area Geolocation
      • Marketing Segments
      • Gift Certificates
      • Gift Cards
      • Customer Segments
      • Customer Segment Prices
      • Customer Segment Ads
      • Customer Retargeting
      • Customer Discounts
      • Coupons
      • Bundles
      Market Place
      • Notifications
      • Master Catalog Products
      • Marketplace Suppliers
      • Marketplace Payments
      • Marketplace Categories
      • Category Profit Margin
      • Approve Products
      Media
      • Manage Media
      Order
      • Manage Refunds
      • Manage Orders
      People
      • Customers
      • Customer Properties
      Settings
      • Basket Preferences
      • Image Scaling
      • Item Properties
      • Order Preferences
      • Payment Gateways
      • Retail Location
      • Tax Rates
      • Store Preferences
      • Store Currencies
      • Shipping Countries
      Templates
      • Manage Templates
      • Reset CDTO Cache
      • Catalog Personalization
    Suppliers
      Catalog
      • Item Properties
      • Inventory
      • Manage Products
      Market Place
      • Approve Products
      • Marketplace Payments
      • Notifications
      Media
      • Manage Media
      Order
      • Customer Messages
      • Reports
      • Manage Refunds
      • Manage Orders
    MCW
      Advanced
      • Change Password
      Market Place
      • Notifications
      • Marketplace Suppliers
      • Approve Products
      Media
      • Manage Media
      Order
      • Customer Messages
      Settings
      • Store Preferences
      • Store Currencies
      • Shipping Countries
      • Item Properties
      Catalog
      • Categories
      • Inventory
      • Item Options
      • Item Reviews
      • Item Size/Weight
      • Item Status Settings
      • Prices
B2B2C - Overview
  • B2B Integration
Import and Export Files
  • Export Orders
  • Import Price and Inventory
  • Importing/Exporting Shipping Rates Spreadsheet
  • Import/Exporting SpreadSheets
  • eShop Features
Appendix
    Documentation Slides
      Others
      • Creating a Supplier Store
      • Rebuild solr
      • Publish
      People
      • Customer Data Management
      • Customers
      • Customer Properties
      Settings
      • Basket Preferences
      • Item Properties
      • MULTI-VALUED PROPERTIES
      • Retail Location
      • Shipping Countries
      • Sitemaps
      • Store Currency
      • STORE PREFERENCES
      • Store Properties
      • Tax Rates
      Advanced
      • Site Admin Preferences
      Reports
      • Business Reports
      Catalog
      • Advanced edit
      • Categories
      • Categories Spreadsheet
      • FREQUENTLY BOUGHT ITEMS
      • Import from XLS
      • Import-Export Advanced Spreadsheet
      • Inventory
      • Item Reviews
      • Manage Facets Manager
      • Simple Add
      • Prices
      • Validate Catalog Data
      • Variations
      Marketing
      • Bundles
      • Basket Additions
      • Coupons
      • Customer Discounts
      • Customer Segments
      • Gift Cards
      • Gift Certificate
      • Promotions
      • Upsell-Cross sell
      Marketplace
      • Approve Products
      Templates
      • Reset CTDO Cache
      Orders
      • Customer Messages
      • Export Orders
      • Email Settings
      • Manage Orders
      • SMS Settings
    Documentation Videos
    • Payment Gateway
    • Retail Location
    • Validate Catalog Data
    • Site Admin Preferences
    • SMS Settings
    • Advanced Edit
    • Variations
    • Manage Orders
    • Categories
    • Basket Preferences
    • Customers
    • Upsell Cross Sell
    • Allowances
    • Customer Discounts
    • Order Preferences
    • Publish
    • Rebuild Solr
    • Email Setting
    • Store Preferences
    • Item Reviews
    • Tax Rates
    • Customer Segments
    • Store Currency
    • Product Data Spreadsheet
    • Export Orders
    • Sitemaps
    • Prices
    • Coupons
    • Bundles
    • Frequently Bought Items
    • Customer Properties
    • Store Properties
    • Multi Valued Properties
    • Gift Cards
    • Promotions
    • Manage Media
    • Gift Certificates
    • Manage Facets
    • Simple Add
    • Import and Export Using Spreadsheet
    • Customer Messages
    • Creating a Supplier Store
    • Approve Products
    • Import XLS
    • Business Reports
    • Item Properties

WordPress

  • Getting Started
  • Document Checklist
  • How to create pages in Wordpress?
  • How to create New Menus?
  • How to edit the Home Page?
  • How to change Favicon and Site Title?
  • How to edit Header and Footer?
  • How to change Header and Footer?
  • How to edit Shipping Policy, Refund Policy and Privacy Policy pages?
  • How to add Google Analytics and Microsoft Clarity
  • Using Existing WP vs Using Fresh WP
  • How to change Logo URL
  • How to create Blog Posts?
  • Blog Look And Layout
  • Netlify Redirects
  • Caching Issues
  • Plugins
Plugins
  • Fluent Forms
  • Perfmatters
  • Blocksy
  • Change SEO Title and Meta Descriptions with Yoast SEO
  • Staging and Backup with WPVivid
  • Stackable
  • Custom Javascript and CSS plugin
Common Issues
  • Does Not Use Passive Listeners
  • Enable Text Compression
  • Preload Largest Content Paint Image
  • Home
  • Docs
  • System Admin Pages
  • Import and Export Files
  • Export Orders

Export Orders

Table of Contents
  • Overview
  • Objectives
    • Manage Orders admin page
    • Prerequisites:
      • Export Orders
      • Instructions of the Export Orders spreadsheet
      • Data Definition
        • Order worksheet
        • Order Property worksheet
  • SUMMARY

Also available in these formats:

Presentation
Video

Overview #

This manual provides information on how to export a list of orders from an XLS spreadsheet.

There are 2 ways of exporting the orders placed in a store.

  1. Using the Manage Orders admin page
  2. Using the Export Orders admin page

Objectives #

By the end of this guide, you will learn how to export the orders spreadsheet and the details of each tab and column of the spreadsheet.

Manage Orders admin page #

The Export Order section is available on the Manage Orders admin page.

Prerequisites: #

  • Access to the system admin pages using a Sys admin role
  • Access to a store on the server
  • The export orders spreadsheet that is used here is .xls format. Ensure you have spreadsheet software that can view and edit these files, such as Microsoft Excel or Open Office.

To access the Manage Orders admin page, follow these steps:

1. Login to the sys admin panel and go to Orders > Manage Orders

2. The Order Details admin page will open in the same window. The Export Orders section will be available at the bottom of the page.

3. Click on the down arrow to expand the section.

The following elements are available in the Export Orders section

  1. Specify Date: This is the first method to export the order data into a .xlsx file. The following duration of data is available:
    • last 10 days
    • last 35 days
    • last 65 days
    • all orders
  2. Status: This button will redirect you to the IMPORT/EXPORT STATUS admin page, where the list of tasks to import and export is displayed. When a task is completed, the file will be available to download.
  3. Export: Use this button to create a new task to export the order data into a .xlsx file according to the duration selected on the Specify Date dropdown menu. After this button is clicked, you will be redirected to the IMPORT/EXPORT STATUS admin page, when the task is completed, the export orders file will be available to download to your computer.
  4. Import: Use this button to import the order data from a .xlsx file on your computer.

Export Orders #

4. From the ‘Export Orders’ section of the Manage Orders admin page, select a specific date from the dropdown menu and click on ‘Export’

5. The IMPORT/EXPORT STATUS admin page will open in the same window.

  • A new Export task will be displayed on the list of tasks as a new record.
  • The new task will have a Waiting Status and Auction.

6. Wait a few minutes, when the export orders file is completed, a download link will be displayed on the Auction columns.

7. Click on the ‘download’ link and save the file to your computer.

8. Open the file and Enable the Edition of the file

Instructions of the Export Orders spreadsheet #

The Export Orders spreadsheet contains the orders’ data that was downloaded from a particular store in the server and in a specific period of time.

It consists of 3 worksheets (Do not forget to fill in the corresponding information on the worksheets):

  1. Order: This is the main tab of this spreadsheet and contains all the important information about the orders that were placed in the store. Here you will find:
    • Order information, such as the Order ID, as well as the date and time of the order.
    • Customer information, such as the customer’s name and billing and shipping addresses of the customer for those specific orders.
    • Product details, such as the product code, title, price, taxes, and shipping per product, as well as product status.
    • Order totals, such as the total pay, net pay
  2. Order Property: This tab will have information about the order properties of each order and their values.
  3. Order Item Property: This tab will have information about the properties of the product per order and their values.

Data Definition #

Order worksheet #

Most of the columns are self-explanatory but refer to the following table for more information and some examples of the values that are expected on each column:

Column Column HeaderDefinition and UseAccepted ValuesExample(s)
AOrder IDThe ID uniquely identifies an order. The Order ID consists of the order prefix and the date when the order was placed, which could be in these 2 formats YYYYMMDDSSSSS or YYMMDDSSSSS. This can be specified on the Order Preferences admin page. AlphanumericABC22121200002
BDateIn this column the date and time when the order was placed will be displayed in the following format:
YYYY-MM-DD hh:mm:ss
Date2022-03-30 16:22:30
CCustomer CodeThe customer code column will display the value of the customer number order property for each product in the order String[email protected]
DCustomer Email AddressThe email of the customer who placed the orderString[email protected]
E-NBill To Columns
The Billing Address information of the customer who placed the order or the Billing Address information of the customer specified in the billing form when the order was placed:
Bill To First Name
Bill To Last Name
Bill To Company
Bill To Address1
Bill To Address2
Bill To City
Bill To State
Bill To Country
Bill To Phone
Bill To Postal/Zip Code
String per column Billing address
O-YShipping To columns
The Shipping Address information of the customer who placed the order or the Shipping Address information of the customer specified in the billing form when the order was placed:
Ship To First Name
Ship To Last Name
Ship To Company
Ship To Address1
Ship To Address2
Ship To City
Ship To State
Ship To Country
Ship To Phone
Ship To Postal/Zip Code
Ship Zone
String per columnShipping address
ZProduct CodeUnique identifier of the products on an order. When the supplier admin exports the spreadsheet from the supplier store, the product code will be shown in this column. That means the product code the supplier used to create the product will be the one displayed in this column.
If the spreadsheet is exported from the Marketplace store using a marketplace or sys admin account, the AIN number will be displayed in this column instead. The supplier product code will be displayed in the next column called “SKU code”. The AIN number is automatically created when the products from different suppliers are copied to the MCW. If your project does not require a Master Catalog Warehouse store (MCW) the products of your store won’t have an AIN number.
This field can not be empty.
StringGOAT-CREAM-CHEESE /
AIN123465
AASKU codeThis column will be empty when exporting the spreadsheet from the supplier store.
The supplier product code will be displayed here when ONLY when the spreadsheet is exported from the MCW and Marketplace stores.
StringGOAT-CREAM-CHEESE
ABQtyThe specific amount of the product on the order. This field can not be empty.Numeric10
ACTitleThe title of the product on the order. The title of the product can not be greater than 255 characters. This field can not be empty.StringIronwood Coffee Medium
ADShipping & ServicesShipping value that was charged when the customer placed the order. Numeric1.56
AEShipping MethodThe name of the Shipping Method that was used to ship the order. This field can be empty.StringDefault Shipping
AFProduct Ship TaxTax charges on delivery or shipping services that were paid when placing the order.
These charges are calculated according to the tax rates set up in the store.
Numeric0
AGProduct Total TaxThe total tax including shipping tax and products sale taxNumeric5.65
AHProduct CommissionCommissions are set up in the marketplace store by marketplace admins.
Marketplace admin can set commission rules on products and categories by applying different commission percentages or fixed amounts to the products or products in a category.
The value in this column is the fee the marketplace will get per line item.
This column will display 0 if commissions haven’t been configured in the marketplace or if the commission rules haven’t been specified for the specific product.
Numeric2.50
AIProduct RefundA value will be displayed here when the order is shipped and then returned and refunded. The refund could be a partial refund or a total refund of what was paid per product when the order was placed. Numeric8.5
AJList PriceThe listed price or the manufacturer’s suggested retail price that the product had when the order was placed.Numeric200
AKItem PriceThe actual price of the product when the order was placed. This price will always be lower than the List Price. Numeric198.85
ALFinal Item PriceThe Final Item price is the item price multiplied by the qty of products per line on the order. Numeric994.25
AMTotal TaxThe total tax value the customer paid per order. Note: All the products in one order will have the same Total Tax per line.Numeric15.55
ANTotal CommissionThe Total Commission value the marketplace will get per order. Note: All the products in one order will have the same Total Commission per line.Numeric2.50
AOTotal RefundThe Total Refund value the customer got when one of the products or the complete order was returned and refunded. Note: All the products in one order will have the same Total Refund value per line.Numeric55.26
APTotal PayThe Total Pay value the customer paid per order. Note: All the products in one order will have the same Total Pay per line.Numeric1250.66
AQNet Pay To SupplierThe Net Pay value the customer paid per order. Note: All the products in one order will have the same Net Pay per line.Numeric168.84
ARSupplier IdThe Supplier ID will be displayed in this column. This is a unique identifier specially used by the marketplace admin to know which products belong to which suppliers. The Supplier admin won’t be using this information.Numeric244
ASAll Applied DiscountsThis column will be empty if there were no discounts or promotions applied to the products on the orderNumeric568.56
ATProduct StatusCurrent Order Item State per product on an order. Each product could have a different order item state on an order, and that will determine the overall order state. The following are the available Order Item State:
·        Being Prepared
·        Cancelled
·        To Be Shipped
·        Shipped On
·        Returned
·        Exchanged
·        Processed
·        On Hold
·        Approved
·        Rejected
·        Delivered
StringApproval Needed
AUCurrencyThis column will display the currency of the order as a 3-digit code. The store currency needs to be previously set up in the store before placing an order. StringUSD / CAD / AUD / EUR
AVPayment TypeThis column will show the code of the payment method used to place each order. The payment gateway code is automatically provided to the supplier when the payment gateway is configured in the store.
The payment gateways are set up directly in the marketplace store so the supplier does not need to set them up.
Some examples of payment gateway codes are:
-Square: Square
-PP: Pay with Paypal
-MO: Pay with Moneris
-NCC-COD: Cash On Delivery
StringNCC-COD
AWPO NumberPO Number will display the information the customer enters on the checkout page when placing the orders only if the order was paid by Purchase Order or by Cheque. Alphanumeric00001 
AXIdentityThe Identity column is storing the credit card number (with only last 4 digits displayed) OR the gift certificate code. This column could be empty. String***********1111
AYTracking CodeIf the product has already been shipped, the tracking code will be displayed on this column. The tracking code is a unique number assigned to each package of the order, if the complete order was shipped with the same tracking code, all the products in that order will have the same tracking code. AlphanumericRH469238277CN

Order Property worksheet #

Order Properties are additional specifications of an order that provide details about the order to help an admin make an informed decision about the order.

The Order Properties are predefined and automatically assigned to the orders after they are placed. 

The Order Property tab consists of 3 columns:

Column NameDefinition and UseAccepted ValuesExample(s)
Order IDThe ID uniquely identifies an order. The Order ID consists of the order prefix and the date when the order was placed, which could be in these 2 formats YYYYMMDDSSSSS or YYMMDDSSSSS. This can be specified on the Order Preferences admin page. AlphanumericABC22121200002
Prop NameThe name of the order property that was automatically attached to the order after it was placed. StringBrowser User Agent
Prop ValueThe value of the order property that was automatically attached to the order after it was placed. StringChrome 10

SUMMARY #

At this point, hopefully, you were successful in exporting the orders of a store. In short, the export process is as follows:

  • Navigate to the Import/Export page
  • Select the data you wish to export
  • Download the files to your computer
  • Open the file and review the information or the orders
What are your Feelings
Still stuck? How can we help?

How can we help?

Updated on January 25, 2023
Import Price and Inventory

Powered by BetterDocs

Table of Contents
  • Overview
  • Objectives
    • Manage Orders admin page
    • Prerequisites:
      • Export Orders
      • Instructions of the Export Orders spreadsheet
      • Data Definition
        • Order worksheet
        • Order Property worksheet
  • SUMMARY

Copyright © 2022 Avetti.com Corporation.