In Progress

WOOCOMMERCE - PROPRIETARY DATABASE integration

Currently we have a Woocommerce installation in development. We need to modify the registry customer system of this woocommerce to integrate it with a external currently working DB (external proprietary CRM, not related with wordpress and that uses his own database in SQL server with table named ‘USERS’ on it.

We want this database the main database for user/customers and that database from woocommerce is synchronized with this one for the ecommerce workflow normally.

Target:

1- Replace register page in woocommerce with our main register form. This register goes to our main DB user table (named USERS), and all data is stored in there. Our register form is the unique way to fill the data user in both systems. So when user registries in OUR database, it has to be also created in woocommerce DB tables.

We have already created a column named ‘woocommerce_id’ on our USERS table for to store the final id assigned to the user when inserted also in Woocommmerce tables.

We must have a way to unequivocally correlate both.

So there has to be also a column in user table on Woocommerce DB. A column for to store the user_id value assigned in our database has to be added to table and filled with correspondant value when new register is done. This column is still not created on woocommerce tables and to create it is a point of the task.

2- Login for the user in both sides has to be ‘the same’ (password and user_name is the same, and when is changed on one of the two DB using the user settings page, it has to change in both sides).

3- For to change user settings, it has to be in our form and simultaneously store values in both databases keeping the values synchronized.

The idea is to use API REST from woocommerce to get this synchronization

or in other case and If developer finds it is not possible, then use direct code insertion in DB (remember that we replace original register form of woocommerce with our own user registry form that already inserts customer into our own users database).

Concrete points to achieve:

1- Make that the form for a new user profile in woocommerce points to our user admin form to create a new user in DB. Currently woocommerce only shows login page, developer has to add the link to our own registry page.

Check that all values are also stored in our platform side and woocommerce side (using API).

And check that we have the columns that point from one to another in order to identify the user correctly.

For this point, user creation form will be available in virtual machine.

2- Manage a way that can be a user token, cookies, post parameters via petition or API in woocommerce to automatically log in a user in the woocommerce when the user comes identified and logged in from the website. This means in essence, that login in one of the sides must then be transparent to be applied on the other side.

For this point, login form for user currently used in our platform will be also available in virtual machine.

Delivering must include:

-All code files for to import project and to have more modifications on it in later tasks.

-A briefing document (guide) with main points of configuration (where to configure database connection and similar if needed)

Skills: WooCommerce, Microsoft SQL Server, ASP, PHP, WordPress

See more: google maps api database integration, flash database integration using php, freepbx ivr database integration, need modify product services, database integration graphical overview, google map database integration aspnet, excel spreadsheet development need require, database administration software development, asterisk ivr database integration, google map address database integration php, mysql database integration api, paypal database integration asp, paypal database integration asp script, website database integration methods, developers for hire web developer and database integration skills required will be c html5 css3 asp net java and sql, developers for hire web developer and database integration skills required will be c# html5 css3 asp net java and sql, woocommerce database integration, explain what php is and how it is used in web development to support web database integration.

About the Employer:
( 25 reviews ) Montcada i Reixac, Spain

Project ID: #30172589

Awarded to:

(319 Reviews)
8.9

50 freelancers are bidding on average €509 for this job

r4rony

##Awaiting for your reply## Hello Greetings !! Sample work (Woocommerce): [login to view URL] [login to view URL] We have read the project proposal & understand that you want to integrate database. We ha More

€500 EUR in 7 days
(212 Reviews)
8.9
(540 Reviews)
8.7
(339 Reviews)
7.8
WordpressHeroes

Hi! I'm Vartolomei from Wordpress Heroes How we can finish your project in time and perfect? The communication is very important! Send me a message now, and we can discuss everything! I have read the project requirem More

€350 EUR in 2 days
(230 Reviews)
7.8
gauravgargcs

hello, i understand your whole project requirements , i can do you work which you describe in your work description , i am expert in woo commerce , please come on chat so we can share your work , thank you Gaurav More

€500 EUR in 7 days
(136 Reviews)
7.4
(65 Reviews)
7.7
AzzkaNoor

Hi. Experienced developer's here, with 11 years of experience in web development. I have developed numerous scalable, secure and SaaS driven cloud-based applications. Upon reading the project details, I would like to a More

€750 EUR in 20 days
(53 Reviews)
7.6
einnovention

Hi there! I’ve carefully checked your requirements and really interested in this project of WOOCOMMERCE - PROPRIETARY DATABASE integration. I am a top freelancer and I will do it in a professional way. I have more than More

€600 EUR in 14 days
(183 Reviews)
7.4
(204 Reviews)
7.7
babitabubu

Hi I have read your job brief. I can modify the registry customer system of this WooCommerce according to your requirement and some more details you share. I have 10 years experience and built several business websit More

€650 EUR in 7 days
(170 Reviews)
7.3
Sunita0610

Hi! I have 6+ year of experience as a full stack developer, your satisfaction will be our first priority ! I have read your entire project requirements. I can create website with- - customize HTML 5, CSS 3, JS , BOO More

€500 EUR in 7 days
(180 Reviews)
7.2
(55 Reviews)
6.5
(166 Reviews)
6.7
divumanocha

Hi Thank you for reading my cover letter.!!! As you are looking for Wordpress/Woo-commerce developer So I am a highly skilled Wordpress/Woo-commerce development with more than 5 years of quality experience in designi More

€555 EUR in 20 days
(41 Reviews)
6.4
fastwebsoft

** Expert in E-commerce Website , PHP , ASP , WordPress , Microsoft SQL Server ** Hello there, Hope you are doing well in this pandemic era ! Thanks for sharing your requirements with us. We reviewed very carefully More

€700 EUR in 27 days
(32 Reviews)
6.3
(26 Reviews)
6.4
desireds

Hello, Greetings.. we are an IT company placed in India with competence in web and mobile development both. our strength is 50+ including full stack developer, mobile developer, designers, and qa/tester and we have wo More

€600 EUR in 7 days
(90 Reviews)
6.4
Marecar2020

Hello I just read job description carefully and understood clearly what do you want. My experience includes expert-level WordPress credentials with 10 years of PHP, JavaScript, and CSS. I have been built many websites More

€500 EUR in 7 days
(29 Reviews)
6.0
Shabee

Hello There, I can start Right Away!! My name is Shabeehul, and I am an Expert Web developer with 7+ years of experience in custom website development. I had done 100s of projects in the past with quality in-time del More

€500 EUR in 7 days
(28 Reviews)
6.0
(33 Reviews)
5.9