Product bulk uploads limitation

The new bulk upload feature is commendable, but it still lacks usability for certain sites, especially those utilizing various groups for budgets, catalog locations, pricing engines, and other purposes. The current restriction of allowing only 5 groups in the spreadsheet renders it impractical. If a product is associated with more than 5 groups, downloading and subsequently uploading it will exclude the additional groups, causing detrimental consequences to the site's functionality.

To address this issue effectively, a better solution would involve implementing a delimited field for groups. For instance, a single column named "groups" could contain the group1:group2:group3:... format, allowing an unlimited number of groups to be accommodated. This modification not only removes the limitation on group usage but also aids in reducing the number of columns required in the upload sheet.

Furthermore, this approach can be extended to other fields such as pricing engines, Suggested Product, and potentially more, offering a consistent and versatile solution for handling various data inputs.