Try SureDone for FREE today!

We're software that helps growing brands & retailers grow and scale. Sync, sell and ship your products and inventory on online marketplaces and storefronts faster, easier and more accurately.

Adding A Spell Checker & Syntax Restrictions

Objective: 

To enhance data quality and consistency in our system by implementing response restrictions and syntax validation mechanisms.


Issue: 

We have observed that users often enter responses with varying formats, spellings, and abbreviations. This inconsistency can lead to data inaccuracies, misinterpretations, and increased time spent on data cleaning and validation. A common example is the different ways users might input units of measurement such as "Inches", "In'", or simply ".

Proposed Solutions:

Spell Checker Integration:

Implement a spell checker to automatically detect and correct spelling errors in user responses. This will ensure that responses are free from typos and misspellings, improving overall data quality.


Syntax Validation:

Introduce a syntax validation feature to standardize the format of specific fields. For instance, enforce a consistent input for units of measurement by validating and correcting entries to a predefined format (e.g., "Inches" instead of "In'" or ").


Utilize predefined templates or dropdown lists where applicable to limit the variations in user responses.


Input Restrictions:

Apply restrictions on certain fields to limit the type of input allowed. For example, restrict numeric fields to accept only numbers or date fields to accept only date formats.


Provide real time feedback to users when their input does not meet the required format, prompting them to correct it before submission.


  • Hi Colin,


    Thanks for the submission, few questions to follow up:

    • Would this be something valuable in the user interface and specifically the product single editor?
    • Would you need some of the consistencies to be defined by your account ie specific to your indusry?

    Jason

  • Hello Jason,

    Yes, I think this would be valuable in the product single editor. In our particular use case with SureDone, several employees work in SureDone all day long creating new products, and regularly, towards the end of the day, we start to see spelling, syntax, grammar, and other miscellaneous mistakes in their listings that a spell/format checker of sorts could've fixed/recognized/prevented.


    If possible yes, we try and keep our product following our industry standards to the best of our ability. If given the ability to set custom checkers and format editors to prevent some of the issues we have below, it would be very helpful and save us so much time in the future. 

    Some examples of some consistencies that we would need to flag in our specific use case are:

    • if the word "inches" were typed and fully spelled out, we'd want it to be abbreviated & flagged to be written as "Inch".
    • If someone typed out "Yagi" in the product title instead of "YAGI" it would be flagged and need to be corrected. 
    • If someone is typing out the diameter of a conduit fitting, and they format the dimensions as "3 1/2 inch" vs. "3-1/2 inch", it would get flagged or need to be revised.

    Please let me know your thoughts on the matter or if there are any more questions you may have. I'd be happy to elaborate more and help in any way I can.

    Thank you,
    Collin

  • Thanks for the clarifications, we're created an internal issue to review the requirements and will follow up in the coming weeks.

Login or Signup to post a comment