Contents x
    Export/Import
    • 26 Jul 2021
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Export/Import

    • Updated on 26 Jul 2021
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    Export in Excel

    The export feature enables to export of the filtered purchase orders table into an Excel document.
    PO_overview_06

    ActionDescription
    Export current pageExports the first page of the filtered purchase orders. The number is based on the number of orders per page and could be defined in the footer menu
    Export selectionExports all selected purchase orders
    Export AllExports all filtered purchase orders

    Selecting one of the menu items prompts a Save As window to specify the name and destination where you want your file to be saved.

    The orders will be saved in .xlsx format.

    Here is a list of columns that will be exported:

    Column nameDescription
    CodePurchase order code
    SalesOrderCodeSales order code (for dropship and back-to-back PO)
    DateDate the PO was created.
    OurReferenceDisplays a reference. For back-to-back and dropship orders, the sales order code will be displayed here as well.
    Supplier CompanyDisplays the supplier's company name and the supplier's full name in parentheses
    Order TotalTotal amount of the purchase order in a currency selected for the purchase order
    Base Order TotalTotal amount of the purchase order in shop owner currency
    ExpectedDeliveryDateDisplays an expected delivery date if one was set for the PO
    Supplier NameDisplays the supplier's full name
    CurrencyCurrency of the purchase order
    ShopDisplays a shop the purchase order is linked to
    Main StatusThe main status of the specific purchase order
    Submit StatusIndicates whether the purchase order was sent to the supplier
    Provision StatusProvision status of the particular purchase order.
    Payment StatusPayment status of the particular purchase order
    Main Status Action DateThe date a purchase order main status was changed
    Submit Status Action DateThe date a purchase order submit status was changed
    Provision Status Action DateThe date a purchase order provision status was changed
    Payment Status Action DateThe date a purchase order payment status was changed
    TypeThe type of the purchase order

    Import

    ShopCtrl supports the option of creating purchase orders via API. Please see the API documentation for more details.

    What's Next