SQL Command to remove default shipping address

(0) Share

Report

Posted on by nazza

395

can someone please help me with a SQL command to remove the default shipping address from entire customers on the database?

Thank you.

All responses (5)

Answers (0)

nazza 395 on at

Like (0)

Report

RE: SQL Command to remove default shipping address

Nice one, will do that. Thank you.
ToddB on at

Like (0)

Report

RE: SQL Command to remove default shipping address

Hi Nazza,

Thank you for the information.

If you have validated that the online orders work, if there is no PrimaryShipToID assigned, then I would say test the query and validate there are no issues. Then make a backup and run against PROD.

I would suggest modifying the query to only update records that have a PrimaryShipToID assigned:

Update customer set primaryshiptoID=0 where PrimaryShipToID <> 0

I would also recommend setting security on the Set Primary button, on the Customer Properties form, so that cashiers cannot mark this:

And set security on the 'This is the primary shipping address for the customer': when creating New or editing address information:
nazza 395 on at

Like (0)

Report

RE: SQL Command to remove default shipping address

Update customer set primaryshiptoID=0

Is this correct?

Off course I will run this on dummy database before making changes in live database.
nazza 395 on at

Like (0)

Report

RE: SQL Command to remove default shipping address

Thanks mate for your reply.

Reason I want to remove default shipping address is, when order is placed online and customer chooses different address on ship to address, RMS is picking default shipping address as per RMS, it completely ignores the customer input on the web. So I think best way to solve this is to untick default shipping address

Please let me know if there is a command to do this. Thanks.
ToddB on at

Like (0)

Report

RE: SQL Command to remove default shipping address

Hi Nazza,

The PrimaryShipToID is stored in the customer table.

To view customers that have a Default Shipping Address assigned, you can run something similar to the below:

select accountnumber, firstname, lastname, PrimaryShipToID from customer where PrimaryShipToID <> 0

What is the reason you are wanting to update the default shipping address to be 0 for all customers?

NOTE: This would be an Update statement; and always make a backup of the database before running any Update, Insert or Delete statements.

_______________________________________________

Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:

https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

Dynamics Retail Management System 2.0 - Microsoft Lifecycle | Microsoft Docs

This is less than 7 weeks from now; and you can continue using RMS after this date, but technical support will not be available.

I would recommend checking with your partner regarding what they may recommend as a replacement system after the extended support end date.