Questions Import / Export: Update stock / price

StartPrev 1 2 NextEnd
01.10.2022 23:41
#1
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Questions Import / Export: Update stock / price

I think this addon would be a good choice if employees should change prices or stock quantities without changing other product details, right?

Some questions before buy:


1. Add categorie before export possible, or allways ALL products export?
2. Price: Change OLD price (via csv) also possible (after change increase in recommended retail price from supplier)
3. nothing else changed except price or quantity? (for example if accidentally change or delete the product name in the csv from the employee)

 
02.10.2022 13:07
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: Questions Import / Export: Update stock / price

1. all product exports.

2. no

3. Addon change only qty / price

 
02.10.2022 13:28
#3
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

ok. perhaps you can add the functions 1 and 2? Because it´s really helpfully, also for other users. We have often price changes from our suppliers, that changed old prices (UVP). working with csv saves much time instead to edit all products individually.

to your 3 answer: what happens, if the editor make a mistake and delete a line in the export csv and import it again? will subsequent products then be overwritten with incorrect prices?


Last change: 02.10.2022 13:33
 
02.10.2022 15:00
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: Questions Import / Export: Update stock / price

3. I do not understand you

 
02.10.2022 16:17
#5
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

no matter i ´ll try. but what do you think about my ideas?

 
02.10.2022 19:17
#6
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: Questions Import / Export: Update stock / price

Will be later.

 
02.10.2022 19:52
#7
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

ok, thanks, this are good news! But i don´t understand the logic of export. But please but look for yourself, this are product exports with attributes stock:

Example 1
Stock is 162, export ist 1620000

or
Example 2
Stock is 11, export is 11.2

Aw: Questions Import / Export: Update stock / price


Last change: 02.10.2022 19:55
 
02.10.2022 20:16
#8
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

Seems like factor x10000
but where coming from the 11.2 from stock 11?


Last change: 02.10.2022 20:18
 
02.10.2022 21:40
#9
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: Questions Import / Export: Update stock / price

Send me example csv

 
02.10.2022 21:48
#10
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

sended you in pvt

 
03.10.2022 08:03
#11
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: Questions Import / Export: Update stock / price

Problem in your editor.

Try use open ofice
or
Excel (not open file)
Data > import csv
Aw: Questions Import / Export: Update stock / price

 
03.10.2022 08:26
#12
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

I used Google Tabellen. Also for all other exports. With all other export works perfekt, but why dosn´t it works with it? I don´t won´t another Tool like Excel, OpenOffice or...

Following problem:

1. With OpenOffice stocks with endlessly (+) are 0.00? Is stock really 0 (edit 0.00 to 0) after import also endlessly not 0. mean: out of stock not possible

edit: after import with Open Office edit endlessly stock is 0 (not available!)

2. And Main-Product with Attributes is displayed total stock in List, possible to hide main product if attributes present?
i think, this is confused, sorry

3. If delete by mistake main Product stock, the totals stock of product list is wrong

Aw: Questions Import / Export: Update stock / price


Last change: 03.10.2022 10:21
 
03.10.2022 22:06
#13
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: Questions Import / Export: Update stock / price

Update stock 2.2.0 (JoomShopping 5.0.0+)
Added category filter
fix number format 8.0000 => 8

 
03.10.2022 22:37
#14
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

Great, thank you - with category perfekt :) ! Edit with OpenOffice Calc is working. But follwing bug:

Change from quantity number (for example 12) to + (endlessly) works though but not back from + (endlessly) to quantity number. After that, Stock is still endlessly.

And hope farther for additional column "OLD Price" in Export Price.

Thanks in Advance.


Last change: 03.10.2022 22:39
 
04.10.2022 14:26
#15
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: Questions Import / Export: Update stock / price

Update stock 2.3.0 (JoomShopping 5.0.0+)

 
04.10.2022 14:50
#16
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

Fantastic! This Tool save so much time for price edits. Thank you!!

 
05.10.2022 15:21
#17
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

Found Bug: After import Prices produts with Addons have wrong Stock in Productlist

Example:
Product A:
Attribute 1: Price 11.35
Attribute 2: Price 15.1

Products in Stock 26.45 (Productlist). the prices for the number of items are added up in the stock-field.

But Stock in Product Attribute is right.

I hope this doesn't affect other functions.

Please repair.
Aw: Questions Import / Export: Update stock / price


Last change: 05.10.2022 15:49
 
05.10.2022 15:45
#18
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

* Addition:

I did more tests! apparently ,,just" a cosmetic bug. After placed an order with the affected product, the stock is corrected again to correct value on the product overview page.

Nevertheless it would be good if this bug would be corrected.

 
05.10.2022 21:57
#19
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: Questions Import / Export: Update stock / price

Bug fixed.
Update stock 2.3.1 (JoomShopping 5.0.0+)

 
06.10.2022 07:49
#20
spike77
Joomshopping forum user no avatar
Name: Manfred
30.04.2015
Posts: 706
Quote
Aw: Questions Import / Export: Update stock / price

now everything works fine. thx.

 
StartPrev 1 2 NextEnd


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.