You can access your site’s products from your templates via craft.products
It returns an ElementQuery object.
{% set products = craft.products.type('normal').all() %}
{% for product in products %}
{% for variant in product.variants %}
{{ variant.sku }} - {{ variant.salePrice }} <br>
{% endfor %}
{% endfor %}craft.products supports the following parameters:
The Product's element ID.
Product Type model or handle.
Product type ID.
Only fetch products with the given status.
Possible values are 'live', 'pending', 'expired', 'disabled', and null. The default value is 'live'. null will return all entries regardless of status.
An entry is 'live' if it is enabled, has a availableOn in the past and an expiresOn Date in the future.
An entry is 'pending' if it is enabled and has availableOn and expiresOn Dates in the future.
An entry is 'expired' if it is enabled and has availableOn and expiresOn Dates in the past.
Fetch products based on their postDate.
Fetch products based on their date of expiry.
Fetch products based on available dates after this date.
Fetch products based on their date available.
Fetch products based on the default variant's weight
Fetch products based on the default variant's height
Fetch products based on the default variant's length
Fetch products based on the default variant's width
Fetch products based on the default variant's sku
Only return products where the hasVariant params would return one or more of the product's variants.
A variant query object can be passed or an array of query params. To see the available query params for variants, see craft.variants.
For example, if you only wanted to return products where at least one variant's color field is red:
{% set products = craft.products.type('tshirt').hasVariant({ color: 'red' }) %}You could alternatively do:
{% set variantQuery = craft.variant.color('red') %}
{% set products = craft.products.type('tshirt').hasVariant(variantQuery) %}