SOLVED - Default Store

Quote

Post by 440music » Mon Nov 22, 2021 9:14 am

I've imported 2500+ manufacture and want to display the names on the Brands page
https://store.440music.com/index.php?ro ... nufacturer
and I've been checking the Default check box which is taking too many hours. I've looked at the database hoping I could find and change all manufactures to Default.
is there a table and column in the database that I can go to and make the change?
Thank you 8)
Last edited by 440music on Tue Nov 23, 2021 10:22 am, edited 1 time in total.

Tommy TBones
Owner
440Music Entertainment Co
Chicago, IL
Indie Music Radio

User avatar
440music
New member
Posts
20
Joined
Wed Jun 24, 2020 8:19 am
Location - Chicago, IL USA
Top

Re: Default Store

Quote

Post by thekrotek » Mon Nov 22, 2021 3:03 pm

It's in manufacturer_to_store table.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com

User avatar
thekrotek
Expert Member
Posts
4375
Joined
Sun Jul 03, 2016 12:24 am
Top

Re: Default Store

Quote

Post by 440music » Tue Nov 23, 2021 10:22 am

Thanks I made the change and this is how I accomplished the update
I exported manufacture table and opened with a spread sheet program
removed the columns name and image and saved as a CSV
The opened with text editor and removed the ( ) and all the SQL data
Imported the CSV into manufacture_to_store
success

Tommy TBones
Owner
440Music Entertainment Co
Chicago, IL
Indie Music Radio

User avatar
440music
New member
Posts
20
Joined
Wed Jun 24, 2020 8:19 am
Location - Chicago, IL USA
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 138 guests