Skip to main content
Solved

Deleting Customer in Acumatica and Sync to BigCommerce


Forum|alt.badge.img
  • Jr Varsity III
  • 37 replies

We just want to confirm if this is what we expect for the connector when a customer was deleted in Acumatica. Please consider the ff:

1. A customer was created in Acumatica
2. It was synced to BigCommerce
3. Customer now exists in BC
4. Customer was deleted in Acu
5. Synced the customer in AC sync history
6. Customer still exists in BC

Is it what we are expecting? Do we have some indication in BC if a Customer was deleted from it's Acu source? Can we forbid them to log-in and place order in BC? 

Thank you
 

Best answer by smarenich

@jib87 

> Is it what we are expecting?

[SM] Yes, when you delete data you have quite some problems with data consistency. For instance, orders are left without customer record. You won’t see history of the orders and so on.

Furthermore, I would encourage to not delete customers in Acumatica too. Better to make then inactive.

 

> Do we have some indication in BC if a Customer was deleted from it's Acu source?

[SM] As far as I know, BigCommerce does not have Active/Inactive for customers.

 

> Can we forbid them to log-in and place order in BC? 

[SM] Probably change password? But they will be able to reset password again. Even if you delete them, probably they can register again.

View original
Did this topic help you find an answer to your question?

3 replies

smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • Answer
  • February 14, 2023

@jib87 

> Is it what we are expecting?

[SM] Yes, when you delete data you have quite some problems with data consistency. For instance, orders are left without customer record. You won’t see history of the orders and so on.

Furthermore, I would encourage to not delete customers in Acumatica too. Better to make then inactive.

 

> Do we have some indication in BC if a Customer was deleted from it's Acu source?

[SM] As far as I know, BigCommerce does not have Active/Inactive for customers.

 

> Can we forbid them to log-in and place order in BC? 

[SM] Probably change password? But they will be able to reset password again. Even if you delete them, probably they can register again.


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

As @smarenich said, it’s not easy to implement a deletion process in the integrated solution. However, I think it could be achieved.

First, BigCommerce doesn’t have data integrity concerns. If you delete a customer who has orders, those orders become Guest Customer orders.

Second, there is an option to use https://developer.bigcommerce.com/api-reference/82f91b58d0c98-get-all-orders before sending the DELETE request. That is, when a customer is deleted in Acumatica, before deleting it in BigCommerce, query BigCommerce, if there are any orders for this customer. And if there are none, delete the record. Otherwise, throw an error.

The only reason I’m expanding on this here, is that it might really be beneficial in situations when a website was maliciously injected with multiple new customer records, or as the author said, when you genuinely need to clean up your data.

Thank you!


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 37 replies
  • February 15, 2023

Thank you @smarenich and @Yuri Karpenko. I agree. Appreciate you expanding these scenarios, and providing tips. Great help!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings