CSV import wizard #1127

[Beyond2000]

Good day
It is creating a new item with every import.
We just want to update prices and quantity and not add new items.
I've run it 2 times and every time I got the item added as new item. I did not delete it after first attempt to see if it is something with the name. We use the SKU to update.

[Basara]

Hello.
Issue already fixed https://github.com/abantecart/abantecart-src/issues/1128

[Beyond2000]

Good day.
I've done the demo file I've given. It updated it and did not add it a second time. Then I've added the complete stock file of our physical shop. But our online shop have only at this stage 181 items and the physical shop have about 4200 items. When i did the price udpate now it added all the stock in the file and dit not update only the ones in tha online database. I have a backup of the site and tried to restore it, but all 4200 items is still there.

www.proteaapteek.co.za/shop
I want to update only items already loaded and not add stock on updates.

There is our complete stock file. (I've deleted some items in it from 232Kb to 121kb)  I will add stock on a daily basis manualy to get pictures loaded as I must first source it as I'm adding it.
How do I no get rid off all the stock online I do not want?

[Basara]

Just skip the quantity during update (do not select quantity in import wizard)

[Beyond2000]

How do I get rid of all the stock that had been loaded now? If I skip quantity during update will the stock levels update if the items is laoded?

[Basara]

Restore database backup.

[Beyond2000]

I've tried to restore backup but it did not work as mentioned earlier on this thread

[Basara]

What do you mean "not work". Any error? What type of backup (in hosting panel, in phpmyadmin, in your admin)?

[Beyond2000]

It said successfull but all the items is still there. Done on the system - data - backup/restore in the admin panel of AbanteCart

After updateting all the sql files all my name are missing.

I've deleted 1000 items of the 4000 and did the update again... without the quanity. It added the stock again!!!
The update stock ADD stock also.
After stock update (that added stock again) most of my stock names are loaded again but not all.

[Beyond2000]

Now it added the stock with a zero stock level and did not change any previously loaded stock levels.

[Basara]

Please make a clear screenshot when import so we can see your mapping and share the csv if possible (you can send scv in private message).

[Beyond2000]

CSV File

[Beyond2000]

Import print screen file

[Beyond2000]

Mapping code

YTo1OntzOjU6InRhYmxlIjtzOjg6InByb2R1Y3RzIjtzOjEwOiJpbXBvcnRfY29sIjthOjU6e2k6MDtzOjg6IkJBUiBDT0RFIjtpOjE7czoyNToiREVTQ1JJUFRJT04gT0YgU1RPQ0sgSVRFTSI7aToyO3M6MjU6IkxBU1QgQ09TVCAoVkFUIElOQ0xVU0lWRSkiO2k6MztzOjI5OiJTRUxMSU5HIFBSSUNFIChWQVQgSU5DTFVTSVZFKSI7aTo0O3M6MTM6IlNUT0NLIE9OIEhBTkQiO31zOjE1OiJwcm9kdWN0c19maWVsZHMiO2E6NTp7aTowO3M6MTI6InByb2R1Y3RzLnNrdSI7aToxO3M6MjU6InByb2R1Y3RfZGVzY3JpcHRpb25zLm5hbWUiO2k6MjtzOjEzOiJwcm9kdWN0cy5jb3N0IjtpOjM7czoxNDoicHJvZHVjdHMucHJpY2UiO2k6NDtzOjA6IiI7fXM6MTA6InVwZGF0ZV9jb2wiO2E6MTp7aTowO3M6Mjoib24iO31zOjE0OiJzZXJpYWxpemVkX21hcCI7czowOiIiO30=

[Beyond2000]

Good day.
I've done the 2 steps over of modifying the import_process.php file. The one in #1127 and #1128 and its works. I must have done some rookie  error in modifying the file.
I'm sorry for wasting time after the #1128 it is solved. It just show the warning now of no picture, but I do not worry as I know we do not use pictures during the update.

Enjoy your day.