Detailed data explanation

  • Resolved Webfolio Webdesign

    (@webreneszansz)


    3 months, 2 weeks ago

    Hi,

    I am a website developer and I also need to analyze the webshop order details to help my clients improve the sales volume etc.

    Is available any detailed decription for the available order informations? I mean, if I export all of the available details, than I will have more than 50 colums and I would like to ensure, that I understans totally clear the content of each column.

    Let me give some example:
    Quantity: the number of the ordered same product in this order
    Stock Quantity: how many product is available / in stick at the purchase of the product

    Unfortunately, not every columns are totally clear, which would be very important to calculate the neccessary information properly. For example, there are e lot of informations, regarding to the amounts: Order Line Subtotal, Order Line Total and the product prices…

    Thank you very much!

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author albarin

    (@albarin)

    Hi @webreneszansz!

    You can see order properties and their description in here: https://woocommerce.github.io/woocommerce-rest-api-docs/#order-properties

    Could you clarify how are you exporting the orders or the list of fields that you need explanations for?

    Thanks a lot! Hope it helps!

    Thread Starter Webfolio Webdesign

    (@webreneszansz)

    Hi,
    Thank you very much for the quick answer, I really appreciate it. I use the free version of the Advanced Order Export?for WooCommerce plugin for the export.

    Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    Hi there!

    Thank you for sharing more details. Please note that we do not provide support for third-party plugins. Since you are using a third-party plugin to export your order details and are facing issues with column details, I recommend contacting the plugin provider directly. You can reach them here: Woo Order Export Lite Support. They should be able to guide you on how to get the complete details for each column.

    You can also use our Analytics feature to get detailed reports about your orders and sales. Alternatively, I suggest using WooCommerce’s default export feature to check if it provides complete data for each column you need.

    When you export order details from WooCommerce, you’re likely to encounter a large number of columns, each representing different pieces of data related to orders. Your examples are a great starting point:

    • Quantity: The number of units of a specific product purchased within a single order.
    • Stock Quantity: The available stock for a product at the moment the order was placed.

    For the financial details, here’s a brief explanation:

    • Order Line Subtotal: The subtotal for each line (product) in the order before applying any discounts or taxes.
    • Order Line Total: The total for each line after discounts are applied, but before taxes.
    • Product Prices: The base price of the product itself, not accounting for discounts, taxes, or additional fees like shipping.

    Understanding each column fully is indeed essential for analyzing sales data effectively. I recommend checking out the official WooCommerce documentation for more information on exported order data. If you need clarification on specific column names, feel free to share them, and I’d be happy to provide a more detailed explanation.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.