RCP90 Posted July 1, 2013 Share Posted July 1, 2013 Hello, I need to bulk uodate cost prices on our website. Eventually there will be over 20k products on the website and the cost prices will change frequently. I have tested and using CSV import with the product ID it is possible to update the cost/selling prices, so that is great. The problem I have will be that i have so many products it will be difficult to track which product has which ID as new products will be added frequently Ideally I would like to be able to use the stock code reference as the ID, this would make things much simpler. I tried this but the import failed. Stock codes will be are alphanumeric. Is it possible to allow the product ID to be alphanumeric? Thank you in advance for any help Link to comment Share on other sites More sharing options...
SmartDataSoft Posted July 1, 2013 Share Posted July 1, 2013 It is not possible to add product id and made it numerical. As there is relationship id_product with other table . You have to build some kind of custom module to achieve the goal which you are referring. Link to comment Share on other sites More sharing options...
RCP90 Posted July 2, 2013 Author Share Posted July 2, 2013 It is not possible to add product id and made it numerical. As there is relationship id_product with other table . You have to build some kind of custom module to achieve the goal which you are referring. OK, thank you for that information, in that case is there a way of updating product details based in product reference? I have tried this but it will just add it as a new product Link to comment Share on other sites More sharing options...
RCP90 Posted July 8, 2013 Author Share Posted July 8, 2013 Whats about if I use Use product reference as key when originally import products? would that work. Link to comment Share on other sites More sharing options...
Recommended Posts