Completed

PHP MySQL Related Project

Tables

General Opencart 3.2.0 and in addition tables = source_1,cat_a_1 , price_spec_a_1,status_a_1

Table "source_1" structure with example data 1:

id,value

1;1

2;99

3;4

4;1.5

5;1.9

6;1

7;1

Table “price_spec_a_1” structure with example data 1:

Id,value

1001;15.15

1002;16.90

Table "cat_a_1" Structure with example data 1:

id, data, cat_id

1001;4005

1002;4006

1 = Category Calc

2 = Price last value

3 = Price Plus specific value (shipment costs)

4 = Chosen Buy price method times given value = Sell price (Special Price)

5 = Result of “4” times given value = Usual Price (Main Price)

6 = Price Buy from manufacterer

7 = Status

Steps

Step 1

Connect to database using supplied information

Go to supplied database table (in this case it’s table “eug_co”)

Table structure

Id;data

1;[url removed, login to view]

2;[url removed, login to view]

Go to supplied id (will be defined differently for each file (in this example id will be “2”))

Id=2 vale is [url removed, login to view]

Download the given file and naming it by given id and current timestamp ([url removed, login to view])

Connect to another database (connection details will be also supplied)

Import the data from the xlsx file into tables wich will be also supplied (for this example it will be source_1,cat_a_1 , price_spec_a_1,status_a_1)

After the process is done I want it to run the steps 2,3 and 4 that are given after this step

After the whole process is done I want it to give a text response (pure text) that is saying “success”

I will need the configurable parts to be at the top of the file

Config 1

Config 2

Config 3

Etc etc

Code

End file

I need the whole process to be in just one php file that I can multiply as I want and make the necessary configurations from the code within

Step 2

Price Calc 1

Tables related :source_1, price_spec_a_1, oc_product_special, oc_product

If table “Source_1” column “id” 6 column “value” is = value “1” then go to Table “price_spec_a_1” and for every single id make the calculation as Column “value” first adds (+) value from Table “Source_1” id 3 then times the result in id 4 and changes the resulted values last (after character “.”) with value given in 2 and relay the resulted are to table “oc_product_special” by the given id in the column “price”, then go to Table “source_” and make the same calculation only excluding the id 3 and instead of using id “4” use id “5”

If to give an example

Table “oc_product_special” = 1001;52.60

Table “spec_a_1” = 1001;45.50

Table “source_1” id 6 = 1

Table “source_1” id 4 = 1.2

Table “source_1” id 3 = 4

Table “source_1” id 2 = 99

Table “source_1” id 5 = 1.4

Then 1001 id value 45.50 + 4 = 49.50 * 1.2 = 59.4 (trim) = 59.00 (add_last) = 59.99 * 1.4 = 83.986 (trim) = 83.00 (add_last) = 83.99

So the product id 1001 in table “oc_product_special” = 1001;59.99 instead of 1001;52.60 and the product id 1001 in table “oc_product” will be 83.99 (or if it makes it easier 1001;83.99) (also column”price”)

Step 3

Category Calc

Tables related :source_1, cat_a_1, oc_product_to_category, oc_product

If table “source_1” id “1” = value “1” then relay given data in table “cat_a_1” to table “oc_product_to_category” but only the given id

If to give an example

Table “oc_product_to_category” = 1001;5000

Table “cat_a_1” = 1001;4005

Then table “oc_product_to_category” = 1001;4005

Step 4

Product close/open

Tables related :source_1, status_a_1, oc_product

If table “source_1” id “7” = value “1” then relay data from table “status_a_1” to table “oc_product” just like in step 2 but with a slight modification

If to give an example

Table “oc_product” = 1001;1

Table “status_a_1” = 1001;0

Then table “oc_product” = 1001;0

This is an important project, please read very carefully before asking any questions because I think I have explained the algorithm of the process as clearly as possible

Regards

Skills: HTML, MySQL, Open Cart, PHP, Software Architecture

See more: projects in php and mysql udemy, the complete web development course - learn by building apps, projects in php and mysql udemy download, projects in php and mysql udemy free download, master php-mysql by building 10 projects, complete php mysql project, php mysql sample projects with source code, php mysql projects for beginners, php mysql library project, php mysql gnu project, php mysql example project, simple php mysql free project, php mysql symple project sample, website security php mysql application project, php mysql sample project coding

About the Employer:
( 2 reviews ) İstanbul, Turkey

Project ID: #16075261

Awarded to:

$150 USD in 8 days
(280 Reviews)
6.7

15 freelancers are bidding on average $194 for this job

trinkaljuneja

I've been designing small to mid size Opencart websites for 8 years. I specialize in Opencart Template, Integrating kinds of api like payment processing, Shipping api, Crm API etc.

$200 USD in 3 days
(208 Reviews)
6.6
$222 USD in 9 days
(114 Reviews)
6.7
$150 USD in 3 days
(83 Reviews)
5.7
protovosolutions

We're Opencart experts - [login to view URL] & would like to help you with PHP MySQL related project. Opencart customization, API integration, bug fixing, and advanced development is our expertise! Opencart Portfo More

$250 USD in 10 days
(40 Reviews)
5.2
ludwig333

hello i have read your description very carefully. i understand what to do exactly. i can do your job in time.

$155 USD in 3 days
(16 Reviews)
5.2
bouguima123

Hello Man, i'm a PHP expert i have already do many opencart project trust me i can give a perfect and quickly jobs regards Omar

$222 USD in 10 days
(20 Reviews)
5.2
kuhu106

PHP OPENCART EXPERTS! Hi, Greetings! Thank you for sharing a chance to work with you. We are a team of 7+ years experienced full-time dedicated freelancers having expertise on Web design with development & iOS a More

$430 USD in 8 days
(5 Reviews)
4.5
bharatchhabra13

Hello, Hey, I am Bharat a Web designer with 10+ years experience based in India. Your project is my skill set and would like to discuss further. We specialize in PHP & PHP frameworks, WordPress & Woocommerce, Ope More

$155 USD in 3 days
(16 Reviews)
4.2
alea001

Hi Greetings from ALEA ! Based on the details provided we would be keen to show our interest in working on the same & can assure you that we have the team which can deliver you what you are looking for and commi More

$250 USD in 7 days
(5 Reviews)
3.7
mayankinnovative

A proposal has not yet been provided

$100 USD in 3 days
(33 Reviews)
3.3
rashmisingh2990

I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.

$155 USD in 3 days
(6 Reviews)
3.0
silicolabs

Hi there , if you are interested to talk please come the chat to discuss more. We have experience with php and mysql

$155 USD in 3 days
(0 Reviews)
0.0
khakanhayder

hi firstly,i had worked in such [login to view URL] will be relaible for you to work with [login to view URL],i need chance to make profile here so it will be my best for you.

$166 USD in 7 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0