Hi There,
We currently have an online shop called www.thegardenrose.co.uk/shop (site 1), I have setup another domain and setup a second site on our opencart installation called www.lovebritishliving.co.uk(site 2)
So far that's all great but we wanted to know if there was a way of activating all current stock on site 1 on site 2 along with all the categories in one foul swoop !
It's getting very boring activating all the products one at a time.
Many Thanks in advance
Luke
No, there isnt such an option in opencart(I dont know about any extension). The point is that generally the stores wouldnt have the same products assigned to them.
You could do a sql query thru phpmyadmin. I forget the syntax, but basically replace the field that assigns the product to the stores with both store ids instead of 1.
Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
Just make sure to back up your database before running any UPDATE query's via php myadmin.labeshops wrote:You could do a sql query thru phpmyadmin. I forget the syntax, but basically replace the field that assigns the product to the stores with both store ids instead of 1.
The database idea sounds like a good move, my experience with Phpmyadmin is rather slim, I know how to run quotes in there to create new tables and entries so if anybody knows what I would need to tap in the box and push go that would be fantastic.
Many Thanks for your input so far
Luke
Many Thanks for your input so far
Luke
Yeah, I haven't done a lot with sql queries in probably 5-8 years so would be hesitate to give you the query to run (and be sure to back up the database before you try!)
You might read thru http://www.tizag.com/sqlTutorial/sqlinsert.php and give it a go.
http://forum.opencart.com/viewtopic.php ... 1&p=242665 might help to - there is script there to run (again after backing up everything!)
You might read thru http://www.tizag.com/sqlTutorial/sqlinsert.php and give it a go.
http://forum.opencart.com/viewtopic.php ... 1&p=242665 might help to - there is script there to run (again after backing up everything!)
Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.
In your opencart admin, go to system > backup and backup the product_to_store table(only that table, unselect the others), open the sql in notepad++ and on each line replace 0 with your new store's id.Also delete the first line from the sql(the one with truncate). Then in phpmyadmin select your store's database and import the newly edited sql.
Free extension to enable / disable multiple products at a time: http://www.opencart.com/index.php?route ... n_id=12115
Who is online
Users browsing this forum: No registered users and 244 guests
