ECommerce Sorting by Number

Design help Ecommerce
1

I am building an ecommerce page for a fundraiser, and each item is named by number. I am using the CSV upload because the sale will be at least 1500 items. Right now I am using a sample collection of 100 items from a previous sale.

I need to sort the items numerically but finding it virtually impossible. I cannot implement my own fields into the CSV upload, and I tried using the “weight” field which works as a numerical field but webflow will not allow me to sort the items by this field. Alphabetical sorting looks like “1, 10, 100…”.

I tried using finsweets CMS sorting (which is on this page) but it doesn’t seem to working? Does anyone have any experience with this or have a script that could help with this issue? I asked GPT to write a JavaScript to sort by the weight category but I haven’t tried implementing it because I have a hard time ever getting GPT’s scripts to run on Webflow.

Please help. <3

Here is my site Read-Only: Webflow - Postcards from the Edge
(how to share your site Read-Only link)

https://preview.webflow.com/preview/postcards-from-the-edge?utm_medium=preview_link&utm_source=designer&utm_content=postcards-from-the-edge&preview=f0c90509a44dfbfb4b751a18b8da1809&pageId=672a68bc60e4e0f6a1e4e18c&workflow=preview

2

With 1500 items the challenge would be sorting across pages. I’d lean into FS Sort + FS Load for this, if you can get your postcard number into a numeric field for effective sorting.

I don’t know the current state of custom field imports for ECom, but that’s where you’d start- create a custom numeric field and try to import your postcard number in from CSV. Alternately you might have to use the API which adds a good deal of work.

As a hacky backup plan, if you shift your product naming convention to a three-digit format like Postcard #082, you can confidently sort on the product name itself, which sidesteps any CSV import issues.