Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
 

Copying Database Fields

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #1  
Old 11-17-2015, 02:06 AM
 
Freakmode Freakmode is offline
 

X-Adept
  
Join Date: Jun 2003
Location: UK
Posts: 696
 

Default 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
__________________
X-Cart 4.7.12 (Live)
Redux Template
CDSEO
Reply With Quote
  #2  
Old 11-17-2015, 03:37 AM
 
PhilJ PhilJ is offline
 

X-Guru
  
Join Date: Nov 2002
Posts: 4,094
 

Default Re: Copying Database Fields

SQL patch, make a DB backup first...
Code:
UPDATE xcart_products_lng_en SET descr = fulldescr;
__________________
xcartmods.co.uk
Reply With Quote

The following user thanks PhilJ for this useful post:
Freakmode (11-17-2015)
  #3  
Old 11-17-2015, 04:36 AM
 
Freakmode Freakmode is offline
 

X-Adept
  
Join Date: Jun 2003
Location: UK
Posts: 696
 

Default Re: Copying Database Fields

Pure Genius as always Phil - worked like a charm

Thank you
__________________
X-Cart 4.7.12 (Live)
Redux Template
CDSEO
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:51 PM.

   

 
X-Cart forums © 2001-2020