7 replies to this topic

[jdiver]

I have a client using OSCommerce for their web ordering and MOM for their order management. They were previously using MIVA for web ordering, and in the MIVA export/MOM import process were somehow able to compare the customers from their web orders with the existing customers in the MOM database and assign the CUSTNUM field for repeat customers. Does anyone know how this can be done? I have the MOM import file being created correctly, and the only problem my client has with it is that it doesn't assign the customer number, which means it duplicates customers who have ordered before. Any help or insight would be greatly appreciated.

[jdiver]

Let me ask another question, which might make the need of the first one null and void. Is the CUSTNUM only needed if the billing and shipping information isn't present in the imported file? Or does the CUSTNUM field serve another purpose as well?

[Videoflicks2004]

Let me ask another question, which might make the need of the first one null and void. Is the CUSTNUM only needed if the billing and shipping information isn't present in the imported file? Or does the CUSTNUM field serve another purpose as well?

If the customer already exists in mom you only need the CUSTNUM for future imports. During the import process, MOM will cross reference the CUSTNUM against the CMS.DBF table and fill in the billing info. You will still need to enter shipping info if there is a different ship to.

If you enter the billing info it must match the info in MOM exactly. If there is a discrepency, MOM creates a new account.

Regards,

David Narciso

[jdiver]

Thanks for the reply David. What if there is no CUSTNUM in the import file, but that customer does exist in the MOM database already? Will MOM just create it as a new account, even if the billing info matches an account already present?

[ypf1258]

Thanks for the reply David. What if there is no CUSTNUM in the import file, but that customer does exist in the MOM database already? Will MOM just create it as a new account, even if the billing info matches an account already present?

99% of the time it will match it up

[MerchantSmurf]

Jdiver,

Do you have anything setup to push order status, inventory and pricing back to Oscommerce?

[KPS]

If you enter the billing info it must match the info in MOM exactly.  If there is a  discrepency, MOM creates a new account.

If the Custnum is imported along with the billing info but the billing info is different ( the customer has updated his info online) will MOM create a new account or will the Custnum indicate to update that customer's info? If a new customer will be created, is there any other way to tell MOM to update the existing customer and not create a new one? I seem to have a major problem with duplicate customers, as even a small change in the address information will create a new record!