01.10.2022 23:41
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Questions Import / Export: Update stock / price
1. all product exports.
2. no
3. Addon change only qty / price
|
|
02.10.2022 13:28
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Questions Import / Export: Update stock / price
3. I do not understand you
|
|
02.10.2022 16:17
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Questions Import / Export: Update stock / price
Will be later.
|
|
02.10.2022 19:52
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
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
Last change: 02.10.2022 19:55
|
|
02.10.2022 20:16
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Questions Import / Export: Update stock / price
Send me example csv
|
|
02.10.2022 21:48
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
Aw: Questions Import / Export: Update stock / price
sended you in pvt
|
|
03.10.2022 08:03
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Questions Import / Export: Update stock / price
Problem in your editor.
Try use open ofice
or
Excel (not open file)
Data > import csv
|
|
03.10.2022 08:26
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
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
Last change: 03.10.2022 10:21
|
|
03.10.2022 22:06
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
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
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Questions Import / Export: Update stock / price
Update stock 2.3.0 (JoomShopping 5.0.0+)
|
|
04.10.2022 14:50
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
Aw: Questions Import / Export: Update stock / price
Fantastic! This Tool save so much time for price edits. Thank you!!
|
|
05.10.2022 15:21
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
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.
Last change: 05.10.2022 15:49
|
|
05.10.2022 15:45
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
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
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25938
|
Aw: Questions Import / Export: Update stock / price
Bug fixed.
Update stock 2.3.1 (JoomShopping 5.0.0+)
|
|
06.10.2022 07:49
|
|
spike77
Name: Manfred
30.04.2015
Posts: 706
|
Aw: Questions Import / Export: Update stock / price
now everything works fine. thx.
|
|