PHP MySQL Related Project


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:









Table “price_spec_a_1” structure with example data 1:




Table "cat_a_1" Structure with example data 1:

id, data, cat_id



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


Step 1

Connect to database using supplied information

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

Table structure


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


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


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

See more: 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, php mysql website project, php mysql gsmarena project, php mysql related videos, php mysql template project, php mysql simple project, php mysql simple project database, php mysql sample project

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

Project ID: #16075261

Awarded to:

$150 USD in 8 days
(280 Reviews)

15 freelancers are bidding on average $194 for this job


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)
$222 USD in 9 days
(114 Reviews)
$150 USD in 3 days
(83 Reviews)

We're Opencart experts - [url removed, login to view] & 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)

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)

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)

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)

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)

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)

A proposal has not yet been provided

$100 USD in 3 days
(33 Reviews)

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)

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)

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

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