Whispar1 Posted September 30, 2013 Share Posted September 30, 2013 Hello, In 1.5.3.1, I have been manually editing supplier and manufacturer references in ps_product in my database. I am doing this only because it is quicker than changing them all one at a time in the product>association and then again in product>suppliers. However, even though my sql tables clearly have the correct changes shown, only random products show the changes I made. In some cases the manufacturer reference I changed is completely wrong (i.e I set manufacturer ID as 13 but BO shows it as 16). Any idea what is going on? Thanks for any help. Link to comment Share on other sites More sharing options...
vekia Posted September 30, 2013 Share Posted September 30, 2013 its because instead of ps_product you have to modify ps_product_shop table Link to comment Share on other sites More sharing options...
Whispar1 Posted September 30, 2013 Author Share Posted September 30, 2013 Thanks for your input Vekia. The only problem I have is ps_product_shop does not have columns for id_supplier or id_manufacturer Link to comment Share on other sites More sharing options...
vekia Posted September 30, 2013 Share Posted September 30, 2013 my bad, you've got right. sorry and what about ps_product_supplier table? there is an id_supplier field well, it's time to check sources of prestashop Link to comment Share on other sites More sharing options...
Whispar1 Posted September 30, 2013 Author Share Posted September 30, 2013 (edited) No sir - no id_manufacturer there From what I understand, the tables all changed from 1.4 to 1.5 The biggest complaint I have is keeping inventory current. There is no easy way to do this and for an eCommerce platform - keeping accurate inventory is a HUGE issue! Quantities are now split between two tables: Items with combinations are listed in the ps_product_attribute tableItems with NO combinations are listed in the ps_product table Edited September 30, 2013 by Whispar1 (see edit history) Link to comment Share on other sites More sharing options...
tuk66 Posted October 1, 2013 Share Posted October 1, 2013 Try ps_manufacturer_shop and ps_supplier_shop tables. Link to comment Share on other sites More sharing options...
Whispar1 Posted October 1, 2013 Author Share Posted October 1, 2013 Thanks for the reply Tuk Unfortunately, the tables you mentioned are only for manufacturer and supplier references and do not contain columns to associate manufacturer/supplier with product id Link to comment Share on other sites More sharing options...
tuk66 Posted October 1, 2013 Share Posted October 1, 2013 You are right, but ps_product_shop do. In reality, usually more than one or two tables are joined. Link to comment Share on other sites More sharing options...
Whispar1 Posted October 1, 2013 Author Share Posted October 1, 2013 Thanks again for the input. However, my ps_product_shop in version 1.5.3.1 does not have columns for supplier or manufacturer references. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts