Author Topic: CSV import wizard #1127  (Read 1124 times)

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
CSV import wizard #1127
« 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.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4253
  • Karma: +202/-0
    • View Profile
Re: CSV import wizard #1127
« Reply #1 on: May 25, 2018, 02:07:16 AM »
“Chuck Norris is so amazing.”
― Mother Teresa

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
Re: CSV import wizard #1127
« Reply #2 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?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4253
  • Karma: +202/-0
    • View Profile
Re: CSV import wizard #1127
« Reply #3 on: May 25, 2018, 03:11:41 AM »
Just skip the quantity during update (do not select quantity in import wizard)
“Chuck Norris is so amazing.”
― Mother Teresa

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
Re: CSV import wizard #1127
« Reply #4 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?
« Last Edit: May 25, 2018, 03:30:34 AM by proteaapteek »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4253
  • Karma: +202/-0
    • View Profile
Re: CSV import wizard #1127
« Reply #5 on: May 25, 2018, 03:30:10 AM »
Restore database backup.
“Chuck Norris is so amazing.”
― Mother Teresa

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
Re: CSV import wizard #1127
« Reply #6 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

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4253
  • Karma: +202/-0
    • View Profile
Re: CSV import wizard #1127
« Reply #7 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)?
“Chuck Norris is so amazing.”
― Mother Teresa

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
Re: CSV import wizard #1127
« Reply #8 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.
« Last Edit: May 25, 2018, 04:48:17 AM by proteaapteek »

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
Re: CSV import wizard #1127
« Reply #9 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.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4253
  • Karma: +202/-0
    • View Profile
Re: CSV import wizard #1127
« Reply #10 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).
“Chuck Norris is so amazing.”
― Mother Teresa

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
Re: CSV import wizard #1127
« Reply #11 on: May 25, 2018, 05:41:19 AM »
CSV File

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
Re: CSV import wizard #1127
« Reply #12 on: May 25, 2018, 05:45:25 AM »
Import print screen file

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
Re: CSV import wizard #1127
« Reply #13 on: May 25, 2018, 05:46:07 AM »
Mapping code

YTo1OntzOjU6InRhYmxlIjtzOjg6InByb2R1Y3RzIjtzOjEwOiJpbXBvcnRfY29sIjthOjU6e2k6MDtzOjg6IkJBUiBDT0RFIjtpOjE7czoyNToiREVTQ1JJUFRJT04gT0YgU1RPQ0sgSVRFTSI7aToyO3M6MjU6IkxBU1QgQ09TVCAoVkFUIElOQ0xVU0lWRSkiO2k6MztzOjI5OiJTRUxMSU5HIFBSSUNFIChWQVQgSU5DTFVTSVZFKSI7aTo0O3M6MTM6IlNUT0NLIE9OIEhBTkQiO31zOjE1OiJwcm9kdWN0c19maWVsZHMiO2E6NTp7aTowO3M6MTI6InByb2R1Y3RzLnNrdSI7aToxO3M6MjU6InByb2R1Y3RfZGVzY3JpcHRpb25zLm5hbWUiO2k6MjtzOjEzOiJwcm9kdWN0cy5jb3N0IjtpOjM7czoxNDoicHJvZHVjdHMucHJpY2UiO2k6NDtzOjA6IiI7fXM6MTA6InVwZGF0ZV9jb2wiO2E6MTp7aTowO3M6Mjoib24iO31zOjE0OiJzZXJpYWxpemVkX21hcCI7czowOiIiO30=

Offline Beyond2000

  • Newbie
  • *
  • Posts: 44
  • Karma: +7/-1
    • View Profile
Re: CSV import wizard #1127
« Reply #14 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.

 

Powered by SMFPacks Social Login Mod