Need a Magento2 Developer or MySQL expert to write SQL Script to scramble Customer data

Looking for a Magento 2 Developer - or a MySQL Expert - who can write a SQL Script that will do the following in detail:

1) Scramble the Customer First Name, Last Name, Phone Number, Email Address for all "Addresses" and "Orders".

-- Customer First & Last Name can be randomized or overwritten with a predefined list of names.

-- Customer Phone Number can be scrambled to anything (or be the same phone number for everyone).

-- Customer Email to become {customer_id}@{[login to view URL]}. Where {customer_id} is the customer id as found in the database. {[login to view URL]} is a "SET = [login to view URL]" statement.

2) Reset all customer passwords to a specific given string as set in the SQL Script (SET="Password")

3) This stand-alone SQL Script will become part of a Continuous Integration (CI) process that will "automatically de-identify" and "sterilize" the data prior to being used in a TEST or DEV environment.

4) SQL remarks should document where variables are set and anything else important within the script.

* if you want to create several smaller scripts that do a single task instead of everything at once, this is okay. Please indicate this when you chat with me. I am very open to this.


1) SQL Script should execute on Magento version 2.3.2 (or newer) without error (as long as the database has not been modified by a 3rd-party)

2) SQL Script should not break any Magento 2.3.2 functionality. Front end and Back end users should still be able to Search, Purchase products, etc. without any side-effects from running this SQL script.

3) After the SQL Script has completed, you should be able to take any 3 random customers and login to the Magento version 2.3.2 front end as this "new scrambled email & assigned password" without error.

One last thing - Too many freelancers are not reading the project description. Would you please tell me the word "Pineapple" when you reply to this project?

Please Note: I'm expecting that you will use your own Magento 2.3.2 instance on your own local computer or server to develop this script and test the script.

Kindly read through this project brief. When complete, please include in your message your best development estimate of time to complete this project so I can plan appropriately on my side.

Thank You and I look forward to talking to as many of you that wish to ask questions.

Skills: PHP, MySQL, Magento, Software Architecture, Linux

See more: freelance website, freelancer id, freelancer jobs, freelance jobs online, freelancer, find freelance work, freelancer app, freelancer company, sql developer mysql integration, need linux apache mysql security expert, mysql import sql script, need write perl script connect address, need help write python script operate telit module, vba script write sql, need write python script telit gc864quad module, script run mysql query write results csv file, find offshore developer dreamweaver php mysql expert affordable, write sql script, script write sql server, mysql sql script cron

About the Employer:
( 12 reviews ) layton, United States

Project ID: #21465687

65 freelancers are bidding on average $18/hour for this job


Good day, As per my understanding you are looking for very experienced developer having expertise in Magento2 development and customization and we can provide you our services as per your requirements. We consider ou More

$27 USD / hour
(101 Reviews)

Hi, We are expert Magento Full Stack Web developers with extensive experience in MySQL development. So, we can surely help you to write SQL Script to scramble Customer data with following details: - Scramble the Cu More

$11 USD / hour
(885 Reviews)

"I love Pineapple" With a rich exposure of 4+ years in "Magento Development" have excellent knowledge in PHP, Magento, JavaScript, jQuery, GIT and E-commerce [login to view URL] check my reviews. - Good knowledge in More

$15 USD / hour
(888 Reviews)

"Pineapple" YES, I can execute your SQL script over updated Magento 2(2.3.2) As I am Magento2 Certified Developer frontend and backend developer having 8+ years of experience. Here you can check my Magento certifica More

$16 USD / hour
(693 Reviews)

"Pineapple" Can you please share your existing website URL along with back end access so that I can analyze your website structure nad based on that I will share my estimation to complete the script as mentioned in th More

$16 USD / hour
(73 Reviews)

Hi there We are top quality full-stack developers and we are ready to work on this project, we use Version Control Systems, Staging Servers, Team Slack Channel and Task Management Tool We are focused on Web Developme More

$50 USD / hour
(190 Reviews)

"Pineapple" Hi, Its been 8 years working with Magento, I can surely help you to write custom SQL Script with (Scramble Customer details, SQL remark, Resent customer passwords) We are ready to get started right away. More

$15 USD / hour
(479 Reviews)

"Pineapple" "Magento2 and Mysql Expert" I will write a SQL Script for your Magento store where user can Search, Purchase products, etc. without any side-effects from running this SQL script. I will add "new scramble More

$12 USD / hour
(87 Reviews)

Hello, I will complete your every requirement as per your need that you have mentioned in your job details. We are group of magento experts. Will support after the work done as well. so please Come to the discussion a More

$25 USD / hour
(575 Reviews)

Hello, I have read your requirements and as per that, we can work on it. We have been successfully completed 1000+ projects in the last 10 years and obtained specialization in PHP. Portfolios explain quality work: ht More

$12 USD / hour
(150 Reviews)

>>> Pineapple <<< Yes, have vast experience in Magento 2/MYSQL and sure can write SQL script to scramble customer data and execute on Magento 2.3.2 as per mentioned requirements. >> Kindly initiate the interview to More

$16 USD / hour
(70 Reviews)

Hello, I am Expert Magento 2 & 1 developer ( 10+ years) and Love to Play with SQL Script. I have masters idea to Complex data Scripting from Multiple table with simple manner so that it will be fast process. Please i More

$16 USD / hour
(54 Reviews)

Pineapple Hi there, Hope you doing great !!! I Am " Magento 2 frontend& Backend developer" and fully expertise in Magento2 store development,Magento2x migration magento2 speed optimise,Magento2 Customization,Magento More

$15 USD / hour
(101 Reviews)

Hello, Thank you for sharing such an interesting project, I would like to apply for this job. I have 8 years of experience working on Magento, You can take a look at my previous projects here, I have built them from A More

$15 USD / hour
(292 Reviews)

Hello Greetings....!! I have a team of experience developers and a long list of satisfied clients...offering you very cheap rate with sure please give us a chance to start our business relation. we do h More

$6 USD / hour
(205 Reviews)

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can do your Magento2 development tasks MySQL expert to write SQL Script to scramble Customer data according to your More

$15 USD / hour
(211 Reviews)

Hello, I have checked your job description as you mentioned and I am able to do this work because I have done many projects in this field and completed customized project, Please review my profile so we can discuss mo More

$15 USD / hour
(281 Reviews)

Please connect back I have some query to discuss with you. Hello, Dear Hiring Manager, ‌I have gone through your job posting on that you are looking for the Web developer for your project. I will assist you with th More

$11 USD / hour
(200 Reviews)

"Pineapple" Hi! I can surely write a SQL Script according to your mentioned details and regarding the budget/Time Estimation of the project we can discuss during the meeting so please feel free to contact me. I have More

$16 USD / hour
(56 Reviews)

Hello. I think the cleanest way to do this is create a module with a console command that can be put in cron or run manually. If you use a deploy tool like fabric or capistrano the console command can also be integrate More

$20 USD / hour
(166 Reviews)