1. Home
  2. Point-Of-Sale Software
  3. Importing customer addresses

Importing customer addresses

I am trying to import about 1000 customers and customer addresses from an external system into RMS. I have the external system's customer data, including their address, in a SQL table I created in the Store Operations database, and will later drop.

I've imported the customers and populated the address fields in the Customer record. Initially, the PrimaryShipToID field is set to 0. Next, I am creating ShipTo records from that Customer's record (each customer has one and only one ShipTo address). Immediately after, I am updating the Customer table, setting the PrimaryShipToID in the customer record to the ID for that customer's ShipTo address.

However, when I bring up the customer in Store Operations Manager and view the customer information, nothing appears on the Shipping Address tab.

What field(s) in what table(s) has to be populated to 1. get the address to appear on that tab, and 2. set that address to the primary shipping address?

I can post or email my SQL script if desired.

Bill Yater The Worth Collection snipped-for-privacy@worthltd.com

Reply to
Bill Yater
Loading thread data ...

Bill,

To get the shipping address to show up in the 'Shipping Address' tab, the ShipTo.CustomerID must match the Customer.ID.

To have it show up as primary, the Customer.PrimaryShipToID must match the ShipTo.ID

- Evan Culver New West Technologies

To create the shipp> I am trying to import about 1000 customers and customer addresses from an

Reply to
Evan Culver

I've done that. After inserting the rows into Customer and Shipto, I run the following statement:

update customer set PrimaryShipToID = isnull((select max(ID) from Shipto where shipto.customerID = customer.id group by shipto.customerid),0) where customer.PrimaryShipToID = 0

That assigns the most recent (highest-numbered) address for each customer as their Primary Ship To ID

I can even verify that information with this statement:

select customer.id, customer.accountnumber, customer.firstname, customer.lastname, customer.primaryshiptoid, shipto.id, shipto.customerid, shipto.address, shipto.city, shipto.state from customer inner join shipto on shipto.customerid = customer.id and customer.primaryshiptoid = shipto.id order by customer.accountnumber

It shows that customer ID 123 has a primary address ID of 456, and address ID 456 is for customer ID 123.

However, when I go into Store Ops Manager and view customer 123, I do not see any shipping addresses.

I've got an RMS var/trainer/support person coming to my office in a half-hour on an unrelated matter. Maybe he can help.

Bill

"Evan Culver" wrote:

Reply to
Bill Yater

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.