I wish to change the vendor ID of one vendor from #189 to #1 (original #1 was already deleted). The only reason I want to do this is to make this vendor as the default vendor when the admin adds a new product.
I tried changing this directly in the database but it broke the links to the products. Is there an easy way to do this without breaking anything?
TIA
Possibly an export, edit, import process?
It gets tricky because “company_id” can also b referenced as “object_id” or other column names in foreign tables. Also in many places, the company_id (vendor id) is stored as serialized data along with other attributes. So it's not as simple as one might expect.
hi buging,
tbirnseth is right - it is necessary to make update in multiple tables and it is needed to know dependencies between cs-cart database tables to make this change.
if you need our assistance, please don't hesitate to contact us.
best regards,
WSA team
We are also at your service to perform this task