Import customers into nopcommerce by Sync plugin

Avatar
  • Total Posts: 4

Josip

I have an issue with Customers who register online and NOP stores record in Cutomer sql table without ExtId. Is it possible to create xml that will update '<CustomerExtId>' like:

<?xml version="1.0" encoding="utf-8"?>
<Customers Version="4.10">
  <Customer>
    <CustomerExtId>769329</CustomerExtId>
    <CustomerId>123</CustomerExtId>
  </Customer>

  <Customer>
    <CustomerExtId>333329</CustomerExtId>
    <CustomerId>1555</CustomerExtId>
  </Customer>
</Customers>

Avatar
  • Moderator
  • Total Posts: 85

Support

1. You can create a copy of Customer script(just in case of Sync plugin updates)
2. Set ExtId(if needed) at the beginning of the Customer script
UPDATE [dbo].[Customer] 
SET ExtId=CAST([your_uniq_id]as nvarchar(200))
WHERE Email IS NOT NULL AND ExtId IS NULL
[your_uniq_id] - unique identifier. For example: Id or Email

Active discussions

View all