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.
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.
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.
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.
- Navigate to Reporting > Variant reports.
- Click the cells for the variants you want to add to the purchase order.
-
Click Create purchase order.
- If you’re adding to an existing purchase order, select the purchase order from the list and click Next.
-
If you’re creating a new purchase order click Create new purchase order, fill out the details, and click Next.
- If you’re adding to an existing purchase order, select the purchase order from the list and click Next.
- 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.
- 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.
- Navigate to Reporting > Variant reports.
- Change the dropdowns and add filters as required.
-
Click Export report.
What's next?
Customizing your inventory reports
Use advanced iventory reports to gain insights about your inventory performance.