Scripts or jobs that can be run to sync customer data to SP.

[chrismshea]

When doing Migrations we need to create the customers, addresses, payment profiles in subscribe pro. Each of these get an entity id from SP that needs to get posted back to SFCC.

Issues when generated ID's not mapped back to SFCC Entities:
subproCustomerID - Issue: Customer cannot see there created subscriptions
subproAddressID - Issue:
subproPaymentProfileID - Issue: If customer creates a new subscription with saved payment Instrument a 409 will be generated due to the duplicate payment token.

I would like a way to run a script/job to be able to filter and create customers/addresses/payment instruments from SFCC to SP, and write the entity IDs back to SFCC.

This negates the step to have to come back, and update these entities in SFCC with a CSV, etc.

[chrismshea]

Hi @okozllov,
For this issue I need a way to filter/create customers on SP from SFCC. Those which do not already have a SP Customer Id. Let me know if you have any questions. This is different from other tasks for keeping profiles in sync.

[okozllov]

Hi @chrismshea
As I understood You would like to add one more button to choose between synchronizing already existing customers on the SP side (only customers who have subproCustomerID on the SFCC side) and all registered customers on the site (customers with subproCustomerID and without it). Have I understood correctly?
Or we can add a filter to synchronize separately customers with subproCustomerID and customers without subproCustomerID

[chrismshea]

That's pretty much it, would like a way to sync those with SP Customer ID, and those that do not have a customer id. I'm also curious if it is possible to have other filters as options on which customers to sync. like "created since" date or something. Are there any standard customer filters available?

[okozllov]

You can find all available filters on the Merchant Tools > Customers > Customers Advanced tab
Also includes Extended Attributes

[chrismshea]

Ok, and how can that be used in the job to sync the customers? Does it have to be pre-determined or can it be easily adjusted per client as needed?

[okozllov]

Hi @chrismshea
I recorded a short video how it can be implemented. Please let me know if you don't manage to open it

Demo.for.33.mp4

[chrismshea]

Hey @okozllov that looks perfect for now!

[okozllov]

Hi @chrismshea
PR for the filters: #64