X-Cart forums - Copying Database Fields

X-Cart forums (https://forum.x-cart.com/index.php)

- Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)

- - Copying Database Fields (https://forum.x-cart.com/showthread.php?t=73091)

Freakmode

11-17-2015 02:06 AM

Copying Database Fields

Hi

Is there an easy way to copy all our "detailed" product descriptions to the "short" description fields. We have nearly 5000 products so cut and paste is not an option.

We have always used only the detailed description but now wish to use both.

Thanks

PhilJ

11-17-2015 03:37 AM

Re: Copying Database Fields

SQL patch, make a DB backup first...

Code:

UPDATE xcart_products_lng_en SET descr = fulldescr;

Freakmode

11-17-2015 04:36 AM

Re: Copying Database Fields

Pure Genius as always Phil - worked like a charm

Thank you

All times are GMT -8. The time now is 02:59 AM.