PeterVD Posted September 25, 2015 Share Posted September 25, 2015 Hello, So I'm importing several tables from several suppliers, some with the same reference, except, some use CAPS and others don't. This generates duplicates. How can I make prestashop to disable case-sensitive? Link to comment Share on other sites More sharing options...
RogueWaveLimited Posted September 25, 2015 Share Posted September 25, 2015 You cannot disable this. It is actually a function of the mySql database. In the past we have gotten around this by prefixing item references with a supplier prefix. Link to comment Share on other sites More sharing options...
PeterVD Posted September 25, 2015 Author Share Posted September 25, 2015 You cannot disable this. It is actually a function of the mySql database. In the past we have gotten around this by prefixing item references with a supplier prefix. Uhm, that's a good option actually, but that will make 2 items with 2 different prices (for example products with % comission). Some suppliers differ on prices. Anyway, I'll try to disable Case-Sensitive on MySQL today and give feedback. Thanks for the info. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now