We use the E-Comlabs Staff Notes addon and find it incredibly useful.
We want to export/import Staff Notes from CS-Cart 4.3.5 to CS-Cart 4.18.2, but if we use CSV we lose the formatting that makes it readable.
Exporting a SQL file direct from the database looks like this (cscart_products table) and you can see the internal SQL formatting
INSERT INTO cscart_products (product_code, staff_notes) VALUES
(‘Test2’, ‘10/09/2024 11:43 G\r\nGeneral staff notes.\r\n\r\nOther product notes.’);
If we import this SQL file directly into the database it completes OK but doesn’t update the Staff Notes field which remains blank.
We have tested below and the result is the same.
CS-Cart 4.3.5 > CS-Cart 4.18.2
CS-Cart 4.18.2 > CS-Cart 4.18.2
We have 2500+ products with staff notes, too many to import by CSV and update individually…
How do we export/import Staff Notes and maintain the SQL formatting?