Hi. How can we help?

Using the variant report

With the variant report, you can view available variant product inventory and create purchase orders from the report to streamline stock management and replenishment.

Accessing the variant report

To access the variants report, navigate to Reporting > Variant reports.

Variant reports page.

When the report loads, it will automatically show parent products in alphabetical order. The current inventory of each variant is displayed in a table under the parent product. The table displays up to 500 variants at a time.

Formatting and filtering the report

The columns and rows are dependent on the attribute order of the variants. Attribute one forms the columns and attributes two and three (if applicable) are shown in the rows.

Table showing how variant attribute order affects the table layout.

To change the way the variant information is formatted in the table, you can reorder the variant attributes on the Edit product page.

Use the filters at the top to refine your report:

  • Outlet: Select an outlet from the dropdown or choose All outlets.
  • Inventory levels: Choose to show All inventory or only Out of stock inventory.
  • Filters: Type a filter, like a supplier, brand, or category and choose from the list.

    Outlet, inventory levels, and filter dropdowns.

Creating a purchase order from the variant report

You can add to an existing purchase order or create a new one directly from the variant report.

  1. Navigate to Reporting > Variant reports.
  2. Click the cells for the variants you want to add to the purchase order.
  3. Click Create purchase order.

    Retail-x-variants-selected-on-table.png

    • If you’re adding to an existing purchase order, select the purchase order from the list and click Next.Add to existing purchase order option.
    • If you’re creating a new purchase order click Create new purchase order, fill out the details, and click Next.

      Create new purchase order option.

  4. Enter the quantity of each variant you want to order for each outlet. If you used the outlet filter on the report, the outlet will be pre-selected.
  5. Click Add products to order. The purchase order will remain open until you send the purchase order to the supplier.

Exporting the variants report

You can export the variant report to a CSV file to share or save for your records.

  1. Navigate to Reporting > Variant reports.
  2. Change the dropdowns and add filters as required.
  3. Click Export report.

    Variant report showing Export report button highlighted.

What's next?

Adding products with variants

Build your product catalog with variant products.

Learn more

Customizing your inventory reports

Use advanced iventory reports to gain insights about your inventory performance.

Learn more

Was this article helpful?