22.02.2013 14:43
|
|
frizerland
Name: Anto
07.11.2012
Posts: 12
|
How to update multiple products
I need to update prices and qnt of multiple products (more then 5000) in quick way, but there is no such option.
So my question is where does your module store data? I have table qr3m4_jshopping_products but there are not all products in it. It drives me crazy, cause I have products on web page that does not exist in any table. I need to use simle SQL command to update prices and quantity of all products but I can't find way to do that?!
Thanks
Joomla: 2.5 JoomShopping: 3.12.2
|
|
22.02.2013 15:24
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25857
|
|
|
23.02.2013 09:17
|
|
frizerland
Name: Anto
07.11.2012
Posts: 12
|
Aw: How to update multiple products
That would work, but now there is second problem. When I export my products, EAN fiels are threated as a number and I lose all prefix zeros. If EAN is 000541 I get 541, but that's not what I want. I try to convert that field in text (excell) but that doesn't work.
|
|
23.02.2013 18:08
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25857
|
Aw: How to update multiple products
Do not see a problem.
I saved as a text box 0001
|
|
25.02.2013 08:30
|
|
frizerland
Name: Anto
07.11.2012
Posts: 12
|
Aw: How to update multiple products
Because I want update all records, I first must EXPORT all products then update file in excell and then IMPORT it back. When I EXPORT products first zeros in EAN are lost. (SS)
http://img245.imagevenue.com/img.php?image=776753401_4_122_202lo.jpg
http://img240.imagevenue.com/img.php?image=776733832_3_122_437lo.jpg
Last change: 25.02.2013 08:31
|
|
25.02.2013 10:56
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25857
|
Aw: How to update multiple products
Use other editor CSV
Try open office.
|
|