View Single Post
Old 02-16-2014, 05:56 AM
  rogue's Avatar 
rogue rogue is offline

Join Date: Apr 2007
Location: Loveland, Ohio
Posts: 770

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

You can do this by:
- Export your products
- Import into Excel
- Delete all columns except for productcode and price
- Rename price column to old_price
- Add a new column new_price with formula to adjust old price as desired.
- Copy values of of new_price to another new column called price.
- Delete the old_price and new_price column leaving only productcode and price
- Export to CSV
- Import to store
Richard Williams
Rogue Wave Limited

Initial Inventory Imports
Daily Inventory Updates
Daily Inventory Reports
Drop Ship Support
Order Export to Shipper/Supplier
Shopping Feeds That Work
Programming for X-Cart
Reply With Quote