MoveM from PrestaShop but Models weren't updated need mySQL

Quote

Post by SavSiteDesign » Wed Jan 25, 2017 8:30 pm

I need to know what table and field in the mySQL database corresponds to the Model in the admin section for the products so that I can run a SQL query on the backend rather than updating each product by hand.
Thanks
H
SavSiteDesign
Newbie
Posts
19
Joined
Tue Apr 17, 2012 6:32 pm
Top

Re: MoveM from PrestaShop but Models weren't updated need my

Quote

Post by uksitebuilder » Wed Jan 25, 2017 8:34 pm

Use phpmyadmin and view the structure of any table with the word 'product' in it's name
User avatar
uksitebuilder
Guru Member
Posts
7716
Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom
Top

Re: MoveM from PrestaShop but Models weren't updated need my

Quote

Post by SavSiteDesign » Fri Feb 10, 2017 7:46 pm

I have done that, I need to know what table within the database contains the model so that I can write a mySQL script that will set p.name = p.model or something to that effect.
SavSiteDesign
Newbie
Posts
19
Joined
Tue Apr 17, 2012 6:32 pm
Top

Re: MoveM from PrestaShop but Models weren't updated need my

Quote

Post by agatha65 » Sat Feb 11, 2017 2:31 am

oc_product
https://github.com/opencart/opencart/bl ... encart.sql

Suppliers Module - XML, CSV, XLS Product Feed Import and Update
Rich Snippets | Facebook Open Graph Meta Tags | WebP Images
Image

User avatar
agatha65
Active Member
Posts
365
Joined
Fri Mar 16, 2012 10:18 am
Location - Canada, QC
Top
Post Reply
Return to “Installation, Upgrade, & Config Support”
Who is online

Users browsing this forum: No registered users and 12 guests