jcmil Posted July 6, 2012 Share Posted July 6, 2012 I have several carrier services listed with unique weight/pricing tables. In this instance Royal mail 1st class & Special delivery would be offered & SD would show incorrect S&H price. It occurred on only one item, where SD would either give the same price value as 1st Class or the maximum weight SD price, depending on PS version. (1.4.2.5 or 1.4.8.2) Finding the issue was related to a single item & only if added alone to an order (i.e. a single item order), I've discovered that the SEO string appears to have been the culprit. Whilst the max is apparently 255 chars, & the string was 240+ only by reducing the string below 235 was I able to get the correct SD price to display. I assume the cells have somehow been bumped in terms of internal references. I find this odd & a bit worrying. Hopefully this info will help resolve any similar 'bugs' in the future. Link to comment Share on other sites More sharing options...
jcmil Posted August 3, 2012 Author Share Posted August 3, 2012 In the event that anyone is having the same problem - The issue seems related to odd interaction with the DB, for some reason the fields are 'shifted' to higher or lower values. What is interesting is that if I do an internal PS DB backup, immediately following modifying a product, that product will generate incorrect S&H values. I discovered the solution was to edit the 'problem' product (I increased the weight by 1gram) & then saved it & then the FO S&H function worked as it should. Bearing in mind that I wiped the old install & did a fresh install & restore of the DB after an 'autoupgrade' failure, this suggests an error is generated by the backup routine. As it is I also use cPanel for backups so I have got 'clean' backups, but it is something that could present serious issues if it went unnoticed. Am I the only person to see this behaviour? Link to comment Share on other sites More sharing options...
Recommended Posts