GAPS item import script is incorrect

[jmbrunskill]

What went wrong? 😲

Some items were incorrectly conflated due to duplicate mSupply item_codes created.
We need to separate these out so they're not duplicated.

Packaging Volumes are off by a factor of 1000 (needs a conversion)

Cold storage types are mapped based on names or strict mapping, should be based on a range e.g. +5 should be between 0 and 10 degrees -20 between -30 and -10, etc.

Variant names are too long and can't be viewed correctly in the UI

Expected behaviour 🤔

Improved setup of gaps items

How to Reproduce 🔨

Steps to reproduce the behaviour:

1. Run create_gaps_item_sql_script
2. Run the output in the generated file (on a fresh db)
3. Check the items are setup correctly

Your environment 🌱

• Open mSupply Version:
• Legacy mSupply Central Server Version:

• Platform:

• Database type:

[adamdewey]

I think good to go with these ranges @jmbrunskill

[adamdewey]

One other thing @jmbrunskill - some of the variant names are too long and user can't distinguish between them in the UI as they get cut off.

So think we need to revisit the naming...