I worked it out, the %d placeholder is for an integer, so if you change it to %s for a string it all works fine:
db_query("UPDATE {uc_product_stock} SET stock = %d WHERE sku = '%s'"
I was showing my Drupal ignorance there!
Non-numeric skus
Wed, 09/30/2009 - 11:42
#1
Non-numeric skus
Stock & Price CSV Updater By: jorditr (12 replies) Thu, 08/06/2009 - 15:14
- uc_stock_update-6.x-2.0 By: david.houlder (05/30/2010 - 00:06)
- So what does it do? By: BayerMeister (05/20/2010 - 04:37)
- Backport drupal 5 By: Jurgen8e (02/17/2010 - 15:42)
- How to export the data the 'lazy way' By: susanb (01/02/2010 - 05:21)
- Te bona pinta :-p By: calbasi (11/27/2009 - 11:35)
- Re: Stock & Price CSV Updater By: jorditr (10/10/2009 - 11:44)
- Is there any export module... By: cyaneo (11/27/2009 - 04:52)
- Non-numeric skus By: park27 (09/30/2009 - 11:42)
- Only works with numeric skus By: park27 (09/30/2009 - 05:00)
- Suggested changes By: Prasad Shir (08/31/2009 - 09:42)
- Wish to test the module By: Prasad Shir (08/26/2009 - 20:36)
- Re: Wish to test the module By: jorditr (08/30/2009 - 12:54)