Hi Clay,
Well, expanding the customer number to 40-50 characters would be a structure change, and would require re-designing every report and screen that displays the customer code.
I don't think we'd ever insist that an email address be unique to a customer for the reasons mentioned by Support. However, we did offer to customize Adagio to enforce this to your consultant. He was going to discuss this customization with you and get back to us.
There are also solutions available from Adagio 3rd Party Developers North49, Dakota and Link2 Systems to improve integration with external web sites. North49 offers a fully integrated web solution, allowing customers to pay their accounts and see the status of their outstanding orders. Link2 has a module that automatically maps email addresses to Customer Codes and changes orders that have been imported. Dakota has a fully integrated iOS mobile solution for remote order entry.
Depending on the number of new clients arriving each day, we also suggested taking a field in the Customer record on the web site and adding the Adagio Customer code there for use in the order export.
There are a lot of different ways that companies use the web for ordering, paying for and fulfilling orders. Some leave everything up to Amazon, others just take orders and merge those into orders being submitted through other means. Some use Magento. Others use Shopify. Others have had something custom created. Almost all Adagio sites have multiple ways of getting orders into OrderEntry. Some take orders over the phone. Others receive emails. Some still receive faxes!
This is an integration problem that needs to be clarified and discussed with your Adagio Consultant to determine the best way to proceed.
_________________________
Andrew Bates