I'm in the process of building a web store for a friend. Importing the product list was easy enough but when I went to Import quantity discount I can't seem to get it to work. The progress bar appears and runs for a couple seconds and nothing has been uploaded but I get no error message either. Any assistance anyone can offer would be greatly appreciated.
Do you see any errors in the server error logs?
I seem to be having the same issue. Cannot import quantity pricing. I have had success with this function before. Version 4.35
I Do have a message in the error log:
Database (error)
Error: Column 'usergroup_id' cannot be null (1048)
Query: INSERT INTO cscart_product_prices (`price`, `percentage_discount`, `lower_limit`, `usergroup_id`, `product_id`) VALUES (1.7, 10, 10, NULL, 1196)
Any ideas?
Please make sure that the User group column in the feed has IDs of the active user groups only
I seem to be having the same issue. Cannot import quantity pricing. I have had success with this function before. Version 4.35
I Do have a message in the error log:
Database (error)
Error: Column 'usergroup_id' cannot be null (1048)
Query: INSERT INTO cscart_product_prices (`price`, `percentage_discount`, `lower_limit`, `usergroup_id`, `product_id`) VALUES (1.7, 10, 10, NULL, 1196)
Any ideas?
We tried to reproduce the problem on our installation but failed.
Can you please provide a sample export file that leads to this error.
Here are two files. One using user group header, one without.
My version is 4.35 free since i have not activated the liscence.
I am building the store under the site mystore.net while my actual store will be mystore.com (wich is curently a live store with a differnt shopping cart)
I did notice that user groups is inactive for free version if this is causing the issue.