Post by svavrek » Wed Feb 12, 2014 10:06 pm

Instead of modifying all of the products on the store for Wholesale customers, is there a way - without VQMod - to do this in bulk or is it a one by one thing...

If I could copy the entire store to another site all together and just modify a second store for wholesale only, that would be wonderful...

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by butte » Thu Feb 13, 2014 1:23 pm

(1) Using a tool such as JNeuhoff's free export/import tool, you can change prices through the entire price field (price column) in a spreadsheet (.xlsx file format) by copy/paste. For example, you can set a column to refer back to the price column.

(2) Multi-stores would accommodate that, as well.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by svavrek » Thu Feb 13, 2014 9:32 pm

Says it needs VQMod, which I am 100% against... I tried, twice, to install VQMod - even with Q's help - and it nuked the damn store both times... maybe the web server we are using doesn't like it; I don't know. So, I will look into the multiple store thing and maybe that will work.

New member

Posts

Joined
Sat May 11, 2013 12:05 am

Post by alexinoz » Sun Mar 02, 2014 7:34 pm

If you're handy with SQL you might be able to do this via phpMyAdmin or something similar, but it really depends how many products you have, and if the changes are standard (ie reduce price by 10%), or more complex by nature.

The steps you could do are as follows:
* duplicate your site and database
* get a dump of the products and edit the table in excel.
* manually write the update query in SQL to update product prices (if that is what you're changing) - then run it in phpMyAdmin. You could write a formula in excel that you then just copy/paste as an SQL queries to do this for you.

You'll need to be handy at writing SQL queries and also writing formulas in excel to do this with confidence - and it may be impractical if you have a LOT of products, but where there is a will there's a way. :)

I'm the founder of http://www.checkoutr.com.au, an Opencart specialist focused on servicing Australian micro, small and midsized businesses.


User avatar
Newbie

Posts

Joined
Sat Jan 25, 2014 7:28 pm

Who is online

Users browsing this forum: No registered users and 6 guests