Changing customer id number sequence

[ron_arad]

Hello to everyone.

First, I want to thank you for reading this.

I am using Magento 1 for my main site and now I want to use Magento 2.2.6 for a test.

I plan to connect it to Braintree the same as my Magento 1 works, however, I am worried that customer id from Magento 1 and Magento 2 might create issues if they are the same.

I would like my new systems (Magento 2) to either start from a different number or add a unique prefix. Do you have some suggestions?

Thank you,

Ron

[westrop]

Hello,

I use a small script in the phpMyadmin sql statement every year.

For this year I use;

ALTER TABLE sequence_order_1 AUTO_INCREMENT=202000001;
ALTER TABLE sequence_invoice_1 AUTO_INCREMENT= 202000001;
ALTER TABLE sequence_shipment_1 AUTO_INCREMENT= 202000001;

(The _1 is the number of your store)

Regards,

rob van westrop

Use Magento 2.2.5 on justsign.nl

[mamun_paul]

If you are use any 3rd party data migration tool like UB Data Migration Tool. In that there is a setting which allows you to have the same customer id that you have in your Magento 1 site or you can also have a new sequence of the migrated  customer id.