How to update multiple products

22.02.2013 14:43
#1
frizerland
Joomshopping forum user no avatar
Name: Anto
07.11.2012
Posts: 12
Quote
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
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25857
Quote
Aw: How to update multiple products

Use import
http://www.webdesigner-profi.de/joomla-webdesign/shop/import-export/universal-csv-import.html

 
23.02.2013 09:17
#3
frizerland
Joomshopping forum user no avatar
Name: Anto
07.11.2012
Posts: 12
Quote
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
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25857
Quote
Aw: How to update multiple products

Do not see a problem.
I saved as a text box 0001

 
25.02.2013 08:30
#5
frizerland
Joomshopping forum user no avatar
Name: Anto
07.11.2012
Posts: 12
Quote
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
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25857
Quote
Aw: How to update multiple products

Use other editor CSV

Try open office.

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.