#60105 - 02/20/19 02:34 PM
How ONLINE RETAILERS use Adagio - Cust # vs Email
|
Adagio Noob
Registered: 08/06/13
Posts: 7
Loc: Texas, USA
|
1. Point of sale is our Website. 2. Customers use their emails for their online accounts and I hope we can all agree that email addresses are the norm for creating unique accounts online. 3. Adagio uses a 6 character field to identify the customer. 4. We are constantly having to manage the relationships of the online account (email address) to the customer number in Adagio. Is there a way for Adagio to allow the email address to serve as the customer number? Meaning the email address is the unique or “key identifier” for the customer.
How are others navigating this obstacle?
It would seem attractive to online retailers needing a solution like Adagio to use the email as the key identifier.
Any and all help is appreciated.
|
Top
|
|
|
|
#60108 - 02/20/19 03:14 PM
Re: How ONLINE RETAILERS use Adagio - Cust # vs Email
[Re: Softrak Support]
|
Adagio Noob
Registered: 08/06/13
Posts: 7
Loc: Texas, USA
|
Thanks for the swift response. I hope I was the catalyst for the dialogue between Consultant and Softrak.
Instead of a data structure change, if the customer number had room for 40-50 characters, that would allow unique emails to be used at that point. From there, a conversion can take place from the 6 digit numbers to the email address.
Im sure that Im oversimplifying it, however, I do find this request to be of benefit to both Softrack and my company. I better include that it could benefit many online retailers too!
|
Top
|
|
|
|
#60125 - 02/21/19 11:59 AM
Re: How ONLINE RETAILERS use Adagio - Cust # vs Email
[Re: Clay_S]
|
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
|
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
|
Top
|
|
|
|
#60170 - 02/25/19 07:05 AM
Re: How ONLINE RETAILERS use Adagio - Cust # vs Email
[Re: Retired_Guy]
|
Adagio Noob
Registered: 08/06/13
Posts: 7
Loc: Texas, USA
|
Appreciate the response and my consultant did relay the options to me. My purpose of posting was in hopes to hear from other users that are in my similar position to better understand how they navigate the obstacle. I will further investigate these options and hope I can talk to other online retailers at AOC to better understand how they work with Adagio.
|
Top
|
|
|
|
#60172 - 02/25/19 09:38 AM
Re: How ONLINE RETAILERS use Adagio - Cust # vs Email
[Re: Clay_S]
|
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
|
Hi Clay,
I guess it would help if we understood what information you were trying to get into Adagio and through Adagio. I don't see how making the email address a key helps you out. Are you importing Orders? Invoices? Shipments? Payments?
What is your web store sending you, and in what format?
_________________________
Andrew Bates
|
Top
|
|
|
|
#60175 - 02/25/19 10:31 AM
Re: How ONLINE RETAILERS use Adagio - Cust # vs Email
[Re: Steve Schwartz]
|
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
|
Hi Steve,
According to Lauren Stief, Link2 Systems already has a solution that does exactly that. However, they have not yet updated it to be compatible with OE 9.3.
This has to be a two stage process because Import Orders insists that the customer already exist in Receivables. What is the OrderEntry import to do with those orders for non-existent emails?
_________________________
Andrew Bates
|
Top
|
|
|
|
#60187 - 02/26/19 06:38 AM
Re: How ONLINE RETAILERS use Adagio - Cust # vs Email
[Re: Retired_Guy]
|
Adagio ADP
Registered: 02/19/09
Posts: 197
Loc: Toronto, Canada
|
Hello Clay,
Lenmax Software Solutions is about to complete the new development of the importer/mapper utility that will allow user/installer to map ASCII, XML, MS Excel, EDI X12 files and ODBC data sources originated on web/ecommerce websites (like Shopify, PrestaShop, Magento, Woocommerce) and import into OrderEntry or SalesCQ in manual or automated modes. The utility will provision the logic and ability to create customer/prospect record for the new email(s) that cannot be found in AC or CQ
Let me know if you are interested Thank you
_________________________
Vlad Maksymiv Lenmax Software Solutions Inc. www.lenmax.com
|
Top
|
|
|
|
#60189 - 02/26/19 09:27 AM
Re: How ONLINE RETAILERS use Adagio - Cust # vs Email
[Re: Vlad Maksymiv]
|
Adagio ADP
Registered: 02/19/09
Posts: 197
Loc: Toronto, Canada
|
Sorry , I meant AR
_________________________
Vlad Maksymiv Lenmax Software Solutions Inc. www.lenmax.com
|
Top
|
|
|
|
|
0 registered (),
37
Guests and
1
Spider online. |
Key:
Admin,
Global Mod,
Mod
|
|
1865 Members
5 Forums
14471 Topics
70679 Posts
Max Online: 432 @ 01/20/25 10:17 PM
|
|
|
|
|
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
29
|
30
|
31
|
|
|