Christopher Short Posted March 16, 2017 Share Posted March 16, 2017 Is there a good way to do mass product description updates? I know it is html based so it doesn't look like excel will work. ideas? Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 16, 2017 Share Posted March 16, 2017 Depends what you want to do. If the edit is to change a wortd or two, then an UPDATE query should work. More than that, I suggest you find a CSV Editor dedicated to the task of editing and managing CSV files. As always, there are free, but competent, tools with a basic, but common, feature set. Then there are not so free applications that can do wonders on a CSV file. A spreadasheet is NOT the tool to use on a CSV file, even though spreaadsheets usually read and write CSV files. They are horrible at managing the data in them. Have phpMyAdmin dump the inventory table to a CSV, make your edits as efficiently as possible, then import the CSV back into a truncated table. Quote Link to comment Share on other sites More sharing options...
keat Posted March 16, 2017 Share Posted March 16, 2017 This can be done en mass with an SQL query. Using PHPMyAdmin, first make a backup copy of the inventory table call it something like CubeCart_inventory-copy, and work on this backup copy. Run the following SQL query UPDATE `CubeCart_inventory-copy` SET `description` = replace(description, 'old-unwanted-phrase', 'new-wanted-phrase') Alternatively, as BSmither suggests, you could export cubecart_inventory as a csv file, then perform a 'find & replace' with something like MS Ecell. Once you've made your ammendments, using PHPMyAdmin, truncate (empty) the backup copy, and import your CSV back in. When you are happy that the inventory tables are to your satisfaction, again using PHPMyAdmin, rename the origianl CubeCart_inventory to something like CubeCart_inventory-orig (just in case) And then rename your backup copy to CubeCart_inventory. Only when you are 200% satisfied that it's all OK should you delete the original (even if at all, maybe leave it there for future reference) Quote Link to comment Share on other sites More sharing options...
Christopher Short Posted March 16, 2017 Author Share Posted March 16, 2017 I got this figured out guys. Thanks Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted March 16, 2017 Share Posted March 16, 2017 Great! What worked for you? Quote Link to comment Share on other sites More sharing options...
Christopher Short Posted March 18, 2017 Author Share Posted March 18, 2017 On 3/16/2017 at 3:43 PM, Dirty Butter said: Great! What worked for you? http://www.g7cart.com/home/index.php?p=viewProd&productId=17&prod=Data Pump (Bulk Import/update/export) this worked well, except the one import where I had 14000 commas at the end of the description entry....that caused my add to cart question earlier. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.