Opened 7 hours ago
#141 assigned enhancement
Enhance bulk chemical import to handle multiple product import
| Reported by: | Mike Dewhirst | Owned by: | |
|---|---|---|---|
| Priority: | medium | Version: | 3.x |
| Keywords: | bulk import caslist | Cc: | chris.bernabe@… |
Description
The objective is to import a set of chemicals (ie., a list of CAS numbers) and simultaneously link an arbitrary number of products which have that same set of chemicals as ingredients.
It is impractical to rely on product names - which may be different in different markets - when a product ID (hereafter SKU) is designed to be reliable and is available.
Therefore, this enhancement relies entirely on a list of SKUs. It will also deal with a list of names but won't rely on them and users will be expected to make necessary product name corrections if there are any discrepancies.
A list of SKUs will each be separated by a comma. An optional list of names likewise.
For the user interface to simultaneously handle single product imports it has to remain more or less the same. For example, the software can detect one or more commas in the Product ID field and process the import as multiple products.
This ticket needs user feedback. For example, what to do with detected missing names or SKUs if lists are different lengths?
Being SKU driven, would it be appropriate for example to import a single product with multiple commas in its name if there were no commas in the Product ID (SKU) field.
