Custom Sort Order for Products in CTGY

[gmanning]

We are switching over to built in search and faceting in Miva from SearchSpring. We currently use a custom sorting based on a custom field driven by our ERP system. Is there any way to use that in the page builder category listing component? I don't think it's supported.

Conversely, is there a way to import the display order to replicate the manual sorting functionality in the admin? If that's possible I could import my custom values that way.

[Nick]

gmanning Using a custom field to sort the products within the Product Listing Flex Component will be available in the next update 10.13.03

As for your other ask, there is no way to adjust the display order of products using an import.

[gmanning]

I can definitely wait for the update. It's not a "must have" currently. Thanks Nick!

[gmanning]

gmanning Using a custom field to sort the products within the Product Listing Flex Component will be available in the next update 10.13.03

As for your other ask, there is no way to adjust the display order of products using an import.

Hi Nick,

See here: https://www.miva.com/forums/forum/on...-field-sort-by

Is there a way to get the sort to treat the custom field as numeric? It's sorting the values as text.

[Kent Multer]

Just off the top of my head: if you pad the numeric values with leading zeroes, so that they are all the same number of digits, then an "alphabetic" sort will put them in numerical order. If these values are going to be displayed to customers, you might want to put some code in the page templates to remove the zeroes. Not the most elegant solution, but it might serve.

[gmanning]

Just off the top of my head: if you pad the numeric values with leading zeroes, so that they are all the same number of digits, then an "alphabetic" sort will put them in numerical order. If these values are going to be displayed to customers, you might want to put some code in the page templates to remove the zeroes. Not the most elegant solution, but it might serve.

Perfect! Won't be customer facing so I just need to pad the output from my ERP that I use to fill in the custom field.