Understanding the Allowed Values List

Oct 13, 2025 by thesweetdesigns.com 137 views

Introduction

In the world of e-commerce, analyzing sales data is crucial for making informed business decisions. One common requirement is to filter and display product sales by date in a block. This can be achieved using a combination of Commerce's custom select list field and some clever coding. In this article, we will explore how to filter and display all commerce product sales by date in a block.

Understanding the Allowed Values List

Before we dive into the code, let's take a closer look at the allowed values list in the Commerce Order settings. The list contains dates in the format DD/MM/YYYY, which will be used to filter the sales data.

Allowed Values List

Value	Date
1	01/03/2013
2	02/03/2013
3	03/03/2013
4	04/03/2013
5	05/03/2013

Creating a Custom Block

To display the sales data in a block, we need to create a custom block using the Commerce module. We will use the commerce_sales view to display the sales data.

Step 1: Create a New Block

Go to the Structure page and click on Blocks.
Click on Add block and select Custom block.
Enter a title for the block, e.g., Sales by Date.
Click on Save.

Step 2: Configure the Block

Go to the Structure page and click on Blocks.
Click on the Sales by Date block and click on Configure.
In the Block settings section, select commerce_sales as the View.
In the Arguments section, add a new argument with the following settings:
- Name: date
- Type: Select list (with/without gaps)
- Allowed values: commerce_sales_date
- Default value: None
Click on Save.

Step 3: Create a Custom View

Go to the Structure page and click on Views.
Click on Add view and select commerce_sales.
Enter a title for the view, e.g., Sales by Date.
Click on Save.

Step 4: Configure the View

Go to the Structure page and click on Views.
Click on the Sales by Date view and click on Configure.
In the View settings section, select commerce_sales as the Display format.
In the Fields section, add a new field with the following settings:
- Name: date
- Type: Date
- Format: DD/MM/YYYY
- Allowed values: commerce_sales_date
Click on Save.

Step 5: Add a Filter

Go to the Structure page and click on Views.
Click on the Sales by Date view and click on Configure.
In the Filters section, add a new filter with the following settings:
- Name: date
- Type: Select list (with/without gaps)
- Allowed values: commerce_sales_date
- Default value: None
Click on Save.

Step 6: Display the Sales Data

Go to the Structure page and click on Blocks.
Click on the Sales by Date block and click on Configure.
In the Block settings section, select commerce_sales as the View.
In the Arguments section, add a new argument with the following settings:
- Name: date
- Type: Select list (with/without gaps)
- Allowed values: commerce_sales_date
- Default value: None
Click on Save.

Step 7: Test the Block

Go to the Structure page and click on Blocks.
Click on the Sales by Date block and click on Place block.
Select a node to place the block on.
Click on Save.

Conclusion

In this article, we have learned how to filter and display all commerce product sales by date in a block. We created a custom block using the Commerce module and configured it to display the sales data in a block. We also added a filter to the view to allow users to select a date range. With these steps, you can now display the sales data in a block and make informed business decisions.

Example Use Cases

Displaying sales data by date in a block on a commerce website.
Creating a custom block to display sales data by date in a commerce website.
Filtering sales data by date in a block using a custom view.

Code Snippets

commerce_sales_date view:

function commerce_sales_date_view($node, $display) {
  $date = $display->getArgument('date');
  $sales_data = commerce_sales_load($date);
  return $sales_data;
}

commerce_sales view:

function commerce_sales_view($node, $display) {
  $date = $display->getArgument('date');
  $sales_data = commerce_sales_load($date);
  return $sales_data;
}

commerce_sales_date filter:

function commerce_sales_date_filter($node, $display) {
  $date = $display->getArgument('date');
  $sales_data = commerce_sales_load($date);
  return $sales_data;
}

Introduction

In our previous article, we explored how to filter and display all commerce product sales by date in a block. However, we understand that you may have some questions about the process. In this article, we will answer some of the most frequently asked questions about filtering and displaying commerce product sales by date in a block.

Q: What is the allowed values list in the Commerce Order settings?

A: The allowed values list in the Commerce Order settings is a list of dates in the format DD/MM/YYYY that will be used to filter the sales data.

Q: How do I create a custom block to display the sales data?

A: To create a custom block to display the sales data, you need to follow these steps:

Go to the Structure page and click on Blocks.
Click on Add block and select Custom block.
Enter a title for the block, e.g., Sales by Date.
Click on Save.

Q: How do I configure the block to display the sales data?

A: To configure the block to display the sales data, you need to follow these steps:

Go to the Structure page and click on Blocks.
Click on the Sales by Date block and click on Configure.
In the Block settings section, select commerce_sales as the View.
In the Arguments section, add a new argument with the following settings:
- Name: date
- Type: Select list (with/without gaps)
- Allowed values: commerce_sales_date
- Default value: None
Click on Save.

Q: How do I create a custom view to display the sales data?

A: To create a custom view to display the sales data, you need to follow these steps:

Go to the Structure page and click on Views.
Click on Add view and select commerce_sales.
Enter a title for the view, e.g., Sales by Date.
Click on Save.

Q: How do I configure the view to display the sales data?

A: To configure the view to display the sales data, you need to follow these steps:

Go to the Structure page and click on Views.
Click on the Sales by Date view and click on Configure.
In the View settings section, select commerce_sales as the Display format.
In the Fields section, add a new field with the following settings:
- Name: date
- Type: Date
- Format: DD/MM/YYYY
- Allowed values: commerce_sales_date
Click on Save.

Q: How do I add a filter to the view to allow users to select a date range?

A: To add a filter to the view to allow users to select a date range, you need to follow these steps:

Go to the Structure page and click on Views.
Click on the Sales by Date view and click on Configure.
In the Filters section, add a new filter with the following settings:
- Name: date
- Type: Select list (with/without gaps)
- Allowed values: commerce_sales_date
- Default value: None
Click on Save.

Q: How do I test the block to ensure it is working correctly?

A: To test the block to ensure it is working correctly, you need to follow these steps:

Go to the Structure page and click on Blocks.
Click on the Sales by Date block and click on Place block.
Select a node to place the block on.
Click on Save.

Q: What are some example use cases for filtering and displaying commerce product sales by date in a block?

A: Some example use cases for filtering and displaying commerce product sales by date in a block include:

Displaying sales data by date in a block on a commerce website.
Creating a custom block to display sales data by date in a commerce website.
Filtering sales data by date in a block using a custom view.

Q: What are some common issues that may arise when filtering and displaying commerce product sales by date in a block?

A: Some common issues that may arise when filtering and displaying commerce product sales by date in a block include:

The block is not displaying the sales data correctly.
The filter is not working correctly.
The view is not displaying the sales data correctly.

Conclusion

In this article, we have answered some of the most frequently asked questions about filtering and displaying commerce product sales by date in a block. We hope that this article has been helpful in providing you with the information you need to successfully filter and display commerce product sales by date in a block. If you have any further questions, please do not hesitate to contact us.