Skip to content
Contact us
  • There are no suggestions because the search field is empty.

Sorting Products

WizCommerce gives you multiple ways to organize your product lists: basic sorting (e.g., A-Z, Z-A, SKU ascending, price high-to-low) and custom sorting orders that match your workflow. This helps you and your customers find products in the order that makes the most sense for your business.

1. Sort Your Product List (A-Z, Price, etc.)

Use the sort menu to quickly arrange products in a logical order. The sorting menu is located just beside the filters panel on your product listing page. sort 1

How Sorting works for WizOrder (the sales rep):

Open the drop-down menu and choose how you want to sort:

  • Alphabetical A-Z: Products sorted by name, A to Z.

  • Alphabetical Z-A: Products sorted by name, Z to A.

  • Price: Low to High: Sorts items by price from lowest to highest.

  • Price: High to Low: Sorts by price from highest to lowest.

  • Newest First: Shows recently added products first.

  • SKU ID Ascending: Sorts products by their SKU code from lowest to highest.

  • SKU ID Descending: Sorts products by their SKU code from highest to lowest.

Once selected, the product list rearranges immediately.

When to use it:

  • A customer asks to see items from cheapest to most expensive.

  • You're looking for a specific product and know its name (use A-Z).

  • You want to highlight New Arrivals.

2. Set a Custom Sorting by Import/Export

Create a specific product order using Import/Export. This lets you decide exactly which products appear first, second, third, and so on, perfect for featuring bestsellers, seasonal items, or promotions at the top of your list.

Step-by-Step Instruction for Custom Sorting

  1. Access Import/Export:

    1. Navigate to the Manage button in the left sidebar of WizOrder, then click Import/Export.sort 2

       

    2. Click on the Product, then export only the fields that you want to update/change. For this article, we will update the Priority field. (Priority field is used when you want to rearrange the order of products on your product listing page) sort 3

       

Tip: Click on the 'i'  beside each field to know what it means.

  1. Review the Exported File and Make Edits

    1. When you open the Excel file, you will find three pages: Instructions, Sample, and Data Sheet.

      If you are performing import/export for the first time, we recommend reading the Instructions page and reviewing the Sample page.  sort 11

    2. To change the Priority field, navigate to the Priority column on the Data Sheet. sort 12

    3. Let’s set the priority of the first five SKU IDs in the list to 1, 2, 3, 4, and 5, respectively.sort 13

       

    4. Once you're done updating all desired fields, save the Excel sheet and import it to WizOrder. To import the saved Excel sheet, navigate to import/export, select Product, and then Import. sort7

       

    5. When importing, select only that field you modified, in this case, just the Priority field.sort 8 

  2. Import the Updated File

    1. For the final steps, follow the workflow video to complete the import. (Please note that out of all Excel pages, only the Data sheet page needs to be imported.) 

       

    2. You may check the import progress in the notification bar. To access, click on the bell icon. sort 9 

    3. Once the import is successful, all products will appear according to their new assigned priority. The five products whose priority we changed have started appearing at the top of the page. sort 10

       

Note:

  1. Leaving the Priority field empty in any row automatically sorts the product's position.

  2. When assigning a new priority value to a group of products within the same category or collection, the product with the lowest numerical value appears at the top.

 

When to use it:

  • You want certain products to always appear at the top.

  • You’re running a promotion and want featured items listed first.

  • Your team has a preferred viewing order that doesn’t match A-Z or price sorting.