AbanteCart Community

Shopping Cart Operations => Support => Topic started by: Beyond2000 on May 24, 2018, 09:14:52 AM

Title: CSV import wizard #1127
Post by: Beyond2000 on May 24, 2018, 09:14:52 AM
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.
Title: Re: CSV import wizard #1127
Post by: Basara on May 25, 2018, 02:07:16 AM
Hello.
Issue already fixed https://github.com/abantecart/abantecart-src/issues/1128
Title: Re: CSV import wizard #1127
Post by: Beyond2000 on May 25, 2018, 03:08:52 AM
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?
Title: Re: CSV import wizard #1127
Post by: Basara on May 25, 2018, 03:11:41 AM
Just skip the quantity during update (do not select quantity in import wizard)
Title: Re: CSV import wizard #1127
Post by: Beyond2000 on May 25, 2018, 03:28:35 AM
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?
Title: Re: CSV import wizard #1127
Post by: Basara on May 25, 2018, 03:30:10 AM
Restore database backup.
Title: Re: CSV import wizard #1127
Post by: Beyond2000 on May 25, 2018, 03:31:51 AM
I've tried to restore backup but it did not work as mentioned earlier on this thread
Title: Re: CSV import wizard #1127
Post by: Basara on May 25, 2018, 03:34:02 AM
What do you mean "not work". Any error? What type of backup (in hosting panel, in phpmyadmin, in your admin)?
Title: Re: CSV import wizard #1127
Post by: Beyond2000 on May 25, 2018, 03:34:40 AM
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.
Title: Re: CSV import wizard #1127
Post by: Beyond2000 on May 25, 2018, 04:49:45 AM
Now it added the stock with a zero stock level and did not change any previously loaded stock levels.
Title: Re: CSV import wizard #1127
Post by: Basara on May 25, 2018, 04:54:31 AM
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).
Title: Re: CSV import wizard #1127
Post by: Beyond2000 on May 25, 2018, 05:41:19 AM
CSV File
Title: Re: CSV import wizard #1127
Post by: Beyond2000 on May 25, 2018, 05:45:25 AM
Import print screen file
Title: Re: CSV import wizard #1127
Post by: Beyond2000 on May 25, 2018, 05:46:07 AM
Mapping code

YTo1OntzOjU6InRhYmxlIjtzOjg6InByb2R1Y3RzIjtzOjEwOiJpbXBvcnRfY29sIjthOjU6e2k6MDtzOjg6IkJBUiBDT0RFIjtpOjE7czoyNToiREVTQ1JJUFRJT04gT0YgU1RPQ0sgSVRFTSI7aToyO3M6MjU6IkxBU1QgQ09TVCAoVkFUIElOQ0xVU0lWRSkiO2k6MztzOjI5OiJTRUxMSU5HIFBSSUNFIChWQVQgSU5DTFVTSVZFKSI7aTo0O3M6MTM6IlNUT0NLIE9OIEhBTkQiO31zOjE1OiJwcm9kdWN0c19maWVsZHMiO2E6NTp7aTowO3M6MTI6InByb2R1Y3RzLnNrdSI7aToxO3M6MjU6InByb2R1Y3RfZGVzY3JpcHRpb25zLm5hbWUiO2k6MjtzOjEzOiJwcm9kdWN0cy5jb3N0IjtpOjM7czoxNDoicHJvZHVjdHMucHJpY2UiO2k6NDtzOjA6IiI7fXM6MTA6InVwZGF0ZV9jb2wiO2E6MTp7aTowO3M6Mjoib24iO31zOjE0OiJzZXJpYWxpemVkX21hcCI7czowOiIiO30=
Title: Re: CSV import wizard #1127
Post by: Beyond2000 on May 28, 2018, 02:47:42 AM
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  :-[ :-[ :-X 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.
Title: Re: CSV import wizard #1127
Post by: Basara on May 28, 2018, 03:58:14 AM
Thank you, proteaapteek for reply back.