Bulk Special Price - phpMyAdmin

Quote

Post by Agathon » Tue Aug 16, 2016 4:13 am

Hi to all

I work as administrator in one electronic shop and recently they asked me to add special price to Bulk products and leave it running for some days. Of course i can change it in admin page one by one. The things is how i can change it through phpMyAdmin. ( Opencart Version 2.1.0.1 )

I have 46 products which cost 25€ and i have to add special price to 20€.

Table we have to update price is

Code: Select all

 oc_product_special
and column we have to update is

Code: Select all

oc_product_special.price
Of course we need products which cost 25€ from table

Code: Select all

oc_product
to retrieve products from this table and change price to 20€

The thing is how to connect these two tables so i can add special price which sql query to run so i can achieve this.

Code: Select all

oc_product & oc_product_special , update this column oc_product_special.price
Any help is appreciated
User avatar
Agathon
New member
Posts
80
Joined
Thu Jan 23, 2014 6:45 pm
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 19 guests