1
Support / Update add not active stock 2x on sql database
« on: August 08, 2018, 09:42:38 AM »
Good day
With all my efforts to pinpoint my problem of not all of the stock update on my update run I found the following issue.
I logged in on the C-panel and looked up the product line on the sql database. to my shock I have 1500 pages of 250 rows per page stock!!! I sorted it according to the SKU columb. There are about 80 to 100 lines of the same sku number. I delete for 3 hours and suddenly think I must do a test run on the update.
Then the SKU numbers I deleted appeared again 2 times and I ran the update only one time
attached is my mapping.
the update program also attached
my data file that I'm using to export is at the following link.
https://drive.google.com/open?id=19haJLxgt67MnL_R8j12SOoc-0WqQ70FY
Can you please use that files and settings and see on the sql database itself if the stock is getting more and more with each run like mine. On the abantecart where you add the stock it shows only once.
Please help
With all my efforts to pinpoint my problem of not all of the stock update on my update run I found the following issue.
I logged in on the C-panel and looked up the product line on the sql database. to my shock I have 1500 pages of 250 rows per page stock!!! I sorted it according to the SKU columb. There are about 80 to 100 lines of the same sku number. I delete for 3 hours and suddenly think I must do a test run on the update.
Then the SKU numbers I deleted appeared again 2 times and I ran the update only one time
attached is my mapping.
the update program also attached
my data file that I'm using to export is at the following link.
https://drive.google.com/open?id=19haJLxgt67MnL_R8j12SOoc-0WqQ70FY
Can you please use that files and settings and see on the sql database itself if the stock is getting more and more with each run like mine. On the abantecart where you add the stock it shows only once.
Please help