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

How to bulk change the price of ALL product

 
Reply
   X-Cart forums > X-Cart 4 > Changing and adding new features
 
Thread Tools Search this Thread
  #11  
Old 02-04-2020, 01:42 AM
 
cheap eyeglasses cheap eyeglasses is offline
 

Senior Member
  
Join Date: Oct 2010
Posts: 140
 

Default Re: How to bulk change the price of ALL product

Remember to backup your database first before you run any mysql commands.
Reply With Quote
  #12  
Old 02-04-2020, 04:08 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 13,932
 

Default Re: How to bulk change the price of ALL product

I don't know what to tell you but it looks like you are missing something. I would guess the files did not upload correctly to the server. The output you posted starts with


* @copyright Copyright (c) 2


which is not how it should be.
The file has to start with <?php
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #13  
Old 02-04-2020, 06:36 AM
 
voodoo1967 voodoo1967 is offline
 

eXpert
  
Join Date: Sep 2009
Posts: 392
 

Default Re: How to bulk change the price of ALL product

The only place where there is that string ie * @copyright Copyright (c) 2 is in the install and uninstall .sql files. I ran the uninstall sql then ran the install script.

Deleted the upload files and re uploaded them again and double checked the files that needed to be edited. All exactly as per instructions.

So Im giving up - the time spent on this I could have done it manually (I have the global product options module) - by changing the price product option into a global option and then changing the appropriate products to use that global option group.
__________________
x-cart Gold Plus 4.7.11
CDSEO Pro latest ver
php 7.0.15
Reply With Quote
  #14  
Old 02-04-2020, 09:59 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 13,932
 

Default Re: How to bulk change the price of ALL product

Quote:
Originally Posted by voodoo1967
The only place where there is that string ie * @copyright Copyright (c) 2 is in the install and uninstall .sql files.




That's not the case. I don't know where you got the installation pack from but this and other php doc lines are at the top of every file within the installation pack. If you are checking the file son the server and not seeing them then your upload is incorrect
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #15  
Old 02-04-2020, 10:34 AM
 
voodoo1967 voodoo1967 is offline
 

eXpert
  
Join Date: Sep 2009
Posts: 392
 

Default Re: How to bulk change the price of ALL product

Apologies Steve - you are correct - there was an error in my search
All the module files have "{* vim: set ts=2 sw=2 sts=2 et: *}

{**
* Products Bulk Prices Module
*
* @category X-Cart Classic Module
* @author CFL Systems, Inc. <support@cflsystems.com>
* @copyright Copyright (c) 2015 CFL Systems, Inc. All rights reserved.
" etc etc
I got the install pack from cfl (I previously purchased it) but I think during an upgrade it was missed - so I re downloaded it yesterday order #12968

So not sure how or what's up with it. I backed out the changes, re uploaded the files again and edited the various files etc done in notepad++ , cleared the xcart cache but got the exact same result
__________________
x-cart Gold Plus 4.7.11
CDSEO Pro latest ver
php 7.0.15
Reply With Quote
  #16  
Old 02-04-2020, 11:30 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 13,932
 

Default Re: How to bulk change the price of ALL product

What you are quoting now is from a template file. Previous output was from php file.
What you are seeing in the browser is the php file not the template file
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #17  
Old 02-04-2020, 01:03 PM
 
illinismitty illinismitty is offline
 

Newbie
  
Join Date: Feb 2020
Posts: 2
 

Default Re: How to bulk change the price of ALL product

I hate the bulk edit in xcart 5. It's far too limited for those of us that do not code. They went backwards on this one.
__________________
Xcart 5
Reply With Quote
  #18  
Old 02-04-2020, 02:19 PM
 
voodoo1967 voodoo1967 is offline
 

eXpert
  
Join Date: Sep 2009
Posts: 392
 

Default Re: How to bulk change the price of ALL product

It's ok Steve - Ive given up, I only have a few products that need updating - so will do it via global product options module instead. We have decided to probably migrate everything to ecwid once we have a spare weekend.
xcart has become too much of a bind to us. And the time spent on things like this means we arent focusing on trying to grow sales.
__________________
x-cart Gold Plus 4.7.11
CDSEO Pro latest ver
php 7.0.15
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Changing and adding new features


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 06:24 PM.

   

 
X-Cart forums © 2001-2020